I’m speaking at SQL Saturday 749 : Baton Rouge
Hello Louisiana! It’s that time of year again. I’ll be speaking on Saturday August 11th in Baton Rouge with many...
2018-07-27
497 reads
Confessions of a Microsoft Addict
SQL Saturday Houston is this weekend
I’m speaking along with many other amazingly talented professionals, including Adam from Guy In A Cube. If you’re in the...
2018-06-19
306 reads
Monday morning comic 2018-05-28
It always seems that when I give a talk on performance there are 100+ people packed in the room but...
2018-05-28
261 reads
You know everything about GROUP BY. Do you?
SQL is a stout language and SQL Server has so many features that it’s impossible to be an expert in...
2018-06-01 (first published: 2018-05-25)
5,824 reads
2018-05-21
301 reads
Back to basics: What is a HEAP table?
Understanding the fundamentals is key for success, with everything you do. These days SQL Server has expanded into much more...
2018-05-24 (first published: 2018-05-16)
5,571 reads
I’m speaking: SQL Saturday Los Angeles 06-09-18
Hello California! I’m headed your way and will be speaking at SQL Saturday #773. The full schedule is live and...
2018-05-14
231 reads
Monday morning comic 2018-05-18
Here’s the first issue of a new Monday morning comic series. Hopefully some of you all get a giggle.
2018-05-14
336 reads
SQL Ops Studio extension development : Starting an adventure
I’ve been in technology a long, long time (more than 2 decades). Over the years, I learned Access which took...
2018-04-26
1,183 reads
SQL Tuning: Finding statements for missing indexes
Missing indexes are an important part of the indexing strategy. I usually start with sys.dm_db_index_usage_stats to find both inefficient and...
2018-04-20
575 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)...