{"id":515,"date":"2010-04-20T13:11:00","date_gmt":"2010-04-20T13:11:00","guid":{"rendered":"\/blogs\/kimberly\/post\/Microsoft-eLearning-Resources-Clinic-10259-(SQL-2008-DBIS).aspx"},"modified":"2013-01-02T06:55:15","modified_gmt":"2013-01-02T14:55:15","slug":"microsoft-elearning-resources-clinic-10259-sql-2008-dbis","status":"publish","type":"post","link":"https:\/\/www.sqlskills.com\/blogs\/kimberly\/microsoft-elearning-resources-clinic-10259-sql-2008-dbis\/","title":{"rendered":"Microsoft eLearning Resources – Clinic 10259 (SQL 2008 DBIS)"},"content":{"rendered":"

\nWhen SQL Server 2008 was in beta, Paul<\/a> and I worked on a project to create content that would "jumpstart" folks in learning and working with SQL Server 2008. We delivered these "new features" courses at various locations and finally, we recorded the content. All of this content is now available FOR FREE from Microsoft through their eLearning outlet. This course is officially titled and available as: Clinic 10259: SQL Server 2008: Database Infrastructure and Scalability<\/a><\/strong>.<\/span>\n<\/p>\n

\nThere are 12 hours of lecture and demo content… lots of good stuff.<\/span>\n<\/p>\n

\n

\n\tModules & Lessons<\/strong><\/span>\n\t<\/p>\n

\n\t<\/span>Availability Enhancements <\/strong><\/span>\n\t<\/p>\n

    \n
  • \n
    \n\t\tModule overview <\/span>\n\t\t<\/div>\n<\/li>\n
  • \n
    \n\t\tDemo: Database Mirroring automatic page repair <\/span>\n\t\t<\/div>\n<\/li>\n
  • \n
    \n\t\tDatabase Mirroring enhancements continued, automatic page repair, log stream <\/span>\n\t\t<\/div>\n<\/li>\n
  • \n
    \n\t\tBackup compression and using Transparent Data Encryption (TDE) to encrypt data <\/span>\n\t\t<\/div>\n<\/li>\n
  • \n
    \n\t\tHot-add CPU, DBCC CHECKDB enhancements, failover clustering enhancements <\/span>\n\t\t<\/div>\n<\/li>\n
  • \n
    \n\t\tPeer-to-peer replication enhancements <\/span>\n\t\t<\/div>\n<\/li>\n
  • \n
    \n\t\tDemo: Peer-to-peer replication <\/span>\n\t\t<\/div>\n<\/li>\n<\/ul>\n

    \n\tPolicy-Based Management and Multi-Server Administration <\/strong><\/span>\n\t<\/p>\n

      \n
    • \n
      \n\t\tModule overview<\/span>\n\t\t<\/div>\n<\/li>\n
    • \n
      \n\t\tCentral management server <\/span>\n\t\t<\/div>\n<\/li>\n
    • \n
      \n\t\tDemo: Central management server <\/span>\n\t\t<\/div>\n<\/li>\n
    • \n
      \n\t\tCentral management server metadata, multi-server script execution <\/span>\n\t\t<\/div>\n<\/li>\n
    • \n
      \n\t\tDemo: Multi-server script execution <\/span>\n\t\t<\/div>\n<\/li>\n
    • \n
      \n\t\tPolicy-based management overview, conditions, facets and policies <\/span>\n\t\t<\/div>\n<\/li>\n
    • \n
      \n\t\tPolicy-based management demo: Facets and conditions <\/span>\n\t\t<\/div>\n<\/li>\n
    • \n
      \n\t\tApplying facets and conditions to policies, policy enforcement <\/span>\n\t\t<\/div>\n<\/li>\n
    • \n
      \n\t\tDemo: Applying facets and conditions to policies <\/span>\n\t\t<\/div>\n<\/li>\n
    • \n
      \n\t\tPolicy based management architecture and execution <\/span>\n\t\t<\/div>\n<\/li>\n
    • \n
      \n\t\tDemo: Applying policies to multiple servers <\/span>\n\t\t<\/div>\n<\/li>\n
    • \n
      \n\t\tPolicy based management advanced topics <\/span>\n\t\t<\/div>\n<\/li>\n<\/ul>\n

      \n\tPerformance Data Collection <\/strong><\/span>\n\t<\/p>\n

        \n
      • \n
        \n\t\tModule overview, management data warehouse <\/span>\n\t\t<\/div>\n<\/li>\n
      • \n
        \n\t\tDemo: Creating and configuring a management data warehouse <\/span>\n\t\t<\/div>\n<\/li>\n
      • \n
        \n\t\tData collection overview and architecture <\/span>\n\t\t<\/div>\n<\/li>\n
      • \n
        \n\t\tDemo: Configuring system data collection on an instance <\/span>\n\t\t<\/div>\n<\/li>\n
      • \n
        \n\t\tDemo: Transact-SQL custom data collection <\/span>\n\t\t<\/div>\n<\/li>\n
      • \n
        \n\t\tData collection reports and module summary <\/span>\n\t\t<\/div>\n<\/li>\n<\/ul>\n

        \n\tResource Management and Troubleshooting Enhancements <\/strong><\/span>\n\t<\/p>\n

          \n
        • \n
          \n\t\tModule Overview <\/span>\n\t\t<\/div>\n<\/li>\n
        • \n
          \n\t\tDemo: Resource Governor <\/span>\n\t\t<\/div>\n<\/li>\n
        • \n
          \n\t\tExtended events, predicates, actions, targets, types, maps, sessions <\/span>\n\t\t<\/div>\n<\/li>\n<\/ul>\n

          \n\tSecurity Enhancements <\/strong><\/span>\n\t<\/p>\n

            \n
          • \n
            \n\t\tModule overview <\/span>\n\t\t<\/div>\n<\/li>\n
          • \n
            \n\t\tTransparent data encryption <\/span>\n\t\t<\/div>\n<\/li>\n
          • \n
            \n\t\tDemo: Transparent data encryption <\/span>\n\t\t<\/div>\n<\/li>\n
          • \n
            \n\t\tBackups and transparent data encryption, transparent data encryption limitations <\/span>\n\t\t<\/div>\n<\/li>\n
          • \n
            \n\t\tIntegrated authentication enhancements, SQL Server 2008 auditing improvements <\/span>\n\t\t<\/div>\n<\/li>\n
          • \n
            \n\t\tDemo: SQL Server 2008 all actions audited <\/span>\n\t\t<\/div>\n<\/li>\n
          • \n
            \n\t\tSecurity Summary <\/span>\n\t\t<\/div>\n<\/li>\n<\/ul>\n

            \n\tManagement Implications of New Features Part 1 <\/strong><\/span>\n\t<\/p>\n

              \n
            • \n
              \n\t\tModule overview, spatial indexes, integrated full-text search <\/span>\n\t\t<\/div>\n<\/li>\n
            • \n
              \n\t\tProblems addressed by sparse columns <\/span>\n\t\t<\/div>\n<\/li>\n
            • \n
              \n\t\tDemo: Sparse columns and column sets <\/span>\n\t\t<\/div>\n<\/li>\n
            • \n
              \n\t\tSparse columns and filtered indexes, best practices for sparse columns <\/span>\n\t\t<\/div>\n<\/li>\n
            • \n
              \n\t\tDemo: Constructing tabular data sets with sparse columns <\/span>\n\t\t<\/div>\n<\/li>\n
            • \n
              \n\t\tLimitations of sparse columns and interaction with other features <\/span>\n\t\t<\/div>\n<\/li>\n
            • \n
              \n\t\tOverview of filtered indexes <\/span>\n\t\t<\/div>\n<\/li>\n
            • \n
              \n\t\tDemo: Using filtered indexes with sparse columns <\/span>\n\t\t<\/div>\n<\/li>\n
            • \n
              \n\t\tFiltered statistics, monitoring filtered indexes and statistics <\/span>\n\t\t<\/div>\n<\/li>\n
            • \n
              \n\t\tDemo: Using filtered indexes for improved index coverage <\/span>\n\t\t<\/div>\n<\/li>\n<\/ul>\n

              \n\tManagement Implications of New Features Part 2 <\/strong><\/span>\n\t<\/p>\n

                \n
              • \n
                \n\t\tChange tracking overview, change tracking best practices <\/span>\n\t\t<\/div>\n<\/li>\n
              • \n
                \n\t\tChange data capture (CDC) overview <\/span>\n\t\t<\/div>\n<\/li>\n
              • \n
                \n\t\tDemo: Change Data Capture <\/span>\n\t\t<\/div>\n<\/li>\n
              • \n
                \n\t\tBlob storage with Filestream overview, enabling Filestream <\/span>\n\t\t<\/div>\n<\/li>\n
              • \n
                \n\t\tFilestream security, filestream and transactions, monitoring filestream storage <\/span>\n\t\t<\/div>\n<\/li>\n
              • \n
                \n\t\tDemo: Filestream manageability demo <\/span>\n\t\t<\/div>\n<\/li>\n<\/ul>\n

                \n\tScalability Enhancements <\/strong><\/span>\n\t<\/p>\n

                  \n
                • \n
                  \n\t\tData compression overview, data compression trade-offs <\/span>\n\t\t<\/div>\n<\/li>\n
                • \n
                  \n\t\tDemo: Estimating data compression space savings <\/span>\n\t\t<\/div>\n<\/li>\n
                • \n
                  \n\t\tEstimating data compressing space savings, choosing row compression <\/span>\n\t\t<\/div>\n<\/li>\n
                • \n
                  \n\t\tDemo: Enabling compression and comparing performance <\/span>\n\t\t<\/div>\n<\/li>\n
                • \n
                  \n\t\tEnabling and disabling compression, data compression options and syntax <\/span>\n\t\t<\/div>\n<\/li>\n
                • \n
                  \n\t\tService broker improvements, Service Broker conversation priority <\/span>\n\t\t<\/div>\n<\/li>\n
                • \n
                  \n\t\tQuery optimizer enhancements, MERGE overview <\/span>\n\t\t<\/div>\n<\/li>\n
                • \n
                  \n\t\tForcing query optimizer plans with plan guides <\/span>\n\t\t<\/div>\n<\/li>\n
                • \n
                  \n\t\tDemo: Using plan guides <\/span>\n\t\t<\/div>\n<\/li>\n
                • \n
                  \n\t\tStar join optimizer improvements <\/span>\n\t\t<\/div>\n<\/li>\n
                • \n
                  \n\t\tPartitioning enhancements overview, partition-aligned indexed views <\/span>\n\t\t<\/div>\n<\/li>\n
                • \n
                  \n\t\tPartitioning and lock escalation enhancements <\/span>\n\t\t<\/div>\n<\/li>\n
                • \n
                  \n\t\tDemo: Improving concurrency with partition lock escalation <\/span>\n\t\t<\/div>\n<\/li>\n
                • \n
                  \n\t\tModule review<\/span>\n\t\t<\/div>\n<\/li>\n<\/ul>\n<\/blockquote>\n

                  \nThere are a few more resources to mention. I've got a few more posts coming on this right away!<\/span>\n<\/p>\n

                  \nEnjoy!!
                  \nkt<\/span><\/p>\n","protected":false},"excerpt":{"rendered":"

                  When SQL Server 2008 was in beta, Paul and I worked on a project to create content that would "jumpstart" folks in learning and working with SQL Server 2008. We delivered these "new features" courses at various locations and finally, we recorded the content. All of this content is now available FOR FREE from Microsoft […]<\/p>\n","protected":false},"author":7,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[36,43,46,51,55,58,59,64,66],"tags":[],"class_list":["post-515","post","type-post","status-publish","format-standard","hentry","category-indexes","category-manageability","category-microsoft-elearning","category-partitioning","category-policy-based-management","category-resources","category-security","category-sparse-columns","category-sql-server-2008"],"_links":{"self":[{"href":"https:\/\/www.sqlskills.com\/blogs\/kimberly\/wp-json\/wp\/v2\/posts\/515","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=515"}],"version-history":[{"count":0,"href":"https:\/\/www.sqlskills.com\/blogs\/kimberly\/wp-json\/wp\/v2\/posts\/515\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.sqlskills.com\/blogs\/kimberly\/wp-json\/wp\/v2\/media?parent=515"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.sqlskills.com\/blogs\/kimberly\/wp-json\/wp\/v2\/categories?post=515"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.sqlskills.com\/blogs\/kimberly\/wp-json\/wp\/v2\/tags?post=515"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}