Please note that this website will be temporarily unavailable during the period 5:00 PM PST on Friday, Dec. 19 and 11:59 PM PST on Saturday, Dec. 20 due to a planned server migration. PASS apologizes for any inconvenience.
The goal of the DBA Virtual Chapter is to provide a PASS community for the DBA. It provides a forum for open discussion and education on issues that face SQL Server database administrators.

Database Administration Virtual Chapter

Meeting Archive

Recordings and Files for events prior to 23 Oct 2013

 
 
 
 
Date: October 9, 2013 
Topic: I got 99 Problems but my backup aint one
Presenter: Richard Douglas
Abstract: 
Abstract: In this session, you’ll gain invaluable guidance for optimizing your backup and recovery efforts. Richard Douglas will show you how to dramatically accelerate backups, perform faster recoveries, and ensure your organization’s critical data is always protected. Plus, you’ll learn tricks and tips to master database monitoring and benchmarking to achieve peak system performance.
Date: September 25, 2013 
Topic: What the Heck is Hekaton? Part 2
Presenter: Sharon Dooley
Abstract: 
While I thought I was too old to deal with yet another release of SQL Server, I couldn’t resist the temptation to dig into it. And once I did so, I became very excited about a new feature that will enhance OLTP performance! It’s so great that Microsoft has finally put some things in the engine that will benefit those of us who labor in the mundane Order Entry, etc. trenches. Part 1 of this presentation (on August 22nd) focused on the architecture of this extension to the database engine. This presentation will cover the Hekaton concurrency model, the behavior of the transaction log when you’re using Hekaton and backup and recovery of Hekaton tables..
 
Date: September 11, 2013 
Topic: What the VLF
Presenter: Mike Hillwig
Abstract: 
Experienced DBAs know that SQL Server stores data in data files and transaction log files. What is less commonly known is that the transaction log file is broken up into smaller segments known as Virtual Log Files, or VLFs. Having too many VLFs will cause performance to suffer. And having too few will cause backup performance to suffer. How do you strike the right balance? In this more advanced session, veteran DBA Mike Hillwig will show you what VLFs are, how they're created, how to identify them, and how to strike the right balance between too few and too many.
Code and Demo Scripts http://mikehillwig.com/go/vlf  
 
Date: August 28, 2013 
Topic: What the Heck is Hekaton? Part 1
Presenter: Sharon Dooley
Abstract: 
While I thought I was too old to deal with yet another release of SQL Server, I couldn’t resist the temptation to dig into it. And once I did so, I became very excited about a new feature that will enhance OLTP performance! It’s so great that Microsoft has finally put some things in the engine that will benefit those of us who labor in the mundane Order Entry, etc. trenches. This presentation will focus on the architecture of this extension to the database engine. On September 25, Part 2 of this presentation will cover the Hekaton concurrency model.
 
Date: August 14, 2013 
Topic: SQL 2012 Columnstore Indexes
Presenter: Kevin Goff
Abstract: 
It might seem far-fetched that a company would upgrade to SQL Server 2012 just for a database index. But after you see the performance enhancements gained from the new in-memory columnstore index in SQL Server 2012, you’ll see why many are calling this one of the most important features in the history of SQL Server. In this presentation, I’ll talk about the physical aspects of columnstore index in SQL Server 2012, how to create it, and what environments (mainly data warehousing environments and ROLAP databases) and queries can make use of it. I’ll show performance benchmarks between columnstore indexes in SQL Server 2012, and compare them to index strategies prior to SQL Server 2012. I’ll also show how the new Batch execution mode can improve performance as well. Time permitting, I'll also talk about the new columnstore enhancements in SQL 2014, such as updateable clustered columnstore indexes.
 
