Sean McCown Microsoft SQL MVP

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.

Designing a backup strategy in SQL is fairly straightforward, but it can get complicated when you’ve got a lot of moving pieces in your scenario. Sean McCown, Microsoft SQL MVP, takes the readers through the “best” practices to follow.

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.