One of the cool features introduced in SQL Server 2014 was the ability to perform an online index rebuild of a single partition. Prior to SQL Server 2014, the only way to rebuild indexes for a partitioned table was to do it on all of the partitions (or, simply put, rebuild the entire index on […]
Back in 2009, a friend of mine asked why we decided to move to Canada despite the 2008 financial crisis that hit North America. To which I replied, “There really is no such thing as a job security. That in itself is a myth.” Now, I don’t want to sound negative here but that statement was […]
But I’ll tell you what hermits realize. If you go off into a far, far forest and get very quiet, you’ll come to understand that you’re connected with everything. – Alan Watts – WARNING: There will be a ton of acronyms in this blog post. Make sure to keep your notebook handy for note-taking reference. […]
I like writing step-by-step guides because they make good documentation for folks like me who keep forgetting how to do things. The guide makes the process repeatable and can easily be shared with junior members of your team. But with the different ways we consume information nowadays, written documentation does not suffice anymore. Besides, providing different […]
This is a question that I regularly ask those attending my high availability and disaster recovery presentations: is your SQL Server Always On Availability Group really highly available? Now, don’t get me wrong. I love the Always On Availability Groups feature in SQL Server (except for the price tag of an Enterprise Edition license.) But there’s […]