24 Hours of SQL Server 2008 – A Video Tutorial presented by Microsoft Experts

Posted by on Sunday, December 21, 2008 · Leave a Comment 

sql server 2008 express tutorial, sql-server-compare, sql-server-copy, sql-server-memory, sql-server-profiler, sql-server-script, sql-server-stored-procedure, sql-server-trigger, sql-stored-procedureOverview: This 24-part tutorial series looks at Microsoft SQL Server 2008 as a productive data platform. The major topics in this series include: , sql server stored procedure, , sql server compare, sql server trigger, , sql server memory, sql server copy.

Most of the videos in this series focus directly on SQL Server 2008, but a few of the videos use Contoso (Container Overseas Shipping Operation) LTD as case study to illustrate how some of the features of SQL Server 2008 can be used. Contoso is a shipping company that arranges the shipping of all kinds of items around the globe.

Creative Commons License photo credit: mwin

Presenter: Ron Cundiff, MSDN Developer Evangelist, Microsoft Corporation

Presenter: Bryan Von Axelson, Partner Solutions Advisor, Microsoft Corporation

Presenter: John Pelak, ISV Architect Evangelist, Microsoft Corporation

Presenter: Chris Avis, IT Pro Evangelist, Microsoft Corporation

Presenter: Mike Benkovich, Developer Evangelist, Microsoft Corporation

Presenter: John Weston, IT Pro Evangelist, Microsoft Corporation

Presenter: Donald Farmer, Principal Program Manager, Microsoft Corporation and Lynn Langit, Developer Evangelist, Microsoft Corporation

 

24 Hours of SQL Server 2008

 

1. Using the Microsoft Data Platform for Easy Data Access with SQL Server 2008
Key Concepts:

  • How Contoso LTD can take advantage of the Microsoft data platform to extend their applications
  • Microsoft .NET Language-Integrated Query (LINQ)
  • ADO.NET Entity Framework

March 03, 2008 60 minutes – Ron Cundiff
2. Reach Your Data with SQL Server 2008
Key Concepts:

  • how Contoso LTD can increase methods of accessing data without the need for complex connections and filters on firewalls
  • Service Broker
  • ADO.NET Data Services

March 05, 2008 60 minutes – Ron Cundiff
3. Streamline Data Access with SQL Server 2008
Key Concepts:

  • new features in SQL Server 2008
  • T-SQL improvements:
  • MERGE
  • the Table Valued Parameters feature that lets data rows be passed as parameters to stored procedures
  • Date/Time
  • Intellisense
  • multi server T_SQL

March 10, 2008 60 minutes – Ron Cundiff
4. Manage Your Unstructured Data with SQL Server 2008
Key Concepts:

  • Client voice mails to scanned and e-mail documents
  • unstructured data
  • options for its storage, access, security, and searching needs
  • FILESTREAM attribute
  • Remote BLOB Store API
  • the differences from large unstructured data storage in Microsoft SQL Server 2005

March 12, 2008 60 minutes – Ron Cundiff
5. Simplify Management of Your SQL Server 2008 Data Platform
Key Concepts:

  • the management side of Microsoft SQL Server 2008
  • challenges that database administrators face
  • managing complex and high-value tasks
  • proactively monitoring and tuning system health
  • scaling management to multiple data centers
  • gaining insight into historical trends and real-time activities

March 17, 2008 90 minutes – Bryan Von Axelson
6. Simplify Management with Policy-Based Management
Key Concepts:

  • Policy-Based Management (PBM)
  • PBM’s use to define policies that apply to servers, databases, and other objects in Contoso’s data environment
  • the scope, definition, and deployment of policies

March 19, 2008 90 minutes – Bryan Von Axelson
7. Map Your Data with SQL Server Spatial Features
Key Concepts:

  • mapping feature
  • how to use spatial data types within SQL Server to create these mapping features using Microsoft Virtual Earth

March 24, 2008 90 minutes – John Pelak
8. Ensuring Your Data Is Secure with a Trusted Platform
Key Concepts:

  • security
  • internal and external threats
  • surface area configuration policies
  • external key management
  • Network Access Protection (NAP),
  • Windows BitLocker Drive Encryption

March 31, 2008 90 minutes – Bryan Von Axelson
9. Securing Your System
Key Concepts:

  • secure your data
  • secure your system
  • Windows Server 2008
  • Windows Vista
  • surface area configuration policies
  • external key management
  • Network Access Protection (NAP),
  • Windows BitLocker Drive Encryption

