SQLSaturday #333 - St. Louis 2014
Event Date: 10/11/2014 00:00:00
Event Location:
- Saint Louis University’s Center for Workforce Organizational Development (The Wool Center)
- 3545 Lindell Blvd
- St. Louis, Missouri
This event has completed. All data shown below is from the historical XML public data available.
If there are any data quality issues or corrections needed, please contact the webmaster for this site or submit a pull request for the appropriate file(s).
Sessions
This is a list of sessions from the event, based on the schedule in the XML files.
Title: SQL Server 2014 Cardinality Estimator changes
Abstract: This session covers the changes made to Cardinality Estimations and Calculations in SQL Server 2014. SQL Server 2014 introduces the first major redesign of the SQL Server Query Optimizer cardinality estimation process since version 7.0. The goal for the redesign was to improve accuracy, consistency and supportability of key areas within the cardinality estimation process, ultimately affecting average query execution plan quality and associated workload performance. Topics Covered in this session How to enable and disable the new cardinality estimator behavior? What changed in new cardinality estimations? How to troubleshoot plan-quality regressions if and when they occur? Note : Presentation based on recent white paper released from Microsoft.
Speaker(s):
- Sreeni Julakanti
Track and Room: Track 2 - N/A
Title: Designing a Better Database
Abstract: Most everyone knows how to build a table, an index, or a relationship, but the real challenge in database design is the process the data professional uses to interpret the business requirements into database designs which are both flexible and extensible.
In this session, I will NOT tell you the syntax of any database object.
In this session, we will review some of the common challenges we face and some philosophies which will help us to design and deliver better database designs.
Speaker(s):
- Rickey Nunn
Track and Room: Track 3 - N/A
Title: Change Data Capture - What is it and Why I should use it
Abstract: High level overview of Change Data Capture, including what it is, how to configure it and how I can benefit by using it to populate my data warehouse.
Speaker(s):
- Dave Bland
Track and Room: Track 3 - N/A
Title: Partition Management
Abstract: SQL Server table partitioning can improve manageability of large tables, and in some cases performance too. This session will review table partitioning concepts, discuss common partitioning mistakes, and show how to automate partition management tasks using SQL Agent T-SQL jobs.
Speaker(s):
- Dan Guzman
Track and Room: Track 2 - N/A
Title: Data-ing Advice: Profiles are Important
Abstract: Data warehousing professionals often consider data profiling to be drudgery and/or an unnecessary part of the larger warehouse design process. However, information unearthed during this process can prove instrumental in avoiding pitfalls later on. This session will explore the reasons for profiling and scenarios in which it proves particularly useful. We will also discuss profiling methods, including the SSIS profiling task and supplemental profiling techniques that provide both developers and business users insight into the quality and consistency of source data.
Speaker(s):
- Britton Gray
Track and Room: Track 4 - N/A
Title: The Elephant in the Room; A DBA’s Guide to Hadoop Big Data
Abstract: The term “Big Data” has risen to popularity in the last few years, and encompasses data platforms outside of the traditional RDBMS (like SQL Server). The purpose of this session is to introduce SQL Server DBA’s to Hadoop, and to promote understanding of how schema-less data can be collected and accessed in coordination with the traditional SQL models. We’ll cover the basic vocabulary of the Hadoop platform, Microsoft’s integration efforts, and demonstrate how to get started with “big data”.
Speaker(s):
- Stuart Ainsworth
Track and Room: Track 5 - N/A
Title: Big Data Market Overview
Abstract: This session will give you an insider look into what is driving the Big Data market. I’ll relay lessons learned from talking with C-level executives from some of the largest corporations in the midwest as well as talking with guys in the trenches from companies like LinkedIn, Facebook, and Twitter. Everything is changing and this session will help you ride the tide and understand where things are going.
Speaker(s):
- Scott Shaw
Track and Room: Track 5 - N/A
Title: Agile Database Development
Abstract: In this talk Aaron will introduce users to some techniques and tools for developing and maintaining SQL code inside an Agile SDLC. Aaron will use test driven development techniques and commit his code changes to Team Foundation Services and schedule a build. He’ll also demonstrate some custom solutions and go over all of the different databases that a DBA might support in an on-premise TFS install.
Speaker(s):
- Aaron King
Track and Room: Track 4 - N/A
Title: Tabular vs Multidimensional. Lets build it together!
Abstract: This session will be one big demo where we will build both a Tabular and Multidimensional model side by side to contrast and compare the uses of both methods. By the end of this session you should have a good understanding of both modeling methods and how to make use of them in the future.
Speaker(s):
- Lance Kolie
Track and Room: Track 1 - N/A
Title: SSIS Project Deployment Model: Deployment and maintenance
Abstract: In this session, you’ll learn everything you need to know to successfully deliver a modern SSIS solution. We’ll cover the mechanics of deployment; creation, configuration and migration of Environment variables; monitoring execution troubleshooting.
Speaker(s):
- Bill Fellows
Track and Room: Track 4 - N/A
Title: NULL: A Love Story
Abstract: NULL - an unknown value. At least, that’s what it’s SUPPOSED to be. The problem is, NULL is often treated differently based on what you’re doing - even equality is suspect. Join JK as he works on demystifying NULLs in the database, looking at how they interact with various queries and how to work around and with the idiosyncrasies of this sometimes misunderstood concept.
Speaker(s):
- JK Wood
Track and Room: Track 1 - N/A
Title: Bridging The Gap
Abstract: For many who come to T-SQL from other languages, dealing with result sets and thinking in set based solutions can be frustrating. Our minds are conditioned to think in processing rows of data, not entire sets. As a consequence many give up and misuse cursors or come up with other ways to create RBAR (Row By Agonizing Row) solutions. Some others try to deal with sets but get caught in the tangle of nested queries. In this session I will deal with Table Expressions with particular emphasis on CTEs or Common Table Expressions. Let me show you how using these simple tools can help simplify your code, bridging the gap between RBAR and set based solutions.
Speaker(s):
- Larry Toothman
Track and Room: Track 3 - N/A
Title: WIT Panel
Abstract: The definition of confidence is “belief in oneself and one’s powers or abilities” but the authors of the new book “The Confidence Code” define confidence as “the quality that turns thoughts into actions.” Traditionally men have been found to have much more confidence in themselves than do women. For example, in a study at Hewlett-Packard, men applied for a promotion when they thought they could meet 60% of the qualifications while women applied only when they thought they could meet 100%. Attend this WIT session to learn more about confidence and how it impacts your career and life. To prepare for the session, it is recommended that you complete The Confidence Quiz (http://theconfidencecode.com/confidence-quiz/)
Speaker(s):
- Kathi Kellenberger
Track and Room: Track 5 - N/A
Title: Understanding SQL Server XML Features
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
Track and Room: Track 5 - N/A
Title: T-SQL Window Function Performance
Abstract: Window functions were first introduced with SQL Server 2005 and enhanced with SQL Server 2012. They enable easy development and great performance…well, sometimes. Learn what you need to know to take full advantage of these features. What you don’t know can hurt you when you are using window functions.
Speaker(s):
- Kathi Kellenberger
Track and Room: Track 1 - N/A
Title: Reporting for SQL Server Health
Abstract: Many of us make our living writing reports for other people; it is time SQL server Professionals take advantage of reporting. You will walk away from this session with 40 or more reports designed to review an SQL Server system for its health and to predict potential problems.
Speaker(s):
- Dennis Graham
Track and Room: Track 3 - N/A
Title: Locks, Blocks, and Deadlocks Oh My!
Abstract: Managing concurrency is one of the most challenging aspects of working with any enterprise DBMS. There is much confusion out there about locking, blocking, and deadlocks. In this demo heavy session we will clear up the confusion.
Speaker(s):
- Randy Knight
Track and Room: Track 2 - N/A
Title: Violin Memory - Presentation
Abstract: Violin Memory - Presentation
Speaker(s):
- Dennis Graham
Track and Room: Track 3 - N/A
Title: Introduction to FileTables in SQL 2012
Abstract: What are FileTables? How do they work? What are their limitations? These questions and more will be answered in this demo filled presentation. We will walkthrough the configuration and implementation of this feature. We will show you some use cases on how this functionality can help you manage your data in whatever forms it exists.
Speaker(s):
- Warren Sifre
Track and Room: Track 4 - N/A
Title: Hive - Interactive SQL Querying for Hadoop
Abstract: This session will go into details around the Hive framework and how interactive SQL querying can be accomplished on a distributed file system. The session has a live demo showing the key features and will also discuss future enhancements. Is Hive a SQL Server killer? Let’s find out.
Speaker(s):
- Scott Shaw
Track and Room: Track 5 - N/A
Title: Transforming Data using the T-SQL PIVOT / UNPIVOT operators
Abstract: Ever wish your horizontal data were vertical for easier data storage, or vice-versa for reporting purposes? Are you writing elaborate routines to transform between them for one-time usage? Are your queries repeating “OUTER JOIN” or “UNION” so often that you wind up back in Kansas when your read them aloud? Join Jeff Foushee as he explains SQL Server’s lesser-known PIVOT and UNPIVOT operators using SQL 2014. After this session, you will no longer need to rotate your monitor!
Speaker(s):
- Jeff Foushee
Track and Room: Track 2 - N/A
Speakers
This is a list of speakers from the XML Guidebook records. The details and URLs were valid at the time of the event.
Scott Shaw
Twitter: - @shawsql
LinkedIn: Scott Shaw
Contact: http://www.dbaexperience.com
Scott Shaw has over a decade of experience in data management. He is a frequent speaker at local and national community events and has co-authored two books on T-SQL. He teaches as well as implements Pig, Hive, Hadoop, as well as teaches courses on SQL Server, and Microsoft BI. He is currently working on a book titled quot;Practical Hive” to be published by Apress publishing. He lives in St. Louis and is a Sr. Solutions Engineer for Hortonworks.
Dave Bland
Twitter: - @SQLDave29
LinkedIn: Dave Bland
Contact: https://www.davebland.com
Over 20 years of SQL Server experience that includes being a DBA, BI development and Application development using VB.NET. Dave currently is the Manager of the DBA team at Stericycle. Dave is a Friend of Red-Gate for 2019. He is a frequent presenter at SQLSaturday events and user groups around the country. Has been teaching SQL Server since version 2000 and is the SQL Server instructor at Harper College in Palatine, IL. Current certifications include: • Microsoft Certified Trainer • MCTS: SQL Server 2008, Implementation and Maintenance • MCTS: SQL Server 2008, BI Development and Maintenance • MCSA: SQL Server 2008 • MCSA: SQL Server 2016 • MCSE: SQL Server 2016 - BI • MCDBA: SQL Server 2000 • MCSD • MCSE: Data Management and Analytics
JK Wood
Contact: http://www.sqlslacker.net
JK Wood is a Data Warehouse developer with three years of experience working with SQL Server and has worked and played with computers since the mid nineties. He is passionate about helping people to move beyond just writing code to writing beautiful, functional, and above all maintainable software. JK is an active member of the SQL community. He is involved with the Southwest Missouri SQL Server User Group and blogs at http://www.sqlslacker.net
Aaron King
Twitter: - trendoid
LinkedIn: Aaron King
Contact: http://www.aaronstanleyking.com
Aaron King is a application architect specializing in enterprise web applications and very large databases.
Warren Sifre
Twitter: - WAS_SQL
LinkedIn: Warren Sifre
Contact: http://www.broadstrokeconsulting.com/blog/, http://www.allegient.com
Warren Sifre has been in the IT community since 1998 and has worked in a variety of industries deploying solutions utilizing MS SQL Server in one capacity or another. In 2003, he decided to make SQL Server his mastery and has since developed skills in most defined disciplines of MS SQL. Currently he is a Principal Consultant and Technology Leader with Moser Consulting. He is responsible for BI Solution Architecture and the mentorship of team members. He has been a SQLSaturday Speaker since 2012, Azure Global Bootcamp, and many user groups in 2015 alone. He has a passion for knowledge transfer and solutions architecture, with a keen interested in Info Security.
Dennis Graham
Dennis Graham has been working with SQL server since 1992 and working in SSRS since 2002. As an Oakwood consultant, he has built applications for investment firms, medical groups, insurance entities, and manufacturing, he is now in the Managed Services Group using SCOM to monitor SQL Server. He also has 16 years as a trainer.
Rickey Nunn
I have worked in IT for twenty-five years. I have had job responsibilities over the years which have progressively increased my technical skills and involved me in all parts of the development life cycle. For the last five years, working for Scottrade, Inc. I have responsibly for database design and architecture. I have been involved in small and large projects on a half dozen platforms over my career and have experience with what works and what does not.
Kathi Kellenberger
Twitter: - auntkathi
LinkedIn: Kathi Kellenberger
Contact: http://auntkathisql.com
Kathi Kellenberger is the editor of Simple Talk at Redgate and a Data Platform MVP. She has worked with SQL Server for over 20 years and has authored, co-authored, or tech edited over a dozen technical books. Kathi is the co-leader of the PASS Women in Technology Virtual Group and a volunteer at LaunchCode. When Kathi isn’t working, she enjoys spending time with family and friends, cycling, singing, and climbing the stairs of tall buildings. Be sure to check out her courses on Pluralsight.
Britton Gray
Twitter: - IDreamInSQL
LinkedIn: Britton Gray
Britton Gray is a veteran of database development, data management, business intelligence, analytics, and data privacy in BI. He has successfully completed projects in a variety of technologies in different technology stacks. Coming from a family full of teachers, he thoroughly enjoys the opportunity to share knowledge and insights; it’s an extension of “getting the right information to the right people at the right time” mantra of BI. He lives near Indianapolis, Indiana, and is the Director of BI for Project Lead The Way, a nonprofit organization providing transformative learning experiences in computer science, engineering, and biomedical sciences.
Randy Knight
Twitter: - randy_knight
LinkedIn: Randy Knight
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.
Larry Toothman
Contact: http://IowaTechBear.com
Larry has been a Database Administrator for a non-profit health system in Cedar Rapids, IA since late 2007. With over 20 years of software and database development experience, he was drafted to be the DBA in 1999 for a dev company. Amazed by the wide variety of people in the SQL Server community as well as the support from the “SQL Family” Larry is always looking for opportunities to pay it forward, spread the word mentoring.
Scott Shaw
Twitter: - @shawsql
LinkedIn: Scott Shaw
Contact: http://www.dbaexperience.com
Scott Shaw has over a decade of experience in data management. He is a frequent speaker at local and national community events and has co-authored two books on T-SQL. He teaches as well as implements Pig, Hive, Hadoop, as well as teaches courses on SQL Server, and Microsoft BI. He is currently working on a book titled quot;Practical Hive” to be published by Apress publishing. He lives in St. Louis and is a Sr. Solutions Engineer for Hortonworks.
Dennis Graham
Dennis Graham has been working with SQL server since 1992 and working in SSRS since 2002. As an Oakwood consultant, he has built applications for investment firms, medical groups, insurance entities, and manufacturing, he is now in the Managed Services Group using SCOM to monitor SQL Server. He also has 16 years as a trainer.
Dan Guzman
Twitter: - guzmanda
Contact: http://www.dbdelta.com
Dan Guzman has been using Microsoft SQL Server since version 4.21 was introduced on the Windows Server platform and has 30 years of experience in Database Administrator, Developer, and Architect roles.
Jeff Foushee
Jeff Foushee has his MCITP certification in both SQL Server and Windows Server. He is also an Enterprise DBA at Louisville-based Humana, Inc., where he supports almost 20,000 databases on 1,800 SQL Servers. His latest endeavor has been around building a warehouse/website in C#/MVC to automate many database-related processes.
Randy Knight
Twitter: - randy_knight
LinkedIn: Randy Knight
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.
Sreeni Julakanti
Sreeni Julakanti is an Enterprise DBA at Humana, Inc., currently working in an Architect role while supporting over 16,000 databases on 1,500 different SQL Servers. He primarily works on troubleshooting performance Issues and fine tuning various database designs and processes. Sreeni holds an MCITP certification in SQL Server and is an active member of the Louisville SQL Users Group, participating in monthly meetings and also participates and presents topic in SQLSaturday.
Kathi Kellenberger
Twitter: - auntkathi
LinkedIn: Kathi Kellenberger
Contact: http://auntkathisql.com
Kathi Kellenberger is the editor of Simple Talk at Redgate and a Data Platform MVP. She has worked with SQL Server for over 20 years and has authored, co-authored, or tech edited over a dozen technical books. Kathi is the co-leader of the PASS Women in Technology Virtual Group and a volunteer at LaunchCode. When Kathi isn’t working, she enjoys spending time with family and friends, cycling, singing, and climbing the stairs of tall buildings. Be sure to check out her courses on Pluralsight.
Stuart Ainsworth
Twitter: - @codegumbo
LinkedIn: Stuart Ainsworth
Contact: http://codegumbo.com
Stuart Ainsworth (MA, MEd) manages a team of Service Reliability Engineers for the Gladiator Enterprise Information Security Services section of Profitstars, a division of Jack Henry and Associates. He’s a former DBA, developer, consultant, and public speaking professor. He’s one of the chapter leaders for AtlantaMDF, and a long-time organizer of SQLSaturday’s. He tweets infrequently (@codegumbo) and blogs even less often at http://codegumbo.com.
Bill Fellows
Twitter: - @billinkc
LinkedIn: Bill Fellows
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.
Lance Kolie
I’m an Independent Business Intelligence Architect / Senior SQL Server DBA at Opportune Tech with 15+ years of professional experience building solutions on the Microsoft platform. My professional experience covers a wide range of industries from marketing, transportation, non-profit, telecom and technology. I enjoy supporting local SQL user groups, sharing knowledge and mentoring.
Sponsors
The following is a list of sponsors that helped fund the event: