Sean McCown Microsoft SQL MVP

This is one of those database topics that sounds really easy on its face but can be tricky in practice. The issue is how to gain exclusive access to a database so you can perform operations like taking it offline, etc. MVP Sean McCown explains what’s involved and the benefits of each method.

While a SQL Server 2008 installation is fairly straight forward, a little planning and background knowledge can ensure the a successful install. Microsoft SQL MVP Sean McCown shares his insight with the readers.

Sean McCown, Microsoft SQL MVP, offers valuable insight on using Perfmon to determine if database slowness is being caused by SQL issues.

It’s a common misconception that you will get a performance gain by using several log files. Although this is something we see quite often, Sean McCown, Microsoft SQL MVP, show us how it simply isn’t true.

In SQL Server 2008 there are 3 recovery models you can use: simple, bulk-logged, and full. These recovery models really just define how log management behaves so you can have what you need to perform your desired backups.

Microsoft SQL MVP Sean McCown outlines the steps to follow in order to uncover the queries causing SQL database slowness.

Microsoft SQL MVP, Sean McCown, takes us through the pros and cons of using Windows authentication vs SQL and Windows Authentication when installing an SQL server 2008.

Important insight on managing large numbers of files in SQL from Microsoft SQL MVP, Sean McCown.