Date: July 24, 2013 
Topic: SQL 2012 Highly Available BI Environments from the Field
Presenter: Chris Testa-O'Neill
Abstract: 
This one hour session will provide insight on what to expect when deploying a highly available end to end SQL Server 2012 Business Intelligence environment as experienced from the field. As well as leveraging the SQL Server Business Intelligence skills that you possess. You will also gain an insight into the additional skills and knowledge that you will need to ensure the successful delivery of technologies such as such as PowerPivot, PowerView, SQL Server Reporting Services and SQL Server Analysis Services on a robust SharePoint architecture.
 
Date: July 10, 2013 
Topic: Accelerate Database Performance Through Data Compression
Presenter: Joseph D'Antoni
Abstract: 
Much like the cars of the 1970s sacrificed gas mileage for better performance, database technology has also made its share of sacrifices for efficiency. Fortunately, times have changed significantly since then. Just as adding a turbocharger to a car delivers more power while saving fuel, the addition of compression to a database accelerates read performance while saving disk space.
Come and learn how, why, and when compression is the solution to your database performance problems. This session will discuss the basics of how compression and de-duplication reduce your data volume. We’ll review the three different types of compression in SQL Server 2012, including the overhead and benefits of each and the situations for which each is appropriate, and examine the special type of compression used for ColumnStore indexes to help your data warehouse queries fly. As with a turbo, data compression also has drawbacks, which we’ll cover as well.
.
Date: June 26, 2013 
Topic: AWSome - Totaljobs Group moves to the cloud
Presenter: Ed Vassie 
Abstract: 
Following its purchase by StepStone GmbH in April 2012, Totaljobs Group were required to vacate their former owner's data centres by the end of the year.
Existing plans to move to AWS were endorsed and the fun began! Over the following 7 months we completed:
  Proof of Concept
  Implementation of SQL P2P replication
  Migration to SQL 2012
  Standardisation on Windows 2008 R2
  Migration of 'Recruiter' website to 64-bit and IIS7
  Migration to new Email solution
  Migration to new Backup solution
  Production Environment Build in AWS
  Server consolidation, eliminating 40 servers
  Full Regression Testing
  Go-Live
  Decommissioning of old servers
This was achieved while significantly improving site response time, and reducing infrastructure costs by one third.
This seminar takes you through the process we went through to deliver these changes. It will explain the AWS building blocks needed to host a high performing and secure site, and some differences in mind-set needed when working with evergreen infrastructure. The end result is a blueprint you can adapt for your own migration into AWS.
 
Date: June 12, 2013 
Topic: The nightmare of locking, blocking and isolation levels
Presenter: Boris Hristov 
Abstract: 
I am sure you all know that troubleshooting problems related to locking and blocking (hey, sometimes there are deadlocks too) can be a nightmare! I also know that you struggle to find some time to go a bit deeper and learn what the various isolation levels can do for you. In this one-hour session, you will be able to see and understand why locking happens, how the locking manager actually works and how can we resolve various locking problems with different techniques ranging from query hints to changing the isolation levels.
 
Date:  May 8, 2013
Topic: SQL Server Internals Series: Physical Join Operators
Presenter: Ami Levin 
Abstract: 
SQL Server implements three different physical operators to perform joins. In this session you'll see how each of these operators work plus its advantages and challenges. You also get to see some informative demos.
You'll learn
•         The logic behind the optimizer's decisions
•         Which operator to use for various joins using (semi) real life examples
•         How to avoid common join-related pitfalls
 
Date: April 24,2013 
Topic: Using PSSDiag to Troubleshoot Performance Issues
Presenter: Stacy Laray 
Abstract:
PSSDiag uses SQLDiag, which ha shipped with every version of SQL Server since SQL 2000. This presentation will tell you what the tool is, why you’d want to run it and how to interpret the output. This utility is used by Microsoft SQL Support Engineers, and it’s available to you, too!
Date: April 10,2013 
Topic: Setting Up Clustered SQL Servers in a Virtual Environment
Presenter: Ilya Rubinshteyn 
Abstract:
SQL Clusters have been around for a while, yet are still not well understood. Active/Active, Active/Passive, what is needed are questions that still cause confusion with DBAs and Systems Administrators. The proliferation of virtualization adds even more to the confusion. This session attempts to clarify some SQL clustering basics and identify some best practices and pitfalls of creating virtual SQL clusters.
Date: March 27,2013
Topic: Master of All I Survey - Tracking Code Changes Across Dozens of Servers Seamlessly and Automatically
Presenter: Michael Bourgon 
Abstract:
Everyone's been bitten by it - rogue changes made on servers, be it SPs, index rebuilds, or even configuration changes. What if you knew? What if you could look historically across servers and track down what changes were made when, by who, and from where? It exists, it's already built into MSSQL, it's easy to implement and it's been there waiting for you for 7 years. Come learn what Event Notification is and why you'll want it in your environment.
Date: March 13,2013
Topic:  Managing FILESTREAM and File
Presenter:  Sven Aelterman
Abstract:
SQL Server 2012 continues support for FILESTREAM, first introduced in SQL Server 2008. In addition, FileTable is a related new feature that opens up new possibilities. For server and database administrators working with FILESTREAM-enabled databases, the experience is somewhat different than dealing with relational data. This session covers the prerequisites for FILESTREAM and FileTable and common configuration and management tasks.
Date: February 27, 2013
Topic:  Data Warehouse Architecture
Presenter:  James Serra
Abstract:
You’re a DBA and your boss asks you to determine if a data warehouse would help the company. So many questions pop into your head: Why use a data warehouse? What is the best methodology to use when creating a data warehouse? Should I use a normalized or dimensional approach? What is the difference between the Kimball and Inmon methodologies? Does the new Tabular model in SQL Server 2012 change things? What is the difference between a data warehouse and a data mart? Is there any hardware I can purchase that is optimized for a data warehouse? What if I have a ton of data? During this session James will help you to answer these questions so your response to your boss will provoke amazement and lead to a big raise. Or at least help to lead you down the correct path!
Date: February 13, 2013
Topic:  Hardware 301: Diving Deeper into Database
Presenter:  Glenn Berry
Abstract:
Making the right hardware selection decisions is extremely important for database scalability. Having properly sized and configured hardware can both increase application performance and reduce capital expenses dramatically. Unfortunately, there are so many different choices and options available when it comes to selecting hardware and storage subsystems, it is very easy to make bad choices based on outmoded conventional wisdom. This session will give you a framework for how to pick the right hardware and storage subsystem for your workload type. You will learn how to evaluate and compare key hardware components, such as processors, chipsets, and memory. You will also learn how to evaluate and compare different types of storage subsystems for different database workload types. This session will give you the knowledge you need to make sure you get the best performance and scalability possible from your hardware budget!.
 
Date: January 23, 2013
Topic:  Resource Governor
Presenter:  Dinesh Asanka
Abstract:
Resource Governor is a new technology introduced in SQL Server 2008 that enables you to manage SQL Server workload and resources by specifying limits on resource consumption by incoming requests.
 
Date: January 9, 2013
Topic:  Revenge: The SQL Part 2: The Sequel!
Presenter:  Rob Volk
Abstract:
In a world...where DBAs are blamed, mistreated, and overworked...one man...WILL. GET. EVEN. In this entertaining and impractical follow-up to the entertaining and impractical Revenge: The SQL, Rob Volk will show you even more impractical but oh-so-tempting ways to get back at those who abuse SQL Server and make you clean it up. Techniques will cover: preventing sa use, preventing ad-hoc SQL, cursors and missing WHERE clauses, and the ever-popular trigger mayhem. And if you stay for the after-credits sequence you may encounter the evil twins, duplicate primary keys!
Download Scripts RevengeTheSQL2_PASSVC.zip
 
Date: December 12, 2012
Topic:  Revenge: The SQL!
Presenter:  Rob Volk
Abstract:
Have you been wronged, cheated, lied to, lied about, or deceived by a coworker? Feel like your DBA position offers no opportunity for revenge? WRONG! This session is a light-hearted exploration of some delightfully mischievous SQL design patterns that will annoy, aggravate, and antagonize anyone who has to work with them...even though they deserved it! Learn how to create tables with no names, columns with duplicate names, and write perfectly valid yet utterly nonsensical SQL. You may never get to use these techniques…but you'll ache for the chance!
 
Date: November 14, 2012
Topic:  Parallel Data Warehouse Version 2
Presenter:  Jack Bradham
Abstract:
• Introducing PDW v2
• Engineering Design Goals
• New Hardware Architecture
• New Database Features
 
Date: October 24, 2012
Topic:  Trimming Indexes, Getting Your Database in Shape
Presenter:  Bradley Ball
Abstract: Indexes are a wonderful thing. We should be using them, and we should be maintaining them. But over time our production databases start to look a little pudgy around the mid-section. Maybe they are a little bloated with Unused Indexes, maybe they have Duplicate Indexes, and possibly even Reverse Indexes. The first step to fixing these problems it so see if you have them and if you do the second is to set about fixing them. You could be costing yourself CPU cycles, I/Op's, and space and never even know it.
  
Date: October 09, 2012
Topic:  Memory Management in SQL Server 2012
Presenter:  Neil Hambly
Abstract: SQL Server 2012 brings a wide range of changes from its previous versions - one key change is the way SQL Server memory is managed. With releases prior to SQL Server 2012, there were 2 memory managers, these have been merged into 1 with the latest version, and that’s just the start of the changes for SQL Server memory. This session will dive into questions related to memory in SQL Server 2012.
 
Date: September 26, 2012
Topic:  Case Studies in Rewriting Transact 
Presenter:  Jeff Garbus
Abstract: This presentation covers 2 real-life scenarios in rewriting t-sql code. We talk about what makes the code inefficient and a variety of approaches on how to fix it & determine the best approaches to identifying which approaches are best.
 
Date: August 22, 2012
Topic:  What on earth is a contained database?
Presenter:  Sharon Dooley
Abstract:
Anyone who has ever needed to move a database from one server to another has experienced the pain of dealing with mismatched SQL Server authentication logins. In this session, I will describe what a contained database is and how this new 2012 feature can ease your pain. I'll look at some of the advantages and disadvantages of this feature and talk about the new SQL Users with Passwords and Windows users. I'll demonstrate how to create a contained database and how to connect to it. Then I will demonstrate the process of making an existing database contained. If time permits, I’ll also talk about the way contained databases handle differences in collation between the contained database and tempdb.
 
Date: August 8, 2012
Topic:  Best Practices for Monitoring Databases on VMware
Presenter:  Kathy Gibbs
Abstract:
SQL Server on VMware??? Many of our customers are either virtualizing databases or planning to do so soon. I hear from many groups that attempted running their database on VMware but went back to physical hardware because of performance issues. There are many reasons this may have happened, but quite often the decision to go back to physical was not based on hard facts. This presentation will explore the fundamentals of monitoring databases running in a VMware environment. If you are using classic O/S monitoring tools, you may be getting misleading data. Understand what metrics are important and how to get to that data.
 
 Date: June 27, 2012
Topic:  SQL Server Security Architecture Decomposed
Presenter:  Ayman El-Ghazali
Abstract:
Security can be difficult to understand when first approaching SQL Server due to the many layers. In this webinar we will take a top down look at SQL Server Security and then "peel" its layers one by one to understand how it works. This webinar will help those who wish to understand security layers and concepts better with in SQL Server. We will cover how to properly manage individual and group access to your SQL Instance, Databases, and many other securables. Please join us on this journey from your server's network port all the way to your tables, stored procedures, and functions.
Code and Slides are available at:  http://www.thesqlpro.com
     
