SQL Server and Power BI - How to Load Stored Procedure Data in SQL Server with DirectQuery June 16, 2020 7 min read Continue reading
SQL Server Express Challenge - Is It Possible to Exceed the 10 GB Data Limit in a Database? December 30, 2018 14 min read Continue reading
SQL Server - How to View the Full Job Execution Return Message Even When It Exceeds 4000 Characters May 2, 2018 3 min read Continue reading
SQL Server - How to query Active Directory (AD) information using Linked Server (ADSI) August 23, 2017 5 min read Continue reading
SQL Server - How to recover the source code of an encrypted object (WITH ENCRYPTION) August 22, 2017 8 min read Continue reading
SQL Server - How to export a CLR assembly as a DLL and reverse engineer it to C# source code February 25, 2017 4 min read Continue reading
SQL Server - Msg 443: Invalid Use of a Side-Effecting Operator RAND Within a Function December 26, 2016 3 min read Continue reading
SQL Server - How to identify weak, empty, or user-name passwords November 24, 2016 4 min read Continue reading
How to use the Pushbullet API to send SMS messages in C#, PHP, Java or through SQL Server (with CLR) September 11, 2016 9 min read Continue reading
SQL Server - How to run PowerShell and Prompt-DOS (MS-DOS) scripts using CLR (C#) September 11, 2016 6 min read Continue reading
SQL Server - How to stop, start, and list Windows services remotely August 7, 2016 8 min read Continue reading
SQL Server - Querying Instance Information from Windows Registry Using sys.dm_server_registry and xp_instance_regread April 23, 2016 3 min read Continue reading
How to retrieve the greatest value among multiple columns in a SQL Server table April 2, 2016 2 min read Continue reading
How to use JSON in SQL Server 2008, 2012 and 2014 - Reading JSON strings, importing into the database and exporting to XML July 25, 2015 14 min read Continue reading