SQL Server - How to use MERGE command to enter, update and delete data with 1 command only September 22th, 2018 3 Database Query Development Little Known Features SQL Server
SQL Server - How to use regular expressions (RegExp) in your database 22 May 2018 3 Database CLR Query Development Little Known Features OLE Automation SQL Server SQLCLR
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 - Using Resource Governor for greater control over server resources February 14rd, 2018 1 Database Little Known Features Maintenance SQL Server
SQL Server - How to document the database and its objects (tables, procedures, columns) using Extended Property October 29th, 2017 6 Database Query Development DMVs and Catalog Views Tools Little Known Features SQL Server
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 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
SQL Server - How to Install the Microsoft.ACE.OLEDB.12.0 and Microsoft.Jet.OLEDB.4.0 Drivers June 5st, 2016 7 Database Little Known Features Maintenance SQL Server
SQL Server - Querying instance information in Windows Registry using sys.dm_server_registry and xp_instance_regread April 23 2016 0 Database DMVs and Catalog Views Little Known Features Hacks SQL Server
Using SQL Server Standard Trace to Audit Events (fn_trace_gettable) April 23 2016 3 Audit Database Little Known Features Safety SQL Server