Date: June 22, 2011
Topic:  Extended Events, Work Smarter Not Harder - Part 2
Presenter:  Jason Strate
Abstract: 
In the last session, we dug into the basics of Extended Events (XEvents).  We arrived at an understanding of what is available with XEvents and how to use it.  In this session, we'll go deeper and look at how to use XEvents for performance tuning and troubleshooting. We’ll explore some common performance issues related to SQL Server and demonstrate method to resolve those issues. 
Date: June 13, 2012
Topic:  Don't Panic - Keep Calm and Organize Your DR
Presenter:  AJ Mendo
Abstract:
Chances are sooner or later you will experience a disaster of some sort. Having the knowledge and skills needed to recovery after a disaster is one of the most important skills a DBA needs to have. Practicing those skills will make you more confident and help you handle yourself during the recovery process instilling calm in others.
 
In this session AJ will discuss what it means to have a recovery plan. He will talk about Service Level Agreements and what you need to know about them. He will talk through several scenarios and demonstrate how to recover from each one. AJ will provide the scripts so you can practice on your own and give you the confidence to Keep Calm And Organize Your DR Plan.
View: Don'tPanicKeepCalmandOrganizeYourDRPlan_061312.wmv
 
Date: May 23, 2012
Topic:  SQL 2012 -- All About HA and DR
Presenter:  Joey D'Antoni
Abstract:
Have you heard about all of the new Availability Group features in SQL 2012? Thinking about implementing a DR solution, but don't know where to start. In this presentation you'll learn all about the new DR features in SQL Server 2012 and see them in practice..
View: SQL2012AllAboutHAand DR_052312.wmv
 
Date: May 9, 2012
Topic:  DBCC Commands: The Quick and the Dangerous
Presenter:  Erin Stellato
Abstract:
There are many DBCC statements at the disposal of Database Administrators and Developers. Some are used for the greater good; others can wreak havoc in your system. The majority of these commands are informational, but if you’re not careful you can introduce chaos or at worst, lose data you may never find again. In this session we will explore DBCC commands that are useful for the DBA and developer, and cover when to use them and how. Expect demonstrations that provide a practical application of these commands - both documented and not - that database professionals can utilize quickly and easily.
View: DBCC CommandDBCCCommandsTheQuickandtheDangerous_050912.wmv
Download Scripts DBCC_050912.zip
 
Date: April 25 2012
Topic:  Manage SQL Server 2012 on Windows Server Core with PowerShell
Presenter:  Allen White
Abstract:
Windows Server 2008 introduced Server Core, the operating system without the Graphical User Interface. SQL Server 2012 is the first version of SQL Server to support Server Core. To gain the maximum efficiency from your servers you want to make use of Server Core and with PowerShell you can effectively manage SQL Server in that environment. This session will demonstrate how to manage SQL Server 2012 on Windows Server Core and provide scripts to help you perform the common tasks you need to perform on that platform.
View: Manage SQL Server 2012 on Windows Server Core with PowerShell_042512.wmv
 
Date: April 11, 2012
Topic:  SQL Server Replication
Presenter:  Hilary Cotter
Abstract:
Replication is a native SQL Server component which allows you to copy data from one database or server to another and can be configured to replicate bi-directionally.
In this webcast, SQL Server MVP., Hilary Cotter discusses replication types as well as common use cases and problems, as well as troubleshooting and monitoring and how to squeeze optimal performance from merge, transactional and bi-directional replication.
 
Date: March 28, 2012
Topic:  Work Smarter Not Harder - Standardize Your Environment With Best Practices
Presenter:  AJ Mendo
Abstract:
Are all your servers standardized across your environment? Do you manually click the next button when installing SQL Server? Do you manually create and configuring your routine maintenance? Are your SQL Agent Jobs owned by other DBAs in your group? Do you know when jobs fail? Or discover them accidentally? Do you have a standardized way to deploy updates?
We will discuss all these things and some others during this session and hopefully when we come out the other side some of this will make your life easier.
1. Attendees will learn how to setup standards for your environment and get other to agree to follow them.
2. Attendees will learn having a standard environment eases the pain of deployments for your projects and ones you support only part of the time. It will also help with trouble shooting.
3. Attendees will see how a standard environment will allow scripting of certain tasks and the set-up/configuration of new servers faster and easier.
 
