SQLSaturday #84 - Kalamazoo 2011
Event Date: 09/17/2011 00:00:00
Event Location:
- Kalamazoo Valley Community College
- 6767 West O Avenue
- Kalamazoo, Michigan
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: Devs are from Mars, Report Servers are from Venus
Abstract: Do you remember what it was like to fall in love? Wasn’t it wonderful?
Lately it just hasn’t been the same. You’ve been stuck in the same old routine, doing the same old charts and tables. Maybe Reporting Services doesn’t tell you what’s wrong. Maybe you’re even thinking about seeing other reporting products. Maybe you and RS just weren’t meant to be together.
In this session, Doug will re-ignite your passion for RS by showing you how to design for better performance, explaining what RS has been trying to tell you through logs (but you haven’t been listening), and demonstrating some new – and easy – tricks you may not have known RS can do. After this session, you’ll want to spend some time alone with your new old flame.
Speaker(s):
- Doug Lane
Track and Room: Track 5 - N/A
Title: The Tally Table: What it is/how it replaces loops
Abstract: Don’t let the “Intermediate” rating scare you “Beginners” away. This “Black Arts” session is for anyone that uses T-SQL. There are dozens of things we do in SQL that require some type of iteration. “Iteration” means “counters” and “loops” to most people and recursion to others. To those well versed in the techniques of “Set-based” programming, it means some form of a “Numbers” or “Tally” Table, instead. SQL Server MVP Jeff Moden takes the mystery out of how this wonderfully compact tool works and how it easily replaces many types of loops. This session has been updated to include additional information about what “Pseudo-Cursors” are and how they work as well discovering why “Recursive CTE’s” can be your worst enemy.
Speaker(s):
- Jeff Moden
Track and Room: Forum Room - N/A
Title: You’re My Density: Making Sense of Statistics
Abstract: The Query Optimizer uses statistics to decide how to execute a query. If statistics are out of date, improperly sampled or simply don’t exist, then you could unintentionally deceive the Optimizer. Accurate statistics can help avoid poor query plans, so if you’re not familiar with how to read a histogram, the various options for updating statistics or want to know why sample size does matter, this session is for you! We will also delve into what happens when a value doesn’t exist in a statistic, discuss methods to manage statistics for volatile tables and examine the challenges that exist with statistics on partitioned tables. Expect a session filled with demos and real-world examples that will create a foundation of statistics knowledge.
Speaker(s):
- Erin Stellato
Track and Room: Track 3 - N/A
Title: Cross Tabs Pivots: Converting Rows into Columns
Abstract: Don’t let the “Intermediate” rating scare you “Beginners” away. This “Black Arts” session is for anyone that uses T-SQL. SQL Server MVP Jeff Moden demonstrates and explains simple methods for converting gobs of “vertical data” into horizontal numeric and textual data by date or other key using Cross Tabs and Pivots. This session includes the “Black Arts” method of “Pre-Aggregation” for incredibly high performance and how to dynamically and automatically produce reports based on a date. The methods learned in this session can be used to provide “dynamically pivoted” result sets to SSRS, Crystal Reports, and other reporting software.
Speaker(s):
- Jeff Moden
Track and Room: Track 3 - N/A
Title: PowerPivot - A cool reporting tool! (
Abstract: The future of BI is self-service reporting and PowerPivot is the conduit to that goal. We will explore how to use the PowerPivot add-in for Excel 2010 to tie different data sources together and deliver analytics.
In this session you will learn how to use PowerPivot (within the familiar interface of Excel) to combine different data sources such as Analysis Services cubes, TSQL queries, Stored Procedures, Excel spreadsheets, flat files and data from the web to create basic PivotTables and PivotCharts in Excel. The data these new spreadsheets overcomes the 1,048,576 row limitation in Excel 2007/2010, contains refreshable data sources and has excellent data compression and lighting fast speed thanks to the utilizati
Speaker(s):
- Scott Schommer
Track and Room: Track 5 - N/A
Title: The Periodic Table of Dynamic Management Objects
Abstract: Taking the periodic table of elements into consideration I’ve created The Periodic Table of Dynamic Management Objects as a reference tool for these functions and views that have become so critical for today’s SQL Server DBA to performance tune and gain metadata insights into their various SQL instances.
In navigating the table we will examine key DMVs and DMFs of interest: requests, sessions, wait stats, indexes, system information will all be covered. We will also delve into how these DMOs - just like their elemental counterparts - can be combined to yeild interesting insights into your servers. We will also look at how things can go awry as well! Like mixing vinegar and baking soda, sometimes combining DMOs can cause a big mess too!
Speaker(s):
- Tim Ford
Track and Room: Forum Room - N/A
Title: BlueGranite Lunch Session
Abstract: In this Lunch session see how BlueGranite – a Microsoft’s 2011 Partner of the Year award winner and top industry partner – has helped customers leverage the Microsoft BI platform to help increase profitability through deeper business analysis. Through an end-users eyes, learn how Microsoft Business Intelligence and SQL Server 2008 R2 can provide an up-to-the-minute view of the health of your business. See real world-examples and use cases from a live solution; including the use of SSAS OLAP cubes, Microsoft Excel, PerformancePoint Services, and mobile platforms.
Speaker(s):
- Matthew Mace
Track and Room: Theatre - N/A
Title: Visualizing Your Indexes - Science behind the Art
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
Track and Room: Track 5 - N/A
Title: Extended Events, Work Smarter Not Harder
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.
Speaker(s):
- Jason Strate
Track and Room: Forum Room - N/A
Title: Read Dirty to Me - Understanding Isolation
Abstract: Issue a “SELECT {data} FROM {myTable}” statement and users need to trust the data returned is accurate. What happens when multiple processes access the same data? What happens further if one of those process is an UPDATE or even a DELETE statement? How about if both processes will be updating that data? Understanding Isolation in SQL Server is paramount in ensuring data integrity in your system. We will cover the different levels of isolation and how they impact what a user views when accessing the data at a given point-in-time.
Speaker(s):
- Wendy Pastrick
Track and Room: Track 4 - N/A
Title: Seven Strategic Discussions About Scale
Abstract: Know those apps that need a complete rewrite from scratch, but management won’t listen to you? Kendra Little has been there and she’s figured out how to frame the big conversations. She’ll give you seven strategies to improve scale and change application architecture, and explain concepts from sharding to caching along the way. You’ll get a toolkit for each conversation: how to gather the right supporting data from the environment, who to talk to, and how to speak the right language to drive each change.
Speaker(s):
- Kendra Little
Track and Room: Track 4 - N/A
Title: Understanding MS SQL Server Indexes
Abstract: A one hour session showing how SQL Server creates and manages indexes using a B-Tree. This will include discussions and demonstrations on clustered vs non-clustered indexes as well as how to build the best performing index solutions.
Speaker(s):
- Charles Otten
Track and Room: Track 4 - N/A
Title: T-SQL : Bad Habits to Kick
Abstract: Bad habits: we all have them. SELECT * is the obvious one; but in this session you will learn about various other habits and why they can be bad for performance or maintainability. Come learn how these habits develop, what kind of problems they can lead to, and how you can avoid them. Eliminating these habits will lead to more efficient code, a more productive work environment, and - in a lot of cases - both.
Speaker(s):
- Aaron Bertrand
Track and Room: Track 5 - N/A
Title: Delivering BI Solutions with SQL and SharePoint
Abstract: This session focuses on SQLServer-based BI solution delivery. Capabilities discussed will include Excel Services, PerformancePoint Services, Business Connectivity Services, Reporting Services Integrated Mode, and PowerPivot. This session will emphasize real-world best practices in technology selection, solution design, security, and deployment.
Speaker(s):
- Rob Kerr
Track and Room: Track 3 - N/A
Title: What’s New in SQL Server “Denali”?
Abstract: SQL Server “Denali” delivers many highly anticipated features that some feel are long overdue. In this session you will get a first-hand look at many of these new features relating to the engine (contained databases, AlwaysOn, and T-SQL enhancements), client tools (Management Studio, Books Online, and “Juneau”), and changes to setup and system requirements. You’ll also learn about some of the features that will not be making it into Denali, and deprecated functionality that will stop working in this or the next release.
Speaker(s):
- Aaron Bertrand
Track and Room: Theatre - N/A
Title: Change Tracking
Abstract: Change Tracking (the little sister to Change Data Capture CDC) will be demonstrated in detail in this session. This SQL server feature is available in Standard Editions of SQL server so everybody can use it. A complete example from server settings to each T-SQL statement will be explored.
Speaker(s):
- Tom Groszko
Track and Room: Track 4 - N/A
Title: SQL Server Best Practices
Abstract: There are many ways to solve problems with SQL Server, and the performance of the various solutions can vary dramatically. This session will focus on specific server settings and T-SQL practices to create efficient running solutions. We’ll discuss how functions can hurt and help performance, approaches to removing cursors in favor of set based approaches, tricks to find missing indexes, how to determine the actual cost of your queries and much more.
Speaker(s):
- Charles Otten
Track and Room: Track 3 - N/A
Title: Waits and Queues and You
Abstract: Many database professional have little to no understanding about how to use wait events as part of an overall performance tuning process. And yet wait events are the secret sauce that many leading experts have been using for years. Attend this talk and you will gain an understanding of the SQLOS execution model, an understanding of how to use DMVs to find out what your queries are waiting for, and why using wait events could be the best thing to happen for your career as a DBA.
Speaker(s):
- Thomas LaRock
Track and Room: Forum Room - N/A
Title: Pro Tips: Tuning the data flow in ssis
Abstract: Synchronous and asynchronous components, memory buffers, data type choices, Oh My! Tuning the data flow is all about choices. In this session we’ll walk through some of the choices that can give you the biggest performance boosts in your ssis data flow. Together we’ll work through the differences between synchronous and asynchronous components. We’ll highlight components that should be avoided and explore alternates that can help us create the fastest data flow possible.
Speaker(s):
- Tim Costello
Track and Room: Track 4 - N/A
Title: How to Defuse Problems Like a Consultant
Abstract: Consultants work with technology, but they also deal with a lot of politics. Brent Ozar was a production DBA for years and sat through thousands of meetings. Now that he’s a consultant, he’s figured out how consultants handle political bombs during meetings, and he wants to share his favorite consulting lines with you. You’ll learn how to deal with dangerous developers, miserable managers, and cussing customers using simple lines that won’t blow up in your face.
Speaker(s):
- Brent Ozar
Track and Room: Forum Room - N/A
Title: SAN Basics for DBAs
Abstract: Storage Area Networks are like a bad black box: we put data in, we get data out, but we have no idea what’s going on inside. Why is everything so slow and yet so expensive? Is it a SAN problem or a SQL problem? Learn what’s happening inside the black box from Brent Ozar, a Microsoft Certified Master and former SAN administrator, who will demystify storage.
Speaker(s):
- Brent Ozar
Track and Room: Theatre - N/A
Title: Automate Policy-Based Management using PowerShell
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.
Speaker(s):
- Allen White
Track and Room: Theatre - N/A
Title: Monitoring Databases in a Virtual Environment
Abstract: When moving databases to a virtual environment the performance metrics DBAs typically use to troubleshoot performance issues such as O/S metrics, storage configurations, CPU allocation and more become unreliable. DBAs no longer have a clear, reliable view of the factors impacting database performance. Understanding the difference between the physical and virtual server environment adds a new dimension to the DBA tasks. This presentation describes the changes that DBAs need to make in their performance and monitoring practices.
Speaker(s):
- Thomas LaRock
Track and Room: Theatre - N/A
Title: How to Thrive (and Survive) as a Woman in IT
Abstract: We often hear about the advantages of diversity in the workforce, but it can be difficult to relate to one another when we all have different backgrounds and experiences. Please join our panelists Kendra Little, Wendy Pastrick, Yanni Robel and Erin Stellato as they explore lessons learned as women working in information technology. They will discuss ways they have been able to leverage their differences to compliment a team and share communication techniques they’ve acquired from working in diverse environments. All attendees are welcome.
Speaker(s):
- Shelly Noll
Track and Room: Forum Room - N/A
Title: Getting Out from Behind the Curtain – The New DBA
Abstract: The days of hiding amongst rows of servers, focusing purely on operational tasks are quickly coming to an end. DBAs that want to hide in their foxhole, focusing purely on operational tasks are quickly being outsourced. This session will cover the steps to becoming a highly valued leader in your organization by building relationships, automating mundane tasks, standardizing processes, and making education a priority.
Speaker(s):
- David Levy
Track and Room: Track 3 - N/A
Title: TempDB Performance Troubleshooting and Optimizing
Abstract: Every SQL Server instance relies on the tempdb database. Whether through explicit use with #temp tables or @table variables, or implicit use through working space for many other operations, most tempdb databases get quite a workout. This session will dig into many of the otherwise-hidden issues that can kill server performance. After this session, you will be able to spot tempdb performance issues, drill into the causes, and take the steps necessary to solve them.
Speaker(s):
- Eddie Wuerch
Track and Room: Track 5 - N/A
Title: NoSQL-What is it and why do I care?
Abstract: NoSQL (or, more correctly NoRel) is a moniker applied to a family of non-relational software systems for storing data that powers some of the largest sites on the Internet. Amazingly enough, non-relational database technology has been around a very long time. This session will include a high level discussion of some of the pros and cons of this technology compared to traditional systems like Oracle and SQL Server; as well as a survey of the most popular “NoSQL” platforms and who uses them. We will also cover a brief history of relational and non-relational databases as it is germane to the topic
Speaker(s):
- Craig Purnell
Track and Room: Track 4 - N/A
Title: Designing an SSIS Framework
Abstract: In this “demo-tastic” presentation, SSIS trainer, author, and consultant Andy Leonard explains the what, why, and how of an SSIS framework that delivers metadata-driven package execution, connections management, and centralizes logging. Key takeaways: 1) Developers can migrate packages from Development, through their lifecycle, to Production without editing SSIS Connection Managers properties. 2) A metadata-driven approach to SSIS package execution. 3) Demonstration of a centralized logging reporting application.
Speaker(s):
- Andy Leonard
Track and Room: Forum Room - N/A
Title: Refactoring SQL
Abstract: Refactoring SQL is not like refactoring application code. This talk will cover proven SQL refactoring techniques that will help you identify where performance gains can be made, apply quick fixes, improve readability, and help you quickly locate places to make sweeping performance improvements. Jeremiah Peschka has years of hands on experience tuning SQL applications for performance, throughput, and concurrency.
Speaker(s):
- Jeremiah Peschka
Track and Room: Theatre - N/A
Title: The Creepy DBA, How to Stalk Your Users
Abstract: Do you know when your users are using the production login accounts from their workstations? Are you aware of changes being made to the development servers that may impact future deployments? Has the new Junior DBA start giving out access like candy? As DBAs, we are responsible for knowing and acting on all of this and much more. Fortunately, SQL Server provides a number of features that you can use to monitor and track user activity. In this session, we’ll look at these features and demonstrate how you can use them to the extent that your users find you creepy!
Speaker(s):
- Jason Strate
Track and Room: Theatre - N/A
Title: Leaving the Windows Open
Abstract: Computing running totals, averages by state or group, and other complex aggregations are not easy to implement in many relational databases. Thankfully, many relational databases include support for window functions. Window functions are an extension to the ANSI SQL standard. More than just another part of SQL, window functions enable complex ranking, ordering, and other aggregations over a subset of rows in a query. Understanding the capabilities of window functions lets you extend application functionality, build rich and complex queries, and reduce overhead in the application tier.
Speaker(s):
- Jeremiah Peschka
Track and Room: Track 5 - N/A
Title: “I See a Control Flow Tab. Now What?”
Abstract: This highly-interactive, demo-intense presentation is for beginners and developers just getting started with SSIS. Attend and learn how to build SSIS packages from the ground up.
Speaker(s):
- Andy Leonard
Track and Room: Track 3 - 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.
Kendra Little
Twitter: - Kendra_Little
LinkedIn: Kendra Little
Contact: http://littlekendra.com
Kendra Little is a Microsoft Certified Master and a Microsoft MVP. Kendra fell in love with the challenge of deploying software to a complex database environment when she worked in a build operations team at a software startup. She went on to become a database administrator for performance critical databases at Microsoft Corporation. Since then, Kendra has worked internationally as a teacher and consultant, and founded the training site SQL Workbooks. She joined Redgate as a Product Evangelist in 2018.
Thomas LaRock
Twitter: - @SQLRockstar
LinkedIn: Thomas LaRock
Contact: http://thomaslarock.com
Thomas LaRock is a Head Geek at SolarWinds and a Microsoft Certified Master, Data Platform MVP, VMware vExpert, and a Microsoft Certified Trainer. He has over 15 years’ experience in the IT industry in roles including programmer, developer, analyst, and database administrator.
Jeff Moden
With more than 51,000 posts and 39 mostly 5 star articles, Jeff Moden is a strong contributor on SQLServerCentral.com where he coined the term “RBAR” (Row By Agonizing Row) and helped make the “Tally Table” a household name. Jeff has more than 2 decades of experience with SQL Server and is mostly self-trained in what he calls the “Black Arts” of T-SQL. He’s known worldwide for his informative articles, high performance T-SQL coding methods, and methods of mentoring. His dedication to helping others earned him the MS SQL Server MVP award for nine years and the RedGate Exceptional DBA Award in 2011. His mantra is “Performance is in the code”.
Andy Leonard
Twitter: - AndyLeonard
LinkedIn: Andy Leonard
Contact: https://andyleonard.blog
Andy Leonard is founder and Chief Data Engineer at Enterprise Data Analytics, Microsoft Data Platform MVP, creator of the DILM (Data Integration Lifecycle Management) Suite, an SSIS trainer, consultant, developer, Business Intelligence Markup Language (Biml) developer and BimlHero, SQL Server database and data warehouse developer, community mentor, engineer, and farmer. He is a co-author of “The Biml Book and SQL Server Integration Services Design Patterns” and author of “Managing Geeks - A Journey of Leading by Doing”, “Data Integration Lifecycle Management with SSIS”, “Building Custom Tasks for SSIS”, and the “Stairway to Integration Services”. Andy blogs at andyleonard.blog where you can learn more on the About Andy page.
David Levy
Contact: http://adventuresinsql.com
An IT Professional with more than 10 years experience, largely in a software development role. Exclusively a DBA for more than 3 years, recently joined Microsoft as a Premier Field Engineer specializing in SQL Server.
Tim Ford
Twitter: - @SQLAgentMan
LinkedIn: Tim Ford
Contact: http://thesqlagentman.com
Tim Ford is a Data Professional, Author and Community Leader whose technical passions lie in creative solutions for managing and presenting data. He#39;s been a healthcare DBA since 2000 and leads SQL Agent Man Consultancy and SQL Cruise. He takes 25 students and leaders in the SQL Community and places them on cruise ships for technical and professional development training without the distractions of the office and internet twice a year on SQL Cruises (www.sqlcruise.com). Currently Tim serves on the Board of Directors for PASS and is passionate about taking fellow Data Professionals to the next level in their careers. He enjoys telling stories with data.
Jeremiah Peschka
Twitter: - @peschkaj
Contact: http://brentozar.com
Jeremiah Peschka 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 that when you need to reinvent something, or get unblocked, you should talk to Jeremiah.
Allen White
Twitter: - SQLRunr
LinkedIn: Allen White
Contact: http://dataperfpro.com/blog/
Allen White is a Data Platform consultant. He has been both a developer and an administrator, so he understands both perspectives towards database technology. He loves sharing his experiences and helping people learn how to use SQL Server. Allen has spent over 40 years in IT, using SQL Server since 1992, and has been awarded Microsoft’s MVP Award for the last 13 years. Allen was a PASS Director from 2016 - 2018.
Brent Ozar
Twitter: - BrentO
LinkedIn: Brent Ozar
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.
Erin Stellato
Twitter: - erinstellato
LinkedIn: Erin Stellato
Contact: http://www.sqlskills.com/blogs/erin
Erin Stellato is a Data Platform MVP and lives outside Cleveland, OH. She has almost 20 years of technology experience and has worked with SQL Server since 2003. Her areas of interest include performance tuning, Query Store, Extended Events, and helping accidental/involuntary DBAs understand how SQL Server works. Erin is an active member of the SQL Server community, has volunteered for PASS at the local and national level, and is a regular speaker at conferences including the PASS Summit, SQLIntersection, and SQLBits. Outside of time with family and friends, she enjoys running, spinning, movies, and all things chocolate.
Aaron Bertrand
Contact: http://sqlblog.com/blogs/aaron_bertrand/
Aaron is a senior consultant for SQL Sentry, makers of performance monitoring and event management software for SQL Server, Analysis Services, and Windows. He has been blogging at sqlblog.com since 2006, focusing on manageability, performance, and new features; has been an MVP since 1997-98; and speaks frequently at user group meetings and SQLSaturday events.
Rob Kerr
Twitter: - @robkerrbi
LinkedIn: Rob Kerr
Contact: http://www.robkerr.com
Rob is CTO with BlueGranite, is a Microsoft SQL Server MVP and holds top Microsoft certifications in both SQL Server Database Administration and BI Development. Rob has implemented data warehouse and business analytics systems for many Fortune 500 companies, and focuses on large-scale data warehousing, geospatial data analysis and mobile solutions. Rob is the lead contributor to msbiacademy.com, a site providing free on-demand training covering a variety of Microsoft BI topics.
Craig Purnell
Twitter: - @CraigPurnell
LinkedIn: Craig Purnell
Contact: http://www.craigpurnell.com/
Craig Purnell is a career database professional, trainer, and community activist. He has spent over 10 years as the Database Administrator at a large Midwestern law firm. He has been in IT for 15 years and has spent his entire career working with enterprise databases and ERP systems. Craig is an active member of the Ohio North SQL Server User Group and has presented at many user groups, SQLSaturdays, and the PASS Summit in 2012 and 2013
Wendy Pastrick
Twitter: - @wendy_dance
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.
Aaron Bertrand
Contact: http://sqlblog.com/blogs/aaron_bertrand/
Aaron is a senior consultant for SQL Sentry, makers of performance monitoring and event management software for SQL Server, Analysis Services, and Windows. He has been blogging at sqlblog.com since 2006, focusing on manageability, performance, and new features; has been an MVP since 1997-98; and speaks frequently at user group meetings and SQLSaturday events.
Charles Otten
Charles has been working with SQL Server since 1999 and has assisted companies with database design, application development, data warehousing, enterprise reporting and performance tuning. He has successfully implemented multi-million dollar systems and system conversions throughout his career. At Dematic Corp he is involved in creating high performance solutions using SQL Server 2005/2008 for high volume (1000’s trans/sec) applications requiring subsecond response times.
Scott Schommer
Doing proof of concept projects and pushing the limits of technology are the passions in my professional life. Many people do projects just because they are assigned to them, but I like to ask questions like “who, what, when, where, why, how and how often”. Finding the answers to these simple inquiries saves not only me, but the people (and teams) around me time, money and resources. I also make spending time with my wife and 2 kids, attend a local PASS user group and enjoy life!
Andy Leonard
Twitter: - AndyLeonard
LinkedIn: Andy Leonard
Contact: https://andyleonard.blog
Andy Leonard is founder and Chief Data Engineer at Enterprise Data Analytics, Microsoft Data Platform MVP, creator of the DILM (Data Integration Lifecycle Management) Suite, an SSIS trainer, consultant, developer, Business Intelligence Markup Language (Biml) developer and BimlHero, SQL Server database and data warehouse developer, community mentor, engineer, and farmer. He is a co-author of “The Biml Book and SQL Server Integration Services Design Patterns” and author of “Managing Geeks - A Journey of Leading by Doing”, “Data Integration Lifecycle Management with SSIS”, “Building Custom Tasks for SSIS”, and the “Stairway to Integration Services”. Andy blogs at andyleonard.blog where you can learn more on the About Andy page.
Brent Ozar
Twitter: - BrentO
LinkedIn: Brent Ozar
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.
Doug Lane
Contact: http://www.douglane.net
Doug Lane (MCITP, MCTS) is a consultant with Brent Ozar Unlimited and has over 14 years’ experience with SQL Server. He blogs about SQL Server with emphasis on Reporting Services and professional development.
Shelly Noll
Shelly Noll is a .NET Developer and recovering DBA with over 15 years of IT experience. Currently serving as a Software Developer with Learning Care Group in Novi, MI, she is involved in the .NET developer community and serves as Vice-President for the Great Lakes Area .NET Users Group. Her education includes a BS in Psychology from Loyola University Chicago and a MS in Information Systems from Lawrence Technological University.
Jeff Moden
With more than 51,000 posts and 39 mostly 5 star articles, Jeff Moden is a strong contributor on SQLServerCentral.com where he coined the term “RBAR” (Row By Agonizing Row) and helped make the “Tally Table” a household name. Jeff has more than 2 decades of experience with SQL Server and is mostly self-trained in what he calls the “Black Arts” of T-SQL. He’s known worldwide for his informative articles, high performance T-SQL coding methods, and methods of mentoring. His dedication to helping others earned him the MS SQL Server MVP award for nine years and the RedGate Exceptional DBA Award in 2011. His mantra is “Performance is in the code”.
Jason Strate
Twitter: - @stratesql
LinkedIn: Jason Strate
Contact: http://www.jasonstrate.com/
Jason Strate is a SQL Server Solutions Architect with Pragmatic Works. He is also a Microsoft SQL Server MVP and MCM. He has over 15 years of experience developing, architecting, and managing data platforms. Jason writes, blogs, and presents on SQL Server.
Tom Groszko
I have been working with MS SQL since 2000 and prior to that with Oracle and Sybase SQL. I have been working with a variety of databases for many years. I also develop desktop applications with C++ and C#.
Matthew Mace
Contact: www.blue-granite.com
Matthew Mace, President/CEO - Matthew was a founder of BlueGranite, helping start the company 1996. Matthew is active in the technology and business community, serving as Chair of the Western Michigan University CIS Advisory Board, past President Vice-President of the Michigan Chapter of the International Association of Microsoft Certified Partners, and an instructor with Junior Achievement. Matthew was selected as one of the Top 40 Business Leaders Under 40 for West Michigan.
Thomas LaRock
Twitter: - @SQLRockstar
LinkedIn: Thomas LaRock
Contact: http://thomaslarock.com
Thomas LaRock is a Head Geek at SolarWinds and a Microsoft Certified Master, Data Platform MVP, VMware vExpert, and a Microsoft Certified Trainer. He has over 15 years’ experience in the IT industry in roles including programmer, developer, analyst, and database administrator.
Tim Costello
Twitter: - timcost
LinkedIn: Tim Costello
Contact: http://www.timcost.com
Tim Costello is an MCITP, MCTS specializing in etl and data analytics for Interworks Inc. Tim is an international speaker that is always looking for opportunities to share his passion for SQL Server, Tableau and data visualization. Tim is active in the SQL community and leads a data visualization focused user group in the Dallas area.
Jeremiah Peschka
Twitter: - @peschkaj
Contact: http://brentozar.com
Jeremiah Peschka 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 that when you need to reinvent something, or get unblocked, you should talk to Jeremiah.
Charles Otten
Charles has been working with SQL Server since 1999 and has assisted companies with database design, application development, data warehousing, enterprise reporting and performance tuning. He has successfully implemented multi-million dollar systems and system conversions throughout his career. At Dematic Corp he is involved in creating high performance solutions using SQL Server 2005/2008 for high volume (1000’s trans/sec) applications requiring subsecond response times.
Eddie Wuerch
Twitter: - @EddieW
LinkedIn: Eddie Wuerch
Contact: http://www.indydba.com
Eddie Wuerch has 20 years of experience as a SQL Server specialist in a much-longer IT career. A Microsoft Certified Master, Eddie spends his days in the Salesforce Marketing Cloud, focusing on performance, scale, and uptime for the massive SQL Server backend. These SQL Servers churn billions of transactions daily against trillions of rows of data in a 24x7 continuously-available online system accessed by millions worldwide every day.
Jason Strate
Twitter: - @stratesql
LinkedIn: Jason Strate
Contact: http://www.jasonstrate.com/
Jason Strate is a SQL Server Solutions Architect with Pragmatic Works. He is also a Microsoft SQL Server MVP and MCM. He has over 15 years of experience developing, architecting, and managing data platforms. Jason writes, blogs, and presents on SQL Server.
Wendy Pastrick
Twitter: - @wendy_dance
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.
Sponsors
The following is a list of sponsors that helped fund the event: