I’d like to thank Pam Shaw (twitter as @pamshaw) and Jorge Nunez (twitter as @sqlchicken) for letting me come down to Tampa this past weekend to present at SQL Saturday #32. Jeez, that picture doesn’t make me look very happy. For someone like me that tends to forget to take time off, this is a … Continue reading SQL Saturday 32 — ABCs of CTEs Deck
I've been selected to speak at the Tampa SQL Saturday coming up at the end of January. I'm a bit pumped to be going down there since I woke up this morning to below zero weather for yet another day. Not that I'm complaining, but my feet could definitely use a little bit of heat. … Continue reading Speaking at Tampa SQL Saturday
A few weeks ago I posted a job that I use to track wait stats in the DBA database that I bring to a number of clients. I had promised to follow-up with a couple or three reports that could be used to monitor the values that were being aggregated in those tables. Before getting … Continue reading Wait Stat Categories
It’s a very good question. One that might not seem to insidious. Nothing that should be able to bring down the system and cause failures. Or will it? I’ve been to a number of clients and done it myself before where I start to check out a stored procedure with some performance issues and sitting … Continue reading Does Your Stored Procedure Grant Itself Permissions?
I got to work with deadlocks quite a bit recently. There were quite a few interesting ones that came up that I had the chance to research. Since I like easy, I’ll start with the one that I forgot to grab the deadlock details for. Well, maybe not all of the details… in this case … Continue reading Deadlocks on exchangeEvent and threadpool
If you don’t know where you've been, how can you expect to know where you are going. Seems like such a simple little line and I’m sure many of us can look at history, politicians, and maybe that restaurant review that you didn't heed when it comes to this line. But this also applies to DBAs and more specifically … Continue reading If You Don’t Know Where You’ve Been
The SSWUG Ultimate Virtual Conference starts this morning. Are you planning to take advantage of this opportunity? The Rock Starspeakers are waiting in the channels, anticipating you every move. But, have you registered? It’s not too late. If you can’t get to the sessions today, there is always tonight to go through and view them. … Continue reading Tap, Tap, Tap – SSWUG Conference Starts Today
It starts next week,the SSWUG Ultimate Virtual Conference on October 21-24. This is an excellent opportunity to get the benefits of heading to a conference full of Rock Star speakers while being able to view the content from the comforts of home or your desk. Have you registered? If you haven’t registered yet, I really … Continue reading Are You Registered?
I like discounts. Paying full price when I don’t have to sucks. It’s a waste of resources, and as a person who’s had to tune databases in the past I’ve grown quite fond of resource management. And the best resource ever to manage is dollars. Because you can buy stuff. What About 2nd Chance? I … Continue reading SQL Server Certification Discounts
Michael Swart (Database Whisperer) posted a great write up and interview with Brad Schulz that is worth checking out. Michael’s post links to a post from Brad on the use of EXIST and what is required for the SELECT portion of the statement. Hope you are still with me. Definitely worth the read and +1 … Continue reading Checking EXISTS – What’s Your Practice?
Strate SQL 