SQLskills.com | Immerse Yourself In SQL Server



	Home

	Remote DBA Service

	Consulting and Performance

	Server Health Checks

	Training

	Resources

	Calendar

	What our Customers say

	What our Students say

	About SQLskills.com

Þ MSDN Series: A Primer to Proper SQL Server Development Click the link above for details on the 10-part series.


Þ TechNet Series: SQL Server 2005 for the IT Professional Click the link above for details on the 11-part series.


Other Webcasts
Þ Surviving Database Corruption (Level 300) Length: 90 minutes. Instructor: Paul S. Randal. Accompanying blog post: here. These videos are part of the MCM Readiness series of videos. Navigate to the link above and look for the Consistency Checking recordings. Your database is corrupt - what do you do? Well, it depends! How critical is the data? Do you know what's really wrong with the database? What does all that DBCC CHECKDB output mean? Should you restore or repair? It’s all about limiting downtime and data-loss when a corruption occurs - from knowing the tools to understanding the implications of choices you make. In this demo-heavy session Paul will give you insight into how to recover from corruption without making things worse. Most importantly you'll get step-by-step instructions for dealing with the more common scenarios.
Þ TechEd 2005: SQL Server 2005 VLDB Availability and Recovery Strategies (Level 300) Length: 75 minutes. Instructor: Kimberly L. Tripp SQL Server 2005 offers an extended feature set for data availability, backup and recovery. For VLDB systems, these new features can offer minimal impact to production data availability even in the event of disk failure or human error. Come to this session to see how VLDB strategies, which include partitioning, can offer more options to keep your database online, as well as offer fast recovery times. Key features covered are: Table/Index Partitioning targeted Backup/Restore, online recovery and Database Snapshots. In this session, Kimberly L. Tripp demonstrates a damaged partitioned database that remains available even through catastrophic disk failure as well as demo recovery of the database while still online. Finally, we talk about how database snapshots work, suggesting how to use the feature to offer easier and faster recovery paths in the event of human error. Watch this session to learn how to keep your VLDB more available and minimize data loss!
Þ TechEd 2005: SQL Server Index Creation Best Practices (Level 300) Length: 75 minutes. Instructor: Kimberly L. Tripp While many indexing best practices continue from SQL Server 2000, there are some new features of which you should be aware. SQL Server 2005 offers more options to cover queries alleviating some SQL Server 2000 restrictions. In this session, we will review a good strategy for table clustering, look at supporting non-clustered indexes and focus on non-clustered covering as well as Indexed Views. Finally, in addition to index creation we will briefly cover the new online operations and how they will impact your table design. If you want optimal table structures, better data availability as well as a strategy for indexing for performance, this is the session to watch!
Þ TechEd 2005: Index Defragmentation with SQL Server 2005 (Level 300) Length: 74 minutes. Instructor: Kimberly L. Tripp Even when properly created (and with the right strategies based on data usage patterns) indexes can lose their effectiveness over time due to fragmentation through inserts, updates and deletes. In this session you will learn the effect of data modifications on indexes and how to clean up the fragmentation. Index fragmentation can negatively impact query performance, require more IOs in large scans and even require more time and space for backups. The effects fragmentation ripple through the database; did you know there are multiple ways to defragment? Did you know that each method provides different pros and cons in terms of maintenance, availability, log space and time? Are you aware of the new features offered by SQL Server 2005 that can offer improved availability while defragmenting tables? Watch this session to make your indexing best practices complete and keep your performance optimal over time.
Þ TechEd 2005: SQL Server Index Creation Best Practices (Level 300) Length: 78 minutes. Instructor: Kimberly L. Tripp SQL Server 2005 offers an extended feature set for data availability, backup and recovery. For VLDB systems, these new features can offer minimal impact to production data availability even in the event of disk failure or human error. Come to this session to see how VLDB strategies, which include partitioning, can offer more options to keep your database online, as well as offer fast recovery times. Key features covered are: Table/Index Partitioning targeted Backup/Restore, online recovery and Database Snapshots. In this session, Kimberly L. Tripp demonstrates a damaged partitioned database that remains available even through catastrophic disk failure as well as demo recovery of the database while still online. Finally, we talk about how database snapshots work, suggesting how to use the feature to offer easier and faster recovery paths in the event of human error. Watch this session to learn how to keep your VLDB more available and minimize data loss!
Þ SQL Server 2000 Performance Tuning - Finding the Right Balance of Indexes (Level 200) Length: 90 minutes. Instructor: Kimberly L. Tripp In SQL Server, Performance Tuning can be achieved through many avenues: hardware, software, the database and the client. While there are many paths that yield gains, finding the improvements that give the greatest gain with the least impact on your current systems is a must. In SQL Server there is no other area in the product where you can get better performance gains than with indexes. However, knowing the right types of indexes as well as finding the right balance of indexes (e.g. Balancing OLTP and DSS requirements) takes strategy. Additionally, once created - indexes must be maintained. In this webcast we will look at what indexes are, why they are beneficial, when they can become a burden and how to find the right balance of indexes for performance. This session will demonstrate quite a few recommendations, and a number of concepts - including index maintenance and numerous tips on how to get better performance without being an indexing and internals expert.