{"id":506,"date":"2010-04-23T01:35:00","date_gmt":"2010-04-23T01:35:00","guid":{"rendered":"\/blogs\/kimberly\/post\/Public-classes-coming-up-in-Dublin-(including-prior-course-testimonials).aspx"},"modified":"2013-01-11T23:10:46","modified_gmt":"2013-01-12T07:10:46","slug":"public-classes-coming-up-in-dublin-including-prior-course-testimonials","status":"publish","type":"post","link":"https:\/\/www.sqlskills.com\/blogs\/kimberly\/public-classes-coming-up-in-dublin-including-prior-course-testimonials\/","title":{"rendered":"Public classes coming up in Dublin (including prior course testimonials)"},"content":{"rendered":"<p>\n<a href=\"http:\/\/www.SQLskills.com\/blogs\/paul\/\" target=\"_blank\">Paul<\/a> and I enjoyed Dublin so much in 2008 and 2009 that we&#39;re going back for two weeks this time &#8211; and teaching three classes while we&#39;re there! We&#39;ll be working with our fabulous friends (Carmel, Sandra, and Bob) at <a href=\"http:\/\/www.prodata.ie\/\">Prodata<\/a> and the event will be hosted by the nice folks at <a href=\"http:\/\/www.microsoft.com\/\">Microsoft Ireland<\/a>. We&#39;ll also be doing a user group presentation, as usual, and you can register for this on the <a href=\"http:\/\/mtug.ie\/Default.aspx?TabId=38&amp;ctl=Details&amp;Mid=369&amp;ItemID=54&amp;ContainerSrc=%5bG%5dContainers\/_default\/No+Container\" class=\"broken_link\">MTUG website<\/a>. Not sure what we&#39;ll talk about at the user group yet (probably SQL Server related :-) &#8211; suggestions?\n<\/p>\n<p>\nIf you register for any of the classes, be sure to use this special discount code &quot;KTB&quot; which gets you 5% off and we&#39;ll know you saw the class on my blog.\n<\/p>\n<p>\nWe decided to structure the first class as a 4-day version of our popular Immersion Event and the&nbsp;following week do two deeper classes focusing on performance and disaster recovery. And, even with as much content as we&#39;ve recorded and mentioned online, our &quot;live&quot; Immersion Events are more in-depth and interactive. You&#39;ll get a lot of information in a relatively short period of time and you&#39;ll be able to go back and immediately apply it. We base our content on what really works in production and what we&#39;ve learned from actual implementations\/architectures.\n<\/p>\n<p>\nWe&#39;ve taught several classes this year already and had rave reviews of the content, our knowledge, and presentation style. Check them out for yourself (with quotes extracted from their blog posts):\n<\/p>\n<ul>\n<li>\n<div>\n\tGreg Gonzalez, President and CEO of <a href=\"http:\/\/www.sqlsentry.com\/\" class=\"broken_link\">SQL Sentry<\/a>&nbsp;wrote a <a href=\"http:\/\/greg.blogs.sqlsentry.net\/2010\/04\/getting-immersed-in-sql-server.html\">long blog post<\/a> about the Immersion Event he attended in Boston in April:\n\t<\/div>\n<ul>\n<li>\n<div>\n\t\t<em>&quot;When it comes to the instructors themselves, Kimberly and Paul simply have no equal.&nbsp; Not only are they both ultimate authorities, but they have endless enthusiasm about the material, and spot on delivery.&nbsp; If either ever got tired they never showed it, even after going all day and all week.&nbsp; We witnessed countless demos over the course of the week, some extremely involved, multi-step processes, and I can&rsquo;t recall a one that didn&rsquo;t go the way it was supposed to.&quot;<\/em>\n\t\t<\/div>\n<\/li>\n<li>\n<div>\n\t\t<em>&quot;These are not beginner presenters, and they put an extreme amount of preparation and attention to detail into everything that they do.&nbsp; Completely, utterly professional.&quot;<\/em>\n\t\t<\/div>\n<\/li>\n<li>\n<div>\n\t\t<em>&quot;You might think that with this extreme level of skill comes extreme levels of egotism and lack of patience.&nbsp; Nothing could be further from the truth. &#8230; They simply know how to teach, and are approachable, humble, and patient.&quot;<\/em>\n\t\t<\/div>\n<\/li>\n<\/ul>\n<\/li>\n<li>\n<div>\n\tFellow-MVP Aaron Bertrand <a href=\"http:\/\/sqlblog.com\/blogs\/aaron_bertrand\/archive\/2010\/03\/31\/the-pros-and-cons-of-learning.aspx\" class=\"broken_link\">discussing the same Immersion Event<\/a>:\n\t<\/div>\n<ul>\n<li>\n<div>\n\t\t<em>&quot;The additional insight around what&#39;s printed in the book or in Books Online is invaluable; and the experience Paul and Kimberly have had with real live customers yields a lot more information and things to watch out for than you&#39;d ever get from the documentation alone.&quot;<\/em>\n\t\t<\/div>\n<\/li>\n<\/ul>\n<\/li>\n<li>\n<div>\n\tNewly-minted MCM Robert Davis of Microsoft&nbsp;<a href=\"http:\/\/www.sqlservercentral.com\/blogs\/robert_davis\/2010\/04\/10\/5-Random-Thoughts-on-the-SQL-Server-MCM-Program\/\">explaining how the previous training<\/a> he&#39;d received from us at Microsoft helped him pass his MCM certification (which we also teach):\n\t<\/div>\n<ul>\n<li>\n<div>\n\t\t<em>&quot;I try to take the SQLSkills classes when I can. I highly recommend to everyone that they take advantage of any training opportunities that they see from this group.&quot;<\/em>\n\t\t<\/div>\n<\/li>\n<\/ul>\n<\/li>\n<li>\n<div>\n\tNewly-minted MCM Brent Ozar of Quest <a href=\"http:\/\/www.brentozar.com\/archive\/2010\/03\/sql-mcm-one-week-down\/\">summing up the first week<\/a> of the recent MCM class that we taught:\n\t<\/div>\n<ul>\n<li>\n<div>\n\t\t<em>&quot;To call them good trainers is an epic understatement.&nbsp; They know how to deliver very, very technical material in ways that illustrate it well.&nbsp; I had to stop Paul at one point and ask him how long it took to build a particular slide because the animations were so good at conveying a hard-to-describe process.&quot;<\/em>\n\t\t<\/div>\n<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<p>\nWe also have a few testimonials and quotes from <a href=\"https:\/\/www.sqlskills.com\/pastcustomers.asp\">past customers<\/a> and finally, here&#39;s the <a href=\"https:\/\/www.sqlskills.com\/blogs\/kimberly\/content\/binary\/sqlimmersionirelandeventreport.pdf\">press release<\/a> from last year&#39;s class. Phew!\n<\/p>\n<p>\n<font size=\"+0\"><strong><u>4-Day&nbsp;Immersion Event, June 28-July 1 2010, Dublin, Ireland:<\/u> <\/strong>See the <a href=\"http:\/\/www.prodata.ie\/Events\/sqlimmersionDublin2010\/\" class=\"broken_link\">Prodata site<\/a> for full details and for registration links and options.\n<\/p>\n<blockquote>\n<p>\n\tDay 1: SQL Server Internals\n\t<\/p>\n<\/blockquote>\n<blockquote>\n<ul>\n<li>\n<div>\n\t\tOn-disk structures: how the data is stored\n\t\t<\/div>\n<ul>\n<li>\n<div>\n\t\t\tRecords, pages, allocation bitmaps\n\t\t\t<\/div>\n<\/li>\n<\/ul>\n<\/li>\n<li>\n<div>\n\t\tIndex internals: how the data is organized\n\t\t<\/div>\n<\/li>\n<li>\n<div>\n\t\tLogging and recovery: how the data is protected\n\t\t<\/div>\n<ul>\n<li>\n<div>\n\t\t\tWhat is logging?\n\t\t\t<\/div>\n<\/li>\n<li>\n<div>\n\t\t\tHow recovery works\n\t\t\t<\/div>\n<\/li>\n<li>\n<div>\n\t\t\tHow the transaction log is structured\n\t\t\t<\/div>\n<\/li>\n<li>\n<div>\n\t\t\tRecovery models&nbsp;\n\t\t\t<\/div>\n<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<p>\n\tDay 2: Designing for Performance\n\t<\/p>\n<ul>\n<li>\n<div>\n\t\tChoosing the RIGHT Data Type\n\t\t<\/div>\n<ul>\n<li>\n<div>\n\t\t\tUnderstanding data types\n\t\t\t<\/div>\n<\/li>\n<li>\n<div>\n\t\t\tCharacter data, overflow and LOB\n\t\t\t<\/div>\n<\/li>\n<li>\n<div>\n\t\t\tLOB considerations\n\t\t\t<\/div>\n<\/li>\n<li>\n<div>\n\t\t\tDate and time data types\n\t\t\t<\/div>\n<\/li>\n<li>\n<div>\n\t\t\tHeterogeneous data types\n\t\t\t<\/div>\n<\/li>\n<li>\n<div>\n\t\t\tSparse columns\n\t\t\t<\/div>\n<\/li>\n<li>\n<div>\n\t\t\tApplication inconsistencies in types\n\t\t\t<\/div>\n<\/li>\n<\/ul>\n<\/li>\n<li>\n<div>\n\t\tTable &amp; Index Partitioning Strategies\n\t\t<\/div>\n<ul>\n<li>\n<div>\n\t\t\tConcepts\/motivating factors in Partitioning\n\t\t\t<\/div>\n<\/li>\n<li>\n<div>\n\t\t\tSQL Server 2000+ Partitioned Views\n\t\t\t<\/div>\n<\/li>\n<li>\n<div>\n\t\t\tSQL Server 2005+ Partitioned Tables\n\t\t\t<\/div>\n<\/li>\n<li>\n<div>\n\t\t\tPartitioning Design Techniques Combined\n\t\t\t<\/div>\n<\/li>\n<li>\n<div>\n\t\t\tPartitioned and non-partitioned Indexes\n\t\t\t<\/div>\n<\/li>\n<li>\n<div>\n\t\t\tImplementing the Sliding Window Scenario\n\t\t\t<\/div>\n<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<p>\n\tDay 3: Indexing for Performance\n\t<\/p>\n<ul>\n<li>\n<div>\n\t\tData Access\n\t\t<\/div>\n<ul>\n<li>\n<div>\n\t\t\tData Access Patterns\n\t\t\t<\/div>\n<\/li>\n<li>\n<div>\n\t\t\tCovering\n\t\t\t<\/div>\n<\/li>\n<li>\n<div>\n\t\t\tUsing INCLUDE (SQL Server 2005+)\n\t\t\t<\/div>\n<\/li>\n<li>\n<div>\n\t\t\tUsing Filters (SQL Server 2008+)\n\t\t\t<\/div>\n<\/li>\n<\/ul>\n<\/li>\n<li>\n<div>\n\t\tIndexing Strategies\n\t\t<\/div>\n<ul>\n<li>\n<div>\n\t\t\tIndexing for AND\n\t\t\t<\/div>\n<\/li>\n<li>\n<div>\n\t\t\tIndexing for OR\n\t\t\t<\/div>\n<\/li>\n<li>\n<div>\n\t\t\tIndexing for Joins\n\t\t\t<\/div>\n<\/li>\n<li>\n<div>\n\t\t\tIndexing for Aggregates\n\t\t\t<\/div>\n<\/li>\n<li>\n<div>\n\t\t\tIndexed Views (Overview)\n\t\t\t<\/div>\n<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<p>\n\tDay 4: Essential Database Maintenance\n\t<\/p>\n<ul>\n<li>\n<div>\n\t\tData and log file provisioning and management\n\t\t<\/div>\n<ul>\n<li>\n<div>\n\t\t\tDatabase layout considerations\n\t\t\t<\/div>\n<\/li>\n<li>\n<div>\n\t\t\tGrowing and shrinking\n\t\t\t<\/div>\n<\/li>\n<li>\n<div>\n\t\t\tInstant initialization\n\t\t\t<\/div>\n<\/li>\n<\/ul>\n<\/li>\n<li>\n<div>\n\t\tTempdb\n\t\t<\/div>\n<\/li>\n<li>\n<div>\n\t\tIndex and statistics maintenance\n\t\t<\/div>\n<\/li>\n<li>\n<div>\n\t\tUsing backup and restore\n\t\t<\/div>\n<\/li>\n<li>\n<div>\n\t\tConsistency checking\n\t\t<\/div>\n<\/li>\n<\/ul>\n<\/blockquote>\n<p>\n<font size=\"+0\"><strong><u>Performance Optimization Masterclass, July 5-6 2010, Dublin, Ireland:<\/u><\/strong> See the <a href=\"http:\/\/www.prodata.ie\/Events\/sqlimmersionDublin2010\/MasterClassPTO.aspx\" class=\"broken_link\">Prodata site<\/a> for full details and for registration links and options.\n<\/p>\n<p>\n(This is <strong>*NOT*<\/strong> duplicate content to the 4-day class &#8211; it&#39;s deeper knowledge and requires the equivalent knowledge to the 4-day class to get the best out of it.)\n<\/p>\n<blockquote>\n<p>\n\tPart 1: Optimizing Procedural Code\n\t<\/p>\n<ul>\n<li>\n<div>\n\t\tModule 1: Batches and Plan Cache\n\t\t<\/div>\n<ul>\n<li>\n<div>\n\t\t\tStatement execution and plan caching\n\t\t\t<\/div>\n<\/li>\n<li>\n<div>\n\t\t\tsp_executesql and dynamic string execution\n\t\t\t<\/div>\n<\/li>\n<\/ul>\n<\/li>\n<li>\n<div>\n\t\tModule 2: Optmizing Procedural Code\n\t\t<\/div>\n<\/li>\n<li>\n<div>\n\t\tUnderstanding stored procedures\n\t\t<\/div>\n<ul>\n<li>\n<div>\n\t\t\tUnderstanding recompilation\n\t\t\t<\/div>\n<\/li>\n<li>\n<div>\n\t\t\tCreating an optimal plan\n\t\t\t<\/div>\n<\/li>\n<li>\n<div>\n\t\t\tForcing plans &amp; plan guides\n\t\t\t<\/div>\n<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<p>\n\tPart 2: Resource Monitoring and Troubleshooting\n\t<\/p>\n<ul>\n<li>\n<div>\n\t\tModule 1: Waits &amp; Queues\n\t\t<\/div>\n<ul>\n<li>\n<div>\n\t\t\tWhat are waits and queues?\n\t\t\t<\/div>\n<\/li>\n<li>\n<div>\n\t\t\tWhat should you be looking for?\n\t\t\t<\/div>\n<\/li>\n<\/ul>\n<\/li>\n<li>\n<div>\n\t\tModule 2: Locking \/ blocking\n\t\t<\/div>\n<ul>\n<li>\n<div>\n\t\t\tLocking overview\n\t\t\t<\/div>\n<\/li>\n<li>\n<div>\n\t\t\tExamples of blocking scenarios\n\t\t\t<\/div>\n<\/li>\n<li>\n<div>\n\t\t\tTroubleshooting blocking\n\t\t\t<\/div>\n<\/li>\n<li>\n<div>\n\t\t\tBlocking avoidance strategies\n\t\t\t<\/div>\n<\/li>\n<\/ul>\n<\/li>\n<li>\n<div>\n\t\tModule 3: Resource governor\n\t\t<\/div>\n<\/li>\n<li>\n<div>\n\t\tModule 4: Extended Events\n\t\t<\/div>\n<\/li>\n<li>\n<div>\n\t\tModule 5: Performance Data Collection\n\t\t<\/div>\n<\/li>\n<\/ul>\n<p>\n\tPart 3: Are Your Index Strategies Working?\n\t<\/p>\n<ul>\n<li>\n<div>\n\t\tModule 1: index cleanup\n\t\t<\/div>\n<ul>\n<li>\n<div>\n\t\t\tIndex usage and consolidation\n\t\t\t<\/div>\n<\/li>\n<\/ul>\n<\/li>\n<li>\n<div>\n\t\tModule 2: Index health\n\t\t<\/div>\n<ul>\n<li>\n<div>\n\t\t\tWhat is fragmentation\n\t\t\t<\/div>\n<\/li>\n<li>\n<div>\n\t\t\tDetecting fragmentation\n\t\t\t<\/div>\n<\/li>\n<li>\n<div>\n\t\t\tRemoving fragmentation\n\t\t\t<\/div>\n<\/li>\n<\/ul>\n<\/li>\n<li>\n<div>\n\t\tModule 3: Missing indexes\n\t\t<\/div>\n<ul>\n<li>\n<div>\n\t\t\tDTA\n\t\t\t<\/div>\n<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<\/blockquote>\n<p>\n<font size=\"+0\"><strong><u>Disaster Recovery Masterclass, July 7-8 2010, Dublin, Ireland:<\/u><\/strong> See the <a href=\"http:\/\/www.prodata.ie\/Events\/sqlimmersionDublin2010\/MasterClassDR.aspx\" class=\"broken_link\">Prodata site<\/a> for full details and for registration links and options.\n<\/p>\n<p>\n(This is <strong>*NOT*<\/strong> duplicate content to the 4-day class &#8211; it&#39;s deeper knowledge and really requires the equivalent knowledge to the 4-day class to get the best out of it.)\n<\/p>\n<blockquote>\n<p>\n\tPart I: Fundamentals\n\t<\/p>\n<ul>\n<li>\n<div>\n\t\tModule 1: Internals\n\t\t<\/div>\n<ul>\n<li>\n<div>\n\t\t\tIntroduction to database structures\n\t\t\t<\/div>\n<\/li>\n<li>\n<div>\n\t\t\tIntroduction to logging and recovery\n\t\t\t<\/div>\n<\/li>\n<li>\n<div>\n\t\t\tHow recovery models affect disaster recovery\n\t\t\t<\/div>\n<\/li>\n<\/ul>\n<\/li>\n<li>\n<div>\n\t\tModule 2: Data Storage\n\t\t<\/div>\n<ul>\n<li>\n<div>\n\t\t\tChoosing a RAID level\n\t\t\t<\/div>\n<\/li>\n<li>\n<div>\n\t\t\tStorage tuning for fast recovery\n\t\t\t<\/div>\n<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<p>\n\tPart II: Strategy\n\t<\/p>\n<ul>\n<li>\n<div>\n\t\tModule 3: Planning a disaster recovery strategy\n\t\t<\/div>\n<ul>\n<li>\n<div>\n\t\t\tRequirements and limitations\n\t\t\t<\/div>\n<\/li>\n<li>\n<div>\n\t\t\tTesting\n\t\t\t<\/div>\n<\/li>\n<\/ul>\n<\/li>\n<li>\n<div>\n\t\tModule 4: Architecting for recoverability\n\t\t<\/div>\n<ul>\n<li>\n<div>\n\t\t\tPartial database availability\n\t\t\t<\/div>\n<\/li>\n<li>\n<div>\n\t\t\tPlanning a backup strategy\n\t\t\t<\/div>\n<\/li>\n<li>\n<div>\n\t\t\tDatabase snapshots\n\t\t\t<\/div>\n<\/li>\n<li>\n<div>\n\t\t\tUtilizing high-availability technologies\n\t\t\t<\/div>\n<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<p>\n\tPart III: Practicalities\n\t<\/p>\n<ul>\n<li>\n<div>\n\t\tModule 5: Recovering from a disaster with backups\n\t\t<\/div>\n<ul>\n<li>\n<div>\n\t\t\tTail-of-the-log backups\n\t\t\t<\/div>\n<\/li>\n<li>\n<div>\n\t\t\tDetermining restore sequence\n\t\t\t<\/div>\n<\/li>\n<li>\n<div>\n\t\t\tPoint-in-time restore\n\t\t\t<\/div>\n<\/li>\n<li>\n<div>\n\t\t\tPiecemeal restore\n\t\t\t<\/div>\n<\/li>\n<li>\n<div>\n\t\t\tSystem databases\n\t\t\t<\/div>\n<\/li>\n<\/ul>\n<\/li>\n<li>\n<div>\n\t\tModule 6: Recovering from a disaster without backups\n\t\t<\/div>\n<ul>\n<li>\n<div>\n\t\t\tInterpreting DBCC CHECKDB output\n\t\t\t<\/div>\n<\/li>\n<li>\n<div>\n\t\t\tUsing database repair\n\t\t\t<\/div>\n<\/li>\n<li>\n<div>\n\t\t\tUsing EMERGENCY mode\n\t\t\t<\/div>\n<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<\/blockquote>\n<p>\nWe really hope to see you at one or more of these classes! And, if you&#39;re interested in attending two or more classes &#8211; special discounts are available. Additionally, we&#39;re also offering discounts to folks that attended last year&#39;s Dublin Immersion Event &#8211; so that they can continue where they left of and add on one or both of the 2-day classes offered in the second week. Feel free to shoot either of us an email [Kimberly OR Paul at SQLskills dot com] OR use one of the contact pages on the ProdData site. You can also find this event on LinkedIn <a href=\"http:\/\/help.linkedin.com\/app\/answers\/detail\/a_id\/1213\" target=\"_blank\" class=\"broken_link\">here<\/a>.\n<\/p>\n<p>\n<strong>We look forward to seeing you there!<\/strong><br \/>\nkt (and pr)<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Paul and I enjoyed Dublin so much in 2008 and 2009 that we&#39;re going back for two weeks this time &#8211; and teaching three classes while we&#39;re there! We&#39;ll be working with our fabulous friends (Carmel, Sandra, and Bob) at Prodata and the event will be hosted by the nice folks at Microsoft Ireland. We&#39;ll [&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,66],"tags":[],"class_list":["post-506","post","type-post","status-publish","format-standard","hentry","category-events","category-sql-server-2008"],"_links":{"self":[{"href":"https:\/\/www.sqlskills.com\/blogs\/kimberly\/wp-json\/wp\/v2\/posts\/506","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=506"}],"version-history":[{"count":0,"href":"https:\/\/www.sqlskills.com\/blogs\/kimberly\/wp-json\/wp\/v2\/posts\/506\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.sqlskills.com\/blogs\/kimberly\/wp-json\/wp\/v2\/media?parent=506"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.sqlskills.com\/blogs\/kimberly\/wp-json\/wp\/v2\/categories?post=506"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.sqlskills.com\/blogs\/kimberly\/wp-json\/wp\/v2\/tags?post=506"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}