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

Because SQL Server manages security identifiers (SIDs) for any user logging into SQL Server, you risk "orphaning" users when you do a restore. It's a common problem, and here's why. Typically, ...

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