I’m a SQL Server MVP and have been involved with SQL Server since 1995. I’ve also been working with multi-terabyte, high-transaction DBs since before they were popular. I'm a Contributing Editor and the sole database expert for InfoWorld Magazine which means I also touch DB2, Oracle, Sybase, and any other DB out there. I've also written for SQL Server Magazine, SQL Server Standard, SSWUG, and SQLServerCentral.com. At the magazine I concentrate on benchmarking vendor products, reviews, and industry analysis. I’m also the founder of MidnightDBA.com. I'm a very prolific speaker and teacher in my community and my 3 main areas of teaching are backups, SSIS, and powershell, though I can teach on a myriad of subjects.
Sean McCown Microsoft SQL MVP's Recent Posts
Recent January, 2011 Stories
Using PowerShell for changing job owners in SQL Server. Sean McCown demonstrates how PowerShell is a more efficient option than SSMS or T-SQL when changing job owners in bulk.
Sean McCown provides an overview of working with cmdlets in PowerShell. Covers how to run help on cmdlets, and search specific cmdlets to learn what's available in PowerShell, including the use of format-table and get-member to control how resulting information is displayed.
Overview of PowerShell basics by Sean McCown. PowerShell makes it possible for DBAs to easily manage multiple servers at once, often with very little coding. This article explains how PowerShell is organized, and how to get information about the different drives you work with.
Why Should DBAs Care About PowerShell? Sean McCown answers this question by demonstrating the simplicity of scripting in PowerShell, in contrast to T-SQL and VBScript, through a variety of real world examples.
Sean McCown builds upon past 2 PowerShell scripting articles (Scripting Database Objects in PowerShell & Scripting Database Objects with Advanced Options in PowerShell) to discuss how to build a scripting process which enables each object to be scripted to its own file.
Sean McCown takes us beyond the basics of scripting database objects in PowerShell. This article explains how to set advanced scripting options using SMO.
A step-by-step guide covering the basics of scripting database objects in PowerShell by Sean McCown. With PowerShell you can easily script all the objects in your database manually, or schedule the scripting anytime you'd like, and for as many of your servers as you'd like.
Sean McCown discusses moving database files in SQL Server with the Detach/Attach method. Includes discussion of restrictions and implications to be aware of when detaching a database.
Sean McCown discusses moving database files in SQL Server by taking the database offline, in his opinion on the simplest, most flexible, and least invasive method.
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.