Regressions

One of the most important take-aways from David Dewitt’s presentation at the PASS Summit was the level of fear within the Query Processing team at Microsoft caused by regressions. If you missed Dr. Dewitt’s presentation, I tried to capture as much of it as I could here, and it will be available within the DVDs […]

Read More

FreeCon

I got my FreeCon. What’s more, I did it in public and didn’t get in trouble. FreeCon is the brain child of Brent Ozar (blog|twitter). Basically Brent gathered together a few bloggers & writers from the SQL Server community, some extremely well known, like Tom LaRock (blog|twitter), some in the middle, like me, and others […]

Read More

Do Foreign Key Constraints Help Performance?

Most people are very aware of the fact that having a foreign key constraint in place on your tables adds overhead to inserts and deletes. And many people believe that there is no benefit to foreign keys beyond referential integrity (which, the application can handle perfectly well, right?). But is that an accurate statement? Here’s […]

Read More

Un-SQL Friday: Branding?

Following in Midnight DBA’s more interesting half new blog fest topic. My branding? I don’t have a clue. There, I said it. Up until very, very recently, I’ve just been doing stuff. I haven’t really even tried to think about what the plan was. Write a book? Sure, sounds like a cool challenge. Write another […]

Read More

Reason for Early Termination of Statement

Wouldn’t you like to know why the optimizer stopped tuning the execution plan you’re looking at? It’s actually possible and simple to get this information. I talked about this a little more than a year ago, but I left out some information that might be useful. Let’s take a very simple query: [sourcecode language=”sql&#...

Read More

SQL Server Team-Based Development

The new book is available in a free download from Red Gate. I had a lot of fun working on the three chapters that I did for this book. The topics I received are near & dear to me because of all the time I’ve spent working on getting databases into source control and automating […]

Read More

Switching Off Parameter Sniffing

Or, another way to put it, in most cases, shooting yourself in the foot. I was not aware that the cumulative update for SQL Server 2008 back in June included a switch that allows you to turn parameter sniffing off within SQL Server. Thanks to Kendra Little (blog|twitter) for letting me know about it (although she let […]

Read More

ScaryDBA Blog Reboot

After all the conversations at FreeCon last week (more on that later, when I’ve assimilated it better), I finally decided to make some changes. The list of things I’m hitting is extremely long, but I’m going to be going through them a few at a time. First, and easiest, was getting moved off the WordPress […]

Read More

The New Path To MCM

Microsoft has announced changes to the MCM program. This page shows all the ways that you can become an MCM without having to spend a month at Microsoft. I’m interested in this for two reasons. First, I’d love to have the opportunity to try to become an MCM. Making it easier to make the attempt, […]

Read More

PASS Summit 2010, Day 3 Key Note

Today is Dr. Dewitt. The ballroom, where the keynotes are held, is filled with extra chairs. The Summit organizers expect extra attendance today, and well they should. Dr. Dewitt was amazing last year. I suspect this year will be more of the same. Rick Heiges is introducing the day (waiting for Dr. Dewitt). Lynda Rab […]

Read More