-
Top load balancing methods for SQL Server
There are a number of way to achieve load distribution in SQL Server environments. Learn about some of the key methods, including merge replication, log shipping and SSAS server farm deployment.29 Jun 2009
-
Performance implications of transaction log autogrowth in SQL Server
Take a closer look at the performance implications of shrinking transaction log files in SQL Server.25 Jun 2009
-
The keys to database backup protection for SQL Server
There is a lot more to database backup than simply saving your info to a disk. Learn the steps that must be taken after the backup process to ensure that you and your database are 100% protected.22 Jun 2009
-
Ensuring high availability of SSAS databases
In part three of this series, Baya Dewald hones in on the administrative side of SQL Server Analysis Services, with details on the various methods on high availability for SSAS.17 Jun 2009
-
Maintaining high availability of SQL Server virtual machines
Learn to take advantage of Hyper-V and Windows 2008 in order to achieve fault-tolerant and highly available SQL Server virtual machines.15 Jun 2009
-
The short course on how SQL Server really works
Have you found yourself in the uncomfortable role of DBA simply because there's no one else to do the job? This series is for you. In part one, learn the basics of how data moves from disk to memor...10 Jun 2009
-
Understanding transparent data encryption in SQL Server 2008
Transparent data encryption can go a long way toward meeting compliance and security standards. Learn what TDE can do for you, with details on the considerations that should be made before it's imp...09 Jun 2009
-
Creating fault-tolerant SQL Server installations
Several fault-tolerance configuration options are available with SQL Server 2008, from the traditional (failover clustering) to the updated (database mirroring).03 Jun 2009
-
Working with sparse columns in SQL Server 2008
Sparse columns can provide significant storage benefits to those working with SQL Server 2008. Learn the proper way to implement sparse columns, as well as column sets and filtered indexes.02 Jun 2009