Event Location:
Cerner Corporation's Riverport Campus
6711 NE Birmingham Rd
Kansas City, Missouri
Abstract:
An entry level session regarding SQL Server statistics and the importance of their accuracy. The presentation will cover basic principles around what statistics are, how they are generated, and how the optimizer utilizes them (Cardinality Estimation). Will cover at a high level and provide examples regarding the histogram, string stats, and density in relation to their function in the estimation process. Will provide scenarios on how out of date stats can generate a bad plan and maintenance principals that can be applied to avoid bad plan generation. Finally, will provide a free set of code to automatically determine out of proportion stats for every database in a set of registered instances.
Speaker(s): Travis Whitley,
Abstract:
By now you have probably already heard about Analysis Services. Maybe you've even said to yourself that you were going to learn more about it but just haven't found the time. The biggest barrier to learning something new is figuring out the first few steps. But where do you begin? Come learn those first few steps by attending this presentation. We will discuss what Analysis Services is, where it shines and more importantly, how to get started.
Speaker(s): Marc Beacom,
Abstract:
Writing MDX can be a little intimidating and so most people that have to create an SSRS report against a cube will use the Query Designer. However, there are advantages to being able to write and craft your own MDX. This session will walk the audience through writing MDX in Reporting Services versus using the Query Designer. During the session we will point out the good and the bad of each approach.
Speaker(s): Frank Kearney,
Abstract:
In this session we will discuss the fundamentals behind data warehousing and the ways to use SQL Server and SSIS to build and populate a datawarehouse.
Speaker(s): Wes Dumey,
Abstract:
Ladies and gentlemen, boys and girls, data professionals of ALL ages, we welcome you to learn the basics of query plans and their operators. This presentation will not only cure you of mental aches caused by the mysteries of estimated and actual row counts, but will also part the misty veil of physical join operators and aggregates. When you leave this room, you will have the fundamental understanding of the language of query plans so that you can begin the wondrous process of query tuning.
Speaker(s): Michael Fal,
Abstract:
Many of our customers are either virtualizing databases or planning to do so soon. I hear from many groups that attempted running their database on VMware but went back to physical hardware because of performance issues. There are many reasons this may have happened, but quite often the decision to go back to physical was not based on hard facts. This presentation will explore the fundamentals of monitoring databases running in a VMware environment. If you are using classic O/S monitoring tools, you may be getting misleading data. Understand what metrics are important and how to get to that data.
Speaker(s): Kathy Gibbs,
Abstract:
In this session we will look at how Powershell can be used to monitor system performance counters in an effort to build that ever important server baseline.
Speaker(s): Mike Lynn,
Abstract:
Do you find yourself always putting out "fires"? Can't take the heat in the data center? Then come learn about some things that you can do to help you do "fire prevention" instead of "fire fighting". We will look at several things that you can take back to your shop and implement ranging from code tuning, backup maintenance, monitoring and performance tuning!
Speaker(s): John Morehouse,
Abstract:
Do you work by yourself each day and wonder what other SQL Server DBA's are doing? Have you ever come across a question and wished that you could ask a Microsoft employee or MVP but didn't know how? Do you read SQL Server Magazine every month and find yourself thinking, there must be more information out there? Do you hear people talk about tweets and blogs and wonder what they're talking about, or stick your nose in the air and think - "that's not important"? Let me show you how useful the various online knowledge and social networking tools can be to the beginner as well as to the expert DBA.
Speaker(s): Andy Galbraith,
Abstract:
A comparison of SQL HA DR options, by a practitioner who has implemented managed all the current SQL HA and DR approaches ( various combinations thereof). Tim is an operational SQL DBA, who keeps SQL servers up running optimized for managed-services customers. We will compare trade-offs between the various SQL HA DR options: for complexity, usability, hardware, licensing, failover speed, initial costs, ongoing support costs, staff skill requirements, etc. And we’ll briefly cover some of the upcoming SQL Denali HA / DR features.
Speaker(s): Tim Plas,
Abstract:
Are you just starting out in the DB world? Are you unsure of things that you should know? Are you a developer wanting to gain further insight on how to improve your SQL Skills? If you answered 'Yes' to any of those question, then this is the session for you! John will be talk about things that he's seen in the trenches that every DBA should know and understand.
Speaker(s): John Morehouse,
Abstract:
When your boss asks you who has access to your databases, do you break out into a cold sweat? Or, instead, are you worried about those other people who might have 'sa' access to your server and might be causing trouble on your server? Either way, as DBAs we need to be able to audit our SQL Server security. This presentation will give you a general overview of the different types of roles that you can use to manage access, what they mean, and how we look at the security gremlins hiding under the covers of our databases.
Speaker(s): Michael Fal,
Abstract:
In this session we will explore Service Broker, one of the lesser known features available since Microsoft SQL Server 2005. This technology provides a robust asynchronous programming model and can be reliably used to develop lightning fast applications that scale very well and can boost your application's throughput. We will look at a few examples of real world service broker implementations in OLTP as well as batch processing modes. We will also discuss some of the commonly used tools for troubleshooting a service broker set up, as well as some few to avoid common pitfalls.
Speaker(s): Sanil Mhatre,
Abstract:
Slow running packages? SSIS consuming all your resources? No idea what it's doing? After attending this session, you will come out with an understanding of how Configuration, Logging, Package settings and deployment work in SQL Server Integration Services. You will also be armed with a list of transformations and perfmon counters to watch out for.
Speaker(s): Bill Fellows,
Abstract:
Getting rid of while loops cursors and other number magic using a Numbers(Tally) table and set-based logic. This is a must have in your database development toolbox.
Speaker(s): John Dempsey,
Abstract:
In this session, we will focus both on the why's of using Service Broker and the how's of actually doing something useful with it. We will also discuss common implementation pitfalls and how to avoid them. Finally, we spend some time covering what you need to know to successfully implement a Service Broker Solution in your Environment.
Speaker(s): Jason Horner,
Abstract:
This sessions intends to give the participant a quick but thorough overview of key explain plan components. We'll go through a step-by-step interpretation of explain plans and look at how we can use them to determine whether or not we've made our queries as efficient as possible. The presentation is geared for open discussion and participation.
Speaker(s): Scott Shaw,
Abstract:
Join Carlos Bossy, Marc Beacom and Jason Horner for an amazing roundtable discussion on all things BI. This will be an open forum to ask the experts your burning questions on the MS Business Intelligence stack. - How do I get started? - What are best practices? - How do I model this?
Speaker(s): Carlos Bossy,
Abstract:
Indexes make queries run faster, right? Not always, no. And finding the right indexes for your needs is often more of an Art than a Science. Attend this session as we take a visual tour of how indexes are laid out and the way data is accessed when indexes are utilized. We will discuss clustered indexes as well as non-clustered indexes and also when to use indexed views along with some other variations.
Speaker(s): Wendy Pastrick,
Abstract:
The XML Functionality embedded into SQL Server 2005 and 2008 is one of its most powerful yet least understood features. This seems to be primarily because DBA's shy away from it and developers prefer to work with XML in their code. In this session we will explore the XML features of SQL Server and how we can bridge these two worlds. Topics covered will include retrieving relational data as XML, storing XML in the database using the XML Datatype, XML indexes, and the XQuery functions included in SQL Server. We will also look at using XML as stored procedure parameters as a way to pass large amounts of complex data between client and server.
Speaker(s): Randy Knight,
Abstract:
I am a database developer/dba like you and love using SSMS (SQL Server Management Studio) just like you. But, since using the Visual Studio Database Edition tools, I am now a convert. Visual Studio 2010 is the most recent released version of the database toolset and continues to greatly improve things providing database developers with the great tools that other developers have had for years. We will cover deploying databases from VS 2010, Configuration Manager, handling Reference data, Pre Post Deployment scripts, and touch on refactoring. Come be converted =).
Speaker(s): John Dempsey,
Abstract:
If you've ever found yourself stating the above, this session is for you. For many developers, writing T-SQL that works is not the challenge. But too often, functional T-SQL is not the same as good T-SQL. In this session, we will examine why "SQL that works" is not good enough. Understanding indexes, exectuion plans, sargability, and more are all critical to writing good T-SQL. We will also examine several real-world examples of T-SQL that "worked great in dev" but caused major issues when it hit production.
Speaker(s): Randy Knight,
Abstract:
This session is all about SQL Server user-defined aggregate functions. We'll start with why you may want to use one even when alternative methods exist to get the same results. Then we'll walk through a simple yet useful example of creating an aggregate function, from start to finish. We'll create the .dll file in Visual Studio, enable the CLR in SSMS, import the aggregate and then put it to use. Along the way we'll cover some of the error messages you may receive, what they mean, and how to correct them. Come see what has been missing in your life without user-defined aggregate functions.
Speaker(s): Arlin Mast,
Abstract:
Lessons Learned - Enterprise Data Management with SQL Server
Speaker(s): Ilona Shulman,
Abstract:
SQL Injection and Cross-Site Scripting (XSS) are frequently listed as the two top web site vulnerabilities being exploited by hackers. In this session you will learn exactly what these exploits are, see how hackers use tools to automate this hacking, and most importantly, learn the steps you can take to minimize the risk of falling victim to these exploits.
Speaker(s): Rob Kraft,
Abstract:
BACKUP and RESTORE are among the most important commands for DBAs, and you don't want to learn them under fire. In just one hour, we'll take a detailed look at exactly how they work and show options you can't get in Management Studio. We'll also cover why you don't have the same capabilities in all recovery models. Once armed with this knowledge, you'll understand best practices for backup strategies, testing restores, and saving your job.
Speaker(s): Bob Pusateri,
Abstract:
This session is a revision of my SQLRally presentation in Orlando, FL. It details the trials and tribulation of a being a DBA in a large (+200 SQL Server) environment. I'll discuss management strategies, corporate policies and politics, and technical challenges. If you are a SQL Server team lead, ever want to be a SQL Server team lead, or just want to know what your team lead might be thinking then join me for a great rant and raving discussion.
Speaker(s): Scott Shaw,
Abstract:
This session will focus on how you can write faster queries. It’s based on all the different “interesting” approaches I’ve seen and fixed as a consultant. It will cover indexing and how to use indexes efficiently, writing efficient WHERE clauses, handling dynamic SQL in reports, tips and tricks to avoid table scans, reducing query compiles and a dozen other approaches to improve the response time of your applications.
Speaker(s): Bill Graziano,
Abstract:
SQL Server's data compression feature can be a great tool for both getting more bang out of your storage dollar and increasing query performance. In this session we'll cover the different types of data compression, the nitty-gritty behind how they work, and how to make sure you're getting the most out of them.
Speaker(s): Bob Pusateri,
This is a list of speakers from the XML Guidebook records. The details and URLs were valid at the time of the event.
LinkedIn: http://www.linkedin.com/in/billinkc
Contact: http://blog.billfellows.net
Bill Fellows is a SQL Server MVP and has been a database developer for most of his career, with the past 15 years focused on ETL. He is the organizer of Kansas City's eight SQLSaturdays and a speaker at many other SQLSaturdays, User Groups and the PASS Summit. Bill is the owner of Sterling Data Consulting where he gets to solve interesting data problems.
Contact: http://www.dbaconsortium.com
Scott Shaw has been an IT professional since the late 90’s and has expertise as both an Oracle DBA and a SQL Server DBA. He is currently employed by Mercy in Saint Louis, MO as the Lead SQL Server DBA. Scott has presented at SQLSaturday #53 (KC) as well as the first SQLRally in Orlando, FL. He currently is working with Kathi Kellenberger (@auntkathi) to revise her book T-SQL Beginning T-SQL 2008 from Apress Publishing for SQL 2011.
LinkedIn: https://www.linkedin.com/in/robkraft?
Contact: http://csharpdeveloper.wordpress.com
Rob Kraft is an independent software architect, project manager, and developer from Lee#39;s Summit, MO. He was a certified trainer on SQL Server and co-authored a few books about SQL Server and network security. He has been a full or part-time SQL Server DBA since version 4.2. He runs www.KansasCityUserGroups.com and he blogs occasionally at http://csharpdeveloper.wordpress.com/.
Arlin Mast is the owner and principal consultant of ARM Software Consulting, LLC. Arlin has been developing software professionally since 1994, and established ARM Software Consulting, LLC in 2005. Arlin specializes in Windows database application development and custom reporting solutions using C# and SQL Server.
Contact: http://www.dbaconsortium.com
Scott Shaw has been an IT professional since the late 90’s and has expertise as both an Oracle DBA and a SQL Server DBA. He is currently employed by Mercy in Saint Louis, MO as the Lead SQL Server DBA. Scott has presented at SQLSaturday #53 (KC) as well as the first SQLRally in Orlando, FL. He currently is working with Kathi Kellenberger (@auntkathi) to revise her book T-SQL Beginning T-SQL 2008 from Apress Publishing for SQL 2011.
LinkedIn: http://www.linkedin.com/in/randyknight
Contact: http://www.sqlsolutionsgroup.com/blog
Randy Knight is a data professional who has worked with Microsoft technology for over 25 years, focusing on SQL Server since 1997. He has worked in a variety of settings, including 6 years as a database architect for match.com. In 2010, he founded SQL Server Solutions Group LLC, a boutique SQL Server consultancy. A Microsoft Certified Master (MCM) in SQL Server, he speaks often at events all over the country including the PASS Summit, SQLIntersections, and numerous SQLSaturday and User Groups.
John Dempsey started his IT career in 1999 as an application developer on web development projects . After a brief hiatus to pursue a dream in law enforcement, he has returned with a renewed passion for the IT field. This passion has been focused on all things databases, specifically Microsoft SQL Server for the last 6 years. He has spoken in the past and is an active member with the St. Louis SQL Server User Group.
Mike started his career as .Net application developer but quickly turned to the brighter side and started focusing on Microsoft SQL Server. During his 6 years in the IT industry not one has gone by where he hasn't been focused on SQL Server. Currently he is a Database Consultant for CCA Global Partners in St. Louis, MO and participates in the St. Louis SQL Server User Group.
Contact: http://whitleysql.wordpress.com
Travis is a Senior SQL Server Consultant at Oakwood Systems Group in St. Louis, with a focus on performance tuning and troubleshooting both OLTP and OLAP environments. He's been working with SQL Server since version 6.5, and also has 8 years of experience as a production SQL Server DBA and developer in the healthcare, finance, retail, and manufacturing industries.
LinkedIn: http://www.linkedin.com/in/bobpusateri
Contact: http://www.BobPusateri.com
Bob Pusateri is a Microsoft Certified Master, DBA, and systems architect with over 10 years of experience on SQL Server. His interests involve internals, performance optimization, and cloud technologies. He is an active member of two Chicago-area PASS Local Groups, a community speaker, and maintains a web presence through both Twitter (@SQLBob) and his blog (bobpusateri.com).
LinkedIn: https://www.linkedin.com/in/tplas
Tim is a Principal Consultant at Virteva, in Mpls MN. His current focus areas are cloud architecture / engineering / migration, operational-DBA services (esp. HA/DR), server migrations, server virtualization, and storage. His experience over the past 25+ years has been primarily with server / data-center infrastructure, including being CTO / co-founder of a successful hosting company. Tim has held a variety of MS certifications since 1994.
LinkedIn: https://www.linkedin.com/in/michaelfal/
Contact: http://mikefal.net
Mike is a specialist in data management technologies. As a community advocate, public speaker, and blogger, Mike is a practicing thought leader for data and automation. He is passionate about DevOps and data, building platforms to optimize, protect, and use data efficiently. Since 1999, Mike has been working in the database field, focusing primarily on SQL Server and specializes in automating data solutions to improve the reliability and efficiency of his environments. He has been caught playing trombone in public on more than one occasion.
LinkedIn: http://www.linkedin.com/pub/andy-galbraith/5/149/98b
Contact: http://nebraskasql.blogspot.com/
I’m a forty-something Microsoft SQL Server DBA of 18+ years, a devoted husband, and a father of three young boys (all aged eight and under!) I have been a DBA at a public university, at a major bank, at a healthcare system, and I now work as a consultant with customers across the United States. I write and speak primarily about the tips and tricks that I discover along my SQL Server journey.
LinkedIn: https://www.linkedin.com/in/sanilmhatre
Contact: http://sqlwithsanil.com
Sanil Mhatre is a Senior Data Engineer, currently focused on delivering Analytical insights for a large Technology solutions Services company in Missouri. He has a Master's degree in Information systems and enjoys working with various Data processing technologies, analytics tools and visualization platforms. Sanil has an interest in Data Science, is an active member of PASS and a frequent speaker at technical conferences and user groups. He volunteers with STEM mentorship programs, blogs and loves to keep up with developments in the fields of Machine Learning AI. When Sanil isn't working he enjoys spending time with family and friends, tasting craft beer and hiking with his dogs.
Contact: http://scalsql.com/
Bill Graziano is a SQL Server consultant specializing in high-throughput transaction environments using SQL Server. He spends his days counting the milliseconds behind credit card swipes. Bill is the former President of PASS and runs a web site for SQL Server developers and administrators at SQLTeam.com.
John Dempsey started his IT career in 1999 as an application developer on web development projects . After a brief hiatus to pursue a dream in law enforcement, he has returned with a renewed passion for the IT field. This passion has been focused on all things databases, specifically Microsoft SQL Server for the last 6 years. He has spoken in the past and is an active member with the St. Louis SQL Server User Group.
LinkedIn: https://www.linkedin.com/in/michaelfal/
Contact: http://mikefal.net
Mike is a specialist in data management technologies. As a community advocate, public speaker, and blogger, Mike is a practicing thought leader for data and automation. He is passionate about DevOps and data, building platforms to optimize, protect, and use data efficiently. Since 1999, Mike has been working in the database field, focusing primarily on SQL Server and specializes in automating data solutions to improve the reliability and efficiency of his environments. He has been caught playing trombone in public on more than one occasion.
Ilona Shulman is a Technical Architect for Analytics with Ameren - a utilities company in Illinois and Missouri. She served as a solution architect on multiple data warehousing and BI projects for IBM, US Government, USBank, and many others. She has an in-depth knowledge of not only Microsoft, but also many other BI vendors and offerings.
Contact: http://wendyverse.blogspot.com
Wendy Pastrick is from Chicago, IL, and for the past 15 years has served as a Database Administrator supporting both development and production environments. Her many years of involvement with PASS include WIT Virtual Chapter and the Chicago Suburban User Group, serving as Regional Mentor, and as a PASS Board member since 2013. Wendy has organized several highly successful SQLSaturday events in Chicago.
Contact: http://dawabi.com/blog.aspx
Marc Beacom is President of DawaBI, a Data Warehouse and Business Intelligence Consultancy firm focusing on Making Data-Driven Decisions Possible. He has been working with SQL Server for over a decade delivering scalable solutions for organizations of all sizes. He has earned several industry certifications and degrees. Marc is an active member of the community and has volunteered for many organizations such as PASS, Denver SQL, Colorado GiveCamp, Camp To Belong, to name a few.
LinkedIn: http://www.linkedin.com/in/jasonhorner
Contact: http://blog.jasonhorner.com
Hi, my name is Jason I'm a practice lead at Redapt. I spend most of my day helping clients solve business problems mostly in the Data and Advanced Analytics spaces. Sometimes this involves various and sundry cloud technologies including Azure Data Factory, Azure SQL Data Warehouse, Azure Data Lake Store, Azure Databricks, HDInsight and Azure SQL Database. I'm fluent in several languages including: SQL, C#, Python, and PowerShell. I'm a Microsoft Certified Master of SQL Server (MCM) and have been recognized for my technical excellence and evangelism efforts by Microsoft by being awarded the Most Valuable Professional (MVP) for the last 5+ years. In my off hours I like to snowboard, karaoke, ride roller coasters, and play arcade games
LinkedIn: http://www.linkedin.com/in/randyknight
Contact: http://www.sqlsolutionsgroup.com/blog
Randy Knight is a data professional who has worked with Microsoft technology for over 25 years, focusing on SQL Server since 1997. He has worked in a variety of settings, including 6 years as a database architect for match.com. In 2010, he founded SQL Server Solutions Group LLC, a boutique SQL Server consultancy. A Microsoft Certified Master (MCM) in SQL Server, he speaks often at events all over the country including the PASS Summit, SQLIntersections, and numerous SQLSaturday and User Groups.
Contact: http://www.durableimpact.com
Wes Dumey is a Senior Consultant for Durable Impact Systems, a Florida-based provider of business intelligence solutions. Wes has experience working with many Fortune 500 clients. Wes grew up in Missouri and is a Cheif's fan, even when it's difficult to be one. He enjoys flying airplanes and traveling helping executives solve business issues through the use of business intelligence.
Contact: http://frankkearney.wordpress.com/
I will be the first one to tell you that I drink the Microsoft cool aid and I carry my soapbox around with me. I have been working in the business intelligence field for over 12 years and specializing in the Microsoft BI stack for the past 10 years. Currently I am the Manager of Business Intelligence for a global manufacturing company CSM. Prior to coming to CSM, I worked for Hostess (Interstate Brands), Sprint and McKesson Corp.
LinkedIn: http://www.linkedin/in/carlosbossy
Contact: http://www.carlosbossy.com
Carlos Bossy (MCTS, MCP BI, CBIP) is a data and cloud analytics architect with 25 years of experience in software and database development. As a principal of Datalere, Carlos focuses on developing BI, Data Science, and Advanced Analytics solutions, including modeling data warehouses and delivering predictive models, integration, and visualization. He has developed warehouses and BI solutions for a variety of industries and state agencies, including health insurance, solar energy, foster care, telecom, and manufacturing.
Contact: http://sqlrus.com
John Morehouse is currently a Database Architect/Engineer with Farm Credit Services of America in Omaha, Nebraska. He is one of the leaders of the Omaha SQL/BI User group and and a frequent speaker at SQLSaturday's as well as other conferences. In his spare time, you can find John running after one of his two sons or working on his 113 year old house.
LinkedIn: http://www.linkedin.com/in/bobpusateri
Contact: http://www.BobPusateri.com
Bob Pusateri is a Microsoft Certified Master, DBA, and systems architect with over 10 years of experience on SQL Server. His interests involve internals, performance optimization, and cloud technologies. He is an active member of two Chicago-area PASS Local Groups, a community speaker, and maintains a web presence through both Twitter (@SQLBob) and his blog (bobpusateri.com).
Contact: http://sqlrus.com
John Morehouse is currently a Database Architect/Engineer with Farm Credit Services of America in Omaha, Nebraska. He is one of the leaders of the Omaha SQL/BI User group and and a frequent speaker at SQLSaturday's as well as other conferences. In his spare time, you can find John running after one of his two sons or working on his 113 year old house.
LinkedIn: http://www.linkedin.com/pub/kathy-gibbs/a/6a8/680/
Kathy has over 19 years of IT work experience and over 13 years of DBA experience including architecting, design, development, implementation, monitoring, and disaster recovery of databases. Before starting with Confio, Kathy worked in the financial, retail, and telecom industries working with critical OLTP and OLAP databases. Kathy excels in being a liaison between technical and the end-users or management teams to provide solutions
The following is a list of sponsors that helped fund the event.