T-SQL Tuesday: Giving back in 2015

          My friend Wayne Sheffield (b|t)is hosting T-SQL Tuesday this month and it’s been a long time since I’ve taken part (wow – since January 2011!). His theme is about how you’re going to give back or continue giving back to the SQL Server community in 2015. I’m going to talk about […]

T-SQL Tuesday #14: Resolutions – continue having fun

  This month's T-SQL Tuesday is being run by newly-minted fellow-MVP Jen McCown (blog|twitter) and the topic is about resolutions. And specifically about resolutions around technology you've been pondering. One of the things I try very hard to do is make it a bit fun when teaching people about SQL Server. Let's face it, it's a very, very […]

T-SQL Tuesday #012 : Summary of why DBA skills are necessary

Last Tuesday I hosted T-SQL Tuesday #012 (see here for the call for participation) and posed the question "why are DBA skills necessary?" This month broke the participation record with 46 people contributing posts – fabulous! Lots of people contributed for the first time too. And what I think is also really cool is that 45 […]

Invitation to participate in T-SQL Tuesday #12 – Why are DBA skills necessary?

In November we're doing T-SQL Tuesday a week early (Tuesday November 2nd) so that it doesn't clash with PASS and I'll be your host! What is T-SQL Tuesday? If you haven't seen it yet, T-SQL Tuesday is the brain-child of fellow-MVP Adam Machanic (blog|twitter). It happens once a month on the 2nd Tuesday (different this month) and […]

T-SQL Tuesday #11: Misconceptions about…. EVERYTHING!!

This month's T-SQL Tuesday is being run by fellow-MVP Sankar Reddy (blog|twitter) and the topic is about Misconceptions in SQL Server. (Check out the 60-page PDF with all the myths and misconceptions blog posts collected together: CommonSQLServerMyths.pdf (732.96 kb)) Back in April I spent an entire month doing a DBA-Myth-A-Day series once a day which was […]

T-SQL Tuesday #008: Top ten mistakes to make when attending a class

Every month there's a flurry of blog posts around the same topic – it's called T-SQL Tuesday and is a neat concept. This month it's being driven by Robert Davis (blog|twitter), who I had the pleasure of teaching in the March rotation of the Microsoft Certified Master – SQL class (he passed first time) and […]

Inside sys.dm_db_index_physical_stats

Way back in the mists of time, at the end of the last century, I wrote DBCC SHOWCONTIG for SQL Server 2000, to complement my new invention DBCC INDEXDEFRAG. I also used to wear shorts all the time, with luminous orange, yellow, or green socks. Many things change – I now have (some) dress sense, […]