SQL Server with Mr. Denny:

SQL University

1

March 25, 2011  2:00 PM

SQL Backup Compression and Backup Dedup are mortal enemies



Posted by: Denny Cherry
Backup & recovery, compression, SQL Server, SQL University, Storage

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...

March 23, 2011  2:00 PM

DAS, NAS and SAN oh my.



Posted by: Denny Cherry
SQL Server, SQL University, Storage

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...


March 22, 2011  2:00 PM

Why can’t I just use RAID 10 for everything?



Posted by: Denny Cherry
SQL Server, SQL University, Storage

In a perfect work, you would use RAID 10 for everything.  However we don't work in the perfect world, we have budgets to deal with.  And these budgets mean that we have to make sacrifices at times so we don't get what we want. RAID 10 is very expensive to implement, much more so per gig than...


March 21, 2011  2:00 PM

Expanding local storage with minimal downtime



Posted by: Denny Cherry
SQL Server, SQL University, Storage

Welcome to the first day of storage week of SQL University.  Over the next week, we'll be covering some different topics, at different levels, but hopefully the information is useful to everyone. One of the big reasons that companies pay for storage arrays is that when it comes to expanding...


1

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to: