Little Known Features

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 Security SQL Server

SQL Server - How to Install the Microsoft.ACE.OLEDB.12.0 and Microsoft.Jet.OLEDB.4.0 Drivers

June 5st, 2016
8
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 Security SQL Server