SQLRALLY.com PASS SQLRally 2011 www.sqlpass.org Twitter Facebook LinkedIn

To vote on which Enterprise Database Administration & Deployment sessions you would like to see presented at PASS SQLRally 2011, please click hereNote: To register to vote for PASS SQLRally 2011 sessions during future rounds, click here

The following abstracts have been submitted for the Database & Application Development category for PASS SQLRally 2011. Voting for these sessions will take place Jan 24-30, 2011.

Category Quick Links

Administration
HA/DR
Indexing & Partitioning
Monitoring/Auditing
PBM
Performance
PowerShell
Responsibilities
Security
Storage
Summit Spotlight


Administration

Title: Fundamentals of SQL Server Internals
Speaker: Jeremiah Peschka
Category: Administration
Level: 200
Abstract: Want to know what makes SQL Server tick? Ever wonder what SQL Server is doing when you run a query? Ever wonder which parts of SQL Server are responsible for specific functionality? Want to know what a HOBT is? I can’t promise answers to every question, but I can set you on the path to knowledge about the inner workings of SQL Server.
Session Goals
  • Identify the layers of SQL Server
  • Learn what happens when a query is submitted and executed
  • Understand how the layers of SQL Server interact
Speaker Bio: Jeremiah Peschka is an Emerging Technology Expert with Quest Software. Jeremiah works with different software to identify new techniques and trends in the world of data storage. Over the course of his career, Jeremiah has worked as a system administrator, developer, and DBA. When he is not volunteering with the development community, Jeremiah blogs about data storage, relational databases, and software development at http://facility9.com. He can also be reached on Twitter via @peschkaj



Title: Overview of SQL 2005 Service Broker
Speaker: Said Salomon
Category: Administration
Level: 200
Abstract: This session will be a basic review of SQL 2005 Service Broker. It will explain what SQL 2005 Service Broker is, and how can it be used. The presentation will include a number example applications and demos of basic SQL 2005 Service Broker.
Session Goals
  • Explain what SQL Service Broker is.
  • Explain how SQL Service Broker works.
  • Show how SQL Service Broker can be used.
Speaker Bio: Said Salomon has over 25 year experience as an IT Professional. He has a vast array of abilities in the field in the areas of Network, Desktop Support, DBA, Staff Project Management, Application Software Development, Business Analysis and Quality Assurance. Said carries Microsoft certifications as a MCTS, MCPS, and MCNPS, and multiple certifications from the Insurance Institute of America. Current Said is a DBA at Unitrin Direct Insurance. Secretary of Philadelphia SQL Server User Group (PSSUG). I am also the SQL Track lead for the Philly Dot Net Code Camps.



Title: SQL SERVER 2011 (Denali) - AVAILABILITY AND MANAGEABILITY ENHANCEMENTS
Speaker: David Pless
Category: Administration
Level: 300
Abstract:

In this session we will cover the Availability and Manageability enhancements to SQL Server 2011 "Denali". For availability, SQL Server "Denali" introduces the "HADR" solution for enhancing availability of user databases. "HADR" is a high-availability and disaster recovery solution to enable you to maximize availability for one or more of your user databases. "HADR" involves configuring one or more availability groups. Each availability group establishes the context within which a selected set of user databases can fail over as a single unit. Similar to Database Mirroring, "HADR" involves a set of failover partners, known as availability replicas. Each availability replica possesses a local copy of each of the databases in the availability group. One of these replicas, known as primary replica, maintains the primary copy of each database. The primary replica makes these databases, known as primary databases, available to users for read-write access. For each primary database, another availability replica, known as a secondary replica, maintains a failover copy of the database known as a secondary database. The SQL Server instances can be either failover cluster instances or stand-alone instances.

In this session we will discuss the "HADR" architecture and connectivity as well as discuss how it compares to other high availability options.  We will also discuss setting up and configuring "HADR", role switching and failover methods, and allowing Read-Only Access to Secondary Replicas and monitoring "HADR" Availability Groups. New Manageability features are: The Query Editor introduces enhanced functionality for T-SQL debugging and IntelliSense. The Watch window now supports watching Transact-SQL expressions. T-SQL IntelliSense introduces the following:
* Breakpoint validation prevents setting a breakpoint in an invalid location.
* T-SQL code snippets are templates you can use as starting points when building statements.
* T-SQL Surround with snippets are templates you can use as starting points when enclosing sets of Transact-SQL statements in a BEGIN, IF, or WHILE block.
Other changes include: Moving databases from one instance of the SQL Server Database Engine to another instance is simplified. Users in a contained database are no longer associated with logins on the instance of SQL Server. Startup options are now configured by using a new Startup Parameters tab of Configuration Manager.

Session Goals
  • Understand the new Availability and Manageability improvements to SQL Server 2011 CTP2 (latest). We will cover HADR and cover the changes to the SQL Server 2011 tool set.
  • Understand how SQL 2011 can help address availability needs with HADR versus the previous high availability technologies.
  • We will cover the improvements to SQL Server Management Studio and Configuration Manager and how they can be applied as well as the new Contained Databases change to user databases. We will also cover other changes to the latest CTP.
Speaker Bio: I am a Senior Premier Field Engineer with Microsoft. As a PFE I perform health checks, conduct chalk talks and full training workshops, and work on reactive and other proactive engagements on SQL Server 2005 and SQL Server 2008 / R2. I support Florida and the Southeast, but can support customers anywhere in the world. My core areas are SQL Server Performance Tuning and Optimization, Database Mirroring SQL Server 2005 / 2008 R2, SQL Server Reporting Services (SSRS), SQL Server Integration Services (SSIS), and other topics such as consolidation, Table Partitioning, Resource Governor, Performance Data Warehouse, SQL Server Auditing, and more. Previous Speaking Experience: I have been speaking consistently with Microsoft over the past four years over numerous topics such as SQL Server Performance Tuning and Optimization, Database Mirroring, SSRS, and SSIS. While I have been at Microsoft I have also built full workshops for Premier customers for repeat delivery scheduling workshops all over the world. External to Microsoft, I have spoken at the SQL PASS Conference in 2009 covering Performance Tuning Techniques. I have also spoken at the Orlando SQL PASS Chapter (OPASS) and the Space Coast SQL Server Chapter (SCSUG).



Title: Top 10 SQL Server Defaults to Evaluate and Modify
Speaker: Jason Wong
Category: Administration
Level: 300
Abstract:

SQL Server is so easy to use that in many enterprises, individual departments have installed SQL Server without involving the DBA management team. Often the DBA team is not even aware of the departmental SQL Server installation until a problem occurs that requires expertise beyond what the department can provide. Working with SQL Server for many years, I have rescued a number of organizations from degrading database performance back to outstanding production database.

In this session, I will discuss top 10 SQL server default settings that DBAs need to evaluate the best settings for their environment. I will elaborate how these values will impact your database operations.
1. Recovery model (default full)
2. Min - Max memory (default 0 to maximum)
3. Initial size, auto-growth ( 2MB data, 1 MB log, auto-grow: true)
4. Default Isolation Level (default Read Committed)
5. Fill Factor (Index) (default 0/100)
6. Primary Key Clustered Index (PK default to Clustered Index)
7. Unique identifier
8. Collation
9. Data type - nvarchar(255), the "N" 10.
What you can expect to take away from this session: 1. Learn the dos and don’ts in SQL Server 2. Understand the default server configuration and its impacts 3. Draw best practice principles based on real world scenarios 4. Learn the consequences if defaults are not understood, not modified 5. Best design to utilize the SQL Server new features

Session Goals
  • Understand the default server configuration and its impacts. Learn dos and don'ts.
  • Draw best practice principles based on real world scenarios
  • Best design to utilize the SQL Server new features such as snapshot isolation
Speaker Bio: http://usa.redirectme.net

HA/DR

Title: The Great High Availability Hustle
Speaker: Mark Broadbent
Category: HA/DR
Level: 200
Abstract: You have just started your new position and are very proud to be joining ACME Corp. Unfortunately for you, they are running several SQL Server Clusters and you happened to tell that little white lie about understanding Clustering. Actually it wasn't so much a lie, but you always had the support of a Windows Clustering expert and now you are on your own. In this presentation I will demonstrate:- How to setup and install SQL Server 2008 Clustering, troubleshooting and administration, repairing a SQL Cluster and disaster recovery techniques in the event of failure, and much more.
Session Goals
  • The session should deliver a good understanding of how SQL Server can be installed in a clustered configuration.
  • The session will provide useful overview of how to manage and administrate the cluster and what not to do.
  • Disaster and recovery scenarios will be covered so that the attendees can feel confident that, should the worst happen, the cluster can be brought back to a state of health.
Speaker Bio: Mark Broadbent is SQL Server specialist and has been using SQL Server since 1997 starting from SQL 6.5 and every release since in numerous highly available configurations. He has worked with many other Microsoft products and likes to dabble with other platforms and environments. Mark currently holds Microsoft professional accreditations MCSE+i, MCAD.NET, MCDBA, MCITP Database Administration for SQL 2005 and SQL 2008 and MCITP in Database Development for SQL 2008.  



Title: Orders of magnitude: Scale-Out your SQL Server Data
Speaker: Mark Broadbent
Category: HA/DR
Level: 300
Abstract: Your company is about to embark on a major overhaul of your current IT infrastructure and applications and want you to start thinking about their Data Tier. Your remit is that "this is a one off investment and an opportunity for change" and due to the speed of growth of your organization, you should plan for capacity and scalability requirements to accommodate for long term growth and expansion. It is now your job to start investigating possible ways to achieve and implement this goal In this presentation I will discuss many different methods and techniques to enable server and enterprise based scaling of your data covering diverse subjects including (but not limited to) database schemas, indexing, horizontal partitioning and what I believe is SQL Server's best kept secret!
Session Goals
  • To demonstrate the numerous scale-out techniques possible using SQL Server 2008
  • To discuss situations where scale-out is suitable and unsuitable.
  • To reveal various scale-out strategies that are not commonly known and to demonstrate that SQL Server 2008 is no longer a single server based product but is truly an Enterprise level database server.
Speaker Bio: Mark Broadbent is SQL Server specialist and has been using SQL Server since 1997 starting from SQL 6.5 and every release since in numerous highly available configurations. He has worked with many other Microsoft products and likes to dabble with other platforms and environments. Mark currently holds Microsoft professional accreditations MCSE+i, MCAD.NET, MCDBA, MCITP Database Administration for SQL 2005 and SQL 2008 and MCITP in Database Development for SQL 2008.  



Title: Peer-to-Peer Replication: Real Life Implementations and Best Practices
Speaker: Meir Dudai
Category: HA/DR
Level: 300
Abstract: Many organizations require challenging scalability and high availability solutions for their database implementations. Peer-to-Peer Replication is one of the most powerful tools in SQL Server. It is a robust technology allowing High Availability and scalability that every DBA and system architect should be aware of. In the session, we will learn how to leverage Peer-to-Peer replication in real-life scenarios in which replication can provide an optimal solution for the business’s requirements. We will go through best practices and see some tips & tricks for easy implementation and maintenance of Peer-to-Peer replication.
Session Goals
  • Understand Peer-to-Peer replication capabilities for high availability and scalability
  • Learn how to implement Peer-to-Peer replication in real life scenarios
  • Learn tips & tricks for easy implementation and maintenance of Peer-to-Peer replication
Speaker Bio: I am involved in SQL Server projects since 1998. My background includes working as a senior consultant for SQL Server as a partner of Microsoft MCS. In 2005 I founded Valinor, which is the leading SQL Server consulting services company in Israel. I am also the editor of SQLServer.co.il - the Israeli Portal for SQL Server DBAs and developers. I have spoken at the Microsoft TechEd in Israel several times, PASS Summit 2009, Microsoft Developer Academy, and at ISUG (Israeli SQL Server User Group) meetings.



Title: DBA Disaster Recovery Techniques To Keep Handy
Speaker: Edwin Sarmiento
Category: HA/DR
Level: 400
Abstract: Nothing is more frightening to a DBA as getting that wake-up phone call that the system is down, especially when it's a mission critical one. This session will focus on being prepared for and dealing with a recovery situation for a SQL Server 2005/2008 database, an instance or an entire server. Topics covered will be backup schemes, partial backups and piecemeal restores, and page-level recovery
Session Goals
  • Understand how disaster recovery strategies should meet the recovery point objective/recovery time objective
  • Be familiar with different recovery strategies based on the selected backup strategies
  • Understand the need for testing disaster recovery strategies on a regular basis
Speaker Bio: Edwin Sarmiento works as a SQL Server DBA for The Pythian Group in Ottawa, ON in Canada. Prior to joining Pythian, he was a senior systems engineer/DBA for Fujitsu Asia Pte Ltd in Singapore and is responsible for maintaining 200+ servers and databases for a global client in 10 countries. He is very passionate about technology but has interests in music, professional and organizational development, leadership and management matters when not working with databases. He lives up to his primary mission statement: "To help people grow and develop their full potential as God has planned for them" He wants the whole world to know that Filipinos are world-class citizens and bring Jesus Christ to the world.

Indexing & Partitioning

Title: Fragmentation and Performance Issues
Speaker: Bryan Oliver
Category: Indexing & Partitioning
Level: 100
Abstract: Three types of fragmentation often affect the Performance of SQL Server and although as DBA's we often understand them little is often done about two of them. Non Clustered Index fragmentation is the one fragmentation that is often monitored and fixed by DBA's, so what of the other two. The first and often most seen is file fragmentation. The impact this has on queries can be significant. I will discuss ways to monitor this fragmentation, what often causes this fragmentation and how to resolve this type of fragmentation once it has reached a critical level. The second type of fragmentation is extent. I will discuss ways to optimize the design of the database to reduce extent fragmentation, ways to monitor the level of fragmentation and final how to resolve extent fragmentation in tables.
Session Goals
  • To make people aware of the effects fragmentation can have upon performance.
  • To enable people to monitor fragmentation
  • To reduce the incidence of fragmentation by improving the layout and planning of a production database.
Speaker Bio: Bryan Oliver has over 20 years of industry experience, 11 of which were spent working primarily with SQL Server. Bryan is a SQL Server Expert focusing on performance tuning, back and restore best practices and general SQL Server issues. Bryan’s position allows him to work with some of the largest and most recognizable SQL database environments in the world. He is also a valued speaker at conferences such as SQL PASS Europe and SQL Server Summit. Born and raised in Australia, Bryan graduated from RMIT University in Melbourne and was an early adopter of SQL Server. Previously Bryan was a Vice President of R&D at Quest Software (so it says on his L1 Visa Application). He worked with a number of solutions, including LiteSpeed for SQL Server. Prior to joining Quest, Bryan was the vice president of research and development for Imceda Software.



