Psst – My services are likely more expensive than the memory your SQL Server needs and wants. Your CIOs and Directors need to stop thinking they are buying servers and components in 2004, or even 2010. I do all sorts of consulting gigs for all different reasons, but a lot of tuning gigs and wellness [...]
Alright so maybe that was a little misleading of a title… SQL Server join syntax changed awhile ago, when ANSI-92 joins became the norm. And Microsoft was threatening to remove it for awhile. The older outer join syntax just doesn’t work in SQL Server 2012.
We All Knew SQL Server Joins Were Changing…
I know… I’m not [...]
Stop expecting people to blindly follow your advice. Stop blindly following the advice of others.
I’m borrowing a lesson from the man who proclaimed he knew exactly when the world would end (last weekend October 21st now). If you only have a minute, my point is simple and I’ve hit it before here -
For Those [...]
When I re-read yesterday’s blog post on troubleshooting steps, I felt guilty. Instantly. Why? Because I had failed to mention something to you in that post and failed to follow advice I just gave in my SQL Rally presentation. *In my own defense, I did mention that one of the bullets I used in that [...]
Welcome to my first contribution to SQL University’s Database Administration Week! I am going to go back to some basics here this week. I know you’ve probably been with us for a few semesters and you don’t want to hear that. That’s fine, Microsoft Certified Master Robert Davis is also covering DBA week and he [...]
Kind of like some previous common sense posts inspired by mundane tasks (Day Job Tips learned from the garden, a dump trip, etc.), I was hit with another blog thought today. This goes well with my post – Plan To Fail or Don’t Expect To Succeed.
Updated: Added a sound piece of advice in the bullet [...]