If you’ve used SQL Server 2008 Management Studio (SSMS 2008), you may have noticed that Microsoft added a pretty neat little feature when looking at Execution Plans, the Missing Index message. This subtle message may appear when you’re looking at either the Actual or Estimated Query Execution Plan in graphical… Read more

Next week, I’ll be “in the cloud” as I give a presentation for the PASS DBA Virtual Chapter. The topic is SQL Server Locking & Blocking Made Simple. You can download the presentation materials here.

Join me from the comforts of your own home or office on February… Read more

Many organizations collect data, lots and lots of data. We have the opportunity and ability today to collect more data than ever before. The challenge is turning the massive amounts of data into usable and actionable information and putting that information into the hands of those who need it when… Read more

Small Business Ownership. It’s one of the Great American Dreams. Our forefathers, the founders of the country that I call home, were entrepreneurs. They were merchants, farmers, and woodworkers. Many, such as the blacksmiths and cobblers, were in the high tech industries of their times. And like those forefathers, the… Read more

For almost a year now, I’ve exchanged emails with the leaders of the Memphis SQL Server User Group, trying to find a time when our schedules would align themselves and I’d be able to join them for a meeting. After many attempts and several near misses, we’ve finally set… Read more