I was asked, “Who here thinks that PASS helps people put food on the table?” To my shame, I initially said no. I mean after all, it’s just training and networking that could lead to improved knowledge and abilities which… hang on. Just how wrong I can be sometimes when… Read more
I was eating dinner with Hugo Kornelis and we started talking about query hash values. You know, like everyone does at dinner. As we talked about it, I suddenly thought about both Plan Guides and the Query Store. I wondered what happened to the query hash values in that case?… Read more
I am so excited to be a data professional in the modern era. Yeah, 15-20 years ago, it was cool to be a DBA and a database developer. However, now, it’s amazing. Data drives, or should drive, all our decisions. Whether we’re deciding how high to set the cost threshold… Read more
In a previous post, I showed how to set up statistics maintenance for your Azure databases using Azure Automation. However, what I didn’t show was how to generate an alert when things go south. Let’s do that now.
An Error Needing an Alert
First, I need to generate an… Read more
I’m working on a technical blog post that I hope to be putting up soon. I’ve run into a number of configuration issues that I’m working through. However, it’s these issues that sparked this blog post.
See, we’re learning Azure all wrong.
What’s the first thing you do… Read more
The winner is: Everyone.
Hey, the challenge was random. I didn’t promise a prize or a winner. Instead, I suggested everyone blog based on an image of the great Tom Baker:
In no particular order we have:
Persist and Aggregate Index Stats Across Server Restarts by Eric Cobb
Nice use… Read more
I made a mistake the other day. For some reason I got it into my head that I was flying to Albuquerque when I was actually flying to Phoenix. I’ve no idea how or why that occurred, but I sent a tweet out on how excited I was to finally… Read more
I’ve written several times about the Cost Threshold for Parallelism and it’s relationship to your execution plans, how to determine your execution plan cost, and even how to decide what value to set your Cost Threshold to. What I haven’t explicitly addressed in extremely clear terms is why you… Read more
I believe in DevOps.
Actually, that’s a pretty horrible way to put it. It’s not about belief, like keeping Tinkerbell alive.
I have successfully worked within an environment that implemented a DevOps approach to development, deployment and maintenance. I also provide classes and consulting on how to approach DevOps from… Read more
Our developers evidently had too much time on their hands after building SQL Clone. They created a skill in Alexa that lets you clone… Read more
OK, for no particular reason at all or maybe because I had too much food at lunch or just because Jason Hall gave me the idea, here’s a blog post challenge for anyone who wants to take it up. Write a technical blog post that incorporates this image:
Link… Read more
In the previous post, I showed how you can get full listings of your execution plan costs. Knowing what the values you’re dealing with for the estimated costs on your execution plans can help you determine what the Cost Threshold on your system should be. However, we don’t want… Read more
Today is the launch of SQL Clone, a great new tool that helps you quickly and easily provision SQL Server databases for development and testing.
Oh god, that sounds like marketing speak. To heck with that. Let me tell you why I’m so excited about SQL Clone and why… Read more
I suspect this may make a few people angry, but I felt the need to share.
I was recently asked to go through my contacts and put together calls with some technologists for a series of discussions. OK. I thought about what we’d need, compared it to a mental list… Read more
As someone who still actively pursues a career in technology, I’m a little on the older side. I got started in tech when a lot of the people I know were still in elementary school. So please understand that when I write the rest of this little… rant.
I read… Read more
One question constantly comes up; What should the Cost Threshold for Parallelism be? The default value of 5 is pretty universally denigrated (well, not by Microsoft, but by most everyone else). However, what value should you set yours to?
What Do Your Plans Cost?
I have a question right back… Read more
I was asked if there was an easy way to export all the plans from cache to a .SQLPLAN file. My immediate answer was, “I’m sure there’s a PowerShell script out there somewhere.” However, rather than do a Gingle search, I figured I’d quickly knock up an example.
I love the questions I get while I’m presenting because they force me to think and learn. The question in the title is one I received recently. The answer, now that I’m not standing in front of people, is easy. Of course the space is not pre-allocated. Query Store tables… Read more
So, my blog got hacked. They edited the page where I thanked Rodney for all that he did. I had to remove that post as a part of the cleanup (still ongoing). However, I couldn’t let that stand. I’ve used caching on the internet to track down the original post… Read more