SQL Server

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 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.

Jennifer McCown covers the basics of indexing in SQL Server, one of the most effective and essential elements to an efficient database system.

In this installment of this SQL Server Reporting Services series, Jennifer McCown covers creating, formatting, and exporting SSRS reports.

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.

Jennifer McCown provides an introduction to SQL Server Integration Services (SSIS), with an emphasis on the SSIS development environment. SSIS is Microsoft’s full feature extract-transform-load (ETL) tool in SQL Server 2005, 2008, and R2.

SQL Server Profiler is a flexible profiling tool that comes with SQL Server. In this article, Jennifer McCown introduces the tool and details how to begin tracing database activity in your environment.

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.