Identify S-1-9-3 logins in sys.dm_exec_sessions

· by · in ,

When looking at sys.dm_exec_sessions to see who is logged into a SQL Server instance, you may notice the login_name column contains a SID such as S-1-9-3-1474169822-1205489898-2971455952-561433448. This can happen as a result of using EXECUTE…

SQL Server Trace Flags

· by · in

Maintaining an up-to-date list of SQL Server Trace Flags is time consuming, and difficult since the majority are undocumented. Aaron over at SQLCrossJoin.wordpress.com maintains an incredibly detailed and comprehensive list of trace flags at https://sqlcrossjoin.wordpress.com/category/trace-flags/….

SQL Server Timer Source

· by · in

Recently, I’ve been looking for a way to better understand timings on SQL Server, and have been intrigued to see that SQL Server can use one of several different mechanisms to determine precision and resolution…

Tool for scripting SQL Server Agent Jobs

· by · in

I recently created an open-source tool that will create a T-SQL script file containing code to recreate whatever jobs you presently have in SQL Server Agent for any given SQL Instance, up to SQL Server…

Use DBCC PAGE to identify rows involved in blocking operations in SQL Server

· by · in

Recently, one of my customers complained about a BizFlow database that was “running slowly”. BizFlow uses SQL Server to store data used in business processes – in this implementation there is a main BizFlow database,…