Jason Brimhall

All authors

Blog Post

Decoded Statistics Names and More

Auto-generated statistics names can seem like they are entirely random, but there is a method to the madness. With a little effort and a bit of TSQL trickery, we...

2020-05-04 (first published: )

651 reads

Blog Post

Audit Logons with Extended Events

This article shows how to audit the logon events for SQL Server 2012 and beyond through the use of XEvents.
Related Posts:

Life Support 2008 - Audit Logons July 17, 2019...

2020-04-29 (first published: )

328 reads

All authors

Blogs

Don’t Fear the Technology

By

The concern that a particular technology is going to destroy the world seems to...

Creating a Custom SQL Server Security Checklist Using the DoD STIG

By

The STIG is detailed, which is a good thing, but I found myself wanting...

Creating a Local Model Chatbot on Windows

By

After my session at VSLive last week, I had a few questions from the...

Read the latest Blogs

Forums

Querying Multiple Tables for the Same Information

By RedSoxRay

I have about 100 Tables that are all suffixed with _Modify. These tables record...

Make It Routine

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Make It Routine

Finding Gaps in Sequential Data Using SQL Server

By Imran2629

Comments posted to this topic are about the item Finding Gaps in Sequential Data...

Visit the forum

Question of the Day

Negative and Positive Numbers

If I want to know whether a number of negative, positive, or zero, what is the easiest way to get this in T-SQL?

See possible answers