THE SQL Server Blog Spot on the Web

Welcome to SQLblog.com - The SQL Server blog spot on the web Sign in | |
in Search

Allen White

[Speaking] Scripting SQL Server Objects with PowerShell

In conjunction with the launch of Red Gate's SQL Source Control product, I'm presenting a webinar on Thursday, November 18 at noon EST. I'll present an introduction to PowerShell for those who've never seen it, walk through the basics of the SQL Server SMO Object Model, so you can see how SQL Server organizes all it's objects, then show you a script which will walk through that object model and create T-SQL scripts of all the objects in a database.

These scripts can then be your basis for your source control management of your database, which will help you keep control of your production environment, and allow you to quickly recover from inadvertent changes.

Register for the free webinar at https://www2.gotomeeting.com/register/183163170, and all registrants are eligible for a $99 licence for SQL Source Control.

See you there!

Allen

Published Wednesday, November 17, 2010 9:21 AM by AllenMWhite
Filed under: , ,

Comment Notification

If you would like to receive an email when updates are made to this post, please register here

Subscribe to this post's comments using RSS

Comments

 

Grant Fritchey said:

Excellent! You made a fantastic script AND you've got presentations out of it. YOU DA' MAN!

November 17, 2010 9:14 PM
 

pzhu said:

I wonder if it was recorded.

November 22, 2010 4:32 PM

Leave a Comment

(required) 
(required) 
Submit

About AllenMWhite

Allen White is a consultant and mentor for Upsearch Technology Services in Northeast Ohio. He has worked as a Database Administrator, Architect and Developer for over 30 years, supporting both the Sybase and Microsoft SQL Server platforms over that period.

This Blog

Syndication

Powered by Community Server (Commercial Edition), by Telligent Systems
  Privacy Statement