SQL Backup Compression and Backup Dedup are mortal enemies

If you have a modern tape backup solution you probably have some sort of dedup process in your backup environment.  What these deduplication processes do normally is look at the data which is being written to the backup platform and remove duplicate values in order to save space on the tape backup system. However if […]

What is faster SAN or DAS (local disk), and most importantly why?

So here’s an answer to the great myth of SAN, it isn’t always going to be faster than local disk (or DAS, JBOD, etc.).  The reason for this is actually pretty straight forward. Local disk is cheap.  That’s the reason in a nut shell.  Let me see if I can’t explain in a little more […]

DAS, NAS and SAN oh my.

In the server world we have three different kinds of storage available.  Today, only two of these can be used with your SQL Server (as long as you want to keep the SQL Server in a supportable configuration).  Your three options are Direct Attached Storage (DAS), Network Attached Storage (NAS) and Storage Area Network (SAN). […]