Title: Big and Tall: When to Partition
Speaker: Kendra Little
Category: Indexing & Partitioning
Level: 200
Abstract: Does SQL Server's table partitioning feature offer performance improvements, manageability benefits, or both? Table partitioning is a significant investment: it's important to understand benefits and impacts of the feature to evaluate where it will be useful. This session will cover basic concepts of table partitioning. We'll discuss where the feature should be applied and required changes to schema. Special considerations for management of partitioned tables will be discussed, as well as required changes to application queries. Enhancements in SQL 2008 and later versions will be included.
Session Goals
  • Cover basic concepts of partitioning.
  • Discuss implications to schema for partitioning, focus on key and index choices.
  • Discuss query choices and changes when using partitioning.
Speaker Bio: Kendra Little has spent ten years nerding out on SQL Server. She likes performance tuning, automating processes, building SQL Reports, and (secretly) writing documentation. Kendra has a Masters in Philosophy and a salt shaker full of certifications, but all the best stuff she's learned lately has come from her smarty-pants colleagues and the SQL Server community. Read her blog at http://littlekendra.com.



Title: How to Do an Index Review
Speaker: Michael DeFehr
Category: Indexing & Partitioning
Level: 200
Abstract: Is your server slow? What does this mean? If you haven't taken a look at the indexes in your system and whether/how they are being used, that could be part of your problem. This is an essential DBA skill and should be done periodically on all systems for which performance is a factor. This session will review the way tables and indexes are structured in SQL server, then dive into the DMVs that expose what you need to pay attention to in your system and show you some of the actions you can take to (often dramatically) improve your system's performance.
Session Goals
  • Learn how to find procedures and/or statements that are using a lot of resources on your server
  • Learn what indexes aren't being used and what indexes could be changed to make them of more use
  • Learn what indexes are missing that your system might benefit from adding
Speaker Bio:  Michael DeFehr is the primary database analyst/developer at Protegra, a leading technology solution provider based in Winnipeg, Manitoba. His career has focused on database administration and development using Microsoft SQL Server. A SQL MVP, Professional Engineer and Microsoft Certified Information Technology Professional in both Database Development and Administration, Mike has spent the past 15 years producing and maintaining database solutions. Mike specializes in the relational and storage engines and his solutions emphasize performance and simplicity. Mike is the chapter president of the Winnipeg SQL Server Users Group



Title: Searching Unstructured Text Data - SQL Server Full Text Searching for DBAs and Developers
Speaker: Robert Cain
Category: Indexing & Partitioning
Level: 200
Abstract: Users have become accustomed to the simple interfaces of search engines such as Microsoft BING and Google. They want to be able to enter key words and have their applications sift through vast quantities of text to get results quickly. Did you know that you can give your users that search ability? SQL Server Full Text Searching is the key. And it's as easy as 1-2-3! Come and learn the how to setup and use full text searching with SQL Server. Chock full of demonstrations this session will start with setting up full text searching on the database and end with issuing a full text query from within a WPF .Net application.
Session Goals
  • Give users a clear understanding of what full text searching is, and how it differs from regular searches.
  • Show users how to create and manage full text indexes as well as how to search them.
  • Demonstrate advanced tools for DBAs to manage FTS and show developers how to make FTS queries from their .Net applications.
Speaker Bio:  Robert C. Cain is a Microsoft MVP in SQL Development, MCTS certified in BI, and works as a Senior Business Intelligence Architect for ComFrame. He is also a technical contributor to Plurasight Training, and co-author of the book "SQL Server MVP Deep Dives". Robert has over 20 years' experience in the IT field, working in a variety of fields ranging from manufacturing to telecommunications to nuclear power. He maintains the popular blog http://arcanecode.com.  



Title: Partitioning in SQL Server 2005/2008
Speaker: Jana Sattainathan
Category: Indexing & Partitioning
Level: 300
Abstract: Starting with SQL Server 2005, Microsoft has made a significant effort to truly streamline partitioning data to be on par with industry leading databases like Oracle. The potential was not fully harnessed by the SQL Server community primarily due to the lack of any user interface associated with partitioning and due to lack of cohesive documentation. For many, Kimberly Tripp’s white paper on “Partitioned Tables and Indexes in SQL Server 2005” is generally regarded as a primary guiding source that bridges the void in MS documentation. Come and get a quick start on partitioning. It is simple, efficient. Manageability and performance come part and parcel.
Session Goals
  • To introduce the audience - both developers and DBA's to partitioning, an obscure topic not often discussed but that is vital when you try to scale up efficiently
  • Change the mind-set of developers working with large volumes of data to think in terms of DDL's as opposed to DML's and how to load data with minimal to no transaction log footprint.
  • Show things that the attendees could take home at the end of the session to roll-out their own partitioning solution to fit their specific needs - from the simplest to the more complex solutions
Speaker Bio: Jana Sattainathan is a Database/Application Architect with Transamerica Reinsurance, one of the biggest reinsurers in the U.S. He has been in the IT industry for over 15 years with a career centered mostly around databases from different vendors. Jana loves architecting efficient database solutions for effectively dealing with extremely large volumes of data. He currently holds the following certifications: MCITP - SQL Server 2005 Developer and Administrator & Oracle Certified Professional Admin He is currently working on a Database Querying tool that he plans to release a beta version of in mid to late 2011.

Monitoring/Auditing

Title: The Thrill of the Trace
Speaker: Don Stevic
Category: Monitoring/Auditing
Level: 100
Abstract: How many times have you been called or emailed by developers or end users tell you the database is running slow and you need to fix it? Unless you have taken steps to monitor before that question is asked, you are suddenly throw into a world of running profiler and trying to recreate the issue. By utilizing server side traces and PerfMon, you can easily have the information at your fingertips. You might even find yourself warning developers that they are going to start seeing some problems with their new code.
Session Goals
  • Introduce the topic on server side traces and PerfMon and how they can be used to gather performance metrics
  • How to consume and use the information put out by the traces
  • How to us that information to troubleshoot and proactively watch for performance issues.
Speaker Bio: Here are the highlights about me: Born in New Jersey, moved to South Florida in 1980 been working my way north slowly.  It has taken me 30 years to get to Orlando. Graduated from Florida Atlantic University with my Masters Degree in Fine Arts - Acting/Directing.  My Pre-SQL life consisted of teaching high school drama and performing in musicals and operas. I entered into the Microsoft world ten years ago as an MCSE trainer, and was asked if I could learn and teach SQL. I learned it, and never looked back. I have worked as a full time and contract DBA at a few companies over the past ten years, and I am currently working at SAIC in Orlando. I am married to a wonderful woman, and have 2 (almost 3) great kids. After a few years being away from the SQL community, I am returning to rejoin the fold.



