SQL Server Data Compression (which was first introduced in SQL Server 2008, and is an Enterprise Edition only feature) lets you compress individual indexes with
Since someone asked me about this today, I thought I would write about it. Aaron Bertrand (blog|twitter) and I sort of have a friendly competition
On February 18, 2013, Microsoft released SQL Server 2008 R2 Service Pack 1 Cumulative Update 11, which is Build 10.50.2869. There are only four fixes
On February 18, 2013, Microsoft released SQL Server 2008 R2 Service Pack 2 Cumulative Update 5, which is Build 10.50.4276. There are 21 fixes in
As you may be aware if you have been reading my blogs or books over the years, I am a pretty strong advocate of staying
One necessary part of being a responsible DBA is to try to configure your SQL Server instances in such a manner so they will be
I recently had the opportunity to give a one hour presentation called Hardware 101: An Introduction to Database Hardware during the evening, after a full
If you are in charge of one or more SQL Server instances, whether they are on your laptop, or a large Production data center, you
Imagine that you are using synchronous database mirroring with SQL Server 2005, SQL Server 2008, SQL Server 2008 R2 or SQL Server 2012 Standard Edition.
With training and consulting from SQLskills, you’ll be able to solve big problems, elevate your team’s capacity, and take control of your data career.