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
A few times this past week I heard the quote, “Hi, Eric Stratton, Rush chairman, damn glad to meet you”. That line kind of summarizes what the PASS Summit was like for me this year. It’s been like coming to a week long rush event for the best fraternity in the world. This fraternity isn’t … Continue reading Hi, Eric Stratton, Rush chairman…
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’ve been skipping on posting technical blogs for a couple months. I’m planning to put that issue to rest with some aggressive blogging over the next couple months to make up for lost time. After reading SQL Fool’s post on her reasons for change, I figured I’d do the same. Not because anyone has noticed … Continue reading Missing Blogger
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?
Sometimes when I get pulled in to look at a database, I’ll sit down with the developers or database administrators working on the database and get some background on the database. This usually includes pointing on the important tables, an explanation of why some design decisions were made, and some pre-conceived notions about where to … Continue reading To Be Or Not To Be In the Memory Buffer
Strate SQL 