2015 review: the year by the numbers

The last post of the year! It’s been a really excellent year all round and time for my traditional post counting down some of the numbers that have been my life this year. 109318: the number of miles I flew on United 33313: my current tweet total (up 1345 from 2014) 12941: the number of subscribers […]

2015: the year in books

Back in 2009 I started posting a summary at the end of the year of what I read during the year (see my posts from 2009, 2010, 2011, 2012, 2013, 2014) and people have been enjoying it, so here I present the 2015 end-of-year post. I set a moderate goal of 50 books this year and I managed […]

October 2016 Dublin IE1/IEPTO1 class open for registration

Through popular demand (our IEPTO2 class in Ireland in October 2015 sold out with 40 students!) we’ve managed to juggle a bit more of our schedule around and found space to fit in another European class in 2016, and it’s open for registration! Kimberly and I will be teaching our signature IEPTO-1 (formerly IE1) Immersion Event on Performance Tuning […]

SQLskills holiday gift to you: all 2014 Insider videos

As we all wind down for the 2015 holiday season, we want to give the SQL Server community a holiday gift to say ‘thank you’ for all your support during 2015, and what better gift than more free content?! As many of you know, I publish a bi-weekly newsletter to more than 13,000 subscribers that […]

Survey: tempdb file configuration (code to run)

I’m running this survey to help the SQL Server team at Microsoft, who would like to get a broad view of current tempdb configurations. I’ll editorialize the results as well in a week or two. Feel free to run the code below any way you want, and also add a single preceding column to the result […]

Data recovery: investigating weird SELECT failures around corruption

An interesting corruption problem cropped up on the MCM distribution list yesterday and after I figured it out, I thought it would make a good blog post in case anyone hits a similar problem. In a nutshell, the problem was corruption such that a simple SELECT * query failed, but a SELECT * query with […]