August 30, 2008
SQL Server 2005 - 10 Free One-Hour Videos From Microsoft Expert
Presenter: Bryan Von Axelson, TechNet Presenter, Microsoft Corporation Bryan Von Axelson joined the SST Team last September as a TechNet Presenter. Before that, Bryan consulted for seven years throughout the Midwest and Western United States, targeting the small and medium business segment. Previously, Bryan worked for Franklin Covey and MCI. Bryan brings 14 years experience as an IT Professional and relates his real-world experiences and best practices into his sessions.
Need a Quick Way to See These .NET Videos and Monitor Your Progress?Click Here to Use Progress Monitor
|
| May I Also Recommend for Further Study? Bob Tabor also has an excellent 20-part series on LINQ that is entitled: LINQ to SQL 101. Check it out in the video library section of LearnVisualStudio. |
| 1. Administration Tools |
| Key Concepts:
Part one of this series explores the changes to the administration and management tools in SQL Server 2005. The discussion focuses primarily on the new Management Studio tool, which encompasses the Enterprise Manager, Query Analyzer and OLAP Analysis Manager from SQL 2000. Because the tool runs within the Visual Studio interface, we will also look at this interface and the functions it can perform. 3/21/2005 | Duration:60 Minutes |
| 2. Monitoring Tools |
| Key Concepts:
In part two of this series, we look at the monitoring tools available with SQL Server 2005. We examine the SQL Profiler, Database Tuning Advisor, Database Maintenance Workflow and Dynamic Management Views (DMVs). 3/28/2005 | Duration:60 Minutes |
| 3. Achieving Greater Concurrency |
| Key Concepts:
SQL Server 2005 provides enhancements to enable greater concurrency and significantly reduce lock contention. In part three of this series, we show you how to use Snapshot Isolation to reduce currency contention. Gain an understanding of database snapshots and replication for scaling and read-only views, and learn how Dynamic Management Views can help you proactively monitor locking and avoid deadlocks. 4/4/2005 | Duration:60 Minutes |
| 4. Securing Your SQL Server |
| Key Concepts:
Parts four and five in our series highlight the security enhancements in SQL Server 2005. Part four of this series focuses on authentication and authorization while crypto support is covered in part five. We begin with authentication, examining the Security model, endpoint-based authentication and the password policy. Then we move on to explore authorization, covering User Schema separation, module execution context, granular permission control and Catalog security. 4/11/2005 | Duration:60 Minutes |
| 5. Protecting Sensitive Data |
| Key Concepts:
Parts four and five in our series highlight the security enhancements in SQL Server 2005. Building upon the discussion of authentication and authorization in the previous session, part five of the series covers the crypto support in SQL Server 2005. We begin with an introduction to the concepts of database encryption including encryption support, keys, certificates and key management. We show how SQL 2005 can protect sensitive data using data encryption and module signatures, and introduce sign modules, what these are and how they work. 4/18/2005 | Duration:60 Minutes |
| 6. Managing Large Databases Using Partitioning |
| Key Concepts:
Partitioned tables improve the scalability and manageability of very large SQL Server databases. In part six of this series we look at the table and index partitioning capabilities in SQL Server 2005. The discussion will outline the features and benefits of partitioning, explain how it works, and illustrate how to implement and set up this feature. 4/25/2005 | Duration:60 Minutes |
| 7. Indexing Enhancements |
| Key Concepts:
The aim of creating indexes and partitioning data in a database is to yield good performance for users. Part seven in this series looks at the enhancements to the indexing within SQL Server 2005. We begin by outlining the basic changes to the indexing compared to previous versions. We then drill into index management and show how to use the Database Tuning Advisor as the main tool to analyze indexes. 5/2/2005 | Duration:60 Minutes |
| 8. Data Recovery |
| Key Concepts:
Part eight in the series covers troubleshooting methods and tools in Microsoft SQL Server 2005 that you can use to recover from various scenarios. Topics include database access problems, such as the database being marked as suspect during recovery; backup and restore failures; database runtime consistency failures, such as checksum; and DBCC CHECKDB errors. Learn how to take advantage of new features in SQL Server 2005 to recover your data in order to make yourself more productive in disaster recovery situations. 5/9/2005 | Duration:60 Minutes |
| 9. High Availability |
| Key Concepts:
Database mirroring is a new technology in SQL Server 2005 that provides very fast, automatic failover to a standby system. In part nine of this series we examine this new enhancement in detail, and will show you how to configure and use it. 5/16/2005 | Duration:60 Minutes |
| 10. Moving Data Between Data Sources |
| Key Concepts:
SQL Server includes a suite of replication technologies that enable a wide range of distributed database applications. SQL Server 2005 introduces a few new scenarios including Web synchronization of merge replication for mobile and distributed data applications, Oracle publishing for integration with Oracle databases, and peer-to-peer replication. In this final webcast in our ten-part series, learn how you can benefit from these scenarios with an enhanced ability to monitor the entire distributed system. 5/18/2005 | Duration:60 Minutes |
Comments