Thanks to all those that voted for my Index Black Ops blog series for the SQLServerPedia blog awards. I am pretty pumped that my series won. When I originally envisioned the posts, I was just hoping to put together some sample code that I could use to understand how sys.dm_db_index_operational_stats functioned. And, obviously, others were … Continue reading SQLServerPedia Awards Winner
The PASS Summit is complete and we got what we asked for from David Dewitt. He spoke on the third day of the PASS Summit and received quite the applause when his presentation ended. David Dewitt came to us at the request of the community. When he was mentioned at an MVP meeting on there … Continue reading David Dewitt at the PASS Summit
Final post for the countdown – a little later in the week than I wanted. Right now there is less than 1-week until the PASS Summit. There’ve been a few posts over the last few weeks on the upcoming summit (1 , 2 , 3 , 4, 5, 6). These have also been aimed at … Continue reading 1-Week to PASS Summit 2010 – After Hours
Finally up to the last post of this series resurgence. Time to update the Index Analysis Custom Report that I developed last year. The previous posts in this complete series are: Analyze Your Indexes Part 1 – Combine existing index statistics and missing indexes into a single output Analyze Your Indexes Part 2 – Find … Continue reading Return of the Index Analysis Report
I thought this week was going to be pretty low key. SQL Saturday 58 has wrapped up. The PASS Summit Ask the Experts scheduling is completed. But it never plays out that way… And this is a good thing. A few of my blog posts have been nominated for the SQLServerPedia Awards. The nice thing … Continue reading SQLServerPedia Award Nomination
Time for another T-SQL Tuesday and this time I'll finish my entry in time. This month we are talking about why DBA skills are necessary. Definitely a topic right up my alley since I've been having discussions along these lines with peers and co-workers for some time now. a.k.a. What You Don't Know Can Hurt … Continue reading Why are DBA skills necessary? #TSQL2sDay
Over the past year there have been a number of SQL Saturday events. These events have occurred across the country from Orlando to San Diego to Minnesota. At many of these events there are shirts given away to speakers and/or the attendees. PASS Fashion I was thinking about this and wondering what I should wear … Continue reading “Wear Your SQL Saturday Shirt Day”
It’s getting down to brass tacks. There is now only 2 more weeks until the PASS Summit. There’ve been a few posts over the last few weeks on the upcoming summit (1 , 2 , 3 , 4, 5) aimed at trying to rally those without plans to attend to get registered. These have also … Continue reading 2-Weeks to PASS Summit 2010 Countdown
Alright, up to the last of the changes I’ve made to the index analysis query that I had planned. This makes the fifth post in the series on this query. The previous posts in this complete series are: Analyze Your Indexes Part 1 – Combine existing index statistics and missing indexes into a single output … Continue reading Return of Index Analysis Part 5
Only 3 more weeks until the PASS Summit and it's time for another countdown post. I've done a few of these now ( 1 , 2 , 3 , 4 ) to hopefully prepare readers for the opportunities at PASS. Trying make sure that you will know as much as possible about the summit to … Continue reading 3-Weeks to PASS Summit 2010 Countdown –
Strate SQL 