Adding bash to Windows 10

Awhile back I added the Windows Subsystem for Linux to my machine, rebooted, and promptly forgot about it. After all, I’m doing more PoSh these days and bash isn’t...

Why I Believe In In-Person Training

I was recently asked a question from a manager regarding someone on my team when I requested to send them to a training experience: 

Are there CBT based alternatives that...

Activate Conference 2019: Databases 101 for the Aspiring App Dev Session Info and Resources

A special hello if you're visiting this blog post during or after my workshop on Thursday afternoon, April 4 at the Louisiana Tech Park as park of the Activate Conference...

Speaking Again at the Techno Security and Digital Forensics Conference

I’ve once again been selected to speak at the Techno Security and Digital Forensics Conference in Myrtle Beach, SC, this year. I’m on the calendar for Wednesday, speaking again...

Two more of my presentations

I recently made available two more presentations that you might find helpful.  Feel free to download them and present them to others (adding a line that you got them...

MAXDOP, Parallelism and the Cloud

Parallelism and MAXDOP The pros and cons of parallelism have always been with us in SQL Server and I blogged about this a couple of years ago. This is...

It’s a UNIX system. I know this.

Jurassic Park was a great film. Steven Spielberg brought technology into the film era in a major way with computer generated dinosaurs and some now-classic film lines, many of...

Speaker at 24 Hours of PASS – 20 Years of PASS

I’m very happy to announce that for the very first time I will be participating as speaker in the 24 hours of PASS event. This specific instance of 24...

SQL Homework – April 2019 – Practice dealing with corruption

Over the last almost 2 years (wow how time flys when you are having fun) we’ve practiced all kinds of ... Continue reading

What’s a Key Lookup?

One of the easiest things to fix when performance tuning queries are Key Lookups or RID Lookups. The key lookup operator occurs when the query optimizer performs an index...