Throwback Thursday #2: Get Your Speak On!
I hope everyone is having a great Thanksgiving with their families. When you come out of that food coma I...
2013-11-28
1,107 reads
John Sterrett
I’m A SQL Server Rockstar Blogger!
SQL Server Rockstar Blogger
I have a quick secret to share with my readers. Ever since I saw Tom Larock’s SQL Server...
2013-11-27
1,177 reads
Throwback Thursday #1: SQL Inspire
What Is Throwback Thursday?
One of my hobbies is being a turntablist. In high school I took a job just so...
2013-11-14
825 reads
SQL Server Performance Root Cause Analysis in 10 Minutes
This year I was honored to be selected by Dell Software to present a ten minute session in their booth...
2013-10-15
1,093 reads
Finding Top Offenders From Cache
When I start a SQL Server Performance Root Cause Analysis I like to find the top waits and then find...
2013-10-14
1,369 reads
What Queries are Causing My Waits?
In my last blog post, I showed you how I go about baselining wait statistics. Typically my next step once...
2013-10-15 (first published: 2013-10-10)
4,258 reads
Benchmark SQL Server Wait Statistics
One of the secret weapons in performance tuning with SQL Server is understanding wait statistics. Every time a process (spid)...
2013-10-08
1,961 reads
Learn SQL Server Performance Tuning Basics in a Single Day
Have you always wanted to dig into performance tuning but wasn’t sure where to start? If so, check out this Introduction...
2013-09-04 (first published: 2013-08-28)
2,610 reads
Workload Tuning: Finding Top Offenders in SQL Server 2012
I have to give credit where credit is due. Microsoft has definitely made performance tuning easier in SQL Server 2012. Performance...
2013-08-15 (first published: 2013-08-07)
2,561 reads
First Look: Microsoft SQL Server 2014
Last week at TechEd 2013 in New Orleans Microsoft publicly released details about the SQL Server 2014 CTP 1. Here...
2013-06-11
1,807 reads
Blogs
When the Internet Stumbles: Lessons from Cloudflare & Azure Front Door Outages
By John
Recently, the world was reminded of just how fragile the internet can be. Two...
Prepping for Certification, Part 4 of 4
By Brian Kelley
In Parts 1-3, I covered how I prepare for a certification exam. In this...
Flyway Tips: Automation Assistance in Flyway Desktop
By Steve Jones
I was chatting with the product managers at Flyway and one asked me whether...
Forums
CAST datetimeoffset(7) as a datetime in UK format
I have a view where I am casting a datetimeoffset(7) field to smalldatetime or...
what are the downsides of TDE not running vs running?
hi for the 2 years i've been here I believe we've had "encryption" turned...
Help! MEMORY_ALLOCATION_EXT wait stalls
Hi I have an overnight process that moves allot of claims records Been working...
Question of the Day
Putting the Player with the Number
In SQL Server 2025, what does this return?
DECLARE @player varchar(20) = 'Bo Nix', @num VARCHAR = '10' SELECT @player || @numSee possible answers