Wrox::Wrox Blox - Short Technical Articles and Code by Top Programmers

Wrox Blox : SQL Server

Browse the list below for all Wrox Blox titles related to SQL Server applications. Here's where you will find the most up-to-date technical expertise on a wide variety of SQL Server and related topics, including scripting SQL management objects (SMO), Windows PowerShell, database administration (DBA), and more. You can count on Wrox Blox to help build your SQL Server knowledge, today!

Wrox Blox Titles

Refine Listing by Topic:

All Titles	Microsoft Servers
ASP.NET	.NET
C#	SQL Server
General	Visual Basic
	Web

Scripting SQL Management Objects in Windows PowerShell

by Willis Johnson

January 2008, Wrox Blox PDF

This Wrox Blox shows how to communicate with SQL Server using SQL Management Objects instantiated on-the-fly in Windows PowerShell scripts. Topics include how to create Windows PowerShell scripts that use SQL Management Objects (SMO) to manage and program SQL Server. In addition, you will learn about areas of potential difficulty and see how to avoid them—for example, the use of '$' in instance name, ... Read More