Title: Using Microsoft Atlanta to Proactively Monitor SQL Servers
Speaker: Chris Skorlinski
Category: Monitoring/Auditing
Level: 100
Abstract: Microsoft Codename Atlanta (http://beta.microsoftatlanta.com) is an online service that analyzes installations of Microsoft SQL Server 2008 and provides proactive alerts to help you avoid system downtime and follow best practices with regard to configuration and usage. Atlanta is developed by the Microsoft Atlanta product group in partnership with Microsoft Support engineers to ensure that the issues customers report to Microsoft are detected before they affect your environment. Atlanta is regularly updated to reflect the most recent experiences of these engineers, who support SQL Server customers around the world.
Session Goals
  • Introduce SQL DBAs to new offering by Microsoft to help proactively monitor SQL Servers.
  • Demonstrate real-world SQL Azure application.
Speaker Bio: Chris Skorlinski has been with Microsoft for 17 years. He is a Support Escalation Engineer at the Microsoft Charlotte NC office specializing in performance tuning and troubleshooting Replication. His is a contributor to SQLShare.com training as well as his own BLOGs on Replication Performance at http://blogs.msdn.com/ReplTalk/.  



Title: Compliance, Auditing and Encryption in SQL Server
Speaker: Tom Norman
Category: Monitoring/Auditing
Level: 200
Abstract: Compliance and Auditing I have this database which must meet all of these governmental regulations. Just like the government to make life a lot harder but wait, now they say I most also meet International regulations. Can this be true? Why me? Let's look at what we can do to help us pass audits and comply with the laws around us. We will explore the features in SQL Server 2008 which help us.
Session Goals
  • I need to become compliant, what does SQLl Server have to help me. Let's get the auditor's to look at something besides the database.
  • Let's understand what an auditor is auditing. What type of audits are there?
  • What are the different objects which must be brought into compliance. Let's see that list. You can accomplish Separation of Duties.
Speaker Bio: Tom Norman, SQL Server Database Administrator, TSYS. Tom has been working with SQL Server since 1998. He has worked internationally with SQLl Server. His current responsibilities include Replication, Performance and Server Compliance of all Production databases in the US and UK. Tom and his team are currently working on a project to upgrade several products to Sql Server 2008 R2 and bring them into PCI compliance. Tom is the past President of the Denver SQL Server User Group.



Title: Database Performance Management – 2008 MDW
Speaker: Janis Griffin
Category: Monitoring/Auditing
Level: 200
Abstract: Management Data Warehouse (MDW) was introduced in SQL Server 2008 and can provide DBAs with useful performance information about Disk Usage, Server Activity and Query Statistics. This presentation will explore how to set up and use MDW. It will review the underlying schema and show examples of both canned and custom reports. It will, also, point out some of its shortcomings in comparison with other performance tools.
Session Goals
  • To give students overview of MDW, and discuss best practices of how to set it up.
  • Show students how to use the existing canned reports to identify database performance issue and how to create custom reports for addition information.
  • Point out short comings of MDW when compared with problem solving techniques and other tools.
Speaker Bio: Before coming to Confio Software, I held DBA positions primarily in the Telecom Industry, working with both real-time network routing databases and OLTP business to business applications.  During that time, I held positions of Principal Architect and Senior Manager, mentoring other DBAs on best practices in database performance tuning. In addition, I was responsible for managing all aspects of voice network databases,  including short and long-term technical and strategic planning.  Most notably, I helped develop several telephony patents: http://www.faqs.org/patents/inv/250539  



Title: SQL Audit
Speaker: David Dye
Category: Monitoring/Auditing
Level: 200
Abstract: SQL Audit provides the ability to track and log activities and changes at the instance or database level. Built upon extended events SQL audit provides both synchronous and asynchronous capabilities. The granularity of events that can be monitored and tracked with SQL audit can only be matched by means of using a SQL profiler trace, but provides reduced overhead and better performance. This presentation will provide insight into the internals of SQL audit, along with how to plan, create, and monitor instance and database level audits. Demonstrations of creating and monitoring audits will be provided using t-sql and SQL server management studio.
Session Goals
  • Attendees will be able to identify the components of creating a SQL audit and how to implement an audit through t-sql and/or SSMS.
Speaker Bio: David is a Sergeant with the Cape Coral Police Department and currently works as a database administrator and developer in the Administrative Services Division. He began his career with the police department in 1990 in the patrol division and worked various assignments until being promoted to Sergeant in 1998. Based on his education and experience David was assigned to his current position in 2002 and is responsible for database administration, software integration, and development for public safety. David’s primary focus and expertise is with SQL Server, reporting services, integration services, and analysis services, and he was recognized for his work by SQL Server Magazine as “Innovator of the Year” runner up in 2007. David is an MCITP for SQL Server 2005 and 2008 in both database administration and business intelligence and is a Microsoft Certified Trainer. He regularly posts on the MSDN SQL Server forums where he also serves as a moderator, and is a contributor at SQLCLR.net. In addition to his knowledge of SQL Server David works as a software developer using VB.net and C# and has worked extensively in SharePoint development.



Title: SQL Server Troubleshooting via DMV's
Speaker: Steve Schneider
Category: Monitoring/Auditing
Level: 200
Abstract: I will present the custom stored procedure I use first whenever an event happens on my 2005 servers. This presents a condensed view the server as drawn through DMV's. I will describe and drill through a SQL Server Troubleshooting Framework down to the DMV level, briefly scoping the tools available at the various levels of trouble detection. At the DMV level, we will focus on specific examples, discussing the selection of DMV-oriented queries and interpret the output in the context of real-life examples. There are four examples which i will walk thru and give the audience the chance to use what I have taught to solve the performance issue. Then, I will discuss the interpretation of the output and the underlying code that extracts that information.
Session Goals
  • Learn the value of DMV's to see into SQL.
  • Perceive the hierarchy of a troubleshooting technique.
  • Keep the audience interest via real-life example problems.
Speaker Bio: Steve Schneider has been a DBA for the city of Jacksonville for 5 years. He has been doing SQL work way longer than that. He is a Microsoft Certified Systems Engineer and a Microsoft Certified Database Administrator. He has recently been focusing on performance tuning and security.



Title: Baselining, trend analysis and system monitoring with Management Data Warehouse
Speaker: Dmitri Korotkevitch
Category: Monitoring/Auditing
Level: 300
Abstract:

Every year more and more businesses use Microsoft SQL Server as the backend database server in their mission-critical systems. High availability of these systems has become a standard requirement. It is not uncommon to have a Service Level Agreement that does not allow more than a few minutes of downtime per calendar year. That forces DBAs to implement proactive monitoring solutions. One of the key components of a proactive system monitoring strategy is baselining. Comparison of the current system state to a baseline helps understand changes in system load and behavior. Monitoring of these changes helps predict and avoid bottlenecks. Historically, system monitoring has been done based on system performance counters, DMO and SQL server traces. One of the challenges with this approach is the heterogeneous nature of the data collected. This requires additional processing and unification of the data before analysis can be performed.

Another challenge is the correlation of different data streams. The standard SQL Server installation does not provide all the necessary tools to solve these problems out of the box. Management Data Warehouse, introduced in SQL Server 2008, simplifies system troubleshooting tasks. The data provided by Data Collectors are unified and stored in a relational database. A set of standard reports allows drilling down to the various aspects of system load and behavior during performance troubleshooting. Unfortunately, the standard configuration for MDW is not optimal for the trend analysis aspects of system monitoring. The standard Data Collectors do not capture enough information to create a comprehensive baseline. As a result, there are no standard reports which can be used to analyze trends and predict possible bottlenecks.

This session will focus on customizations and enhancements to MDW and Data Collectors that will help with system baselining, monitoring and trend analysis. Specifically, it will demonstrate how to enhance existing and create new Data Collectors in order to obtain a comprehensive system baseline. It will give an overview of MDW database schema and object dependencies. And finally, it will show how to query the collected data for analysis, reporting and monitoring purposes.

Session Goals
  • Give attendees a better understanding of Management Data Warehouse schema and Data Collectors architecture.
  • Demonstrate how to customize and enhance Data Collectors and build a comprehensive system baseline
  • Demonstrate how to create custom queries against Management Data Warehouse for analysis, reporting and proactive system monitoring purposes
Speaker Bio: Dmitri Korotkevitch is Director of Development at Actsoft - Tampa, FL based company developing GPS Tracking and Mobile Workforce Management solutions. Dmitri is responsible for architecture, design and development of the database solution handling in about 2500 TPS during the peak time. Dmitri holds Master’s degree in Computer Science as well as MCITP certifications as SQL Server 2005 and 2008 Database Developer and SQL Server 2008 Database Administrator. He also has MCPD certification as an Enterprise Applications Developer. Dmitri has 15 years of experience in the industry including more than 9 years of experience working with Microsoft SQL Server.



Title: Special Topics in SQL Server Monitoring
Speaker: Edward Stangler
Category: Monitoring/Auditing
Level: 400
Abstract: This session will cover special difficult topics in monitoring Microsoft SQL Server. Using the Dynamic Management (DM) views and functions, as well as legacy DBCC commands and perfmon, we will discuss how to get at these metrics, with textual and graphical views to illustrate. Specific topics include: how to find the owner of a temp table, breakdown of tempdb space usage, speeding up measuring space usage of one thousand databases in an instance, watching multiple instances compete for CPU and memory resources on the same box, identifying idle SQLOS threads, timed event monitoring, and more.
Session Goals
  • Have a deterministic way of finding performance bottlenecks in certain areas of SQL Server.
  • Find the root cause of performance bottlenecks in certain areas of SQL Server.
  • Have more tools at your disposal for monitoring tempdb, large numbers of databases, and multi-instance boxes of SQL Server.
Speaker Bio: Mr. Stangler came to Bradmark through the acquisition of Pace Systems, which took place in June of 2000. Pace Systems was a product development company which Bradmark used as a lab for the development of its NORAD Surveillance monitoring product line. Mr. Stangler is responsible for the development of the server agent, event management, and central repository technology of the NORAD product line, along with the associated middleware. He's worked with SQL Server and other databases for over 10 years. Well respected in the field, he holds an MS and BS in Computer Science from the University of Houston. Though Mr. Stangler was accepted into the PhD program at the University of Houston, he declined, favoring his work at Bradmark Technologies.

PBM

Title: Evaluate your daily checklist against 100+ instances of SQL Server while you get a cup of coffee
Speaker: John Sterrett
Category: PBM
Level: 100
Abstract: You will walk away from this session with an understanding of how to use the Policy Based Management and Central Management Server to complete a daily checklist against your whole SQL Server farm. We will cover the basics to evaluate, monitor and apply best practice policies, which are included out of the box with SQL Server 2008. We will also make custom policies to cover additional best practices to evaluate daily checklist items. Finally, we will combine Policy-Based Management and Central Management Server with the Enterprise Policy Management Framework on codeplex to automate the monitoring process and create manager friendly reports to monitor your checklist items against the whole SQL Server farm.
Session Goals
  • You will be able to install, configure and run scripts against the Central Management Server
  • You will be able to use Central Management Server and/or Policy-Based Management to complete a daily checklist
  • You will be able to evaluate and build custom policies.
Speaker Bio: John Sterrett is a database administrator at Orrick Herrington & Sutcliffe, an international law-firm, and is responsible for over 100 instances of SQL Server. John has been active within the SQL Server community, including hosting the first SQL Saturday in West Virginia. John also presented a lightning talk and chalk-talk at the SQL Server 2010 Member Summit, presented sessions at three SQL Saturday’s, and presented to the Pittsburgh SQL Server User Group. John is a syndicated blogger at SQLServerPedia and contributes tips at MSSQLTIPS. You can find his blog at www.johnsterrett.com



Title: Policy-Based Management in a Nutshell
Speaker: Jorge Segarra
Category: PBM
Level: 100
Abstract: In this session we will be learning an overview of this powerful new feature in SQL Server 2008 and how you can leverage it to help manage your existing SQL environment (yes, even your non-2008 servers!). This will include plenty of demos, best practices and Q&A so by the end you should be able to walk away ready to take control of your SQL Servers today!
Session Goals
  • Grasp a basic overview of the Policy-Based Management feature in SQL Server 2008
Speaker Bio: I’m an MCTS (SQL Server 2005) currently working as a BI Consultant for Pragmatic Works consulting. In addition to being a member of the Tampa SQL Server, Tampa SQL Server Business Intelligence, and VMware user groups I am also a Hypervisor for the PASS Virtualization Virtual Chapter and a Regional Mentor for PASS. I have also co-authored the book from Apress “SQL 2008 Pro Policy-Based Management“. Redgate Exceptional DBA of the Year 2010 Finalist.



Title: Policy Based Management
Speaker: Peter Trast
Category: PBM
Level: 200
Abstract:

Maybe you were a system admin that got sucked into the exotic land of database administration because there was no one else to do it. Maybe you are a DBA on purpose. It might even be possible that one day you were writing web applications in your remote and intentionally isolated cube at the far end of the “trailer park” and faster than you can say DBCC CHECKDB REPAIR_ALLOW_DATA_LOSS you found yourself in charge of an unwieldy, quickly expanding and barely governed SQL Server environment. In any case, you may have wondered, if there were some way to control the environment of SQL Server proactively and to have an automated way to enforce all of those naming convention standards and object settings that you TALKED about, documented and trained on.

Have I got news for you! In SQL Server 2008, a new feature called Policy Based Management (PBM) was introduced. The idea is that if you have a setting or convention that you wish to check for and/or ENFORCE (get your control freak on), you just create a policy that defines the object (maybe a database), a facet (the property that can be checked for or enforced, like the recovery model of a database), and a condition (the value of the property, like Full for the recovery model). Systems Administrators recognize this concept (Group Policy in Active Directory) but the application and verification of the policy is done quite differently. See what it is and how it’s done!

Session Goals  
Speaker Bio: Peter has been an IT professional for 15 years. He worked his way from desktop and server support up to systems administration and engineering for the Navy-Marine Corps Intranet Project and for private clients, then delivered Windows services and SQL Server classes for Centriq Training in Leawood, Kansas, and is now a Microsoft Design Architect specializing in SQL Server design with Alexander Open Systems in Overland Park, Kansas. He likes all music styles, heavy doses of science fiction and building expensive treehouses for his 9 children in Kansas City, Missouri, and does NOT, in fact, look like Mr. Clean.



Title: Policy Based Management
Speaker: Tom Norman
Category: PBM
Level: 200
Abstract: Policy Based Management, what is this? What can it do for me? Do I really need it? How do I install and configure it? How can it help me to pass audits? You mean each server can really be configured the same. Let's explore Policy Based Management and what it has to offer us in better management of our SQL Servers.
Session Goals
  • Understand the different management types and how Policy Based Management can help solve each type.
  • Why use Policy Based Management, is it really for you! I never thought I would!
  • Show how to use Policy Based Management from beginning to the end.
Speaker Bio: Tom Norman, SQL Server Database Administrator, TSYS. Tom has been working with Sql Server since 1998. He has worked internationally with SQL Server. His current responsibilities include Replication, Performance and Server Compliance of all Production databases in the US and UK. Tom and his team are currently working on a project to upgraded several products to SQL Server 2008 R2 and bring them into PCI compliance. Tom is the past President of the Denver SQL Server User Group.

Performance

Title: Execution Plan Basics
Speaker: Thomas LeBlanc
Category: Performance
Level: 100
Abstract: This will be a Beginner to Intermediate session highlighting the starting point for using the execution plans to assist in query tuning. Briefly, we will look at the history to get an idea of how Microsoft has improved the display through Graphical Plans and Missing Index suggestion. This session will answer questions like: What is the difference between a Table and Clustered Index Scan? What is a Lookup? How do you improve performance of Lookups? What are the different types of Loops? How to get more information from the Plan from the properties window and XML output?
Session Goals
  • Scans - table, clustered and non-clustered Joins - Nested, Merge & Hash
  • Graphical and Text Query Plans Missing Index feature in Query Plans
  • Statistics IO and Time SET statements and results
Speaker Bio: Thomas LeBlanc is a semi-retired Senior DBA turned ETL Lead Architect for Amedisys, Inc in Baton Rouge, LA. He has been in the IT field for 20 years starting as a COBOL programmer, graduating to dBase, FoxPro, Visual FoxPro, VB 3 thru 6 and even some .Net(C#). Designing and developing normalized database has become his passion. Full-time DBA work started about 6 years ago for Thomas while working at a Paper Mill in St. Francisville, LA continuing with IEM, then Amedisys. Current activity at Amedisys involves 2 other DBAs and a manager supporting 300+ GB databases with replication to a Data Warehouse and DB Mirroring to a disaster recovery site. Performance tuning and reviewing database design and code are an everyday occurrence for DBAs at Amedisys. Thomas’ free time is spent helping those less fortunate and bettering the relationship with his family and God.



Title: Troubleshooting Performance Problems by Reading the Waits
Speaker: Eddie Wuerch
Category: Performance
Level: 100
Abstract: Start with a simple proposition: a process is either working or waiting. You can tune the working part, but are you seeing the whole picture? There are many different resources on which your process could be waiting – a lock, memory, disk, CPU, and much more. When a process must wait, SQL Server will log it. There are hundreds of different wait types, and they are a gold mine of data for finding and solving performance problems – and proving the changes worked. After attending this session, you will be able to gather wait stats and use them to zero in on performance issues affecting your databases. Session includes all scripts to get started, plus an overview of the most common wait types and ways to resolve the problems they indicate. Stop guessing, start knowing!
Session Goals
  • Describe what a 'Wait State' is, and what SQL Server tracks regarding them
  • Query, track, record, and analyze Wait Stats in SQL Server (scripts included in session download)
  • Use Wait Stats to identify and eliminate performance problems, and verify the fixes worked
Speaker Bio: Eddie Wuerch is a DBA, developer, and trainer specializing in SQL Server for over ten of the twenty years he has spent in IT. Eddie is currently the Principal Database Architect and DBA team lead at a leading SaaS company located in Indianapolis, Indiana.  Eddie and his team manage the many multi-terabyte 24x7 SQL Server database clusters that form the foundation of the application.  In addition to holding MCITP certifications in SQL Server 2005 and 2008 development and administration, Eddie is also Microsoft Certified Trainer, bringing his VLDB experience to developers and DBAs, delivering courses in SQL Server high availability, development, administration, optimization, and Reporting Services.



Title: Baselines first, troubleshooting second
Speaker: Erin Stellato
Category: Performance
Level: 200
Abstract: “The system is slow. It was much faster last week! This is taking forever.” Statements like these from users can be frustrating for any DBA, unless you have the data to prove how the system regularly performs. In this session we will cover some of the tools and techniques freely available to SQL Server DBAs for capturing baselines that can be used for measuring performance, capacity planning and understanding usage patterns. We also discuss how these utilities and their data can be used to identify warning signs and troubleshoot performance issues. Tools covered include: PerfMon, PAL, Profiler, ClearTrace, RMLUtils, who_is_active and SQL Server DMVs
Session Goals
  • Provide DBAs with a set of methods to easily capture and store baseline data for a database server.
  • Introduce methods and free utilities available for analyzing and aggregating baseline data.
  • Discuss what baseline data is most useful to reference when troubleshooting performance issues.
Speaker Bio: Erin Stellato is a Senior Database Engineer at Hyland Software, Inc. in Westlake, OH. After receiving B.S. and M.S. degrees in Movement Science from the University of Michigan, Erin entered the technology field where she has been working for over 10 years. She has worked with SQL Server for the last seven years, providing support to customers who have problems that involve the database and/or system performance. Erin is an active member of the SQL Server community and blogs regularly about her experiences. Her areas of interest include Internals, Maintenance strategies, Performance Tuning and High Availability.



Title: Automating Execution Plan Analysis
Speaker: Joe Chang
Category: Performance
Level: 300
Abstract: The execution plans contain a wealth of details not found elsewhere, including specific index usage and improperly formed search arguments. Critical tables often have an excessive number of indexes. Some are outright not used, but others are infrequently used. It should be possible to consolidate indexes with similar keys, and others can be dropped. But which SQL would be impacted? By analyzing all execution plans, it is possible to determine where infrequently used indexes are referenced. And this is practical only with automation.
Session Goals
  • Automate execution plan analysis
  • Learn to how determine which indexes can be consolidated
  • Learn how to find SQL execution plans that reference infrequently used indexes.
Speaker Bio: Joe is a SQL Server Consultant and Tools developer for automating SQL XML plan analysis, cross-referencing index usage to execution plans. He has developed models for predicting SQL Server performance early in the design phase, and taking the guess work out of performance tuning. He has built a more complete model than the SQL Server internal cost based query optimizer, including processor and system architecture dependencies and logic costs, which are not incorporated in the cost based optimizer.



Title: Discovering the Plan Cache
Speaker: Jason Strate
Category: Performance
Level: 300
Abstract: Execution plans are stored after execution in the plan cache. This metadata about how queries are executed can provide insight into how your SQL Server environment is functioning. By using XQuery to browse and search the plan cache you can find potential performance issues and opportunities to tune your queries. This information can be used to help reduce issues related to parallelism, shift queries from using scans to using seek operations, or discover exactly which queries are using what indexes. All of this and more is readily available through the plan cache. In this session we will explore the plan cache and start you on the road to discovery.
Session Goals
  • Discuss information available in an execution plan
  • Demonstrate use of XQuery to query plan cache
  • Demonstrate methods to use the plan cache for performance tuning
Speaker Bio: Jason Strate, Digineer Inc, is a database architect and administrator with over twelve years of experience. In July 2009, he was awarded Microsoft MVP (Most Valuable Professional) for SQL Server. His experience includes design and implementation of both OLTP and OLAP solutions as well as assessment and implementation of SQL Server environments for best practices, performance, and high availability solutions. Jason is a SQL Server MCITP and participated in the development of Microsoft Certification exams for SQL Server 2008. He is actively involved with the local PASS chapter (SQL Server User Group) and is currently serving as the Director of Program Development. In the past year, Jason worked with the current board to organize the PASSMN SQL Summit 2009 in September for the local community. Jason enjoys helping others in the SQL Server community and does this by presenting at technical conferences and user group meetings. Most recently, Jason has presented at the SSWUG Virtual Conferences, TechFuse 2009, SQL Saturday #19, and at PASSMN user group meetings. He is scheduled to speak at this year’s PASS Summit in Seattle, WA. Jason is also a contributing author for the Microsoft white paper “Empowering Enterprise Solutions with SQL Server 2008 Enterprise Edition.” Jason is an active blogger with a focus on SQL Server and related technologies.



Title: SQL SERVER 2008 / R2 - TROUBLESHOOTING SQL SERVER STATISTICS
Speaker: David Pless
Category: Performance
Level: 300
Abstract:

Statistics issues can be one of the most difficult to troubleshoot. Often, DBAs and developers narrow down the expensive statement using DMVs. The DBA discovers that statistics are the root cause, but the effort to understand and correct the issue becomes difficult. There are situations where recompilation will not help and recompiles have their own performance drawbacks. This session is all about understanding and correcting statistics issues. Statistics are an internal BLOB (statblob) representing data about data. This statistical data is maintained by SQL Server to help build query plans making decisions on accessing data based on the size and distribution of your actual data. Most DBAs maintain these statistics by using the default auto update statistics and auto create statistics settings. This is a good start. However, there are cases where the auto update of statistics is not enough and may not help address certain poorly performing queries and conditions. Additionally, the auto update statistics setting can cause performance issues on large tables forcing the DBA to turn this setting off.

In this session we will discuss several case scenarios where statistics are not being leveraged optimally. Statistics can be out of date or have missing statistics, the optimizer might "guess" rather than leveraging statistics, the distribution of statistics may not be optimal, and other conditions can occur where the query plan is not constructed to best leverage statistics. One of the first signs of statistics issues is slow and unpredictable query execution times. This can be due to statistical 'guessing', parameter sniffing, and other query plan conditions. Statistics issues can occur after large insert operations on ascending or descending key columns and after certain maintenance operations. We will discuss how to respond to these situations and how to designing queries that use statistics effectively. To troubleshoot these situations it is often necessary to examine the query plans and to look at the SET STATISTICS PROFILE output. We will cover these troubleshooting efforts and others. Finally we will cover new capabilities in SQL Server 2008, R2 / 2011 to address statistics issues by influencing plans and keeping plans when a good one is found. Using AUTO_UPDATE_STATISTICS_ASYNC, Filtered Statistics, plan freezing, and plan guides, and more will be covered to help get the upper hand on statistics issues.

Session Goals
  • The class will understand what SQL Server Statistics are internally, how they are maintained (manually / internally), and core troubleshooting techniques.
  • The class will learn about several methods available on how to solve statistics issues such as updating statistics, recompilation, plan freezing / plan caching, use of query hints, leveraging filtered statistics, and rewriting SQL statements.
  • Finally, we will discuss changes to the product between versions regarding statistics / query plans and best practices.
Speaker Bio: I am a Senior Premier Field Engineer with Microsoft. As a PFE I perform health checks, conduct chalk talks and full training workshops, and work on reactive and other proactive engagements on SQL Server 2005 and SQL Server 2008 / R2. I support Florida and the Southeast, but can support customers anywhere in the world. My core areas are SQL Server Performance Tuning and Optimization, Database Mirroring SQL Server 2005 / 2008 R2, SQL Server Reporting Services (SSRS), SQL Server Integration Services (SSIS), and other topics such as consolidation, Table Partitioning, Resource Governor, Performance Data Warehouse, SQL Server Auditing, and more. Previous Speaking Experience: I have been speaking consistently with Microsoft over the past four years over numerous topics such as SQL Server Performance Tuning and Optimization, Database Mirroring, SSRS, and SSIS. While I have been at Microsoft I have also built full workshops for Premier customers for repeat delivery scheduling workshops all over the world. External to Microsoft, I have spoken at the SQL PASS Conference in 2009 covering Performance Tuning Techniques. I have also spoken at the Orlando SQL PASS Chapter (OPASS) and the Space Coast SQL Server Chapter (SCSUG).



Title: Query Optimizer Cost Formulas
Speaker: Joe Chang
Category: Performance
Level: 400
Abstract: There are many SQL Server experts, yet very few can say exactly when the execution plan changes from an index seek with key lookup to a table scan. Several best practice writers have suggested this might occur when index selectivity is a few percent of the total number of rows. The Query Optimizer cost formulas determine the actual cross over point in terms of the number of rows relative to the number of leaf level pages, which no one else has suggested as the true determinant. Understanding the plan cost formulas also allows a better understanding of parallel execution plans, for which plan cost is a poor model for parallel plan scaling. The current SQL Server cost based optimizer has no useful capability to determine when to limit the degree of parallelism, so this strategy must be set manually.
Session Goals
  • Cost-based optimizer concepts
  • When does SQL Server query optimizer use an index and when it uses a scan operation.
  • Identify indexes that will not be used
Speaker Bio: Joe is a SQL Server Consultant and Tools developer for automating SQL XML plan analysis, cross-referencing index usage to execution plans. He has developed models for predicting SQL Server performance early in the design phase, and taking the guess work out of performance tuning. He has built a more complete model than the SQL Server internal cost based query optimizer, including processor and system architecture dependencies and logic costs, which are not incorporated in the cost based optimizer.

PowerShell

Title: Practical Powershell for SQL Server Professional - Success Cases
Speaker: Laerte Junior
Category: PowerShell
Level: 100
Abstract:

Here are 3 scenarios :
1.You need to Gathering Performance counters in 20 SQL Server servers with heterogeneous environments (SQL Server 2005, 2008, 2008 R2 – Windows 2003, 2008, 2008 R2)
2.You need to merge and filter several with SQL Server Profiler Traces with different events and columns to solve a specific problem.
3. You need to provide an elegant and automated solution to create a T-SQL Code Review and take off the rework in a SDLC (Software Development Life Cycle) in Team Build 2010

This session will show practical solutions applied to problems of everyday life (specifically those scenarios) that were solved using Powershell. We'll see real demos , the problem , the resolution and the code used.

Session Goals
  • Real Life Demonstration the Powershell code scalability between different environments.
  • Real Life Demonstration of consistency of code in Powershell.
  • Real Life Demonstration of Powershell integration with other Microsoft products, with focus on ALM (TFS 2010)
Speaker Bio: Laerte Junior is Data Platform Architect at Solid Quality Mentors a SQL SERVER MVP and, through his technology blog and simple-talk articles, an active member of the Microsoft community in Brasil. He is a skilled Principal Database Architect, Developer, and Administrator, specializing in SQL Server and Powershell Programming with over 8 years of hands-on experience. He holds a degree in Computer Science and has accomplished a number of certifications (including MCDBA), and is an expert in SQL Server 2000 / SQL Server 2005 / SQL Server 2008 technologies. He also organizes and speaks at Microsoft community events, attracting as many as 830 attendees. Laerte has also recently become a Friend of Redgate in Brazil



Title: Windows PowerShell Best Practices for SQL DBA's
Speaker: Ed Wilson
Category: PowerShell
Level: 100
Abstract: Windows PowerShell Best Practices for SQL DBA’s Learn Windows PowerShell best practices as they apply to each stage of the script development lifecycle. See the differences between working interactively from the Windows PowerShell prompt, writing an inline script, adding basic function, advanced functions and finally the implementation of Windows PowerShell Modules. What is a local best practice for Windows PowerShell development is not the same as a global best practice, and this talk covers those differences.
Session Goals
  • Demonstrate ease of Windows PowerShell use
  • Illustrate that Windows PowerShell does not require script development
  • Illustrate how to transform Windows PowerShell commands into reusable modules by following the "script progression."
Speaker Bio: Ed Wilson is the Microsoft Scripting Guy and a well-known scripting expert. He writes the daily Hey Scripting Guy! blog. He has also spoken at TechEd and at the Microsoft internal TechReady conferences. He is a Microsoft-certified trainer who has delivered a popular Windows PowerShell workshop to Microsoft Premier Customers worldwide. He has written 9 books including 6 on Windows scripting that were published by Microsoft Press. He has also contributed to nearly a dozen other books. His Windows PowerShell 2.0 Best Practices book for Microsoft Press was recently published. Ed holds more than 20 industry certifications, including Microsoft Certified Systems Engineer (MCSE) and Certified Information Systems Security Professional (CISSP). Prior to coming to work for Microsoft, he was a senior consultant for a Microsoft Gold Certified Partner where he specialized in Active Directory design and Exchange implementation. In his spare time, he enjoys woodworking, underwater photography, and scuba diving.



Title: Automating SQL Server Login Administration and Compliance Audits with PowerShell
Speaker: Ronald Dameron
Category: PowerShell
Level: 200
Abstract: Do you have hundreds of servers? Are your internal auditors asking that the administration of SQL Server logins be handled by a third party? Are your compliance and audit departments asking you to determine if password policies are being enforced, who the sysadmins are on your servers, who owns databases? If so, come to this session to learn how to complete these tasks quickly and efficiently using PowerShell and SQL PowerShell Extensions (SQLPSX). This automation is capable of adding or dropping logins and adding or dropping members in database or server roles on any database server. Also, I will demonstrate how to automate compliance reporting via PowerShell, SMO and Excel automation to report on the usage of password complexity/expiration policies, database owner, sysadmin role members, and other security related information.
Session Goals
  • Demonstrate how to automate SQL Server ID Administration using PowerShell and the Codeplex project SQLPSX (SQL PowerShell Extensions)
  • Demonstrate how to automate Compliance and Audit reporting using PowerShell, SQLPSX, and Excel.
  • Demonstrate several real-world examples that can be used in a large server farm.
Speaker Bio: Ronald Dameron is a Lead Database Administrator for the largest life insurer in the United States. He is currently exploring how PowerShell can simplify his life as a DBA. He is a previous speaker at SQL Saturday Tampa, Orlando, South Florida and the Tampa SQL User group. He writes at RonaldDameron.blogspot.com, www.simple-talk.com, sqlserverpedia.com. Follow him on Twitter at @RonDBA.



Title: Building a truly unattended install of SQL Server using PowerShell
Speaker: Michael Wells
Category: PowerShell
Level: 200
Abstract: Have you ever done an unattended install of SQL Server using the command line or a configuration file? How much time did you need to spend after the install getting the instance ready for your environment? Imagine if the install process could be expanded to include everything from installing SQL to applying operating system configurations like MSDTC to deploying SQL objects like sp_WhoIsActive. You could not only decrease the amount of time needed to stand up a server, but also achieve a more standardized deployment. In this session you’ll be taken on a tour through a process that was created for just this purpose. This process is currently in use in a large environment to deploy SQL 2005, 2008, and 2008R2 Servers to development, test, and production. You can see exactly how it works and how to easily customize it for your organizations' needs.
Session Goals
  • To show a real-world example of using PowerShell to aide in the deployment SQL Server.
  • To explain how to use the framework and customize it for their specific needs.
  • To show the benefits of automation and get people to think about other areas that may benefit from automation.
Speaker Bio: Michael is a Database Administrator for a large financial firm in the Tampa Bay area. He has been working in IT since 2000 and has been administered all versions of SQL Server from 2000 and up. Michael runs the Sarasota SQL Server User Group located in Sarasota, FL and has presented at numerous SQL Saturday, CodeCamp, and User Group events.



Title: Learn PowerShell using Real World Examples
Speaker: Ronald Dameron
Category: PowerShell
Level: 200
Abstract: PowerShell is a springboard to learning more about Windows Management Instrumentation, SQL Server Management Objects, .NET, Automation and object-oriented programming. This session will teach you PowerShell the way I learned it, by example. I will review the fundamentals you'll need to understand examples that automate repetitive tasks and help you better manage your workload. Then, we will review several REAL WORLD examples that I as a Senior IT Pro use regularly to manage issues encountered in a 600 server inventory.
Session Goals
  • Demonstrate fundamentals needed to understand PowerShell examples.
  • Demonstrate several REAL WORLD examples applicable to large server farms.
  • Provide attendees examples that they can take back to their work place and execute with minimal changes.
Speaker Bio: Ronald Dameron is a Lead Database Administrator for the largest life insurer in the United States. He is currently exploring how PowerShell can simplify his life as a DBA. He is a previous speaker at SQL Saturday Tampa, Orlando, South Florida and the Tampa SQL User group. He writes at RonaldDameron.blogspot.com, www.simple-talk.com, sqlserverpedia.com. Follow him on Twitter at @RonDBA.



Title: Real World Administration with SQL Server PowerShell Extensions (SQLPSX)
Speaker: Chad Miller
Category: PowerShell
Level: 300
Abstract: See how the CodeProject SQLPSX, an extensive PowerShell-based open source project representing over 3,000 hours of development, is used for real world PowerShell automation tasks. We'll cover retrieving SQL Server information, SSIS administration, Policy-Based Management, replication and SQLIse a WPF-based query tool. Along the way we'll also discuss why would use PowerShell over other solutions and highlight where non-PowerShell based solutions are more appropriate.
Session Goals
  • Introduce the CodePlex project SQL Server PowerShell Extensions
  • Demonstrate real-world PowerShell solutions and NOT some cute made for presentations scripts
  • Discuss areas where non-PowerShell based solutions are more appropriate.
Speaker Bio: Chad Miller is a Senior Manager of Database Administration at Raymond James Financial. Chad has worked with Microsoft SQL Server since 1999 and has been automating administration tasks using Windows Powershell since 2007. In his spare time he is the Project Coordinator/Developer of Powershell-based Codeplex project SQL Server PowerShell Extensions (SQLPSX). Chad leads the Tampa Powershell User Group and is also a frequent speaker at SQL Server users groups, SQL Saturdays and Code Camps.

Responsibilities

Title: Become a Bilingual DBA! Oracle for the SQL Server DBA
Speaker: Randy Knight
Category: Responsibilities
Level: 100
Abstract: In today's enterprise environments, it is becoming increasingly necessary to integrate data from a variety of sources. As SQL Server continues its march into the enterprise, the days of focusing 100% on one platform are over. At a bare minimum, we need to be able to communicate with DBA's for other platforms. Terminology as simple as Instance and Database mean very different things in Oracle than they do in SQL Server. In this session, we will compare and contrast the two platforms in terms of features and terminology. We will also discuss some of the best practices and pitfalls when integrating the two.
Session Goals
  • Provide a translation between the worlds (SQL Server and Oracle).Understand terminology differences.
  • Understand the similarities and differences between the two platforms.
  • Understand some of the SQL language differences between the two platforms.
Speaker Bio: Randy Knight (MCITP) is an IT Professional who has been working with Microsoft technology for over 20 years, focusing on SQL Server for the last 14. He has worked in a variety of settings, including six years as a Database Architect for Match.com, one of the largest and most successful dot coms.  Randy made a name for himself as a full time SQL/Microsoft Trainer in the 1990's.  He traveled extensively around the country, helping employees of both small and large companies obtain Microsoft and Novell certifications.



Title: Fundamentals of DBA-ism
Speaker: Don Stevic
Category: Responsibilities
Level: 100
Abstract: Database administrators are required to have a large and varied toolset to do their jobs. We need to have a working knowledge of networks, hardware, .NET development, 3rd party software, and know the impact of all these things on the SQL infrastructure. But at the end of the day there are specific things that they need to do to keep things running. This session will go back to the fundamentals of the DBA - Backups, Index maintenance, performance tracking, how to explain to other departments what needs to be done to keep SQL healthy are some of the topics that will be covered.
Session Goals
  • The give a understanding of the foundational skills/job of a DBA
  • Introduce and explain the baked in tools SQL provides for these jobs
  • Give the participant knowledge to take back to their enterprise and use
Speaker Bio: Here are the highlights about me: Born in New Jersey, moved to South Florida in 1980 been working my way north slowly.  It has taken me 30 years to get to Orlando. Graduated from Florida Atlantic University with my Masters Degree in Fine Arts - Acting/Directing.  My Pre-SQL life consisted of teaching high school drama and performing in musicals and operas. I entered into the Microsoft world ten years ago as an MCSE trainer, and was asked if I could learn and teach SQL. I learned it, and never looked back. I have worked as a full time and contract DBA at a few companies over the past ten years, and I am currently working at SAIC in Orlando. I am married to a wonderful woman, and have 2 (almost 3) great kids. After a few years being away from the SQL community, I am returning to rejoin the fold.



Title: Help Desk to DBA in 60-ish minutes
Speaker: Meredith Ryan-Smith
Category: Responsibilities
Level: 100
Abstract: Most ‘accidental DBAs’ start their foray in to database administration in a similar way. You start with little knowledge of SQL server and maybe even little knowledge of system administration basics at all. I will share some tips and tricks that I have picked up over the years to help you get on your feet as a DBA, by showing you how to find out where your instances of SQL are, what business processes depend on them, what their current states are and how to learn the skills you need to keep your databases safe and available.
Session Goals
  • You will gain some basic techniques for finding where SQL is installed, who depends on it, and how each instance is used.
  • You will learn basic techniques to assess the current health of your SQL server instances
  • You will learn some of my favorite ways to learn the skills you need as a new DBA
Speaker Bio:   Meredith is a DBA, wife and mother to the only 4-year-old on the block who can recite Codd’s Law. With more than 10 years of experience in IT, Meredith’s responsibilities have included everything from manning the Help Desk to VAX/VMS cluster administration. Most recently she has served as the production database administrator specializing in cluster administration and performance. Meredith has attended six PASS Summits, and had volunteered with the WIT Virtual Chapter since early 2009.  Outside work, Meredith is a founding member of the University of New Mexico Hospital’s Pediatric Cystic Fibrosis Clinic’s Family Advisory Board and she is a new member of the Women In Technology Virtual Chapter. She spends as much time as she can with her daughter, her little geek-in-training, and in her spare time, loves to read, knit, maintain a social life, and perform her hundreds of “Mom Duties.”  



Title: The Enterprise SQL DBA
Speaker: Scott Shaw
Category: Responsibilities
Level: 100
Abstract: Ever wondered what it takes as a DBA to successfully navigate the political and technical world of a large database environment? What do you do your first day on the job with more than 300 SQL servers and thousands of databases to manage? This sessions tries to answer these questions and shows how to manage very large database environments (+200 SQL Servers). We'll discuss management shortcuts, maintaining complex environments, and tightening security. We'll also discuss personal development and challenges like handling customers and vendors, project management, standardization, and job advancement. Who knows, you may even find out whether or not becoming a DBA in a large corporation is a career path you want to choose.
Session Goals
  • Help beginning DBAs understand the pros and cons of working in large corporate IT environments.
  • Gather ideas and best practices from other DBAs who already work in large environments.
  • Have fun and learn from each other.
Speaker Bio: After getting a Masters in Literature and realizing that there wasn't much use for more English professors, I self-studied and entered the IT field. I've recently went back to school and received a Masters of Science in Management Information Systems. I hope I can say I'm done with school for a long time. Nothing learned in school can compare with the support and learning gained from the SQL community! I have more than 7 years SQL experience and more than 10 years IT experience. Currently I am team lead for a great group of professional SQL DBAs who work hard to keep the hospitals running and the patients safe.



Title: Adopt, Discover and Improve – How to take ownership of a system and survive on a new job
Speaker: Dmitri Korotkevitch
Category: Responsibilities
Level: 200
Abstract: The current job market is extremely competitive. Employers receive dozens or even hundreds of resumes for every job opening. Unfortunately, getting the job offer is not enough – employers often do not want to give new employees enough time to get familiar with their systems and expect them to start producing ROI almost immediately. It becomes critical for newly hired Database Administrators and Developers to take ownership of the system as soon as possible if they want to keep the position they won. Taking ownership of the system is an iteration-based process. As a first step, initial system state needs to be analyzed and bottlenecks identified. Next, the source of bottlenecks needs to be determined. There are few common reasons why bottlenecks occur: systems outgrow the hardware, servers are misconfigured or, most commonly, the database and/or application code are poorly designed. In any case, the problematic places need to be detected and fixed. This session will focus on the entire process. It will show how to analyze the system state using wait statistics, data management objects and system performance counters. It will demonstrate how specific resource bottlenecks relate to database design, concurrency and code issues. It will show how to pinpoint the most problematic queries and code patterns as the first candidates for refactoring. It will also demonstrate how to detect anti-patterns and design issues such as heap tables, inefficient clustered and non-clustered indexes, incorrect data type usage and many others using catalog views, data management objects and SQL server traces.
Session Goals
  • Demonstrate how to detect resource bottlenecks in the system using various techniques
  • Demonstrate how to detect problematic queries, design and code issues that lead to resource bottlenecks
  • Demonstrate how to detect inefficiencies and anti-patterns in the database design
Speaker Bio: Dmitri Korotkevitch is Director of Development at Actsoft - Tampa, FL based company developing GPS Tracking and Mobile Workforce Management solutions. Dmitri is responsible for architecture, design and development of the database solution handling in about 2500 TPS during the peak time.Dmitri holds Master’s degree in Computer Science as well as MCITP certifications as SQL Server 2005 and 2008 Database Developer and SQL Server 2008 Database Administrator. He also has MCPD certification as an Enterprise Applications Developer.Dmitri has 15 years of experience in the industry including more than 9 years of experience working with Microsoft SQL Server.



Title: Who's responsible? The vendor or the DBA?
Speaker: Erin Stellato
Category: Responsibilities
Level: 200
Abstract: Database administrators - you don't really trust your third party software vendors, do you? Software vendors - you think most of the DBAs out there are hiding things, don't you? Well guess what, you're both right! Join Erin Stellato (representing vendors) and Mike Walsh (representing customers) for an interactive session where they will tackle some of the toughest challenges that DBAs and vendors face. Attendees will walk out with a better understanding of what both parties can do to contribute to a successful relationship, as well as a set of fair questions to ask to set the right expectations from the start.
Session Goals
  • Provide ISVs with an understanding of what information they should provide to DBAs about their database (e.g. security, maintenance plans).
  • Review and discuss a list of questions which DBAs should ask prospective and current ISVs.
  • Enlighten both ISVs and DBAs on the perspective of the other party.
Speaker Bio: Erin Stellato is a Senior Database Engineer at Hyland Software, Inc. in Westlake, OH. After receiving B.S. and M.S. degrees in Movement Science from the University of Michigan, Erin entered the technology field where she has been working for over 10 years. She has worked with SQL Server for the last seven years, providing support to customers who have problems that involve the database and/or system performance. Erin is an active member of the SQL Server community and blogs regularly about her experiences. Her areas of interest include Internals, Maintenance strategies, Performance Tuning and High Availability.

Security

Title: Encryption 2005 101
Speaker: Steve Schneider
Category: Security
Level: 100
Abstract: Learn how to implement SQL 2005 Encryption using 2-way and 1-way encryption and why you would use either. Learn what a DBA needs to know and what the developer needs to know. Learn how to maintain encryption...backup and restore issues as well as cross-server issues. This will include a live demonstration of the concepts presented. Implementation: Encryption Types DBA responsibilities Developer’s role Encryption, Speed, and 1 way hashes Maintenance: Backup/restore Storage of backup keys Cross Server ... (all with just 16 slides and two Demo’s)
Session Goals
  • Show that encryption need not be feared. That it is a doable item.
  • Show that developers can use this encryption in relatively painless ways.
Speaker Bio: Steve Schneider has been a DBA for the city of Jacksonville for 5 years. He has been doing SQL work way longer than that. He is a Microsoft Certified Systems Engineer and a Microsoft Certified Database Administrator. He has recently been focusing on performance tuning and security.



Title: Data Encryption and Key Management in SQL
Speaker: Said Salomon
Category: Security
Level: 200
Abstract: Overview of data encryptions and key management that is built into SQL 2005 and later. Topics that will be cover include: transparent column data encryption techniques, Transparent Data Encryption (TDE) new in 2008, use of keys (symmetrical and asymmetrical), what is a database master key, use of certificates in combination with key management, how to backup and safeguard keys.
Session Goals
  • Over view of encryption keys in SQL 2005, 2008
  • Understanding of the key management system in SQL 2005, 2008
  • Underline good practices in using encryption keys in SQL 2005, 2008
Speaker Bio: Said Salomon has over 25 year experience as an IT Professional. He has a vast array of abilities in the field in the areas of Network, Desktop Support, DBA, Staff Project Management, Application Software Development, Business Analysis and Quality Assurance. Said carries Microsoft certifications as a MCTS, MCPS, and MCNPS, and multiple certifications from the Insurance Institute of America. Current Said is a DBA at Unitrin Direct Insurance. Secretary of Philadelphia SQL Server User Group (PSSUG). I am also the SQL Track lead for the Philly Dot Net Code Camps.



Title: Protect Your Data's Privacy! Data Encryption with SQL Server
Speaker: Joe Kuemerle
Category: Security
Level: 300
Abstract: Your data at rest is at risk. We take great pains to write secure applications that prevent bad guys from snooping around and stealing confidential information, but what about when we finally write to the database? In this session you will learn to protect your data by leveraging the built in encryption functionality in SQL Server 2005/2008. We will walk through a brownfield application and transparently secure all of the sensitive data it stores without frustrating the overworked developers. Topics covered will include column level data encryption, providing lookups of encrypted data, basics of key management and the transparent data encryption capabilities of SQL Server 2008.
Session Goals
  • Protecting sensitive data accessed by multiple clients in multiple applications with built in data encryption.
  • Improve application and data security by replacing clear text password storage with hashed values.
  • Improve application performance and functionality by demonstrating how to safely look up encrypted data without having to scan and decrypt every row.
Speaker Bio:  Joe Kuemerle is a developer and speaker in the Cleveland, OH area specializing in .NET development, security, database and application lifecycle topics.  He is currently a Lead Developer at PreEmptive Solutions, LLC .  PreEmptive is the maker of Dotfuscator, the premier obfuscator for .NET; DashO, the top Java obfuscator; and Runtime Intelligence, a solution to inject application usage tracking into .NET and Java applications.  



Title: Administrator's Idol: Secure Database
Speaker: Erdal Ozkaya
Category: Security
Level: 400
Abstract: This session will provide you with the ability to run a network intrusion vulnerability analysis through penetration testing and then create the best possible prevention plan available. With cyber crime and attacks rising, it is necessary to be aware and it's everyone's goal to have a secure database. If you care about security then this session is right for you.
Session Goals
  • Have a secure database
  • Security Patch managment
  • penetration testing against database servers
Speaker Bio: Erdal is a co-founder and Senior Microsoft Instructor at CEO IT Training; one of Australia’s Gold certified Microsoft Learning Partners. Erdal travels across Australia teaching IT workshops and has served as Project Manager/Engineer for several large organisations in Australia, China, Philippines and the USA. Erdal actively participates in worldwide events as a Technical Lead and Speaker. He was awarded “Best Technical Learning Guide” and “Best Speaker” in Microsoft Technical Education Seminars (TechEd) Australia. He specialises in Security (EC-Council, ISO 27001) , Windows , Exchange 2007/2010, Sharepoint2007/2010 The passion and commitment that Erdal has shown to his work has been recognized by Microsoft. In 2009 and 2010 Erdal Ozkaya was awarded the Microsoft Most Valuable Professional award as Windows Expert – IT Pro. Recently, in April 2010, Microsoft went one step further and announced Erdal Ozkaya as the FIRST Microsoft Certified Leaning Consultant in Australia. There are few recipients of this award in the world, with only one recipient in Australia, Erdal Ozkaya. Erdal is also leading some User groups of PASS, GITCA (Culmins) & INETA



Title: Social Engineering, the art of Deception!
Speaker: Erdal Ozkaya
Category: Security
Level: 400
Abstract: We all like to stay out of trouble, and we all like to have secure and protected networks. We use the tools to protect our networks, but is there a tool to protect as from the art of deception? We patch our operating systems, upgrade our hardware’s firmware but do we have a patch for human stupidity? This session is designed to introduce you to the dangers that may come your way through social engineering!  Following this 75 minute session, you will not be the same again. Yes, it is a good idea to protect your systems with ForeFront products but it is also a good idea to be aware of non-computing attacks which might affect your networks.
Session Goals
  • Make BI, DB & IT Pros aware
  • How can our databases be protected against non computer attacks?
  • SQL Injection protection
Speaker Bio: Erdal is a co-founder and Senior Microsoft Instructor at CEO IT Training; one of Australia’s Gold certified Microsoft Learning Partners. Erdal travels across Australia teaching IT workshops and has served as Project Manager/Engineer for several large organisations in Australia, China, Philippines and the USA. Erdal actively participates in worldwide events as a Technical Lead and Speaker. He was awarded “Best Technical Learning Guide” and “Best Speaker” in Microsoft Technical Education Seminars (TechEd) Australia. He specialises in Security (EC-Council, ISO 27001) , Windows , Exchange 2007/2010, Sharepoint2007/2010 The passion and commitment that Erdal has shown to his work has been recognized by Microsoft. In 2009 and 2010 Erdal Ozkaya was awarded the Microsoft Most Valuable Professional award as Windows Expert – IT Pro. Recently, in April 2010, Microsoft went one step further and announced Erdal Ozkaya as the FIRST Microsoft Certified Leaning Consultant in Australia. There are few recipients of this award in the world, with only one recipient in Australia, Erdal Ozkaya. Erdal is also leading some User groups of PASS, GITCA (Culmins) & INETA

Storage

Title: Solid State Storage Deep Dive
Speaker: Wesley Brown
Category: Storage
Level: 100
Abstract: If you have ever wanted to know how SSD's and Flash memory works this talk is for you. We will cover the fundamentals of Flash in detail. I will also highlight some of the specific vendor implementations and what makes a particular SSD enterprise- ready vs consumer grade. We will also cover SQL Server usage patterns what is a good fit for SSD's and when it may be better to go with hard disks. Solid State Storage isn't a cure-all for every situation, this presentation will give you the tools you need to make the right choice for your SQL Server environment.
Session Goals
  • Understand the fundamental building block of Flash memory.
  • Get a clear explanation of what makes some SSD's robust enough for enterprise use.
  • Learn where SSD will and won't make a real difference in your SQL Server environment.
Speaker Bio: Wes Brown is a PASS chapter leader and loves to teach others about SQL Server. He writes for SQL Server Central and maintains his technical blog at http://www.sqlserverio.com. Wes is Currently serving as Chief Database Architect for eScan Data Systems. Previous experiences include Product Manager for SQL Litespeed by Quest software and consultant to fortune 500 companies. He specializes in high availability, disaster recovery and very large database performance tuning.



Title: Understanding Storage Systems and SQL Server
Speaker: Wesley Brown
Category: Storage
Level: 100
Abstract: The most important part of your SQL Server is also the slowest, Storage. This talk will take you through the fundamentals of your server's Disk I/O System. From how hard drives work, through RAID configurations, and how to configure the file system. This session should give you a solid foundation over storage systems and help you understand why they are slow and how to overcome some of their limitations.
Session Goals
  • Understand the physical characteristics of IO hardware.
  • Understand the fundamentals of RAID.
  • Understand how to configure the file system.
Speaker Bio: Wes Brown is a PASS chapter leader and loves to teach others about SQL Server. He writes for SQL Server Central and maintains his technical blog at http://www.sqlserverio.com. Wes is Currently serving as Chief Database Architect for eScan Data Systems. Previous experiences include Product Manager for SQL Litespeed by Quest software and consultant to fortune 500 companies. He specializes in high availability, disaster recovery and very large database performance tuning.



Title: Using SSIS to manage and monitor SAN - Mount Volumes
Speaker: Srikkant Sridharan
Category: Storage
Level: 200
Abstract: Many organizations struggle to manage space especially in the DB environments. As your SQL Server foot print grows, the love-hate relationship with the SAN increases. Attend this session to get some ideas around how to monitor and trend DB Space using SSIS. You will also learn how to capture SAN / Mount point usage using WMI calls. At the end of the session, you will be able to monitor, forecast and trend your SQL DB footprint along with SAN mountpoint info. This will help your management team to budget for SAN growth in a more efficient and predictable manner.
Session Goals
  • Provide a framework that will help you track and monitor SAN mount volume space. Many tools - including basic Windows functionality will not report mount volume space correctly. This fills that gap.
  • Provide a framework to collect data from multiple servers without buying 3rd party tools that you cannot carry from one job to another.
  • If you are going into a new environment, this is a nice tool to understand to help you grasp lots of great information about the environment.
Speaker Bio: Sri is the President of North Texas SQL Server User Group. Sri has been involved with SQL Server since version 4.2 and has held various roles developer/dba/ architect / pre-sales over the years. He is largely responsible for some of  few features in SQL 2008 like TDE and tools like MAPS. Sri holds a Bachelor's Degree in Physics , Masters in Computer Information Systems and an MBA in Finance. His wife Hema, made sure he got a 3rd Masters in parenting their 2 sons.



Title: Page And Row Compression How, When, and Why
Speaker: Bradley Ball
Category: Storage
Level: 300
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 into 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. And what you should you take into consideration for additional overhead.
Session Goals
  • Explain what Row, Page Dictionary, and Column Prefix Compression are.
  • Learn how your Allocation Units and Update and Scan pattern’s affect the compression types you should consider
  • Discuss what additional overhead should be allowed for, when considering compression
Speaker Bio: Bradley Ball is a MCITP SQL 2005 & MCTS 2008 Database Administrator with over 10 years of IT experience. Bradley spent 8 years working as a Defense contractor for clients such as the U.S. Army and The Executive Office Of the President of the United States. He is currently a Sr. SQL Database Administrator for Publix Supermarkets. Bradley can be found blogging on http://sqlballs.blogspot.com .

Summit Spotlight

Title: A PowerShell Cookbook for DBAs
Speaker: Trevor Barkhouse
Category: Summit Spotlight
Level: 100
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, and 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.
Session Goals
  • Show the value of PowerShell to DBAs through practical applications of the tool, rather than teaching the language itself
  • Help new PowerShell users to get started by walking through installation and running one's first scripts
  • Provide a dozen scripts that can be used immediately in the attendee's daily work to save them time
Speaker Bio: Trevor Barkhouse is an Escalation DBA for Terremark Worldwide, Inc., a leading global provider of IT infrastructure services. His passions are automation, performance tuning, and troubleshooting. Trevor has spoken at many user group meetings, five SQLSaturday events, the 2010 Houston TechFest, and last two the PASS Community Summits (North American).



Title: As A DBA, Where Do I Start?! - Tips to unwind the mess waiting for us
Speaker: Mike Walsh
Category: Summit Spotlight
Level: 100
Abstract: You've always wanted to get promoted into the DBA position. The good news is you got it; the bad news is you have no idea what to do first. What's important, what's not a big deal, and what can get you fired if you're not careful? If your answer wasn’t “update my resume”, then this session is a good start. We’ll chat about a natural priority for the overwhelming flood waiting in our offices. By focusing on a few words ending in “ity” we’ll realize what is most important. Through the interaction, stories and examples you’ll leave feeling ready to attack your environment. Be warned – along the way to knowing where to start, you may get that feeling in your stomach that makes you log on to the VPN to check a few things out.
Session Goals
  • Leave with questions and concerns for your environment.
  • Leave with the idea that you are the data advocate at your company and no one else is.
  • To beat up a recurring myth in most SQL Server shops (Come to the session to see the myth)
Speaker Bio: Mike is an experienced SQL Server professional and has worked with SQL Server for over ten years. He has performed the duties of Database Administrator, Developer, Architect and Performance Team Lead but always leans on his DBA experience in each role. Mike is working for a Microsoft Solutions Provider in Portland Maine, Winxnet as a Sr. SQL Server Systems Consultant. He is the president and co-founder of the Seacoast SQL Server Users Group in Portsmouth, NH; he blogs at www.straightpathsql.com and contributes to community projects like SQL University.



Title: Automating Routine Maintenance
Speaker: Ken Simmons
Category: Summit Spotlight
Level: 100
Abstract: You have installed SQL Server in your environment, but now what? Unfortunately, far too many servers are neglected after SQL Server has been installed and the applications are up and running. In order to sustain a SQL Server instance that provides optimum performance, it requires constant maintenance. Luckily, you can use the same tools within SQL Server to automate maintenance tasks that you use to meet the business needs of the organization. This session will cover the tasks you need to perform in order to maintain a healthy instance of SQL Server as well as the tools you can use to automate them.
Session Goals
  • Make informed decisions about the maintenance that must be performed within SQL Server.
  • Enhance proactive administration by receiving notifications for job failures and alerts.
  • Improve performance across your environment by performing routine system maintenance.
Speaker Bio: Ken Simmons is a DBA, Developer, and Microsoft SQL Server MVP. He is the coauthor of Pro SQL Server 2008 Administration (Apress, 2009), Pro SQL Server 2008 Mirroring (Apress, 2009), and Pro SQL Server 2008 Policy-Based Management (Apress, 2010).



Title: Let Service Broker Help You Scale Your Application
Speaker: Allen White
Category: Summit Spotlight
Level: 100
Abstract: Service Broker was introduced in SQL Server 2005 to provide asynchronous messaging in your database applications, but it's seldom used because it isn't well understood. In this session we'll walk you through the basics of Service Broker and show how you can use it to build highly scalable applications.
Session Goals
  • Understand Service Broker basic architecture
  • Understand how to construct/deconstruct Service Broker messages
  • Look at designs for highly scalable applications using Service Broker
Speaker Bio: Allen is a consultant and mentor for Upsearch Technology Services in Northeast Ohio. He's spent over 35 years in IT and has been using SQL Server since 1992 and is certified MCITP in SQL Server and MCT. Allen has been awarded Microsoft’s MVP Award for the last four years. He's active in the Ohio North SQL Server User's Group and contributes in the MSDN Forums, answering questions about SMO and PowerShell, and maintains a blog at http://sqlblog.com/blogs/allen_white/default.aspx.



Title: Back From the Dead: How to Restore a SQL Server in 60 Minutes or Less
Speaker: Brad McGehee
Category: Summit Spotlight
Level: 200
Abstract: While most DBAs know how to perform backups, restoring an entire SQL Server instance under the pressure of having to get the server up and running as soon as possible, is often another story. In this session, I will demonstrate, step-by-step, the entire process of restoring all of the system and user databases from a damaged instance to a new instance. By learning how to perform a quick server restore, not only will your manager and users be happier, you will feel a lot less stress when you are under the gun. This session is filled with demonstrations, and assumes attendees have a basic understanding of how to use the BACKUP and RESTORE commands. This session is most appropriate for DBAs who manage databases less than 100GB in size.
Session Goals
  • Many DBAs underestimate the importance of fully understanding how to restore a SQL Server in the case of an emergency. Because of this, the first goal is to get attendees to understand the important of knowing this process inside and out.
  • The session will begin with an overview of all the necessary planning, implementation, and testing required to restore a SQL Server instance. The goal is to provide attendees with the "big picture".
  • Once attendees understand the big picture, the rest of the session will include a complete demo of restoring a dead SQL Server, step-by-step.
Speaker Bio: Brad M. McGehee is a MCSE+I, MCSD, and MCT (former) with a Bachelor's degree in Economics and a Masters in Business Administration. Currently the Director of DBA Education for Red Gate Software, Brad is an accomplished Microsoft SQL Server MVP with over 16 years SQL Server experience, over 7 years training experience, and has been involved in the industry since 1982. Brad is a frequent speaker at SQL PASS, European PASS, SQL Connections, SQLTeach, devLINK, SQLBits, SQL Saturdays, TechFests, Code Camps, SQL Server user groups, and other industry seminars, where he shares his 15 years’ cumulative knowledge. In 2010, Brad made 29 public presentations to a total of 3,075 attendees, Brad was the founder of the popular community site SQL-Server-Performance.Com, and operated it from 2000 through 2006, where he wrote over one million words on SQL Server topics. A well-respected and trusted name in SQL Server literature, Brad is the author or co-author of more than 15 technical books and over 250 published articles. His most recent books include How to Become an Exceptional DBA (2nd Edition), Brad's Sure Guide to SQL Server 2008: The Top Ten New Features for DBAs, Mastering SQL Server Profiler, and Brad’s Sure Guide to SQL Server Maintenance Plans.  



Title: Clustering, Database Mirroring, Log Shipping, Replication, and HADRON: Oh My!
Speaker: Allan Hirt
Category: Summit Spotlight
Level: 200
Abstract: Are you confused by the buffet of options available to you now or that soon will be available to you in Denali for making your instances and databases available? There are many built-in features such as failover clustering, replication, database mirroring, log shipping, and soon, HADRON. This session will compare and contrast all of them in a practical way so you can think about how and where you would use them. MOre importantly, this session will cover what it takes to truly have mission critical SQL Server deployments. Also discussed will be the non-SQL Server options for making instances and databases highly available.
Session Goals
  • Understand the different availability options and their tradeoffs
  • Understand the basics of what it takes to make SQL Server highly available and mission critical
  • Understand the non-SQL Server options for making SQL Server available
Speaker Bio: Allan Hirt is a Clustering MVP who has been using Microsoft SQL Server in various guises since 1992 since interning at Sybase in college. Except for the OS/2 version of SQL Server, Allan has worked with all versions on Windows since 4.21a. He has also worked with other RDBMS systems over the years including Oracle, Sybase, and Informix, and can relate to non-SQL Server DBAs and those who are not familiar with Windows. He is currently based in the Boston, MA area and for the past ten years has traveled all over the world to work with clients as well as deliver training. Before forming Megahirtz in 2007, he most recently worked for both Microsoft and Avanade. Over the years, he has authored or contributed to publications about SQL Server for Microsoft, SQL Server Magazine, and others including whitepapers, webcasts, training courses, and books. He is a frequent speaker at conferences like Tech·Ed and SQL PASS. His most recent book, "Pro SQL Server 2008 Failover Clustering," was published by Apress in July, 2009, and Allan's most recent whitepaper on consolidation was published by Microsoft in October, 2009. His blog and contact information can be found at http://www.sqlha.com.



Title: Database Maintenance Essentials
Speaker: Brad McGehee
Category: Summit Spotlight
Level: 200
Abstract: Many DBAs take routine database maintenance for granted. What they don’t understand is that the cumulative effect of poor database maintenance can significantly hurt performance and reduce up time. In this session, you will learn the key things all DBAs need to know in order to help them maintain their databases at peak performance. As such, this session is targeted towards those who have less than one year’s experience as a SQL Server DBA. In this session you will learn about: Physical File Fragmentation; Database and Log File Management; tempdb Maintenance, msdb Maintenance; Index Maintenance; Statistics Maintenance; Data Corruption Detection; Database and Log File Protection; and Database Maintenance Monitoring. Because of time considerations, and the amount of content to be covered, the focus will be on explaining what needs to be done, not how to perform each task. By learning the best practices suggested in this session, DBAs will be able to go back to their organizations and begin to immediately implement them.
Session Goals
  • Many novice, or accidental DBAs, aren't familiar with why database maintenance is important. This session will introduce them to the importance of database maintenance, and help persuade them to implement an appropriate strategy.
  • Once attendees understand the important of database maintenance, this session is designed to introduce them to the essentials they need to know in order to optimize their database's performance and up time.
  • Each key database maintenance task will be described in detail, including a list of best practices attendees can implement when creating their database maintenance jobs.
Speaker Bio: Brad M. McGehee is a MCSE+I, MCSD, and MCT (former) with a Bachelor's degree in Economics and a Masters in Business Administration. Currently the Director of DBA Education for Red Gate Software, Brad is an accomplished Microsoft SQL Server MVP with over 16 years SQL Server experience, over 7 years training experience, and has been involved in the industry since 1982. Brad is a frequent speaker at SQL PASS, European PASS, SQL Connections, SQLTeach, devLINK, SQLBits, SQL Saturdays, TechFests, Code Camps, SQL Server user groups, and other industry seminars, where he shares his 15 years’ cumulative knowledge. In 2010, Brad made 29 public presentations to a total of 3,075 attendees, Brad was the founder of the popular community site SQL-Server-Performance.Com, and operated it from 2000 through 2006, where he wrote over one million words on SQL Server topics. A well-respected and trusted name in SQL Server literature, Brad is the author or co-author of more than 15 technical books and over 250 published articles. His most recent books include How to Become an Exceptional DBA (2nd Edition), Brad's Sure Guide to SQL Server 2008: The Top Ten New Features for DBAs, Mastering SQL Server Profiler, and Brad’s Sure Guide to SQL Server Maintenance Plans.  



Title: Deadlocking for Mere Mortals
Speaker: Jonathan Kehayias
Category: Summit Spotlight
Level: 200
Abstract: While troubleshooting deadlocking in SQL Server has gotten easier in SQL Server 2005 and 2008, it continues to be a constant source of questions in the forums online. This session will look at the most common deadlocks asked about on the forums, and how to troubleshoot them using the various methods available to DBA’s in SQL Server 2005 and 2008; including Trace Flags, SQL Trace, Event Notifications, and Extended Events.
Session Goals
  • Understand why deadlocks occur in SQL Server
  • Understand how to capture deadlock graphs in various SQL Server versions.
  • Understand how to read the deadlock graph to determine the specific cause and how to mitigate against the deadlock.
Speaker Bio: Jonathan Kehayias is a MCITP Database Administrator and Developer, who got started in SQL Server in 2004 as a database developer and report writer in the natural gas industry. After spending two and a half years working in TSQL, in late 2006, he transitioned to the role of SQL Database Administrator. His primary passion is performance tuning, where he frequently rewrites queries for better performance and performs in depth analysis of index implementation and usage. Jonathan blogs regularly on SQLBlog, and was a coauthor of Professional SQL Server 2008 Internals and Troubleshooting.



Title: Developing a Multilevel Business Continuity Plan
Speaker: Robert Davis
Category: Summit Spotlight
Level: 200
Abstract: High Availability (HA) and Disaster Recovery (DR) are often treated as distinct entities. These topics are closely related concepts that can fall under a single umbrella of Business Continuity (BC). Business Continuity is more than just being highly available or being able to recover from disaster. Business Continuity is all about keeping the business in business. This should be the end goal of a good HA/DR plan. If you simply come up with an HA/DR plan without thinking about how it will affect the business, you may end up with a lot of unhappy people if disaster strikes or availability is affected in a way that had not been anticipated. This session will guide you through the various high availability and disaster recovery options and will examine how the features complement each other to form a comprehensive BC plan. This session is about more than just checking items on a checklist. Learn how you can set realistic business expectations for uptime and recoverability that set you up for success in the event of a disaster or unplanned downtime.
Session Goals
  • Understand the available High Availability (HA) and Disaster Recovery (DR) features of SQL Server and how they complieent each other.
  • Learn how to develop a Business Continuity (BC) plan that sets you up for success.
  • Learn about the new High Availability (HA) and Disaster Recovery (DR) features in SQL Server Denali.
Speaker Bio: I am a Sr. Production DBA at Microsoft and have worked with SQL Server for 10+ years. I am a SQL Server 2008 Certified Master. In my current role at Microsoft, I am the technical lead of the SQL V-Team in PQO (Product Quality & Online) Operations that strives to drive the SQL Strategy within PQO Operations and provide SQL Services to PQO Engineering. I am helping to promote the SQL Server advanced certification tracks for Certified Master and Certified Architect. I helped found the SQL PASS Virtual Chapter for Data Architecture. I am co-author of the book Pro SQL Server 2008 Mirroring. The principal PM for the HADRON feature in SQL Server Denali used my book as a reference for building the user interface (UI) for HADRON. I often speak or present internally at Microsoft or at SQL Server events on topics such as High Availability and Disaster Recovery. Outside of work, I am married with two German Shepherds named Maggie and Woody. I am also an avid writer. I frequently blog about SQL Server topics at www.SQLSoldier.com, and I also enjoy writing horror fiction, much of which is posted online at www.writerscafe.org/Rawhide. I am active on Twitter as @SQLSoldier.



Title: Migrating to SQL Azure
Speaker: Lynn Langit
Category: Summit Spotlight
Level: 200
Abstract: Are you looking to migrate your on-premise applications and database from MySql or other RDBMs to SQL Azure? Or are you simply focused on the easiest ways to get your SQL Server database up to SQL Azure? Then, this session is for you. We cover two fundamental areas in this session: application data access tier and the database schema data. In Part 1, we dive into application data-access tier, covering common migration issues as well as best practices that will help make your data-access tier more resilient in the cloud and on SQL Azure. In Part 2, the focus is on database migration. We go through migrating schema and data, taking a look at tools and techniques for efficient transfer of schema through Management Studio and Data-Tier Application (DAC). Then, we discover efficient ways of moving small and large data into SQL Azure through tools like SSIS and BCP. We close the session with a glimpse into what is in store in future for easing migration of applications into SQL Azure. Using Microsoft Visual Studio 2010 to Build Applications That Run on Windows Azure Azure Services Platform - AZP A platform is only as powerful as the tools that let you build applications for it. This session focuses on using demos, not slides, to show the best way to use Visual Studio 2010 to develop Windows Azure applications. Learn tips, tricks and solutions to common problems when creating or moving an existing application to run on Windows Azure. Come see how Visual Studio 2010 supports all parts of the development cycle as we show how to take an ASP.NET application running on IIS and make it a scalable cloud application running on Windows Azure. Advanced Business Intelligence with Microsoft Excel and Excel Services Business Intelligence - BIN This session covers the new advanced capabilities in Microsoft Excel 2010 to help you create detailed analytical reports. We cover new capabilities, such as how to use dynamic sets leveraging the content in Analysis Services, using write-back to provide closed loop analysis, and taking advantage of the new calc-member filtering and slicers with cube functions. We also show you how to share this in Excel Services to create a real-time view and use the new REST API to empower your users. Architecture of Master Data Services in Microsoft SQL Server 2008 R2 Business Intelligence - BIN While your enterprise applications and infrastructure technology change rapidly, the underlying Information Architecture must transcend those evolutions
Session Goals
  • Understand Migration tools
  • Understand Migration strategies
Speaker Bio:   I am a DE (Developer Evangelist) for the MSDN (Microsoft Developer Network) team.  My job is to give talks to developers throughout Southern California, to listen to their feedback, and to communicate that feedback back to Redmond.  My interests and specialities are as follows: Web development Microsoft SharePoint Server SQL Server (everything!) BI (Business Intelligence) using SSAS, SSRS and SSIS (that's Analysis Services, Reporting Services and Integration Services) Teaching Kids Programming I am a "language geek" with a degree in linguistics and have a hobby of learning foreign languages.  Semantic modeling - both visual and verbal - fascinates me.  I love LINQ, SDML, ORM and the like...I mean, really, how many people have you ever met that actually used English Query in SQL Server 7.0?            



Title: Strategies for Working with VLDBs
Speaker: Robert Davis
Category: Summit Spotlight
Level: 200
Abstract: Very large databases (VLDBs) are just like regular databases, right? There's just more of them to love. Working with very large databases can be difficult and tricky at times. Everything takes longer and minor issues become major very quickly. In this session you will learn some strategies for working with VLDBs such as how to speed up backups and restores, how to minimize your maintenance window requirements, and how to efficiently and quickly set up failover partners and replicas. Demos will include how I set up a log shipping secondary and a replica of a 2 TB database in less than half an hour.
Session Goals
  • Learn how to speed up common maintenance tasks such as backup and restore.
  • Learn how to minimize maintenance window requirements.
  • Learn strategies for setting up and configuring HA and DR secondaries/partners with minimal downtime.
Speaker Bio: I am a Sr. Production DBA at Microsoft and have worked with SQL Server for 10+ years. I am a SQL Server 2008 Certified Master. In my current role at Microsoft, I am the technical lead of the SQL V-Team in PQO (Product Quality & Online) Operations that strives to drive the SQL Strategy within PQO Operations and provide SQL Services to PQO Engineering. I am helping to promote the SQL Server advanced certification tracks for Certified Master and Certified Architect. I helped found the SQL PASS Virtual Chapter for Data Architecture. I am co-author of the book Pro SQL Server 2008 Mirroring. The principal PM for the HADRON feature in SQL Server Denali used my book as a reference for building the user interface (UI) for HADRON. I often speak or present internally at Microsoft or at SQL Server events on topics such as High Availability and Disaster Recovery. Outside of work, I am married with two German Shepherds named Maggie and Woody. I am also an avid writer. I frequently blog about SQL Server topics at www.SQLSoldier.com, and I also enjoy writing horror fiction, much of which is posted online at www.writerscafe.org/Rawhide. I am active on Twitter as @SQLSoldier.



Title: The Art of Indexing
Speaker: Ken Simmons
Category: Summit Spotlight
Level: 200
Abstract: Creating indexes can be one of the most useful performance gains you can add to your database. However, having too many indexes can hurt performance as well as require additional space and maintenance time. The introduction of Dynamic Management Views has made indexing easier; however, there are still many tactics you need to be aware of when applying indexes. This session will cover strategies such as discovering and applying missing indexes, finding and removing overlapping indexes, and identifying rarely used indexes that are expensive to maintain.
Session Goals
  • Introduce the different kinds of indexes and index options along with best practices for using them.
  • Provide strategies for creating indexes by taking advantage of DMV's and the Plan Cache.
  • Cover the various ways indexes can degrade performance along with options for finding and removing them.
Speaker Bio: Ken Simmons is a DBA, Developer, and Microsoft SQL Server MVP. He is the coauthor of Pro SQL Server 2008 Administration (Apress, 2009), Pro SQL Server 2008 Mirroring (Apress, 2009), and Pro SQL Server 2008 Policy-Based Management (Apress, 2010).



Title: Things to do in SQL when you’re dead(locked)
Speaker: Kevin Goode
Category: Summit Spotlight
Level: 200
Abstract: Do you have some weird ideas in your head about things to do in SQL when you're dead(locked)? Well, then; this is the session for you. This session will give an over-view of what a deadlock is and several ways to capture information about deadlocks. The captured deadlock will be dissected with XQuery -exposing what resources were deadlocked and what statements caused the deadlock. To wrap up the session, several techniques will be demonstrated that can be used to eliminate, or at least gracefully recover from, deadlocks.
Session Goals
  • Understand what a deadlock is and how to capture information about it
  • Understand how to read a deadlock graph
  • Learn how to avoid or recover from deadlocks
Speaker Bio: Kevin Goode is an MCSE, MCSD, and MCDBA. Currently, he is the Senior Data Architect for Inmar Inc. Kevin has over 12 years SQL Server experience starting with 6.5 and 15 years of IT experience. He has worked in many industries including manufacturing, distribution and logistics, financial services, IT outsourcing and has worked for several fortune 500 companies. His specialties include SQL Server development, Performance Tuning, Business Intelligence, and ETL.



Title: Automate Policy-Based Management using PowerShell
Speaker: Allen White
Category: Summit Spotlight
Level: 300
Abstract: The Policy-Based Management feature in SQL Server 2008 provides a great way to ensure your systems are configured consistently and correctly, but it can be tedious to implement on each server in your environment. PowerShell scripts allow you to automate the implementation of your policies so you can focus on more important problems. This session will walk you through how PBM works, how to define your policies in PowerShell, and how to set up Agent jobs to evaluate those policies regularly to let you know when you need to take action.
Session Goals
  • Understand basics of Policy-Based Management
  • Understand how to find PBM objects in PowerShell
  • Build PowerShell scripts to create policies
Speaker Bio: Allen is a consultant and mentor for Upsearch Technology Services in Northeast Ohio. He's spent over 35 years in IT and has been using SQL Server since 1992 and is certified MCITP in SQL Server and MCT. Allen has been awarded Microsoft’s MVP Award for the last four years. He's active in the Ohio North SQL Server User's Group and contributes in the MSDN Forums, answering questions about SMO and PowerShell, and maintains a blog at http://sqlblog.com/blogs/allen_white/default.aspx.



Title: Clustering for Mere Mortals
Speaker: Geoff Hiten
Category: Summit Spotlight
Level: 300
Abstract: Learn about clustering in current SQL Server and Windows Server releases. Failover Clustering is a fundamental step for any High Availability SQL implementation. Learn how Clustering works, what are the new requirements for Failover Clustering, and how you can make the most of this feature.
Session Goals
  • Understanding of Windows Failover Clustering Concepts
  • Understanding of SQL Server Clustering concepts
  • Information to decide if Failover Clustering is an appropriate technology for your needs.
Speaker Bio: Microsoft MVP Geoff Hiten is a Principal SQL Server consultant for Intellinet.  Geoff began working with SQL Server in 1992 with version 4.2 and has used every version since.  He specializes in high-availability and high-performance SQL systems.  Recent projects include: system upgrades, SQL Server platform migrations, performance tuning, custom reporting solutions, and database strategy implementations.   Geoff is currently on the leadership team of the Atlanta area Microsoft Database Forum Users group (AtlantaMDF) and can be found lurking in the halls at PASS (Professional Association for SQL Server) Community Summit events.  In addition, Geoff has been a Subject Matter Expert for Microsoft Training Curriculum materials and has authored articles, white papers and podcasts on SQL Server.



Title: Maximizing Parallelism Performance
Speaker: Victor Isakov
Category: Summit Spotlight
Level: 300
Abstract: Servers with multiple processors are now the de-facto standard. SQL Server 2008 R2 supports up to 256 processors. As a DBA you need to get a handle on how parallelism works in SQL Server so as to be able to troubleshoot any performance problems and maximize your parallelism performance. In this session Victor Isakov (MCT, MCM, MCA) will cover how parallelism works in SQL Server and how to best configure your SQL Server instance(s). He will then show how you can determine whether parallelism is "hurting" your query performance and what corrective action you can take. Finally Victor will go through a number of use cases of the different types of parallelism problems that you may see in the field.
Session Goals
  • Understand how parallelism works in SQL Server.
  • Ability to recognize parallelism problems and whether anything can be done to solve them.
  • Performance tune / maximize parallelism performance.
Speaker Bio: Victor Isakov (MCT | MCM | MCA) is a Database Architect and Trainer who provides consulting and training services to various organizations in the public, private and NGO sectors globally, and been involved in different capacities at various international events and conferences. Victor has authored a number of books on SQL Server and worked closely with Microsoft to develop the new generation of SQL Server Certification and Microsoft Official Curriculum for both instructor led training (ILT) and e-Learning. In 2010 Victor who worked with Microsoft on the eBackpack solution at the Department Of Education (NSW) to build a Sharepoint 2010 solution that scales to 1.3 million users.



Title: Performance Proof! Database Compression on Microsoft SQL Server 2008 R2
Speaker: Kevin Kline
Category: Summit Spotlight
Level: 300
Abstract: Database compression technologies in SQL Server 2008 R2 enable you to store more data within an active database in less space. But did you know database compression can also enable your applications to run faster? This session will teach you all about planning and implementing database compression. Not only that, we’ll take you through high-end scalability tests using the TPC benchmarks to show you the actual impact that database compression has on database performance with up to 2,000 concurrent users! Here’s what you’ll learn in this session: • Goal 1: Learn how to plan, prepare for, and implement database compression on your SQL Servers. • Goal 2: Learn the GUI and Transact-SQL commands, through live demos, that implement database compression. • Goal 3: Learn about the performance impact of database compression, where it is most and least helpful for performance through high-end TPC scalability tests of up to 2,000 concurrent users.
Session Goals
  • • Goal 1: Learn how to plan, prepare for, and implement database compression on your SQL Servers.
  • • Goal 2: Learn the GUI and Transact-SQL commands, through live demos, that implement database compression.
  • • Goal 3: Learn about the performance impact of database compression, where it is most and least helpful for performance through high-end TPC scalability tests of up to 2,000 concurrent users.
Speaker Bio: Kevin Kline is the Technical Strategy Manager for SQL Server Solutions at Quest Software. A Microsoft SQL Server MVP since 2004, Kevin is a founding board member and past president of the international Professional Association for SQL Server (PASS). He has written or co-written several books including SQL in a Nutshell (O’Reilly & Associates), SQL Server MVP Deep Dives (Manning), Pro SQL Server 2008 Database Design and Optimization (APress) and Database Benchmarking: Practical Methods for Oracle & SQL Server (Rampant). Kevin contributes to SQL Server Magazine and Database Trends & Applications Magazine and blogs at SQLBlog.com and SQLMag.com. Kevin is a top rated speaker at conferences worldwide such as Microsoft TechEd, the PASS Community Summit, Microsoft IT Forum, DevTeach, and SQL Connections, and has been active for over 20 years.



Title: Performance Proof! Parallel Query Processing on Microsoft SQL Server 2008 R2
Speaker: Kevin Kline
Category: Summit Spotlight
Level: 300
Abstract: The Query Optimizer in SQL Server 2008 R2 is a finely tuned machine that enables applications to quickly process and retrieve data. A key element of query processing speed is delivered by parallel query processing by exploiting the modern multicore hardware accessing large amounts of data. But not every workload is able to fully exploit the promise of parallelized queries. But how do you know when parallel queries give the most bang for the buck? In this session, you learn the answer to this question and many more including the use of high-end TPC scalability tests on applications supporting up to 2,000 concurrent users. Here’s what you’ll learn in this session:
• Goal 1: Understand how query processing, in general, and parallel query processing in particular work within SQL Server 2008 R2
• Goal 2: Identify the most common parallel query performance problems, as revealed by high-end TPC scalability tests supporting up to 2,000 concurrent users.
• Goal 3: Discover work-arounds that enable you to fully exploit parallel query processing for the most commonly occurring problems.
Session Goals
  • Understand how query processing, in general, and parallel query processing in particular work within SQL Server 2008 R2
  • Identify the most common parallel query performance problems, as revealed by high-end TPC scalability tests supporting up to 2,000 concurrent users.
  • Discover work-arounds that enable you to fully exploit parallel query processing for the most commonly occurring problems.
Speaker Bio: Kevin Kline is the Technical Strategy Manager for SQL Server Solutions at Quest Software. A Microsoft SQL Server MVP since 2004, Kevin is a founding board member and past president of the international Professional Association for SQL Server (PASS). He has written or co-written several books including SQL in a Nutshell (O’Reilly & Associates), SQL Server MVP Deep Dives (Manning), Pro SQL Server 2008 Database Design and Optimization (APress) and Database Benchmarking: Practical Methods for Oracle & SQL Server (Rampant). Kevin contributes to SQL Server Magazine and Database Trends & Applications Magazine and blogs at SQLBlog.com and SQLMag.com. Kevin is a top rated speaker at conferences worldwide such as Microsoft TechEd, the PASS Community Summit, Microsoft IT Forum, DevTeach, and SQL Connections, and has been active for over 20 years.



Title: Planning and Deploying Failover Clustering for SQL Server 2008 and Denali
Speaker: Allan Hirt
Category: Summit Spotlight
Level: 300
Abstract: Failover clustering is one of the most popular options to make SQL Server available in environments both large and small. However, clustering is something that must be properly planned and has many aspects to consider. This session will demystify what you need to do to have rock solid cluster deployments using Windows Server 2008 and Windows Server 2008 R2 for SQL Server, including how clustering will need to be thought about for the upcoming Denali release. Also discussed will be the top tips for deploying and administering a clustered SQL Server failover clustering instance.
Session Goals
  • Understand how to plan a Windows failover cluster for SQL Server
  • Understand how clustering is used in Denali
  • Tips and tricks for deploying clustered SQL Server instances
Speaker Bio: Allan Hirt is a Clustering MVP who has been using Microsoft SQL Server in various guises since 1992 since interning at Sybase in college. Except for the OS/2 version of SQL Server, Allan has worked with all versions on Windows since 4.21a. He has also worked with other RDBMS systems over the years including Oracle, Sybase, and Informix, and can relate to non-SQL Server DBAs and those who are not familiar with Windows. He is currently based in the Boston, MA area and for the past ten years has traveled all over the world to work with clients as well as deliver training. Before forming Megahirtz in 2007, he most recently worked for both Microsoft and Avanade. Over the years, he has authored or contributed to publications about SQL Server for Microsoft, SQL Server Magazine, and others including whitepapers, webcasts, training courses, and books. He is a frequent speaker at conferences like Tech·Ed and SQL PASS. His most recent book, "Pro SQL Server 2008 Failover Clustering," was published by Apress in July, 2009, and Allan's most recent whitepaper on consolidation was published by Microsoft in October, 2009. His blog and contact information can be found at http://www.sqlha.com.



Title: Quantitative Analysis of SQL Server Error Logs
Speaker: Trevor Barkhouse
Category: Summit Spotlight
Level: 300
Abstract: The SQL Server error log is essential for administering SQL Server, especially when troubleshooting. Unfortunately the error log has existed in its current form, a flat text file, for at least seventeen years. Parameters are combined with message templates and the resulting strings are written to the log file. These entries are useful for review by administrators, but are not suitable for automatic processing (categorization, summarization, or trending). Regular expressions enable extraction of data from the logs; however most administrators do not think the benefit is worth the effort. A newly developed, open-source tool (a PowerShell module), lets you decompose error log contents into each entry's message ID and a delimited list of message parameters. In this atomic state, you can perform quantitative analysis of the error log data. I will demonstrate the PowerShell Cmdlets, analyze data in the new format, and then discuss the algorithm for decomposing error log entries.
Session Goals
  • Demonstrate using the new PowerShell Cmdlets to decompose error message components
  • Show how quantitative analysis of error log messages helps troubleshoot several types of problems
  • Explain the approach for decomposing the error messages that is used by the Cmdlets
Speaker Bio: Trevor Barkhouse is an Escalation DBA for Terremark Worldwide, Inc., a leading global provider of IT infrastructure services. His passions are automation, performance tuning, and troubleshooting. Trevor has spoken at many user group meetings, five SQLSaturday events, the 2010 Houston TechFest, and last two the PASS Community Summits (North American).



Title: The Dirty Dozen: PowerShell Scripts for the Busy DBA
Speaker: Aaron Nelson
Category: Summit Spotlight
Level: 300
Abstract: For DBAs PowerShell provides a simple but powerful way to automate everyday tasks. This session walks you through a dozen scripts to simplify and easily automate time-consuming and tedious elements of your day to day job. This isn’t stuff you’ll use SOMEDAY, these are scripts you can use when you get home tonight. Harness the power of PowerShell to easily find Servers short on space, Script out tables and constraints across all of your databases at once. Backup databases and restore them to a different environment. These tricks and many others will allow PowerShell to simplify your job like no other tool.
Session Goals
  • Simplify Administration
Speaker Bio: Aaron Nelson ( blog | twitter ) is a Senior SQL Server Architect with over 10 years of experience in Architecture, Business Intelligence, Development, and Performance Tuning of SQL Server. He has experience managing enterprise wide data needs in both transactional and data warehouse environments. Aaron holds certifications for MCITP: Business Intelligence Developer, Database Administrator, Database Developer; as well as MCTS: Windows Server Virtualization, Configuration (meaning Hyper-V). Aaron helps run the AppDev and PowerShell Virtual Chapters of PASS, and volunteers for the local PASS Chapter AtlantaMDF. He also co-runs the Atlanta PowerShell User Group, and helps organize SQL Saturday events in Atlanta.



Title: Using Event Notifications in SQL Server 2005/2008
Speaker: Jonathan Kehayias
Category: Summit Spotlight
Level: 300
Abstract: Event Notifications have been a hidden gem in SQL Server 2005 and 2008, just waiting to provide you with real time information inside of events happening inside of SQL Server. This session will provide an overview of the Service Broker components used by Event Notifications and the difference between Event Notifications and other features of SQL Server like SQL Trace and DDL Triggers. You will learn how to build a monitoring solution for common problems in SQL Server like blocking and deadlocks that capture the needed information for troubleshooting in real time and provide email notification that a problem exists.
Session Goals
  • Understand the basic concepts behind Event Notifications
  • Demonstrate XML and XQuery requirements for consuming Event Notification information from Queues.
  • Show how to automate centralized collection of events from an enterprise of servers to simplify event management.
Speaker Bio: Jonathan Kehayias is a MCITP Database Administrator and Developer, who got started in SQL Server in 2004 as a database developer and report writer in the natural gas industry. After spending two and a half years working in TSQL, in late 2006, he transitioned to the role of SQL Database Administrator. His primary passion is performance tuning, where he frequently rewrites queries for better performance and performs in depth analysis of index implementation and usage. Jonathan blogs regularly on SQLBlog, and was a coauthor of Professional SQL Server 2008 Internals and Troubleshooting.



Title: Using SQL Server Denali's Always On
Speaker: Denny Cherry
Category: Summit Spotlight
Level: 300
Abstract: In this session we will look at the features which are provided with Microsoft SQL Server "Denali" as part of the "Always On" features including site to site configurations to allow of a large scale high availability solution without the need for any high end SAN storage solution. Additionally we will be looking at the ability to have redundant servers which can be used for reporting or for taking your backups reducing the load from the production database.
Session Goals
  • Learn how to setup "Always On"
  • Lean how to leverage "Always On" to increase production performance by offloading reporting and backups.
  • See the other two
Speaker Bio: Denny Cherry has over a decade of experience managing SQL Server, including MySpace.com’s over 175 million user installation, one of the largest in the world. Denny’s areas of technical expertise include system architecture, performance tuning, replication and troubleshooting. Denny currently holds several Microsoft Certifications related to SQL Server as well as being a Microsoft MVP. Denny is a longtime member of PASS and Quest Software’s Association of SQL Server Experts and has written numerous technical articles on SQL Server management.



Title: Are You Sure Your Network isn't Causing SQL Server Slowdowns?
Speaker: Brett Hawton
Category: Summit Spotlight
Level: 400
Abstract: Network latency and queues are often overlooked by the DBA when trying to determine performance problems with their SQL Servers. This session shows DBA's how to accurately gauge the network performance and demands being made by SQL Server as the typical OS performance counters and wait stats don't always show the whole picture. The session then goes on to show a DBA how network performance problems can be relatively inexpensively corrected or mitigated.
Session Goals
  • Be able to accurately gauge if the server is indeed experiencing network performance problems as they affect SQL Server.
  • Be able to correct all software settings to maximize network performance.
  • Be able to suggest to IT management relatively inexpensive methods to correct network hardware performance problems.
Speaker Bio: Brett has been involved in SQL Server since version 4.21. Initially as a DBA and then as a SQL performance consultant and finally as a product designer of SQL Server DBA tools. The tools that he has designed specifically for SQL Server DBA's run on over 100,000 SQL Server servers at over 5,000 organisations worldwide including many mission critical federal government agencies.  Brett has given performance and internals lectures at numerous SQL Server user groups over the years as well as at 2 previous SQL Pass events.



Title: How to Maximize SAN Performance in Real-world SQL Server Situations
Speaker: Brett Hawton
Category: Summit Spotlight
Level: 400
Abstract: In this session DBAs and administrators are shown precisely how to measure the real-world performance of the SAN as it handles SQL Server's IO requests. The overload points (in terms of IO/s) are clearly identified. Learn how to take these scenarios and overload points, and describe for each scenario how to re-configure in order to relieve the situation; thereby improving overall performance.
Session Goals
  • Show how to extract precise metrics of SAN performance as it relates to SQL Server IO requests
  • Take those extracted metrics and model them to derive overload points in SAN LUN usage.
  • For each overload scenario to provide various reconfiguration options for the SAN LUN.
Speaker Bio: Brett has been involved in SQL Server since version 4.21. Initially as a DBA and then as a SQL performance consultant and finally as a product designer of SQL Server DBA tools. The tools that he has designed specifically for SQL Server DBA's run on over 100,000 SQL Server servers at over 5,000 organisations worldwide including many mission critical federal government agencies.  Brett has given performance and internals lectures at numerous SQL Server user groups over the years as well as at 2 previous SQL Pass events.



Title: SQL Server 2008 Database Internals
Speaker: Klaus Aschenbrenner
Category: Summit Spotlight
Level: 400
Abstract: Do you already wanted to know how SQL Server 2008 stores a database file physically on the hard drive? In this session you will learn the internal structure of a SQL Server 2008 database file, and how SQL Server stores tables and indices internally in the file system. Furthermore you will see the DBCC T-SQL command in action, with which you can analyze the internal storage format of your database files. All these information from this session helps you in your next database design to get out the last percent of performance from your new database solution. We will cover: *) Database Structure *) Fixed data types *) Variable data types *) LOB data types *) Sparse Columns
Session Goals
  • Learn the physical structure of SQL Server Databases
  • Learn about the differences between fixed and variable length data types
  • Learn how database design decisions impact the physical storage of SQL Server tables
