{"id":639,"date":"2006-05-22T04:29:43","date_gmt":"2006-05-22T04:29:43","guid":{"rendered":"\/blogs\/kimberly\/post\/TechNet-Webcast-Series-for-the-ITPro-Part-11-of-11.aspx"},"modified":"2013-01-02T06:59:17","modified_gmt":"2013-01-02T14:59:17","slug":"technet-webcast-series-for-the-itpro-part-11-of-11","status":"publish","type":"post","link":"https:\/\/www.sqlskills.com\/blogs\/kimberly\/technet-webcast-series-for-the-itpro-part-11-of-11\/","title":{"rendered":"TechNet Webcast Series for the ITPro &#8211; Part 11 of 11"},"content":{"rendered":"<p><P>Well&#8230; 11 of 11 has completed. Friday was our last chat &#8211; until next time ;). It was a summary event where I took a slightly different spin on things focusing on grouping technologies by the amount of effort that&#8217;s needed to implement them. Simply put, we looked at the technologies in order of what gives you the biggest bang for the buck. We ended the session with a ton of great questions (as always!) and there was even a question on the origin of <a href=\"http:\/\/searchcio-midmarket.techtarget.com\/definition\/foo\" class=\"broken_link\">foo<\/a>&nbsp;(make sure to also see <a href=\"http:\/\/whatis.techtarget.com\/definition\/FUBAR\">fubar<\/a>).<\/P><br \/>\n<P>First, there were a few links that I wanted to provide from the session, I&#8217;ll start with those:<\/P><br \/>\n<UL><br \/>\n<LI>Demo Script on SQL Injection and using QUOTENAME to prevent SOME forms of injection: <a href=\"https:\/\/www.sqlskills.com\/blogs\/kimberly\/content\/binary\/sqlinjection.sql\">SQLInjection.sql (3.59 KB)<\/a><br \/>\n<LI>TempDB Optimizations referenced in other blog entries: <a href=\"https:\/\/www.sqlskills.com\/blogs\/kimberly\/commentview.aspx?guid=934f3755-5b1d-4572-a386-c6a2a0d14a9e\">8 Steps to Better Transaction Log Throughput<\/a>&nbsp;and <a href=\"https:\/\/www.sqlskills.com\/blogs\/kimberly\/permalink.aspx?guid=8be9d388-b354-429f-8c98-e45989a4bebe\">Understanding TempDB, table variables v. temp tables and Improving throughput for TempDB<\/a><\/LI><\/UL><br \/>\n<P>And, we also talked about Migrations:<\/P><br \/>\n<UL><br \/>\n<LI><a href=\"http:\/\/www.microsoft.com\/sqlserver\/en\/us\/default.aspx\">SQL Server Migration Assistant for Oracle V2.0<\/a>,<br \/>\n<LI><a href=\"http:\/\/technet.microsoft.com\/library\/bb497059\">Solution Guide for Migrating Oracle on Unix to SQL Server on Windows<\/a><br \/>\n<LI>SQL Server Migration Assistant for Access &#8211; CTP1 released in May 2006 (<a href=\"https:\/\/www.sqlskills.com\/blogs\/kimberly\/permalink.aspx?guid=85049abf-ba04-49bd-8338-6f8c0f8a960b\">read this blog entry for details<\/a>)<br \/>\n<LI>SQL Server Migration Assistant for Sybase &#8211; CTP1 released in May 2006 (<a href=\"https:\/\/www.sqlskills.com\/blogs\/kimberly\/permalink.aspx?guid=85049abf-ba04-49bd-8338-6f8c0f8a960b\">read this blog entry for details<\/a>)<br \/>\n<LI><a href=\"http:\/\/www.microsoft.com\/sqlserver\/en\/us\/default.aspx\">Migrate to SQL Server with a<STRONG> (limited time offer) <\/STRONG>discount of up to 50%<\/a><\/LI><\/UL><br \/>\n<P>Finally, capacity planning:<\/P><br \/>\n<OL><br \/>\n<LI>Calculate the amount of space needed for your tables (calculate this as rows per page and then required pages as MB)<br \/>\n<LI>Calculate the amount of space needed for your indexes (you can use sp_spaceused to get a current ratio of index to data and then use that OR you can estimate 1-3times your current data in indexes&#8230;yes, if you have 10GB of tables &#8211; you should estimate 10-30GB for indexes)<br \/>\n<LI>Calculate in your estimate on future growth<br \/>\n<LI>Take your single largest table and multiply by 1.5 for free space. (Use 2.5 IF you&#8217;re going to use ONLINE index operations). So, if the single largest table is 3GB then I&#8217;d add 7-8GB for free space)<br \/>\n<LI>Add a &#8220;just in case&#8221; extra 10-20%<br \/>\n<LI>And, I didn&#8217;t mention this BUT you should also include alerts to help you monitor space usage and significant changes to your free space!<\/LI><\/OL><br \/>\n<P>And that wraps up the series. Wow &#8211; I can&#8217;t believe how many of you joined in for questions as well as stayed on until the end. It&#8217;s really great that so many of you are still having fun with SQL Server as well. I look forward to another series with you&#8230;at some point! In the interim, here are a few places where I&#8217;ll be:<\/P><br \/>\n<UL><br \/>\n<LI><A href=\"http:\/\/www.dotnetrocks.com\/\">DotNetRocks<\/A> &#8211; Friday, May 26, 2006 &#8211; 15:00-17:00 Pacific Time<br \/>\n<LI><a href=\"http:\/\/northamerica.msteched.com\/\" class=\"broken_link\">Microsoft Tech Ed<\/a> in Boston, MA &#8211; June 11-16, 2006. NOTE: The event is sold out HOWEVER, you can still attend pre-conference workshops and <a href=\"http:\/\/channel9.msdn.com\/Events\/TechEd\">ours<\/a> will definitely be intense, informative and fun! The abstract is lame but the content is all about designing production systems for performance, reliability, manageability and useability.<br \/>\n<LI>Immersion Event <a href=\"http:\/\/www.trivadis.com\/speziell\/notfound.html?redirect_url=%2Ftraining%2FKursdetail.aspx%3FKategorieID%3D6%26SubkategorieID%3D46%26KurseID%3D272\" class=\"broken_link\">&#8220;Indexing for Performance&#8221;<\/a> with <a href=\"http:\/\/www.trivadis.com\/speziell\/notfound.html?redirect_url=%2Fd%2F\" class=\"broken_link\">Trivadis<\/a> in Zurich, Switzerland &#8211; June 26-27, 2006<br \/>\n<LI><a href=\"http:\/\/www.microsoft.com\">Microsoft Tech Ed for Developers<\/a> in Barcelona, Spain in November 2006<br \/>\n<LI><a href=\"http:\/\/www.sqlconnections.com\/shows\/sqlfall2006\/default.asp?s=84&amp;refer=\" class=\"broken_link\">SQL Connections<\/a> in Las Vegas, NV in November 2006<br \/>\n<LI><a href=\"http:\/\/www.microsoft.com\">Microsoft Tech Ed for ITProfessionals<\/a> in Barcelona, Spain in November 2006<\/LI><\/UL><br \/>\n<P>SQLskills Immersion Events &#8211; in the US&#8230; will be announced shortly. The BEST place to be when we announce the dates for these events is a subscriber on SQLskills. Subscribing is FREE and the announcements are going to be later this month. Here&#8217;s a link to directly subscribe on SQLskills: <A href=\"https:\/\/www.sqlskills.com\/login.aspx\">https:\/\/www.sqlskills.com\/login.aspx<\/A>.<\/P><br \/>\n<P>Thanks again for attending the series! It was great fun. I&#8217;ll post a final blog entry with ALL of the links as well as all of the survey links. I know that they&#8217;re going to send me these so that you can get easier access to them.<\/P><br \/>\n<P>See you next time,<BR>kt<\/P><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Well&#8230; 11 of 11 has completed. Friday was our last chat &#8211; until next time ;). It was a summary event where I took a slightly different spin on things focusing on grouping technologies by the amount of effort that&#8217;s needed to implement them. Simply put, we looked at the technologies in order of what [&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-639","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\/639","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=639"}],"version-history":[{"count":0,"href":"https:\/\/www.sqlskills.com\/blogs\/kimberly\/wp-json\/wp\/v2\/posts\/639\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.sqlskills.com\/blogs\/kimberly\/wp-json\/wp\/v2\/media?parent=639"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.sqlskills.com\/blogs\/kimberly\/wp-json\/wp\/v2\/categories?post=639"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.sqlskills.com\/blogs\/kimberly\/wp-json\/wp\/v2\/tags?post=639"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}