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 Safety 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