Date: March 14, 2012
Topic:  Policy-based Management Overview
Presenter:  Victor Pavlov
Abstract:
The session will go over what Policy-based Management is and how to use it. I will create one policy using  SQL Server 2012 RC0.
 
Date: February 22, 2012
Topic:  Mirroring Start to Finish
Presenter:  Ryan Adams
Abstract:
Mirroring can be an integral part of your high availability and disaster recovery planning. We’ll cover what mirroring is from start to finish, how it can fit into an HA/DR plan, the rules surrounding its use, configuration via the GUI and T-SQL, as well as how to monitor mirroring. This presentation is designed to not only give you an overview of mirroring, but to also walk you through a basic implementation. At the end you will have learned what mirroring is, how it can fit into your environment, what business requirements it solves, and how to configure it.
 
Date: January 11, 2012
Topic:  New DBA Features in SQL Server 2012
Presenter:  Ayman El-Ghazali
Abstract: 
The session will go over a few of the new features and some demos for SQL Server 2012
Date: October 26, 2011
Topic:  Transparent Data Encryption
Presenter:  Ben Miller
Abstract: 
In SQL Server 2008 Enterprise edition you have the ability to use Encryption for “At Rest” database files. This presentation will cover how this works and how you set all this up. I will also show a few gotchas in using TDE and when the presentation is over, you will have a pretty good handle on how Encryption works in SQL Server, not just with TDE but with the Encryption Hierarchy as well. The demos will create a database and encrypt it and show how it works when you move databases to another server.
Date: September 28, 2011
Topic:  SQL Server N-Way Clusters and Denali Availability Groups
Presenter:  Ryan Lence 
Abstract: 
This session will provide a deep dive into building, supporting, and maintaining SQL Server N-Way clusters and Denali Availability Groups. From SQL Server 2005, 2008, 2008 R2 and now 2012, Microsoft has made several improvements to HA and N-Way clustering technologies. Here we will go over the differences between these versions, and go under the covers to look at cluster logging, mount points, MSDTC, cluster groups, patching, using Availability groups instead of traditional clusters, etc. Mission critical topics like how to I add new cluster instances without affecting uptime, and what is the right way to expand the cluster will be covered. We will also go over how to create your own Virtual N-Way Cluster for testing using iSCSI between virtual machines on a laptop. This session will be filled with real world examples, and demos to help the participants gain a deeper understanding of using N-Way clusters and Availability Groups to solve real world issues, while reducing the total cost of their SQL Server environment.
Date: September 14, 2011
Topic:  Through the Looking-Glass With DMVs, and What Alice Found There
Presenter:  Greg Larsen 
Abstract: 
When your world is SQL Server, you need a looking-glass to determine server health, diagnosis problems, and tune performance. In this session will we follow Alice through the looking-glass to determine what she finds in SQLServerLand. Alice will be using dynamic management views and functions (DMVs) to explore the land behind the looking-glass. She will find statistics, poorly performing queries, and much more. Follow Alice and her new friends, as she traverses across SQLServerLand and provides you with snippets of T-SQL code that you can use to explore your own SQLServerLand.
Date: August 24, 2011
Topic:  Missing Index Gotchas
Presenter:  Vicky Harp
Topic:  Manage Your Shop with CMS and Policy Based Management
Presenter:  Ryan Adams
Abstract: 
In this presentation we talk about Central Management Server and how it can help you manage a disperse environment. We will also cover what Policy Based Management is and how you can leverage its power to better manage your environment. With PBM we'll see what it can and cannot do to help you enforce standards in your enterprise. We will cover and demonstrate PBM for the beginner from creating and evaluating policies to receiving alerts on policy violations..
Date: July 27, 2011
Topic:  Concurrency Control
Presenter:  Sebastian Meine
Abstract: 
This session will explain the different transaction isolation levels that SQL Server provides. You will see examples of different locking and blocking behaviors and you will gain insight into how the transaction isolation level affects query concurrency and performance.
Date: June 8, 2011
Topic:  Extended Events, Work Smarter Not Harder - Part 1
Presenter:  Jason Strate
Abstract: 
There are many ways to performance monitor your SQL Server environment.  In this session we’ll introduce you to Extended Events; which is one of the newer SQL Server monitoring platforms.  Learn the ins and outs of how to get detailed information on the errors and events that occur within SQL Server and how to dig into the information.  With a few T-SQL statements, issues that could take weeks to research can be investigated in minutes. 
Date: May 25, 2011
Topic:  Let Service Broker Help You Scale Your Application
Presenter:  Allen White
Abstract: 
How your business applications interact with the corporate database directly can have a dramatic impact on how successful you are, and one of the biggest issues is performance with large databases.  By designing the application to use asynchronous messaging for non-critical updates you can focus performance concerns to where the timeliness is critical.  SQL Server Service Broker handles the asynchronous requests quickly and efficiently, and minimizes the conflicts with your critical updates.  This session will walk you through the steps to get Service Broker up and running and providing a consistent delivery of your business data. 
Date: May 11, 2011
Topic:  Getting To Know Your DB
Presenter:  Jason Brimhall
Abstract:
In this session we will explore some practical scripts to help create database documentation. We will be looking at how to make some of those documentation tasks easier, while giving you greater insight into your database(s). Attendees will be able to leave with some additional tools for their toolbox and through the use of these scripts the attendee will be able to perform these tasks faster. 
View:  Getting_To_Know_Your_DB_051111.wmv  
Download Demo Script and Slides:  GettingToKnowYourDB_051111.zip
Date: April 27, 2011
Topic:  Dr Availability, You're Wanted in the Recovery Room
Presenter:  Kendal Van Dyke
Abstract:
There are a lot of options when it comes to disaster recovery and high availability with regards to SQL Server. Most business owners (and many DBA's) lump disaster recovery (DR) & high availability (HA) together and while they do share some pieces, they call for different strategies. Do you pick one or more than one of these options, and based on what? It's incredibly important that you understand the decision tree that helps you pick the right one(s) for your business, and that you can explain the choices clearly to the stakeholders. It's not as complicated as it sounds, but it is complicated – and in this hour presentation we'll give you a high level understanding of the options, the costs, complexities, & reasons for using each of them. 
View:  Dr Availability_042711.wmv
 
Date: April 13, 2011
Topic:  Server Consolidation - Using Virtualization, Lessons Learned & Roadmap
Presenter:  Lindsey Allen & Prem Mehra
Abstract:
Please attend this session for a comprehensive understanding of SQL Server consolidation using virtualization and available tools to help you plan, deploy, and manage the consolidated environment. We will share what other customers are doing to consolidate their server sprawl and discuss best practices gained from working with them. 
Date: March 23, 2011
Topic:  Page and Row Compresion: How, Why, and When
Presenter:  Bradley Ball
Abstract:
Page and Row Compression are powerful new tools. Vardecimal shipped with SQL 2005 SP2, Page & Row with SQL 2008 RTM, and Page & Row with Unicode Compression with SQL 2008 R2. Get an overview of how each version of compression works internally. Learn how your Allocation Units will determine if your data is a candidate for compression. Understand how your tables’ Update and Scan patterns affect the compression types you should consider as well as what you should you take into consideration for additional overhead. 
 
 
Date: February 23, 2011
Topic:  Tips and Tricks for Writing Better Queries
Presenter:  Joe Webb
Abstract:
Transact-SQL is not a very difficult language to learn. As long as the syntax is correct, it can be quite forgiving. However to truly get the best performance from your SQL Server, careful consideration should be given to the structure and logic of the queries. In this session, we’ll discuss some Transact-SQL tips and tricks that can be employed to help you write better queries, allowing your server to perform better. 
 
Date: February 9, 2011
Topic:  Windows Failover Clustering Basics for the DBA
Presenter:  Allan Hirt
Abstract:
While you can go to numerous places to see how to install SQL Server in a clustered configuration, what a DBA really needs is a solid foundation of Windows to truly be able to understand that SQL Server implementation and its subsequent administration. This session will demystify the Windows layer of clustering and present it from a DBA focus. Using Windows Server 2008 R2, some of the topics that will be shown are: failover cluster validation and its impact on installing SQL Server, a tour of the new Failover Cluster Manager and how it can be used for administration, using the new cluster logs for troubleshooting, and more.
View:  Windows Failover Clustering Basics for the DBA.wmv
 
Date: January 26, 2011
Topic:  How SQL Server Indexes Work
Presenter:  Sharon 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.
View:  How_SQL Server Indexes Work.wmv
Download Slide Deck:  How_SQL_Server_Indexes_Work.pptx
 
Date: December 8, 2010
Topic:  Dr. DMV: How to use Dynamic Management Views to Monitor and Diagnose Performance Issues with High Volume OLTP Workloads
Presenter:  Glenn Berry
Abstract:
SQL Server 2005 introduced Dynamic Management Views (DMVs) that allow you to see exactly what is happening inside your SQL Server instances and databases with much more detail than ever before. SQL Server 2008 R2 adds even more capability in this area. You can discover your top wait types, most CPU intensive stored procedures, find missing indexes, and identify unused indexes, to name just a few examples. This session (which is applicable to both 2005, 2008 and 2008 R2), presents and explains over thirty DMV queries that you can quickly and easily use to detect and diagnose performance issues in your environment.
 
Date: October 27, 2010
Topic:  A PowerShell Cookbook for DBAs
Presenter:  Trevor Barkhouse
Abstract:
This introduction to PowerShell is different than most.  Instead of starting with a full treatment of the language, you will receive a brief overview then a collection of "recipes," stand-alone PowerShell scripts that automate various administration tasks for SQL Server 2000, 2005, 2008/2008 R2.  You will learn by example, and quickly realize why investing a little time into learning PowerShell will make your job a great deal easier.
 
Date: October 13, 2010
Topic:  Use PowerShell to Get the Most out of SQL Server
Presenter: Allen White
Abstract:
PowerShell is the new scripting environment from Microsoft for managing server environments.  Because PowerShell supports the .Net Framework, accessing SQL Server in a scripting environment is easier than ever before.  Whether you need to access data or manage SQL Server, PowerShell makes it possible.  This session will give an introduction to PowerShell, explain the basic ADO.Net objects required to connect with SQL Server, and demonstrate accessing SQL Server from PowerShell scripts, both from a data and a management perspective.
 
Date: September 22, 2010
Topic: Top 10 SQL Server Mistakes and Missteps
Presenter: Tim Ford
Abstract:
From Tim Ford's (@SQLAgentMan's) continuing blog series on the same topic comes a presentation in which we'll go over common mistakes made by new and seasoned SQL Server Professionals alike. Learn how to avoid these issues before they happen and correct matters after you've seen them in your environments
 
Topic: Ins and Out of Data Protection and High Availability
Presenter: Don Allen
 
Date: August 25, 2010 
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
Date: May 12, 2010  
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.
View:   IndexingGuidelines.wmv
Download Meeting:  
IndexingGuidelines.zip
Download Scripts:  IndexingGuidelinesScripts.zip
 
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

 

 TitleCategoryDescription 
testtesttestDownload
BestPracticesforMonitoringDatabasesonVMware_080812 Presenter: Kathy GibbsDownload

Meeting Archive