Event Location:
Holiday Inn Elk Grove Village
1000 Busse Rd
Chicago, Illinois
Abstract:
Clustering is a black box to many DBAs. Often, the IT dept configures installs the SQL cluster then turns it over to DBAs to deploy databases and set up backup maintenance plans. The problem is when things go wrong the DBAs are reliant on the IT dept when their time is better spent working on other things. The goal of this session is to discuss underlying aspects of SQL Server clustering. We will touch on OS and SQL Server issues as well as how it reacts differently being clustered vs non-clustered. We will also discuss the pitfalls of upgrading clustered databases and installing clusters from scratch including lessons learned from a real-world upgrade of a SQL Server cluster where the active and passive nodes are 1,200 miles apart!
Speaker(s): Chuck Heinzelman Michael Steineke,
Abstract:
In this session we will learn to perform several everyday DBA tasks like backing up user databases, scripting table objects and evaluating disk space usage with PowerShell. For each tasks we will explore the benefits is using PowerShell over the standard method. Only a basic understanding of PowerShell or DOS is needed. This session should serve as a good introduction to PowerShell for database users. The goal is to get data professionals feet wet about PowerShell.
Speaker(s): Aaron Nelson,
Abstract:
In this session we will talk about building a data warehouse using the SQL Server 2008 database and SQL Server Integration Services ETL product. We will cover the basics of data warehousing, how to start the project, and look at how we can use the tools to solve a business problem using a real-world example.
Speaker(s): Wes Dumey,
Abstract:
"You are a database guy, how do I write a query in MDX?" This is a question that many of you are probably hearing right now as your companies' database experts. As the amount of data access being delivered cubes in increasing every day your company is looking to you to help unlock that stored potential. You have used the query designers and profiler to build some really simple stuff, but now you need to really understand the language and figure how to do some more complex stuff. This session will help you take that journey from not understanding MDX to being an MDX Developer. This session will give you the core concepts of MDX and how to utilize them with clear concrete examples, along with the tools to get you there.
Speaker(s): Andrew Karcher,
Abstract:
These two tools are the key to successful performance tuning. I’ll show you how to get started with these tools, how to slice and dice the results, and even how to data mine the results to look for interesting trends. Whether you like to monitor performance with native tools or third party utilities, knowing how the native tools work will help you get better results out of your tools. You'll learn why Perfmon is like a Nissan GT-R’s dashboard, what Perfmon counters to measure (and why), and how to use ClearTrace to get insight into your trace files.
Speaker(s): Brent Ozar,
Abstract:
Spatial data is being pushed more and more into the forefront of our application universe. With the advent of MapPoint and Google Maps companies are consistantly pushing the boundaries of what traditional databases can do. Now with SQL Server 2008 we have built in spatial data types that will make your life a little easier in the days to come. This session will focus on utilizing these native types to store, analyze, and retrieve spatial data so that you can become the spatial data pro in your organization.
Speaker(s): Arie Jones,
Abstract:
Indexed views are an often misunderstood and underused feature of SQL Server that more DBAs should learn to master. Essentially, an indexed view is a standard view that has been materialized (made physical) by adding a unique clustered index to it. When used appropriately, they can greatly speed query performance. In this session, you will learn the features and benefits of using indexed views, learn where indexed views work best, learn how to create indexed views, and review indexed view best practices.
Speaker(s): Brad McGehee,
Abstract:
SQL Server Reporting Services has been around for a number of years now and the 2008 release provided DBAs and Developers with a truly enterprise class reporting platform. If your company had not embraced Reporting Services fully yet then now is the time! Come see not only some of the new features that are available but also how to programmatically interface with the Reporting Services web services in order to extend your own custom applications!
Speaker(s): Arie Jones,
Abstract:
You're minding your own business in your corner office - well, no, you're a DBA, so it's just your cubicle - when somebody says, "Did you know about this SQL Server over here?" Suddenly, you have to find out what the server's doing, how it was set up, and whether things are working correctly. In this real-time session, Brent will show you how he tackles unknown servers in 60 minutes to find problems, take an inventory, and set the server up for easier management down the road.
Speaker(s): Brent Ozar,
Abstract:
At Microsoft we understand that in the current economic climate you are being asked to better manage your database environment and reduce costs; in essence, keep the lights on. We have pulled together best practices for not only keeping the lights on but helping you manage more SQL Servers with less time and expense. The focus of this presentation is around: o o Management best practice: SQL Server Discovery o Microsoft Assessment and Planning Toolkit (MAP) o MAP query and report analysis o SQL Server 2008 management enhancements o Policy Based Management o Performance Data Warehouse o Configure Resource Governor o Management best practice: Cross Platforms
Speaker(s): Ross LoForte,
Abstract:
Vendor Presentation
Speaker(s): Aaron Lowe,
Abstract:
In this introductory level session, which is designed for DBAs with little or no knowledge of query execution plans, you will learn why execution plans are important, how they are created, learn about the different execution plan formats, discover different ways to produce them, find out about the difference between estimated and actual execution plans, and most importantly, learn the basics of how to read and interpret graphical execution plans. This includes taking a look at ten of the most commonly used execution plan operators, and finding out exactly what they mean.
Speaker(s): Brad McGehee,
Abstract:
Welcome and Keynote
Speaker(s): Aaron Lowe,
Abstract:
Find out the tricks and techniques needed to make SQL Server stored procedures achieve top performance. Numerous tips will show you how to make your stored procedures run faster, with fewer errors, and with better reliability. This class assumes a basic understanding of Transact-SQL. The session covers both SQL Server 2005 and 2008.
Speaker(s): Kevin Kline,
Abstract:
After Party
Speaker(s): Aaron Lowe,
Abstract:
In this session, you will learn how to split your measure group data in to more manageable pieces using partitions to speed up cube processing time. Then designing aggregations on your partitions will be discussed including how to create aggregations using Usage Based Optimization (UBO) to speed up query time.
Speaker(s): Devin Knight,
Abstract:
I will explain what is defensive programming, what are its advantages, and provide several simple real life examples that show how to use it. I will demonstrate how to develop robust Transact SQL code that correctly works in high concurrency environments, gracefully handles cases of unintended use, and is easy to maintain in changing environments.
Speaker(s): Alex Kuznetsov,
Abstract:
In our 101 session we covered general basics and walk throughs of some of the ground-level skillsets for a DBA. In this second class we dive into more advanced topics such as indexes, DMVs and advanced troubleshooting.
Speaker(s): Jorge Segarra,
Abstract:
Vendor Presentation
Speaker(s): Aaron Lowe,
Abstract:
We all know how difficult it is being a DBA. Everyone assumes they are your top priority, and time is in short supply to get everything accomplished daily. Heck, we all like to sleep at night too! This session will demonstrate the tools out of the box, as well as developed by the presenter, that allow you to automate tasks and make it possible for you to be a great DBA AND have a personal life.
Speaker(s): Tim Ford,
Abstract:
SQL Server stores its execution plans as XML in dynamic management views. The execution plans are a gold mine of information. From the whether or not the execution plan will rely on parallelism to what columns are requiring a key lookup after a non-clustered index seek. Through a the use of XML this information can be available at your finger tips to help determine the value and impact of an index and guide you in improving the performance of your SQL Server databases. Goals: 1. Discuss information available in an execution plan 2. Demonstrate use of XQuery to query execution cache 3. Demonstrate methods to performance tune
Speaker(s): Jason Strate,
Abstract:
Ask the Experts QA
Speaker(s): Aaron Lowe,
Abstract:
There are many ways to performance monitor your SQL Server environment. In this session we’ll review Extended Events, which is one of the newer SQL Server monitoring platforms. Learn the ins and outs of how to get detailed information on the errors and events that occur within SQL Server and how to dig into the information. With a few T-SQL statements, issues that could take weeks to research can be investigated in minutes. Goals: 1. Define the architecture for Extended Events 2. Identify scenarios where Extended Event can be used to troubleshoot performance 3. Demonstrate solutions to real-world performance scenarios
Speaker(s): Jason Strate,
Abstract:
This talk will focus on the benefits, features, object model and ease of use of SQL Server Data Services. Learn how your projects can benefit from a hosted data storage and query processing service. See by example how to design your program to use SQL Server Data Services.
Speaker(s): Aaron King,
Abstract:
Using Wait Time Analysis and Wait Types is a newer method for tuning SQL Server instances. As a result, there is often confusion on exactly what the data means. The issue typically centers around the fact the wait time data is analyzed at the wrong level or the collected wait time data is not detailed enough. This presentation will focus on these problems and review several real-life case studies of using SQL Server Wait Type data coupled with Wait-Time based performance analysis to solve the most difficult performance related issues.
Speaker(s): Dean Richards,
Abstract:
Overcome the barriers of traditional training and seminars with this Quick Start to building a cube. This all demo session will get you started and answer many questions you have about building cubes the right way, the first time.
Speaker(s): Adam Jorgensen,
Abstract:
Dynamic SQL is a misunderstood and much maligned part of a DBA’s tool kit – it can be used to solve difficult business problems, respond to diverse data needs, and alleviate performance problems. Many DBAs reject dynamic SQL outright as a potential source of SQL injections, being poorly performing, or just for being a hacky solution in general. Not so! Jeremiah Peschka has been making extensive use of dynamic SQL throughout his career to solve a variety of problems. He’ll set about dispelling these misconceptions and demonstrate how dynamic SQL can become a part of every DBA’s tool kit.
Speaker(s): Jeremiah Peschka,
Abstract:
The days of hiding amongst rows of servers, focusing purely on operational tasks are quickly coming to an end. This presentation will provide a high level overview of how to boost your value to your organization by automating the mundane operational tasks and focusing on supporting new development. Topics covered will include tools and techniques available for automation, integration with development teams and relationship management.
Speaker(s): David Levy,
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.
Speaker(s): Jeremiah Peschka,
Abstract:
Dynamic Management Views and Functions first made their appearance in SQL 2005. With almost five years of exposure they are still forbidden fruit for many DBAs. Find out how to tap into the power of these objects. To tune indexes, examine file I/O and wait stats, maintain healthy indexes, and see just who is doing what and when on your SQL Servers.
Speaker(s): Tim Ford,
Abstract:
We will be learning an overview of this powerful new feature in SQL 2008 and how you can leverage it to help manage your existing SQL environment. This will include plenty of demos, best practices and QA so by the end you should be able to walk away ready to take control of your SQL Servers!
Speaker(s): Jorge Segarra,
Abstract:
The days of long, inefficient Business Intelligence (BI) and data warehousing projects are coming to an end. Customers need to ability to reap quick business value for their investments. In this session we will take a tour of methodologies, techniques, and technologies that enable a quick return on investment for the Microsoft BI platform.
Speaker(s): Derek Comingore,
This is a list of speakers from the XML Guidebook records. The details and URLs were valid at the time of the event.
LinkedIn: https://www.linkedin.com/in/deknight/
Contact: http://devinknightsql.com
Devin Knight a Microsoft Data Platform MVP and the Training Director at Pragmatic Works. He is an author of seven SQL Server and Business Intelligence books and speaks at conferences like PASS Summit, PASS Business Analytics Conference, SQLSaturdays and Code Camps. He is also a contributing member to several PASS Virtual Chapters. Making his home in Jacksonville, FL, Devin is the Vice President of the local Power BI User Group and SQL Server User Group (JSSUG).
Contact: http://www.bradmcgehee.com
Brad M. McGehee is an MCSE+I, MCSD, and former MCT with a Bachelor’s degree in Economics and a Master's in Business Administration. Currently the Director of DBA Education for Red Gate Software, Brad is a Microsoft SQL Server MVP with over 16 years' SQL Server experience. He has been involved in the industry since 1982. Brad is a frequent speaker at industry conferences and events, including PASS Summit, the European PASS Conference, SQL Server Connections, SQLTeach, devLINK, SQLBits, SQLSaturdays, Code Camps, and SQL Server user groups. He founded the popular community site SQL-Server-Performance.com, which he operated from 2000 through 2006, and is the author or co-author of more than 15 technical books and over 275 published articles. He blogs at www.bradmcgehee.com.
Contact: http://feeds2.feedburner.com/StrateSql
Jason Strate, Digineer Inc, is a database architect and administrator with over 12 years of experience. In July 2009, he was awarded Microsoft MVP (Most Valuable Professional) for SQL Server. Jason is a SQL Server MCITP and participated in the development of Microsoft Certification exams for SQL Server 2008. He is actively involved with MN PASS chapter and is currently serving as the Program Director. Jason enjoys speaking and has presented for SSWUG, PASSMN, and at the PASS Summit.
Contact: http://www.aaronlowe.net
Aaron has over 14 years of SQL Server experience. He is strong in database design development, also having extensive experience in SSIS, SSRS, and administration, including performance, migrations and replication. Aaron is a MCITP in 2005 and 2008 as well as having a Masters in Information Systems Management. He is currently co-president of the Chicago SQLPASS Chapter and founder of SQLFriends.org. When he’s not working, he’s spending time with his bride, 5 children and 2 dogs.
Contact: http://brentozar.com
Jeremiah sees the magic in technology. He knows how to do things now, and he also knows how to think about possibilities. Jeremiah likes to imagine new kinds of indexes, new kinds of teams, new kinds of applications — this means when you need to reinvent something, or get unblocked, you should talk to Jeremiah.
Contact: http://KevinEKline.com
Kevin Kline is the Director of Engineering Services at SQL Sentry. A Microsoft SQL Server MVP, Kevin is a founding board member of PASS, editor-in-chief of SQLServerPedia.com and the author of popular IT books like “SQL in a Nutshell” (O’Reilly Associates). His twitter handle is @kekline and he blogs at http://KevinEKline.com. Kevin is a top-rated speaker at industry trade shows and has been active in the IT industry for over 20 years.
Contact: http://www.aaronlowe.net
Aaron has over 14 years of SQL Server experience. He is strong in database design development, also having extensive experience in SSIS, SSRS, and administration, including performance, migrations and replication. Aaron is a MCITP in 2005 and 2008 as well as having a Masters in Information Systems Management. He is currently co-president of the Chicago SQLPASS Chapter and founder of SQLFriends.org. When he’s not working, he’s spending time with his bride, 5 children and 2 dogs.
LinkedIn: http://www.linkedin.com/in/jdsegarra
Contact: http://sqlchicken.com
Jorge Segarra is a senior consultant for Microsoft (Premier Support for Developers) and a former SQL Server MVP. Jorge has co-authored titles including "SQL 2008 Pro Policy-Based Management" and "SQL Server 2012 Bible" .
Contact: http://www.bradmcgehee.com
Brad M. McGehee is an MCSE+I, MCSD, and former MCT with a Bachelor’s degree in Economics and a Master's in Business Administration. Currently the Director of DBA Education for Red Gate Software, Brad is a Microsoft SQL Server MVP with over 16 years' SQL Server experience. He has been involved in the industry since 1982. Brad is a frequent speaker at industry conferences and events, including PASS Summit, the European PASS Conference, SQL Server Connections, SQLTeach, devLINK, SQLBits, SQLSaturdays, Code Camps, and SQL Server user groups. He founded the popular community site SQL-Server-Performance.com, which he operated from 2000 through 2006, and is the author or co-author of more than 15 technical books and over 275 published articles. He blogs at www.bradmcgehee.com.
Contact: http://www.aaronlowe.net
Aaron has over 14 years of SQL Server experience. He is strong in database design development, also having extensive experience in SSIS, SSRS, and administration, including performance, migrations and replication. Aaron is a MCITP in 2005 and 2008 as well as having a Masters in Information Systems Management. He is currently co-president of the Chicago SQLPASS Chapter and founder of SQLFriends.org. When he’s not working, he’s spending time with his bride, 5 children and 2 dogs.
Contact: http://thesqlagentman.com
Tim Ford is a Microsoft SQL Server MVP and co-founder of SQL Cruise (sqlcruise.com). He is currently a Senior DBA and the SQL Server SME with Spectrum Health, a major healthcare system located in West Michigan. He is the leader of the West Michigan SQL Server Users Group (westmisql.org) and is a community speaker and author. His book with Louis Davidson: Performance Tuning With SQL Server Dynamic Management Views is now widely available.
LinkedIn: https://www.linkedin.com/in/sqlvariant
Contact: http://sqlvariant.com/
Aaron Nelson is an author, public speaker, blogger, and leader in the community. He has over 15 years of experience in architecture, Business Intelligence, development, and performance tuning of SQL Server. Aaron has received many certifications and is a six time winner of the Microsoft MVP Award. Aaron leads the PowerShell Virtual Group of PASS (SQLPS.io), is a board member of PowerShell.org, and is a volunteer at his PASS Local Group, AtlantaMDF.
Contact: http://brentozar.com
Jeremiah sees the magic in technology. He knows how to do things now, and he also knows how to think about possibilities. Jeremiah likes to imagine new kinds of indexes, new kinds of teams, new kinds of applications — this means when you need to reinvent something, or get unblocked, you should talk to Jeremiah.
Contact: http://feeds2.feedburner.com/StrateSql
Jason Strate, Digineer Inc, is a database architect and administrator with over 12 years of experience. In July 2009, he was awarded Microsoft MVP (Most Valuable Professional) for SQL Server. Jason is a SQL Server MCITP and participated in the development of Microsoft Certification exams for SQL Server 2008. He is actively involved with MN PASS chapter and is currently serving as the Program Director. Jason enjoys speaking and has presented for SSWUG, PASSMN, and at the PASS Summit.
Contact: http://www.aaronlowe.net
Aaron has over 14 years of SQL Server experience. He is strong in database design development, also having extensive experience in SSIS, SSRS, and administration, including performance, migrations and replication. Aaron is a MCITP in 2005 and 2008 as well as having a Masters in Information Systems Management. He is currently co-president of the Chicago SQLPASS Chapter and founder of SQLFriends.org. When he’s not working, he’s spending time with his bride, 5 children and 2 dogs.
LinkedIn: http://www.linkedin.com/in/jdsegarra
Contact: http://sqlchicken.com
Jorge Segarra is a senior consultant for Microsoft (Premier Support for Developers) and a former SQL Server MVP. Jorge has co-authored titles including "SQL 2008 Pro Policy-Based Management" and "SQL Server 2012 Bible" .
Contact: http://thesqlagentman.com
Tim Ford is a Microsoft SQL Server MVP and co-founder of SQL Cruise (sqlcruise.com). He is currently a Senior DBA and the SQL Server SME with Spectrum Health, a major healthcare system located in West Michigan. He is the leader of the West Michigan SQL Server Users Group (westmisql.org) and is a community speaker and author. His book with Louis Davidson: Performance Tuning With SQL Server Dynamic Management Views is now widely available.
LinkedIn: https://www.linkedin.com/in/brentozar
Contact: https://www.BrentOzar.com
Brent Ozar loves to make SQL Server faster. He created sp_Blitz and the SQL Server First Responder Kit. He shares what he's learned at BrentOzar.com.
Contact: http://blogs.claritycon.com/blogs/andrew_karcher
As a Senior Database Consultant with Clarity Consulting (http://www.claritycon.com), for over 10 years, Andrew's duties include architecting and developing solutions, for a variety of clients in diverse fields on the Microsoft platform including SQL Server, .Net, and Business Intelligence. Andrew is a 3-Time Microsoft MVP for SQL Server. He serves the community in multiple roles including the organizer of SQLSaturday in Orange County.
Contact: http://www.durableimpact.com
Wes is a Senior Consultant with Durable Impact Consulting, a Florida-based data warehouse and business intelligence firm. Wes has over 10 years experience working with clients around the world, both large and small, on their business intelligence and operational needs.
Ross LoForte is a Technology Architect at the Microsoft Technology Center in Chicago focused on SQL Server solutions. With more than 16 years of business development, project management, and SQL architecture solutions experience, he has been working with the Microsoft Technology Centers the past 10 years and has led architecture design and proof-of-concept engagements for Microsoft’s largest and most strategic customers to design enterprise, mission-critical SQL Server solutions.
Contact: http://memydatabaseandi.blogspot.com
Chuck Heinzelman is a Senior DBA. His primary role is database design and development, with some server configuration and administration. He has a BS degree in Management Computer Systems from the Univ of Wisconsin – Whitewater. --Michael Steineke-- is the Vice President of Information Technology for Edgenet – Big Hammer. He has been working with NLBS and Windows Clustering on Windows NT 4 Server through 2008R2, creating clusters with IIS, File System, SQL, ISA, and Hyper-V, including geograph
LinkedIn: https://www.linkedin.com/in/brentozar
Contact: https://www.BrentOzar.com
Brent Ozar loves to make SQL Server faster. He created sp_Blitz and the SQL Server First Responder Kit. He shares what he's learned at BrentOzar.com.
LinkedIn: https://www.linkedin.com/in/wadamjorgensen/
Contact: http://www.pragmaticworks.com
As President of Pragmatic Works Consulting Adam drives market strategy, sales, partnerships, implementation and thought leadership. He has over 15 years of experience helping companies use their data to fuel their growth. Adam has been wowing audiences around the world for over a decade. He has delivered hundreds of sessions, published over a dozen books and hundreds of online videos and webinars on data and cloud topics. His passion is growing companies and mentoring leaders and companies to help them achieve their dreams.
Contact: http://sqlblog.com/blogs/alexander_kuznetsov/default.aspx
Alex Kuznetsov is a database developer with more than a decade of experience. Alex has written a book entitled "Defensive Database Programming with Transact-SQL", and contributed to "MVP Deep Dives" and "The Red Gate Guide to SQL Server Team-based Development". He blogs on sqlblog.com and publishes articles on simple-talk.com and devx.com,.
Contact: http://www.programmersedge.com
Arie Jones 'AJ' is the Principal Technology Manager for Perpetual Technologies, Inc. in Indianapolis, IN. Arie leads PTI’s team of expert consultants in planning, design, development, deployment, and management of database environments and applications to achieve the best combination of tools and services for each client. Additionally, AJ is a community speaker, has written several books such as “Learn SQL in 24 Hours”, and blogs extensively at http://www.programmersedge.com
Contact: http://adventuresinsql.com
IT Professional with 10 years experience, largely in a software development role. Exclusively a DBA for more than 2 years, responsible for support of large e-commerce portal, internal sales application and EDI system supporting more than 40 developers at a large computer solutions provider. Previous industries include healthcare, finance and commercial print. Previous speaking engagements include SQLSaturday #31.
LinkedIn: http://www.linkedin.com/pub/dean-richards/6/167/a90
Dean Richards is a Senior DBA for DBMS Insights and has helped hundreds of companies solve database and virtualization performance issues. Dean has over 20 years of experience in both development and database administration and has focused his entire career on performance tuning of Oracle and SQL Server environments. Most recently Dean has focused on the trend to virtualize and move databases to the cloud.
Contact: http://www.programmersedge.com
Arie Jones 'AJ' is the Principal Technology Manager for Perpetual Technologies, Inc. in Indianapolis, IN. Arie leads PTI’s team of expert consultants in planning, design, development, deployment, and management of database environments and applications to achieve the best combination of tools and services for each client. Additionally, AJ is a community speaker, has written several books such as “Learn SQL in 24 Hours”, and blogs extensively at http://www.programmersedge.com
Contact: http://www.aaronlowe.net
Aaron has over 14 years of SQL Server experience. He is strong in database design development, also having extensive experience in SSIS, SSRS, and administration, including performance, migrations and replication. Aaron is a MCITP in 2005 and 2008 as well as having a Masters in Information Systems Management. He is currently co-president of the Chicago SQLPASS Chapter and founder of SQLFriends.org. When he’s not working, he’s spending time with his bride, 5 children and 2 dogs.
LinkedIn: https://www.linkedin.com/in/trendoid
Contact: http://www.aaronstanleyking.com
Aaron King is a application architect specializing in enterprise web applications and very large databases.
Contact: http://BIVoyage.com
Derek is the founder and a Principal Architect with BI Voyage, a Microsoft Partner specializing in BI solutions (www.bivoyage.com). As a SQL Server MVP and a certified professional in several Microsoft technologies, including SQL Server BI, he speaks at local and national SQL Server user groups and is a published author on SQL Server topics.
The following is a list of sponsors that helped fund the event.