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,103 reads
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,172 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
823 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,076 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,228 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,362 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,928 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,602 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,546 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,801 reads
Blogs
My 2024 in Data: Music
By Steve Jones
This is my last week of the year working (I guess I come back...
A New Word: Suente
By Steve Jones
suente– n. the state of being so familiar with someone that you can be...
Side Projects
Anyone (everyone?) who has ever tried to learn a programming language knows that to...
Forums
Timeout Error while executing a TSQL statement in Sql server Express Edition
I am getting the below error when I execute a SQL command in SQL...
Timeout Error while executing a TSQL statement in Sql server Express Edition
I am getting the below error when I execute a SQL command in SQL...
Sql script replace and rearrange numbers
Hi everyone. I have this table and this information. (left side of the image)...