CPU Spikes Caused by Periodic Scheduled Jobs

In this article I’ll show you how to eliminate periodic spikes in the CPU that are caused by the jobs...

SSIS Data Flow "Sequence Containers" are Here!

Wooo!
OK - maybe too much of a celebration... and I do have meatier topics in the article pipeline.  However, I just...

SQL Server – Playing With Trace Flags

Trace flags are used to temporarily set specific server characteristics or to switch off a particular behavior. They are usually...

MSDB log file grown large – SLEEP_MSDBSTARTUP waittype

Issue: MSDB database log file is getting full very rapidly and became very huge. Currently, T-Log file is of 5GB...

What’s the little popup window in #SQLPrompt?

Awhile back I was working in SSMS and saw this window.

It threw me off since I was trying to write...

This Week in Data – Episode 14 (Hacking Your Professional Development)

Welcome back to another episode of This Week In Data! If you missed our previous episodes, you can watch them...

Query Tuning 101: Debugging a procedure

I was recently asked to help tune a stored procedure that has been historically taking between 55 and 60 seconds...

Reflecting on Ten Years of SQLSaturday

It’s hard to believe it’s been more than 10 years since we started the planning for the first event in...

Using OUTPUT with a field list.

I recently wrote an article for SQL Server Central about using OUTPUT. In case you aren’t aware OUTPUT is a...

SQL Server & Containers – Part Three

This post follows on from Part Two in which we created a custom docker image. We’ll now look at pushing...