April 02, 2008 90 minutes – Chris Avis
10. Ensuring Business Continuity
Key Concepts:

  • high availability options in Microsoft SQL Server 2008

April 07, 2008 90 minutes – Bryan Von Axelson

11. Predictable Response to Your Users
Key Concepts:

  • Resource Governor enables administrators to define limits and assign priorities to individual workloads that are running on a SQL Server instance
  • Plan Freezing in SQL Server 2008 enables greater query performance stability and predictability by providing new functionality to lock down query plans.

April 16, 2008 90 minutes – Bryan Von Axelson

12. Data Warehousing Scale and Performance
Key Concepts:

Business Intelligence strategy that supports scalability and extensibility:

  • Partition-aligned indexed views
  • Star join query optimization
  • Data compression
  • Partitioned table parallelism
  • Grouping sets

May 05, 2008 90 minutes – Bryan Von Axelson
13. Data Warehousing Management
Key Concepts:

new features that Contoso can use to manage the enterprise data warehouse:

  • Minimal logging for inserts
  • Online index management
  • Backup compression
  • Switching in a new partition
  • Using the resource governor

    • .

May 07, 2008 90 minutes – Bryan Von Axelson
14. Reporting Services Designer Improvements
Key Concepts:

  • new features in Microsoft SQL Server 2008 Reporting Services
  • new report designer layout features
  • tablix
  • chart features
  • variables

May 08, 2008 60 minutes – Mike Benkovich
15. Upgrade Your Database
Key Concepts:

  • the methods that Contoso used to upgrade

May 10, 2008 90 minutes – Chris Avis
16. Performance Troubleshooting
Key Concepts:

  • monitoring and troubleshooting of any performance issues
  • Performance Studio
  • Best Practice Analyzer for SQL Server

May 13, 2008 90 minutes – Bryan Von Axelson
17. Scale Your Business
Key Concepts:

  • solutions for Contoso to scale out and up
  • how to take advantage of the latest hardware, such as 64-bit, hot add memory, and CPU, as well as software features
  • Learn to speed up query processing with Partitioned Table Parallelism through backup and compression, and to speed up backup times and replication

May 15, 2008 90 minutes – Chris Avis
18. AS Design and Performance Improvements
Key Concepts:

  • To support high-performing ad hoc analysis, Contoso wants to develop a Microsoft SQL Server Analysis Services database
  • the new features in Analysis Services that may help Contoso accelerate development and achieve optimal performance include:
  • Developing a cube and dimensions using the wizards
  • Working with best practices warnings
  • Designing proper attribute relationships
  • Using the aggregation designer

May 19, 2008 90 minutes – John Weston

19. Data Mining
Key Concepts:

    T he data mining capabilities of the Microsoft business intelligence (BI) platform include:

  • Using Microsoft SQL Server Data Mining Add-ins for Excel for table analysis
  • Developing a mining structure with multiple mining models
  • Viewing mining model results including drill-through and reviewing accuracy
  • Viewing results of mining models using Data Mining Add-ins for Excel.
    Using the Time Series algorithm for forecasting

May 21, 2008 90 minutes – Donald Farmer

20. Streamlining Data Integration
Key Concepts:

    The new features in Integration Services that help Contoso streamline the development and execution of processes to extract, transform, and load data into the data warehouse included:

  • ADO.NET connectivity
  • persistent lookups
  • pipeline improvements
  • data profiling
  • Change Data Capture function
  • MERGE command
  • ADO.NET data source
  • working with lookup caches
  • identifying dirty data with data profiling

May 28, 2008 90 minutes – Bryan Von Axelson
21. Reporting Services Architecture Improvements
Key Concepts:

    New features in Reporting Services that enable organizations to easily configure and manage a scalable, high-performance reporting infrastructure include:

  • the new physical architecture of Reporting Services
  • authentication configuration
  • the new processing and rendering architecture
  • memory management

    • Demonstrations on configuring Reporting Services include:

  • using the Configuration Manager
  • configuring authentication alternatives
  • configuring memory settings

May 31, 2008 90 minutes – Bryan Von Axelson
22. Reach Users with the 2007 Office System
Key Concepts:

    The integrated reporting and analytics options available to Contoso, include:

  • Microsoft Office Excel 2007
  • Excel Services
  • Microsoft Office SharePoint Server 2007
  • Microsoft Office PerformancePoint Server

June 03, 2008 60 minutes – Ron Cundiff

 

Filed under SQL Server, Videos · Tagged with , , , , , , , ,