Database Administration Virtual Chapter
Live Meeting Recordings
Date: August 25, 2010
Topic: SQL Storage for Performance Best Practices
Sponsored by Computer Associates, Inc.
Presenter: Amy Styers
Abstract:
SQL Storage Planning for Best Performance. What are the different storage optimizations available for SQL Server? What are some techniques that can be used to determine performance bottlenecks? Amy will discuss tips and tricks from the field on how to answer these questions for planning and designing your SQL infrastructure from disk up!
Date: August 11, 2010
Topic: What a DBA needs to know about Data Modeling
Sponsored by Computer Associates, Inc.
Presenter: Sanjay Shirude
Topic: Transactional Replication Deep Dive
Presenter: Arie Jones
Abstract:
Transactional Replication is often one of those black box features where if you are using the wizard in a standard implementation then you are fine. Yet, what do you do when you have to do something like transactional replication across non-trusted domains. In this session, we will discuss the internals of transactional replication, how it works, and what you can do to manage your implementations more effectively by understanding what going on underneath the covers .
Topic: Using XML to Query Execution Plans Sponsored by Computer Associates, Inc.
Date: July 28, 2010 Noon Eastern Time
Presenter: Jason Strate
Abstract:
SQL Server stores its execution plans as XML in dynamic management views. The execution plans are a gold mine of information. From the whether or not the execution plan will rely on parallelism to what columns are requiring a key lookup after a non-clustered index seek. Through a the use of XML this information can be available at your fingertips to help determine the value and impact of an index and guide you in improving the performance of your SQL Server databases. In this session we'll look at how you can begin to understand and query the structure of the execution plans in the procedure cache. Also, we'll review how to uncover some potential performance issues that may be lurking in your SQL Server.
View: Using_XML_to_Query_Execution_Plans.wmv
Topic: Why I should use Stored Procedures? Sponsored by Computer Associates, Inc.
Date: July, 14, 2010 Noon Eastern Time
Presenter: Jack Corbett
Abstract:
With the proliferation of ORM Tools like Linq To SQL, NHibernate, there has been a move to no longer use stored procedures for Data Access, I personally disagree. This will be a professional and polite open discussion starting with why I believe stored procedures are the best way to access data in SQL Server. Alternate view pooints welcome.
Topic: How SQL Server Indexes Work Sponsored by Computer Associates, Inc.
Date: June 23, 2010 Noon Eastern Time
Presenter: Sharon F. Dooley
Abstract:
There are many useful presentations about indexes. Most of these concentrate on tricks and techniques. This presentation will provide the background knowledge of index architectures so that you can understand why techniques work and select the appropriate indexing strategies for your databases. Topics covered include page splits/fragmentation, disk accesses required for different index types, covering indexes and optimization.
Topic: Building the Right Backup Strategy Sponsored by Computer Associates, Inc.
Date: June 9, 2010 Noon Mountain Time
Presenter: Paul Randal
Abstract:
In many situations, database backups are critical for recovering from a disaster, but there are lots of misconceptions about how backups work and what a good backup strategy is. The purpose of taking backups is, of course, to be able to restore them at some point - but that can sometimes be easier said than done, depending on what you want to be able to restore. In this in-depth session, Paul will explain how the three most common types of backups work and how they can be combined into an effective backup strategy. Paul will also cover how restore works, the three recovery options for restoring a backup, and some useful examples. You don't want to find out that your backups are unusable when disaster strikes - this session provides the knowledge you need to make sure you can recover. (Paul recommends that you read through the "Understanding Logging and Recovery in SQL Server" Technet Magazine article - February 2009 before watching this talk.)
Data Access Layers A Road Map to Smarter, Efficient and Effective Queries
Presente: Steve Simon
Date: May 26, 2010
Description: How often have our SQL Servers been bogged down with a myriad of users issuing lengthy and poorly constructed or poorly performing queries against our tables and views. More often than not, nearly bringing our systems to their knees. This beginners to intermediate level hands-on presentation is aimed at the SQL Server developer and business analyst alike and will show the attendee how we have managed to eliminate 90 % of our poorly performing queries by creating a data access layer which provides our end users with a suite of well developed and tuned SQL Server FUNCTIONS and UDT''s with which to render their data. The presentation will discuss the high level principles and concepts behind our data access layer, the scenarios under which we have benefited from its usage and then compare and contrast some of the poorly performing queries that we once had..with some more efficient and effective queries that we have now provided to our end users.
View: DataAccessLayers.wmv
Download Meeting: DataAccessLayers.zip
Indexing Guidelines
Presenter: Greg Larsen
Description: This session will discuss indexing guidelines. During this discussion there will be information about how developers and DBA’s should approach the indexing development lifecycle. This lifecycle will help attendees understand that you shouldn’t just develop some indexes while you are developing your applications and then forget about them. In addition some indexing guidelines will be discussed. These guidelines will help you make better choices on which columns to select for your indexes and how those columns should be ordered in multi-column indexes. There will be number of demonstrations to support this discussion.
SQL Server 2008 Audit
Presenter: Thomas LaRock
Date: April 28, 2010
Description: With SQL Server 2008 you now have the ability to set up auditing with SQL Server Audit. Attend this session for an overview of SQL Server Audit, learn how to initially configure an audit for your server or databases, and examine the audit logs to report on the information that is captured.
Using SQL Server 2008 Database Mirroring to Become a Super Hero!
Presenter: Glenn Berry
Date: April 14, 2010
Description: Database mirroring is a valuable technology that can be used to minimize or avoid downtime due to hardware failures, with less complexity than fail-over clustering. It can also be used for other innovative uses, such as easily migrating from SQL Server 2005 to SQL Server 2008 with a sub-minute outage. Database mirroring can be used during normal scheduled maintenance for rolling updates to minimize downtime. Database mirroring works very well for migrating very large databases from one SAN to another with minimal downtime. This session will cover all of these scenarios, with practical techniques, scripts and tips to help you take advantage of database mirroring.
View: Using_SQL_Server_2008_Database_Mirroring.wmv
Download Meeting: Using_SQL_Server_2008_Database_Mirroring.zip
SQL Server Internals and Architecture
Presenter: Kevin Kline
Date: March 24, 2010
View: SQL Server Internals and Architecture.wmv
Download Meeting: SQL Server Internals and Architecture.zip
Microsoft SQL Server 2008 R2 Application and Multi-Server Management
Presenter: Clifford Dibble
Date: March 10, 2010
View: Microsoft SQL Server 2008 R2 Application and Multi-Server Management.wmv
Download Meeting: Microsoft SQL Server 2008 R2 Application and Multi-Server Management.zip
Download Slides: Microsoft SQL Server 2008 R2 Application and Multi-Server Management Slides.zip
Locking and Blocking Made Simple
Presenter: Joe Webb
Date: Feburary 24, 2010
View: Locking and Blocking Made Simple.wmv
Download Meeting: Locking and Blocking Made Simple.zip
Top 10 DBA Mistakes on Microsoft SQL Server
Presenter: Kevin Kline
Date: Feburary 10, 2010
View: Top 10 DBA Mistakes on Microsoft SQL Server.wmv
Download Meeting: Top 10 DBA Mistakes on Microsoft SQL Server.zip
Download PowerPoint Slides: Top 10 DBA Mistakes on Microsoft SQL Server Slides.zip
SQL Server Consolidation : How to Decide on the Right Approach (Between DB, VMs, Instance)
Presenter: Sung Hsueh
Date: January 27, 2010
View: SQL Server Consolidation.wmv
Download Meeting: SQL Server Consolidation.zip
Looping, Moving Files, and Splitting Data Streems: Intermediate SSIS Tasks for the DBA
Presenter: Tim Mitchell
Date: January 13, 2010
View: SSIS Looping and Moving Files and Splitting Data Streams.wmv
Download Meeting: SSIS Looping and Moving Files and Splitting Data Streams.zip
SQL Server High Availability and Disaster Recovery: Customer Deployments and Best Practices
Presenter: Sanjay Mishra, Prem Mehra
Date: October 28, 2009
View: SQL Server High availability and Disaster Recovery.wmv
Download Meeting: SQL Server High Availiability and Disaster Recovery.zip
Optimizing Performance in SQL Server Analysis Services
Presenter: Carl Rabeler
Date: September 23, 2009
View: SSAS 2008 Perf Tuning and Troubleshooting.wmv
Download Meeting: SSAS 2008 Perf Tuning and Troubleshooting.wmv
Download Powerpoint Slides:SSAS 2008 Perf Tuning and Troubleshooting.zip
Description:
In this session, you will learn about techniques to optimize processing and query performance in SQL Server Analysis Services. These techniques will include cube design techniques, processing considerations, relational tuning techniques, and MDX tuning options.
T-SQL Best Practices
Presenter: Greg Larsen
Date: July 24, 2009
View: T-SQL Best Practices.wmv
Download Meeting: July Live Meeting - T-SQL Best Practices.zip
Description: This presentation covers a number of different SQL Server T-SQL coding best practices. There will be a discussion around each best practice so attendees will better understand the rationale behind each. Some of the best practices will have a demo to showing how different coding styles arrive at the same answer while using different amounts of SQL Server resources (CPU, and I/O). These demos will help attendees better understand how poor coding practices produce sub-optimal execution plans.
End-to-End Troubleshooting for SQL Server 2005/2008
Presenter: Kevin Kline
Date: February 25, 2009
View Meeting: Troubleshooting_SQL_Server.wmv
Download Meeting:
Description: Learning how to detect, diagnose and resolve performance problems in SQL Server can be very difficult. It often takes years of on-the-job experience to learn how to use the tools and techniques that help you detect when a problem is occurring, diagnose the root-cause of the problem, and then resolve the problem. This hands-on session will take you from the very start of a problem situation on SQL Server, showing you how to use the native tools that help you keep SQL Server at top performance.
SQL Server 2008 Resource Governor
Presenter: Steven Wright
Date: January 28, 2009
View Meeting: DBASIG_January2009.wmv
Download Meeting:
Description: In this presentation, Steve will provide an overview of Resource Governor, a new feature in SQL Server 2008 that gives DBAs and system administrators much more granular control over how CPU and memory are used by SQL Server. He’ll discuss the components that make up Resource Governor, then walk through examples of how to set it up along with various usage scenarios.
Automating Common DBA Tasks
Presenter: Jonathan Kehayias
Date: October 22, 2008
View Meeting: Automating_Common_DBA_Tasks.wmv
Download Meeting:
Description: Database Administrators often spend hours each day doing the same repetitive tasks; checking Error Logs, Backups, Drive Space, Agent History, Job Logs, and other common “checklist” items. Learn how to easily automate these common tasks in SQL Server 2000, 2005 and 2008 using the tools that are already available in the Operating System and SQL Server.
SQL Server 2008 Data Collection
Presenter: Gregory A. Larsen
Date: September 24, 2008
View Meeting: SQL2008 Data Collection Live Meeting.wmv
Download Meeting:
sigs.sqlpass.org/portals/0/dba/SQL2008DataCollectionLiveMeeting.zip
Description: This live meeting discusses the new Data Collection component of SQL Server 2008. This presentation covers how the Data Collection feature can be used to gather, monitor and provide trend analysis for key performance indicators in your SQL Server 2008 environment. This session discusses the architecture of the Data Collection component, how to configure it to collect statistics, and will review some of the standard reports available. Also discussed was how you can extend the data collection process by defining your own data collection routines.
New DBA Toys in SQL Server 2008 Part 1
Presenter: Sharon Dooley
Date: June 25, 2008
View Meeting: New DBA Toys in SQL Server.wmv
Download Meeting:
sigs.sqlpass.org/portals/0/dba/New DBA Toys in SQL Server.zip
Description: SQL Server 2008 introduces four major new capabilities: policy-based management, the Resource Governor, Performance Data Warehouse and auditing. This talk focuses on the first two. Part 2, which will be presented at a later date, covers the last two. Policy-based management allows you to enforce rules for how things should be on one or more servers. The terminology is complex, and the capabilities are immense. The Resource Governor allows you to define workloads and specify the resources, including cpu, memory and i/o bandwidth, a specific workload should have. In this demo-rich presentation, you'll get an introduction to the capabilities of both of these new features and learn how you can make them work for you. This presentation assumes a solid knowledge of Transact-SQL, a good understanding of SQL Server database engine features, as well as an understanding of the performance requirements of different types of queries.
Query Processing - Someone Else's Idea and Some of My Own
Presenter: Tjay Belt
Date: April 23, 2008
View Meeting: Query Processing - Someone else's ideas and some of my own.wmv
Description: The first noticeable aspect of SQL that is different from other programming languages is the order in which the code is processed. In most programming languages, the code is processed in the order in which it is written. In SQL, the first clause that is processed is the FROM clause, while the SELECT clause, which appears first, is processed almost last. The presentation will be a brief description of the different logical steps applied in both SQL Server 2000 and SQL Server 2005. You'll also see a demonstration of SQL code written by Itzik Ben-Gan from his book Inside Microsoft® SQL Server™ 2005 T-SQL Querying.
Notes: Suggest jumping 8 minutes and 30 seconds into recording to start the presentation
SQL Server 2008
Presenter: Greg Lowe
Date: November 28, 2007
View Meeting: SQL Server 2008 Features Overview.wmv
Download Meeting:sigs.sqlpass.org/portals/0/dba/SQL Server 2008 Features Overview.zip
Description: "An Early Look At SQL Server 2008". In this session, Greg will provide a rapid introduction to the highlights of SQL Server 2008. He will cover the messaging regarding the product, drill into the four pillars of the product with demos from each and then cover the way the CTP model for SQL Server has been implemented.
Notes: This session doesn’t have sound
Introduction to Scripting and Automation with SQLCMD
Presenter: Haidong “Alex” Ji
Date: October 27, 2008
View Meeting: Introduction to scripting and automation with SQLCMD.wmv
Description: This Live Meeting discusses sqlcmd, osql, isql comparison, Batch and Interactive mode, Variable for powerful scripting , Error Handling, and, Sqlcmd customization.
Notes: This session does not have sound
Optimizing Transactional Replication Performance
Presenter: Hilary Cotter
Date: September 26, 2007
View Meeting: Optimizing Transactional Replication Performance.wmv
Description: This Live Meeting discusses Basics, Monitoring, Architecture, Log Reader Agent, Distribution Agent, Cleanup Task, and, Resources.
Notes: This session doesn’t have sound
Advanced Tips and Techniques for Using SQL Server 2005 Profiler
Presenter: Brad M. McGehee
Date: August 27, 2007
View Meeting: Advanced tips & techniques for using SQL Server 2005 Profiler.wmv
Download Meeting:
sigs.sqlpass.org/portals/0/dba/Advance tips & techniques for using SQL Server 2005 Profiler.zip
Description: This Live Meeting discusses How to identify and analyze slowly performing queries, How to identify deadlock issues, How to identify sort warnings, How to identify blocking process, How to identify excessive auto stats activity, How to identify excessive SP compilations, How to identify excessive database file growth/shrinkage, and, How to identify excessive table/index scans.
Notes: This session doesn’t have any sound.
Microsoft SQL Server Outside the Box Scripting and Automation
Presenter: Edward J. Pochinski III
Date: July 25, 2007
View Meeting: Microsoft SQL Server Out Side the Box Scripting & Automation.wmv
Description: This Live Meeting discusses the following:
- Dump the event logs into a custom table which can be used for many different purposes such as alarming and testing a few queries.
- Load some performance data
- Use a WMI Script to monitor the MSSQL & SQL Agent Services.
- View a very simple cmd shell watcher script that views processes in time and monitors block for you.
- SA monitor scripts to detect if a SA account has been compromised. Plus dump some of the commands from the input buffer from the offensive SPID.
- VB Script that calls up Excel and loads useful data for a few different purposes.
Notes: Suggest jumping 8 minutes and 30 seconds into recording to get to the start of the presentation.
A Review of SQL Server Storage Practices
Presenter: Linchi Shea
Date: June 29, 2007
View Meeting: A Review of SQL Server Storage Practices.wmv
Description: Disk storage is a critical component in any SQL Server environment. As SQL Server evolves, so do SQL Server storage practices. From time to time, it is useful to stop and review how we manage storage in our SQL Server environments. In this presentation, we'll first highlight the concept of I/O path, and identify the key factors on an I/O path that may have a significant impact on SQL Server performance. We'll then discuss and evaluate various practices, opinions, or folklores with respect to these factors on the I/O path.
Notes: Suggest jumping 7 minutes and 30 seconds into recording to start presentation.
SQL Server Monitoring Strategies
Presenter: Bill Wunder
Date: May 23, 2007
View Meeting: SQL Server Monitoring Strategies.wmv
Description: This Live Meeting discusses:
- Describe the consideration for an effective monitoring strategy
- Drill to some of the more interesting monitoring problems
- Compare several different real world monitoring strategies
SQL Server 2005 Encryption: A Gentle Introduction
Presenter: Sharon F. Dooley
Date: May 23, 2007
View Meeting: SQL Server 2005 Encryption A Gentle Introduction.wmv
Download Meeting:
sigs.sqlpass.org/portals/0/dba/SQL Server 2005 Encryption A Gentle Introduction.zip
Description: This Live Meeting discusses the following information about encryption: Concepts; Backup and restoring encryption keys; Best practices.
Notes: Suggest jumping 8 minutes and 30 seconds into recording to start the presentation
|
|
|
The Professional Association for SQL Server (PASS) is an independent, not-for-profit association, dedicated to supporting, educating, and promoting the Microsoft SQL Server community. From local user groups and special interest groups (SIGs) to webcasts and the annual PASS Community Summit � the largest gathering of SQL Server professionals in the world � PASS enables knowledge sharing, in-depth learning, access to the Microsoft SQL Server team, and the ability to influence the direction of SQL Server technologies.
PASS was founded in 1999 by Microsoft and CA and continues to enjoy executive level endorsement from both organizations. As the number one user community for Microsoft SQL Server, Microsoft looks to the PASS community for valued feedback, input, and inspiration. PASS Mission Empower the global Microsoft SQL Server community to connect, share, learn and be inspired through networking, knowledge sharing, peer-based learning, and the ability to influence the direction of Microsoft SQL Server products and services.
|
|