Moving Tables that use Partitioning and Compression Across File Groups

Never an Infinite Loop Around When You Need One

You may be thinking, “You’re a DBA. I thought DBAs hated infinite loops.” Well, you’re right, most of the time....

Back to iOS from Android

I pre-ordered a Samsung Galaxy S4 last spring, after listening to my wife talk about how much happier she was...

#TribalAwards with RedGate!

You know what? You’re doing a good job. You’re reading blogs, and that’s generally the sign of a person wanting...

Last Weeks Top “Reading” Links #61

Monday morning and it’s time for weekly round-up.  If you follow me on twitter (@StrateSQL), you’ll know that throughout the day I tweet...

Undocumented functionality in FORMATMESSAGE

I was reading a rather interesting post on stackexchange “Why is % a forbidden char in a THROW message?” (which is...

Interviews with Brent Ozar, Adam Machanic and Denny Cherry for SQL Server Radio

While in SQLRally Amsterdam, I had the honor to interview Brent Ozar (blog | twitter), Adam Machanic (blog | twitter) and Denny Cherry (blog | twitter)...

Don’t Get Slimed By Bad Parameter Sniffing

Listen! Do you smell something? Are you suffering from random, unexplained slowdowns? Users complaining about queries that sometimes run fast,...

SSAS – Setting Attributes as Properties for Excel

When a user is browsing your cube with excel they may not understand how to slice the data and end...

SQL Server Training in London this Christmas

If you are thinking of upgrading to SQL Server 2012 in the near future then why not join me in...