Using compression with SSMS is just as easy. Simply set the compression option on the Options page of the Back up Database dialog. You may be asking yourself: How effective is this compression? The ...

Now in SQL Server 2008, Transparent Data Encryption allows a DBA to encrypt an entire database without the need for any application code changes. In fact, all we need to do is set a database option ...

I have taught several classes on the new features of SQL Server 2008, made a Web Seminar and written a Whitepaper on the subject. I have also attended the SQL PASS Summit in Seattle where there were ...

For as long as I can remember, I have always configured the computers within my own organization to store data on network servers as opposed to the data being stored on workstations. That way, if one ...