A lot of times you’ll hear how people are experiencing sudden, intermittent, poor performance on a query, bad parameter sniffing at work, so they’ll fix it by running the following code:
Yeah, you just nuked the cache on your server because you wanted to take out a… Read more
I recently spent two days consulting with a company on their database development and deployment processes. They are a small, capable, team of developers, database developers and a DBA who have embraced the idea that they need to be able to automate their deployments. I wasn’t in there to teach… Read more
I was actually travelling for most of July and some of that was on holiday with the family, the real family. That’s why I didn’t get a June update posted.
I don’t have anything much exciting to report. We’re finally getting data out of our Chapter database and can report… Read more
I’m actively working to put together the leadership course that I talked about here and here. No, not full time. I still have to pay the bills with real work. But progress is going forward. I have an initial name and the principle around which we’re going to do… Read more
Does generating an Estimated Plan cause that plan to be loaded into the plan cache?
What? Still here? You want more? Proof? Fine. Let’s first run this bit of code (but please, not on your production server):
That will remove all plans from cache. Now, let’s… Read more
I’m putting the finishing touches on the all day seminar on execution plans that I’ll be putting on at DevConnections this year. I have tons of examples to show you how to interpret execution plans as part of query performance tuning. We’ll be able to fill our time. However, I’ve… Read more
No more procrastinating. No more complaining about the process from the outside. No more excuses.
You have to run for the PASS Board.
The Nominations Committee is all set, off and running. We’ve got great people involved who are going to do their best to ensure that the… Read more
I have, in the past, made way too much of the need for Actual Plans when doing performance troubleshooting. The primary reason for this is to get the Actual Plan in order to see the differences between the Actual and Estimated Row Counts as a means of understanding how the… Read more
Alternate Title: I’m traveling a bunch. Let’s get together and talk.
A bunch of trips and presentations coming up, so I thought I’d share. First, I’ll be SQL Saturday Omaha for my first time ever presenting in Nebraska. I’m excited to add this state to my list (which is almost… Read more
- Get a better name
- Define my personal goals for the course
I won’t be sharing these with you. I may share them with my Inner Circle (defined below). I’m thinking this is a 2-3 year commitment I’m making. I need to have my own set of measurements to ensure that… Read more
That’s right. There’s been a divorce. SQL Server Management Studio (SSMS) has been divorced from the server product. In fact, Microsoft is inviting you to the new SSMS coming out party.
I’m pretty excited about this. While I’m very comfortable in SSMS, to a large degree, it’s like that… Read more
You’ve been working as a DBA for X number of years. How do you know you’re good at it? Heck, you’ve been doing any sort of job for a while. How can you measure whether or not you’re competent?
The single best measure isn’t how much work you do, your… Read more
I frequently see statements on forums along the lines of “I don’t have a test server, so I’m going to do something I’ve never done before directly on my production servers…” This is usually followed by questions along the lines of:
- But that’s OK and I won’t get fired, right?
With my travel schedule, I don’t always get out to events where I can see a community speaker. Sometimes, I just see pros. That’s the case this month. Instead of skipping the month entirely, which feels wrong, I’ve decided to do a special award.
Speaker of the Month for June… Read more
I know a few people in the SQL Server community who have been involved in Scouting. A couple of them have taken or helped lead Scoutings leadership training program known as Wood Badge. It’s an amazing program. I won’t even attempt to tell you what Wood Badge has done… Read more
When I attend sessions at events, I try to mix it up. I’ll go to a session that, really, I probably will never use the information, just to expand my knowledge level a little. I also go to sessions by the masters so that I can try to expand my… Read more
Columnstore indexes are fascinating and really cool. Unfortunately, they’re adding an interesting new wrinkle to an old problem.
What’s the Cost Threshold for Parallelism set to on your server? If you just said “The whatsis of whositz?” then the value is 5. The cost threshold is the point at which… Read more
I’ve had a busy month on the Board.
You may have seen some tweets going by about our compliance with international laws regarding SPAM. This has been something of an education, so anything I say wrong below, it’s because I’m wrong, but not malevolent (at least in regards to this… Read more
I would love to see the Database Engine Tuning Advisor (DTA) pulled from the product. Completely. Heck, I feel bad that I included a chapter on it in my query tuning book (all updated for SQL Server 2014 by the way). Let me tell you why we need to pull… Read more
I heard about Connected from a show on NPR (Yes, I listen to NPR, why do people keep saying that?). It was right after another segment talking about how positivity affects your mood and your ability to think and act in a clear fashion. I’ve long been a believer in… Read more