Jason Brimhall

Life Support 2008 – Audit Logons

Planning to upgrade/migrate requires a fair amount of prep work. Some of that prep work involves auditing your server for any users that may still be using the instance.
Related...

2019-08-09 (first published: )

197 reads

Finding Data Gaps

Quality data is a goal we all strive to attain. Nobody wants to have bad data. Yet, despite our best efforts, the problem of bad data has its way...

2019-08-05 (first published: )

394 reads

Event Files on Linux

For the most part, things work the way you might expect them to work in windows - except it is on Linux. Sure some things are different, but SQL...

2019-07-29 (first published: )

140 reads

Is That Database in Use?

This article demonstrates how to use Extended Events to determine if a database is being used by someone or something.
Related Posts:

Finding Deprecated Uses in SQL Server November 7, 2016...

2019-07-22 (first published: )

810 reads

Join a List of Values

There are multiple ways of retrieving data from a table when you have a list of values. This article explores the use of the table value constructor.
Related Posts:

Correlate Trace...

2019-07-18 (first published: )

470 reads

Database File Changes

Data professionals around the globe are frequently finding themselves occupied with figuring out why and when a file (data or log) for a database has changed in size. Whether...

2019-07-10 (first published: )

227 reads

Job History – Back to Basics

An important part of any DBAs job is to ensure database related jobs are running prim and proper. Sometimes that just doesn't happen. When jobs are being overlooked, it...

2019-07-04 (first published: )

424 reads

Blogs

Query Performance Tuning with Filtered Statistics

By

Introduction I recently got a call from our DBA telling me that the CPU...

Performance Tuning Steps Query by looking an execution plan and effectiveness of the index Part 2

By

How to read execution plan to improve poorly... [[ This is a content summary only....

VSCode Tips–Remove the Highlighted Line

By

VSCode was making me crazy as I was writing a script. I like a...

Read the latest Blogs

Forums

Growing and Changing

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Growing and Changing

Azure Stretch Database, Part I: Getting Going

By SQLBlimp

Comments posted to this topic are about the item Azure Stretch Database, Part I:...

Minimalistic SELECT

By Thomas Franz

Comments posted to this topic are about the item Minimalistic SELECT

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers