SQL Server - How to Use the MERGE Command to Insert, Update and Delete Data with Just One Command September 22, 2018 15 min read Continue reading
SQL Server - How to Use Regular Expressions (REGEXP) in Your Database May 22, 2018 22 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 - Using Resource Governor for Greater Control of Server Resources February 14, 2018 15 min read Continue reading
SQL Server - How to document the database and its objects (tables, procedures, columns) using Extended Property October 29, 2017 24 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 identify weak, empty, or user-name passwords November 24, 2016 4 min read Continue reading
SQL Server - How to install the Microsoft.ACE.OLEDB.12.0 and Microsoft.Jet.OLEDB.4.0 drivers June 5, 2016 7 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
Using the Default SQL Server Trace to Audit Events - fn_trace_gettable() April 23, 2016 5 min read Continue reading
Enabling and using dedicated remote administrator connection (DAC) in SQL Server October 4, 2015 4 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