SQL Server DBA, BI Analyst and Microsoft MVP

Posts Archive

Month: April 2016

Back to Archive

SQL Server - The Danger of Using JOIN Between Columns of Different Data Types

April 29, 2016 2 min read

Continue reading

Using Sequences in User-Defined Functions in SQL Server

April 28, 2016 2 min read

Continue reading

SQL Server 2012 - Working with Sequences and comparisons with IDENTITY

April 28, 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

SQL Server - The Database Owner SID Recorded in the Master Database Differs from the Database Owner SID Recorded in Database

April 21, 2016 3 min read

Continue reading

Monitoring DDL and DCL operations using SQL Server fn_trace_gettable

April 4, 2016 3 min read

Continue reading

Monitoring automatic space growth (Autogrowth) events in SQL Server databases

April 4, 2016 2 min read

Continue reading

SQL Server 2016 - List of new features and resources

April 3, 2016 9 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 find the last access date of a table or view and the last execution of a stored procedure in SQL Server

April 2, 2016 3 min read

Continue reading