Speaker Bio: Klaus Aschenbrenner provides independent SQL Server Consulting Services across Europe and US. Klaus works with the .NET Framework and especially with the SQL Server 2005/2008 from the very early beginnings. In the years 2004 - 2005 Klaus was entitled with the MVP award from Microsoft for his tremendous support in the .NET Community. Klaus has also written the book Pro SQL Server 2008 Service Broker which was published by Apress in the Summer of 2008.



Title: SQL Server Index Internals
Speaker: Klaus Aschenbrenner
Category: Summit Spotlight
Level: 400
Abstract: SQL Server provides two kinds of indexes for relational data: Clustered- and Non-Clustered Indexes. Both can be defined as unique and non-unique. In this session you will learn how to use Clustered- and Non-Clustered Indexes in your database and how you can improve the execution time of your queries with those indexes. Furthermore we will have a look into the concrete storage details of both indexes and how they differ when you define them as unique and non-unique, and what  the tradeoff is between it. Finally, you will get some best practices how to deal effectively with Clustered- and Non-Clustered Indexes in your database.
Session Goals
  • Learn the differences between Clustered- and Non-Clustered Indexes and how they are stored physically
  • Learn the difference between unique and non-unique indexes and how they are stored physically
  • Learn how to use Clustered- and Non-Clustered Indexes to improve the performance of your queries
Speaker Bio: Klaus Aschenbrenner provides independent SQL Server Consulting Services across Europe and US. Klaus works with the .NET Framework and especially with the SQL Server 2005/2008 from the very early beginnings. In the years 2004 - 2005 Klaus was entitled with the MVP award from Microsoft for his tremendous support in the .NET Community. Klaus has also written the book Pro SQL Server 2008 Service Broker which was published by Apress in the Summer of 2008.
RegisterToAttend Agenda
The Orlando World Center
Resort Marriott
Hashtag:#sqlrally
Connect with us on Twitter
Presenting Sponsor
 
 
Silver Sponsors


 
  
 
 Bronze Sponsors