{"id":677,"date":"2005-06-23T19:17:25","date_gmt":"2005-06-23T19:17:25","guid":{"rendered":"\/blogs\/kimberly\/post\/SQL-Server-2005-Tools-Resources-to-effectively-use-SQLCMD.aspx"},"modified":"2013-01-02T07:06:53","modified_gmt":"2013-01-02T15:06:53","slug":"sql-server-2005-tools-resources-to-effectively-use-sqlcmd","status":"publish","type":"post","link":"https:\/\/www.sqlskills.com\/blogs\/kimberly\/sql-server-2005-tools-resources-to-effectively-use-sqlcmd\/","title":{"rendered":"SQL Server 2005 Tools &#8211; Resources to effectively use SQLCMD"},"content":{"rendered":"<p><P>On Tuesday, June 21, I had the pleasure of assisting on a TechNet webcast delivered by Michiel Wories &#8211; 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&#8217;ll probably learn more if you just watch the webcast! Below are a bunch of resources related to SQLCMD, I hope you enjoy.<\/P><br \/>\n<P>Michiel Wories webcast titled: <a href=\"http:\/\/www.microsoft.com\/events\/EventDetails.aspx?CMTYSvcSource=MSCOMMedia&amp;Params=%7eCMTYDataSvcParams%5e%7earg+Name%3d%22ID%22+Value%3d%221032275435%22\/%5e%7earg+Name%3d%22ProviderID%22+Value%3d%22A6B43178-497C-4225-BA42-DF595171F04C%22\/%5e%7earg+Name%3d%22lang%22+Value%3d%22en%22\/%5e%7earg+Name%3d%22cr%22+Value%3d%22US%22\/%5e%7esParams%5e%7e\/sParams%5e%7e\/CMTYDataSvcParams%5e\" class=\"broken_link\">Scripting in Microsoft SQL Server 2005 (Level 300)<\/a><BR>Michiel Wories blog entry with all of his webcast demo scripts: <a href=\"http:\/\/blogs.msdn.com\/msgs\/?messageid=9\" class=\"broken_link\">http:\/\/blogs.msdn.com\/mwories\/archive\/2005\/06\/21\/scripting_webcast.aspx<\/a><\/P><br \/>\n<P>As for additional resources:<BR>I&#8217;ve written a couple of blog entries that related to new SQL Server 2005 tools and specifically SQLCMD here:<BR>&nbsp;&nbsp;&nbsp;&nbsp; <a href=\"https:\/\/www.sqlskills.com\/blogs\/kimberly\/permalink.aspx?guid=edcbec05-a111-49c6-af33-10b2d34981bb\">SQL Server 2005 &#8211; Management Studio Scripting Options and SQLCMD (loving it!)<\/a><BR>Click <a href=\"https:\/\/www.sqlskills.com\/blogs\/kimberly\/categoryview.aspx?category=SQL%20Server%202005\">here<\/a> for the full group of my SQL Server 2005 blog entries.<\/P><br \/>\n<P>Click <a href=\"https:\/\/msevents.microsoft.com\/cui\/default.aspx?culture=en-US&amp;community=1\">here<\/a> for the full list of all TechNet on-demand webcasts.<\/P><br \/>\n<P>Click <a href=\"https:\/\/msevents.microsoft.com\/cui\/default.aspx?culture=en-US&amp;community=1\">here<\/a> for the list of &#8220;Get Ready for SQL Server 2005&#8221; resources!<\/P><br \/>\n<P>Last but not least, here are the blogs of the other MVP&#8217;s&nbsp;who helped answer questions during the SQLCMD session &#8211; lots of great stuff to keep reading!<BR><a href=\"http:\/\/public-api.wordpress.com\/wls\/redirect.php?alias=drsql\" class=\"broken_link\">Louis Davidson<\/a>, <a href=\"http:\/\/users.drew.edu\/skass\/\">Steve Kass<\/a>&nbsp;and <a href=\"http:\/\/www.drdobbs.com\/database\/\" class=\"broken_link\">Kent Tegels<\/a><BR><\/P><\/p>\n","protected":false},"excerpt":{"rendered":"<p>On Tuesday, June 21, I had the pleasure of assisting on a TechNet webcast delivered by Michiel Wories &#8211; 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 [&hellip;]<\/p>\n","protected":false},"author":7,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[27,58,65],"tags":[],"class_list":["post-677","post","type-post","status-publish","format-standard","hentry","category-events","category-resources","category-sql-server-2005"],"_links":{"self":[{"href":"https:\/\/www.sqlskills.com\/blogs\/kimberly\/wp-json\/wp\/v2\/posts\/677","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.sqlskills.com\/blogs\/kimberly\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.sqlskills.com\/blogs\/kimberly\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.sqlskills.com\/blogs\/kimberly\/wp-json\/wp\/v2\/users\/7"}],"replies":[{"embeddable":true,"href":"https:\/\/www.sqlskills.com\/blogs\/kimberly\/wp-json\/wp\/v2\/comments?post=677"}],"version-history":[{"count":0,"href":"https:\/\/www.sqlskills.com\/blogs\/kimberly\/wp-json\/wp\/v2\/posts\/677\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.sqlskills.com\/blogs\/kimberly\/wp-json\/wp\/v2\/media?parent=677"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.sqlskills.com\/blogs\/kimberly\/wp-json\/wp\/v2\/categories?post=677"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.sqlskills.com\/blogs\/kimberly\/wp-json\/wp\/v2\/tags?post=677"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}