On Tuesday, June 21, I had the pleasure of assisting on a TechNet webcast delivered by Michiel Wories – a Program Manager from the SQL Server Development Team at Microsoft. My assistance was limited as I really just listened and helped answer some of the questions that came up during the session. In fact, there were a few of us fielding questions and in general, there seems to be a lot of excitement around this new tool. The focus of the webcast was a new utitlity called SQLCMD. SQLCMD is a command-line tool that replaces OSQL and allows a lot of new functionality, such as: parameterization, access to environment variables, complex scripts that connect and execute against multiple servers, MUCH better code page support, input scripts, output scripts and error handling within scripts. Well, you’ll probably learn more if you just watch the webcast! Below are a bunch of resources related to SQLCMD, I hope you enjoy.
Michiel Wories webcast titled: Scripting in Microsoft SQL Server 2005 (Level 300)
Michiel Wories blog entry with all of his webcast demo scripts: http://blogs.msdn.com/mwories/archive/2005/06/21/scripting_webcast.aspx
As for additional resources:
I’ve written a couple of blog entries that related to new SQL Server 2005 tools and specifically SQLCMD here:
SQL Server 2005 – Management Studio Scripting Options and SQLCMD (loving it!)
Click here for the full group of my SQL Server 2005 blog entries.
Click here for the full list of all TechNet on-demand webcasts.
Click here for the list of “Get Ready for SQL Server 2005” resources!