I work as a SQL Server Administrator near Dallas Texas. I started working with databases over 20 years ago now. Back in the day, when the world was young, I started out working with Foxpro for DOS. It’s been awhile though, so I’m afraid I can barely spell “Foxpro” anymore. I’ve been working in SQL Server for over 15 years now with a fairly even split between administration and development.
This blog is to share some of the interesting bits and pieces I’ve either learned over the years or that I’m just now learning. If anyone has any suggestions for me to write about or questions about what I’ve already written I would love to hear them. I can almost always be found hanging out on twitter so stop by and say hi!
Honored to be considered a Microsoft Data Platform MVP.
My Recent Posts
Using GROUP BY instead of DISTINCT
Recently, Aaron Bertrand (b/t) posted Performance Surprises and Assumptions : GROUP BY vs. DISTINCT. In it he says he prefers GROUP BY over DISTINCT. He discusses the fact that GROUP BY will, in fact, under certain circumstances, produce a faster query plan. I highly recommend taking the time to read ...