5 MCM Readiness Indexing Videos You Should Watch

Earlier this year, I finally passed the Microsoft Certified Master (MCM) for SQL Server 2008 certification.  In the process of preparing for the MCM lab portion, I did a lot of studying.  One of the my key resources, were the MCM Readiness Videos that SQLSkills put together a couple years back. The thing is, even if … Continue reading 5 MCM Readiness Indexing Videos You Should Watch

Index Analysis Update – January 2012

In the past couple weeks, I've gotten a couple reports of issues with sp_indexanalysis.  The update today fixes those issues.  It's fun to finally be playing with these scripts again.  I'm hoping to start writing blog posts showing the scripts in action in the next couple weeks. INDEX ANALYSIS UPDATES The main updates to the … Continue reading Index Analysis Update – January 2012

T-SQL Tuesday #025 – Share Your Tricks #TSQL2sDay

Another month and it’s another T-SQL Tuesday.  This month we are being hosted by Allen White (Blog | @SQLRunr) and the topic is to Share Your Tricks. One of my favorite things to do in SQL Server is to run queries against the plan cache.  Within there, you have the ability to see what SQL … Continue reading T-SQL Tuesday #025 – Share Your Tricks #TSQL2sDay

Can You Dig It? – Researching Index Scans

Follow the rest of this series at the Can You Dig It? - Plan Cache series introduction post. It’s been a while since the last plan cache series post.   In the last few posts, I was focusing on specific attributes.  Instead of continuing on that vein, I want to cover a use case that fit … Continue reading Can You Dig It? – Researching Index Scans

Pain of the Week: Understanding Your Indexes

Want to take a few minutes out of your day on to learn a bit more about indexes?  On Thursday, I’ll be presenting at Quest’s Pain of the Week webcast.  The session will be Understanding Your Indexes: Operational Stats. There's a lot that goes on under the covers of SQL Server with your indexes. But … Continue reading Pain of the Week: Understanding Your Indexes

PASS DBA Virtual Chapter Tomorrow

Tomorrow is time for part two of my presentations this month on Extended Events for the PASS DBA Virtual Chapter.  If you missed the first part of this series, you can watch it before hand here. Below are the details on the event and the session description… Extended Events, Work Smarter Not Harder – Part … Continue reading PASS DBA Virtual Chapter Tomorrow

Speaking at PASS DBA Virtual Chapter

If you are looking to become more familiar with extended events, take a gander at this month’s DBA Virtual Chapter meeting.  I’ll be presenting at both of the meetings for the month. The first meeting will cover the basics and some information on where Extended Events is going.  The second will cover some deeper content … Continue reading Speaking at PASS DBA Virtual Chapter

T-SQL Tuesday #17 – APPLY Knowledge

It’s that time of the month again… again.  Time for T-SQL Tuesday!  This month’s event is being hosted by Matt Velic (Blog | @mvelic).  The topic that he chose for this month is the APPLY operator. This is a great topic.   I like it because, often, when I am presenting I ask the question, “who … Continue reading T-SQL Tuesday #17 – APPLY Knowledge

Aggregating With Correlated Sub-Queries #tsql2sday

It’s that time of the month again.  Time for T-SQL Tuesday!  This month’s event is being hosted by Jes Schultz Borland (Blog|@grrl_geek).  The topic that she chose for this month is aggregates. The Dilemma A few months ago, a client I was working with had a dilemma with one of their search queries.  A query … Continue reading Aggregating With Correlated Sub-Queries #tsql2sday

Can You Dig It? – Plan Cache Series

A few PASS Summit’s ago, I became interested in the information available in the Plan Cache.  As part of that interest, I started digging into the plan cache to  find out what is there and available to be pulled out. Some of those investigations led to a few presentations; which have in turn led to … Continue reading Can You Dig It? – Plan Cache Series