TSQL Tuesday #96: Folks Who Have Made a Difference

It’s been almost three years since I wrote a T-SQL Tuesday post (shame on me!), but this is one I definitely want to contribute to. It’s hosted by Ewald Cress and is about “the opportunity to give a shout-out to people (well-known or otherwise) who have made a meaningful contribution to your life in the world […]

Physical security

This month’s T-SQL Tuesday (hosted by Kenneth Fisher – @sqlstudent144) is about security This hasn’t been my area of expertise for a long time, although I did write a long TechNet Magazine article about common security issues and solutions back in 2009. There’s a huge amount that’s been written about implementing security in SQL Server and Windows – working towards […]

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, […]