{"id":648,"date":"2006-04-10T05:53:00","date_gmt":"2006-04-10T05:53:00","guid":{"rendered":"\/blogs\/kimberly\/post\/TechNet-Webcast-Series-for-the-ITPro-Part-5-of-11.aspx"},"modified":"2013-01-11T23:12:39","modified_gmt":"2013-01-12T07:12:39","slug":"technet-webcast-series-for-the-itpro-part-5-of-11","status":"publish","type":"post","link":"https:\/\/www.sqlskills.com\/blogs\/kimberly\/technet-webcast-series-for-the-itpro-part-5-of-11\/","title":{"rendered":"TechNet Webcast Series for the ITPro &#8211; Part 5 of 11"},"content":{"rendered":"<p>\nWell, Friday brought another flood of great questions from everyone as we moved our way through many of the new 2005 tools. The one thing that I really wanted to stress was that *many* SQL Server 2005 tools (SQLCMD, SSMS and SQL Profiler) offer important features that can be leveraged today, even if your primary production servers are still SQL Server 2000. I did move through the tools quickly and showed quite a few new features; there are a lot of excellent resources to help you dive in deeper now that you&#39;re interested, ready and know some of the rewards of starting now. Here are a few of those resources:\n<\/p>\n<ul>\n<li>My Blog entry: <a href=\"https:\/\/www.sqlskills.com\/blogs\/kimberly\/sql-server-2005-tools-resources-to-effectively-use-sqlcmd\/\">SQL Server 2005 Tools &#8211; Resources to Effectively use SQLCMD<\/a>&nbsp;this includes a few additional links but most importantly, links to the TechNet webcast: Scripting in SQL Server 2005, by Michiel Wories. <\/li>\n<li>TechNet webcast: <a href=\"https:\/\/msevents.microsoft.com\/cui\/EventDetail.aspx?culture=en-US&amp;EventId=1032290603&amp;CountryCode=US\">Manage SQL Server 2005 Using Command Line Tools and the SQLCMD Utility<\/a> by Ramesh Singh.&nbsp; <\/li>\n<li>TechNet Webcast: <a href=\"https:\/\/msevents.microsoft.com\/cui\/Error.aspx?culture=en-US&amp;ErrorMsgID=ErrorMessage.EventDoesNotExist&amp;EventID=\">Administration Tools<\/a> <\/li>\n<li>TechNet Webcsat: <a href=\"https:\/\/msevents.microsoft.com\/cui\/Error.aspx?culture=en-US&amp;ErrorMsgID=ErrorMessage.EventDoesNotExist&amp;EventID=\">Monitoring Tools<\/a> <\/li>\n<li>And &#8211; checkout the large number of related &quot;on-demand&quot; webcasts here: <a href=\"https:\/\/msevents.microsoft.com\/cui\/default.aspx?culture=en-US&amp;community=1\">http:\/\/www.microsoft.com\/events\/series\/technetsqlserver2005.mspx<\/a><\/li>\n<\/ul>\n<p>\nFor deleting old database backup history, there are a couple of stored procedures in msdb that can be used:\n<\/p>\n<ul>\n<li>sp_delete_backup_and_restore_history <\/li>\n<li>sp_delete_backuphistory <\/li>\n<li>sp_delete_database_backuphistory<\/li>\n<\/ul>\n<p>\nFor cycling errorlogs, use: sp_cycle_errorlog.\n<\/p>\n<p>\nAnd &#8211; lots of other questions that I primarily answered online in the last&nbsp;40+ minutes. We had a great group and I hope everyone had fun. For the second half+ of the series we&#39;re going to focus on architectures and solutions &#8211; mostly related to disaster recovery and avoidance. However, the next part of the series is going to branch into a new (and *very* interesting) area of SQL Server 2005 &#8211; Service Broker. There are many impacts of Service Broker on the SQL Server system AND you might find a few applications of the technology within your own application as well. Have a great time with <a href=\"http:\/\/www.SQLskills.com\/blogs\/bobb\/\" class=\"broken_link\">Bob<\/a> for <a href=\"https:\/\/msevents.microsoft.com\/cui\/EventDetail.aspx?culture=en-US&amp;EventID=1032290571&amp;CountryCode=US\">part 6<\/a> and I&#39;ll be back for <a href=\"https:\/\/msevents.microsoft.com\/cui\/EventDetail.aspx?culture=en-US&amp;EventID=1032290563&amp;CountryCode=US\">part 7<\/a> next Friday.\n<\/p>\n<p>\nSee you soon!<br \/>\nkt<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Well, Friday brought another flood of great questions from everyone as we moved our way through many of the new 2005 tools. The one thing that I really wanted to stress was that *many* SQL Server 2005 tools (SQLCMD, SSMS and SQL Profiler) offer important features that can be leveraged today, even if your primary [&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,74,78],"tags":[],"class_list":["post-648","post","type-post","status-publish","format-standard","hentry","category-events","category-resources","category-sql-server-2005","category-technet-webcasts","category-tips"],"_links":{"self":[{"href":"https:\/\/www.sqlskills.com\/blogs\/kimberly\/wp-json\/wp\/v2\/posts\/648","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=648"}],"version-history":[{"count":0,"href":"https:\/\/www.sqlskills.com\/blogs\/kimberly\/wp-json\/wp\/v2\/posts\/648\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.sqlskills.com\/blogs\/kimberly\/wp-json\/wp\/v2\/media?parent=648"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.sqlskills.com\/blogs\/kimberly\/wp-json\/wp\/v2\/categories?post=648"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.sqlskills.com\/blogs\/kimberly\/wp-json\/wp\/v2\/tags?post=648"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}