Esoteric

Now that SQL Server 2008 SP1 is released (download link here ), it is time to test a very interesting capability: Service Pack slipstreaming. That means that you can save some time by doing an 'integrated' installation of SQL 2008 which includes the SP1 Read More...

Here's a quick checklist before you install an instance of SQL Server on a failover cluster; or any service pack or hotfix for an instance. Following this list should eliminate 90% of the most common causes of setup failure. Please note that this checklist Read More...

Recently a colleague asked me if there were any changes specific to Windows Server 2008 which allow SQL Server (clustered instance) to listen on multiple subnets. There was only one change in Windows 2008 to my knowledge (which I have detailed in this Read More...

Overview Many a time, we are asked by customers about the effect of overlapping backup schedules: for example, whether they can backup the transaction log at the same time that a long-running complete backup of the database is taking place. Books Online Read More...

One of the most exciting new features in SQL Server 2005 is DB Mirroring. Now that Service Pack 1 is released, we officially support this feature. A really useful resource to understand the options available in using this feature and their pros / cons Read More...