Hacks

SQL Server and Power BI: How to load Stored Procedure data into SQL Server with DirectQuery

June 16st, 2020
2
Database Business Intelligence (BI) Query Development Hacks Power BI SQL Server

SQL Server Express - CHALLENGE: Is it possible to exceed the 10 GB data limit on a single basis?

December 30th, 2018
3
Database Hacks What not to do SQL Server

SQL Server - How to view the entire return message from Job execution (even when it exceeds 4000 characters)

2 May 2018
2
Database DMVs and Catalog Views Errors Little Known Features Hacks Maintenance SQL Server SQL Server Agent

SQL Server - How to query Active Directory (AD) information using Linked Server (ADSI)

August 23st, 2017
3
Database Little Known Features Hacks Easy SQL Server

SQL Server - How to retrieve the source code of an encrypted object (WITH ENCRYPTION)

August 22st, 2017
5
Database C # (CSharp) Hacks SQL Server

SQL Server - How to export a CLR assembly as a DLL and reverse engineer to C # source code

February 24rd, 2017
0
Database C # (CSharp) CLR Hacks SQL Server

SQL Server - Msg 443 Invalid use of a side-effecting operator 'rand' within a function

December 26th, 2016
0
Database Errors Hacks SQL Server

SQL Server - How to identify fragile passwords, empty or equal to username

November 24th, 2016
2
Database Data Formatting and Validation Little Known Features Hacks Maintenance Monitoring Security SQL Server

Using the Pushbullet API to send SMS messages in C #, PHP, Java, or SQL Server (with CLR)

September 11th, 2016
7
Database C # (CSharp) CLR Hacks Easy Monitoring PHP Powershell / CMD Programme SQL Server

SQL Server - How to Run PowerShell and Prompt-DOS (MS-DOS) Scripts Using CLR (C #)

September 11th, 2016
0
Database CLR Hacks Easy File Handling Powershell / CMD SQL Server