SQLSaturday #122 - Louisville 2012
Event Date: 07/21/2012 00:00:00
Event Location:
- University of Louisville School of Business
- 2301 3rd Street
- Louisville, Kentucky
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 Internals Architecture
Abstract: Let’s face it. You can effectively do many IT jobs related to SQL Server without knowing the internals of how SQL Server works. Many great developers, DBAs, and designers get their day-to-day work completed on time and with reasonable quality while never really knowing what’s happening behind the scenes. But if you want to take your skills to the next level, it’s critical to know SQL Server’s internal processes and architecture. This session will answer questions like: - What’s different about 32- and 64-bit systems? - What are the various areas of memory inside of SQL Server? - How are queries handled behind the scenes? - What does SQL Server do with procedural code, like functions, procedures, and triggers? - …and much more.
Speaker(s):
- Kevin Kline
Track and Room: DBA - N/A
Title: Why Data Warehousing Projects Fail
Abstract: Is your organization planning to build a data warehouse or BI solution? Data warehousing projects, like many large IT projects, have high failure rates. While the exact rate of failure for data warehousing projects is difficult to pin down, the causes of these failures fall into a small number of categories. It is obviously possible to successfully complete a data warehousing project and deliver value to the business. Craig Utley has seen Microsoft BI solutions in various states of completeness at over 30 companies worldwide and has seen some awesome successes and some spectacular failures. This session addresses the reasons data warehousing projects fail and how you can succeed in overcoming these obstacles.
Speaker(s):
- Craig Utley
Track and Room: BI - N/A
Title: Private Clouds with SQL Server 2012
Abstract: The recent growth of cloud computing has companies evaluating when how, not if, they will move their data offsite. Despite the benefits that the cloud, many DBAs are leery of jumping into the cloud, fearful that their sensitive data will become vulnerable. The goal of this session is to provide you a blueprint to design build your own SQL Server cloud, where you can control the server availability performance reliability, yet still take advantage of the resource elasticity and hardware flexibility of the cloud. In this session, I will demonstrate how to use features like always on, resource governor, policy based management PowerShell scripts to automate your servers behavior to achieve the benefits of the cloud without the risks
Speaker(s):
- Sarah Barela
Track and Room: Azure/Big Data - N/A
Title: Bulletproof: Hardening your SQL Server from Attack
Abstract: Recent major security breaches have not only exposed customer data, but also the system vulnerabilities DBAs must overcome daily. As data protection is a DBA’s primary responsibility, establishing an impenetrable environment to host the data is the first step towards risk-free security. How can DBAs ensure SQL Servers are fortified against the latest threats and vulnerabilities? In this session, we will go through the process of hardening your SQL Server from attack from Windows Server to the database level step-by-step. I will share will share with you how establish security baselines and monitor for changes to your security foundation. This session will provide specific actions for you to take back and apply to your servers.
Speaker(s):
- Sarah Barela
Track and Room: Design/Architecture - N/A
Title: So I started this blog… now what?
Abstract: Ever thought about trying your hand at blogging? Or maybe you’ve started a blog but struggle with what to write about. We’ll take a beginner’s look at blogging and examine common roadblocks, finding topics, building readership, and setting you on the road to blogging stardom.
Speaker(s):
- Colleen Morrow
Track and Room: Prof. Growth - N/A
Title: Bridging the Chasm: BI Theory vs. Practice
Abstract: A Dynamic Dialog session: According to research compiled by Gartner from discussions with many BI clients, a substantial disparity exists, in the implementation of BI, between theory (standard approaches, promises, claims and expectations) and practice (shortfalls, compromises and other realities). In this session, Business Intelligence Architect and Microsoft MVP Bill Pearson leads a dialog within which we will gain an understanding of the general types of discrepancies between the “ideal” approach to BI and the compromised reality that a large number of organizations experience. We’ll then share and class experiences as a group, and discuss ways to avoid these discrepancies in future projects.
Speaker(s):
- William E Pearson III
Track and Room: BI - N/A
Title: What Sequence objects are (and are not)
Abstract: SQL Server 2012 adds a new object to our arsenal called a sequence that can will give us the capability to implement automatically incrementing values. However, it cannot replace a lot of functionality that we have used a numbers table and windowing functions for (though they can be complimentary to one another). In this session I will demonstrate the uses and performance characteristics of sequences, including how they compliment the use of number tables and windowing functions to create surrogate key and sorting values, and more.
Speaker(s):
- Louis Davidson
Track and Room: Design/Architecture - N/A
Title: Throwing T-SQL 2012 Enhancements Against the Wall
Abstract: Just like your grandma tested spaghetti to tell if it was done, we’ll be throwing several of the new T-SQL enhancements against the wall to see what’s good and what falls off. We’ll silence the lion’s RaiseRror by throwing some meaty exceptions. We’ll bring together the old lovers “Coalesce” and “+” for one last jaunt before they are banished by the Concat function. We’ll even open the window on some of the new aggregate and analytical functions as well as some other t-sql enhancements introduced in SQL 2012.
Speaker(s):
- Kyle Neier
Track and Room: Developer - N/A
Title: Understanding Parameter sniffing and making it wor
Abstract: Parameter Sniffing is usually thought of as the bad guy, in association with a performance problem in your database. Contrary to the popular belief, Parameter Sniffing is usually the good guy, continuously working under the hood to help your database applications run faster. However, it can sometimes go wrong, causing severe performance degradation of your queries. In this session we will discuss the workings of Parameter Sniffing and demonstrate how it helps improve the performance of your database applications. We will also explore how Parameter Sniffing can go wrong and its impact. Several ways to fix bad Parameter Sniffing will be demonstrated to help make an appropriate choice for your scenario.
Speaker(s):
- Sanil Mhatre
Track and Room: Developer - N/A
Title: What Counts For a DBA
Abstract: The world of a DBA can be daunting for a person, either as a new or old, because not only do they need to keep up with new and emerging technologies, but also with the code and designs of their coworkers. In this highly participation driven session, we will employ a random topic chooser to pick several of these traits for discussion as a group. Possible topics include past blog topics such as Logic, Curiosity, Failure, Humility, Skill and Passion, as well as any other topics that might be added for that day. So come prepared to participate and voice your opinion about what counts for a DBA.
Speaker(s):
- Louis Davidson
Track and Room: Prof. Growth - N/A
Title: SQL Azure Data Sync and What’s New
Abstract: In this session, you will get introduced to SQL Azure Data Sync and learn how to get started. We will explore how to migrate data from an existing on-premise SQL Server database to SQL Azure and bi-directional data synchronization and data management capabilities allowing data to be easily shared across SQL Azure databases across multiple data centers. What you will learn: • Overview of SQL Azure • How to Get Started with SQL Azure Data Sync • Cloud to cloud synchronization • Enterprise (on-premises) to cloud • Cloud to on-premises. • Bi-directional or sync-to-hub or sync-from-hub synchronization
Speaker(s):
- Andy Thiru
Track and Room: Azure/Big Data - N/A
Title: My Favorite SSIS Tips and Tricks
Abstract: SSIS is a very powerful platform for creating different types of data integration solutions. But unless you’ve been using SSIS every day, read through countless blogs each week, and attend every available SSIS session at every conference available, you’ve probably missed out on several SSIS tips and tricks that have surfaced over the years. So come and listen as I describe and demonstrate some of my favorite SSIS tips and tricks!
Speaker(s):
- Dave Fackler
Track and Room: BI - N/A
Title: Designing data frameworks for SQL Server
Abstract: Having trouble in managing large scan data process for SQL Server? Efficient way to MODEL, PROCESS ANALYSE large scale data for SQL Server platform. Identifying common and client specific process steps to process client data. Parsing Efficient way to process data comes in multiple formats (Excel, Flat Files, Access etc. ) for SQL Server. Automate and schedule large scale data in parallel. Centralized management of client data model across multiple domains.
Speaker(s):
- Rameshdurai Palnisami
Track and Room: Azure/Big Data - N/A
Title: Advanced Charting Techniques in SSRS
Abstract: SSRS 2008 R2 has been a game changer for SQL Server in terms of visualization techniques. With a wide range of available options for charting, BI professionals struggle to get familiar with even the basic functionalities of most charts. This session will talk about the basic functionalities of all the charts as well as some tips and tricks around them. Come to this session and take your charting skills to the next level.
Speaker(s):
- Jason Thomas
Track and Room: BI - N/A
Title: Partitioning for Perf Management of Large Tables
Abstract: Managing data in ever-growing transaction and history tables can be challenging. Activities with large chunks of data such as moving data to archive tables, batch-importing many rows, or defragging an entire table when only the active portion changes introduces heavy I/O and blocking. Table partitioning seamlessly solves a host of headaches with minimal effort. Ever wanted to truncate or defrag part of a table, or insert an entire staging table of data into another table in milliseconds instead of hours? Come see what partitioning can provide for you.
Speaker(s):
- Eddie Wuerch
Track and Room: Advanced DBA - N/A
Title: Change Data Capture the foundation of BI
Abstract: This session will explore the fundamental importance of Change Data Capture to an organization building a Business Intelligence infrastructure. Many organizations will spend large amounts of time and money researching Business Intelligence software and databases without understanding how key business metrics are consistently captured. The techniques and methodologies used to capture business events are the key success factors for a winning Business Intelligence strategy.
Speaker(s):
- Jim Deppen
Track and Room: BI - N/A
Title: PowerShell 101 for the SQL Server DBA
Abstract: The more you have to manage, the more likely you’ll want to automate your processes. PowerShell is the scripting language that will make you truly effective at managing lots of servers. This session will introduce you to PowerShell and show you how to use it to manage SQL Server across many instances.
Speaker(s):
- Allen White
Track and Room: DBA - N/A
Title: Parallel Query Execution Deep Dive
Abstract: What exactly does it mean to parallelize a query? Why would the optimizer do this and what are the benefits and what are the drawbacks?? Is it always faster? Can it cause problems? Are there reasons we might NOT want parallelization? What can prevent it’s use by the engine? These are some of the topics we will cover as we dig into this facet of the SQL Server relational engine.
Speaker(s):
- Kevin Boles
Track and Room: Advanced DBA - N/A
Title: SQL Azure Intro and What’s New
Abstract: In this session, you will get introduced to SQL Azure and learn how to get started. We will explore how to migrate an existing on-premise SQL Server database to SQL Azure. We will then walkthrough how to manage and administer your SQL Azure servers and databases. We will take a look at how to connect and build applications using SQL Azure. Next, we will look at more advanced scenarios using new capabilities like reporting with SQL Azure Reporting, synchronizing data with SQL Azure Data Sync for hybrid scenarios and global reach. Finally, we will explore some of the things you should consider when using SQL Azure
Speaker(s):
- Andy Thiru
Track and Room: Azure/Big Data - N/A
Title: Optimizing Stored Procedures
Abstract: In this talk 4 time MVP Mark Rosenberg will talk about SQL Server stored procedures and techniques you can use to optimize them. He will cover stored procedures from a developer’s point of view including table variables, common table expressions and temporary tables. Which do you use and when do you use it. There will also be a number of quick tips that anyone can use to improve query performance when they walk out of the session
Speaker(s):
- Mark Rosenberg
Track and Room: Developer - N/A
Title: Revenge: The SQL!
Abstract: Have you been wronged, cheated, lied to, lied about, or deceived by a coworker? Feel like your DBA position offers no opportunity for revenge? WRONG! This session is a light-hearted exploration of some delightfully mischievous SQL design patterns that will annoy, aggravate, and antagonize anyone who has to work with them. (But they deserved it!) Learn how to: create tables with no names; columns with duplicate names; and write perfectly valid yet utterly nonsensical SQL. You may never get to use these techniques…but you’ll ache for the chance!
Speaker(s):
- Rob Volk
Track and Room: Design/Architecture - N/A
Title: Communicating Upward
Abstract: This session explores how to influence your manager and higher executives in the organization. In addition, this session explores how to convey information upwards without filtering out important information or self-censoring. This session delves into a variety of important behaviors, including:
• Building credibility and influence with your boss • What is the most effective process to win explicit support for a new project? • How to get executives to spend money for something you think is important
Speaker(s):
- Kevin Kline
Track and Room: Prof. Growth - N/A
Title: Strategies for Sharding with SQL Azure Federations
Abstract: Putting big data in the cloud is not without its difficulties and the Microsoft Azure teams have been consistently upping the resource limits that you are able to utilize within a given instance. Those of us with larger capacity instances still have to hedge our bets when looking at moving to the cloud. That is until the recent release of SQL Azure Federations, which offers a native SQL Azure based option to possible unlimited scalability. In this session, we will break down the basics of sharding within SQL Azure Federations, explain what needs to be taken into consideration in terms of database design, and put you on the right path to a successful Federation based deployment.
Speaker(s):
- Arie Jones
Track and Room: Azure/Big Data - N/A
Title: Transaction Log Internals
Abstract: The transaction log is the most important aspect of a SQL Server database. Separating the data and log files is usually good advice, but there is so much more about the transaction log that is misunderstood. Join Microsoft Premier Field Engineer Tim Chapman as he discusses data modification internals, write-ahead logging and the inner workings of the SQL Server transaction log.
Speaker(s):
- Tim Chapman
Track and Room: Advanced DBA - N/A
Title: Death by UDF
Abstract: Using User Defined Functions in your database code is like playing Russian Roulette with 5.97 bullets in the gun!! There are SOOOOO many ways they can kill you: staggering performance degredation, tempdb allocation issues and bad data!! Oh, did I mention performance issues?? Those include row-by-row processing under the covers, bad estimates leading to horrible query plans, voiding parallelization in the engine, etc. In this jam-packed session we will cover all this and also discuss several ways you can get rid of them.
Speaker(s):
- Kevin Boles
Track and Room: Advanced DBA - N/A
Title: PWNED! Security, SQL Server, and You!
Abstract: With an ever increasing workload, security is often hoisted upon the DBA. So where do you start? Sometimes it’s better to start off by understanding what an attacker could do to you in order to get a clearer picture of what you need to do to prevent it. In this session, we will delve into the key features of the SQL Server and explain what the various attack vectors are, what an attack can do with them, and what you can do about them. We’ll also look at important features such as SQL Audit that, while not helping to prevent, can definitely help you in definitely help in figuring out what is going on. It’ll be AWESOME!
Speaker(s):
- Arie Jones
Track and Room: Design/Architecture - N/A
Title: SQL Server 2012 T-SQL
Abstract: You have heard all about AlwaysOn, BI Semantic Model, and Power View. Did you know that SQL Server 2012 has a host of new T-SQL features? Attend this session to learn more about the Sequence object, new functions and enhancements to the OVER clause.
Speaker(s):
- Kathi Kellenberger
Track and Room: Developer - N/A
Title: Revenge: The SQL Part 2: The Sequel!
Abstract: In a world…where DBAs are blamed, mistreated, and overworked…one man….WILL. GET. EVEN. In this entertaining and impractical follow-up to the entertaining and impractical Revenge: The SQL, Rob Volk will show you even more impractical but oh-so-tempting ways to get back at those who abuse SQL Server and make you clean it up. Techniques will cover: preventing sa use, preventing ad-hoc SQL, hiding and obfuscating data and code, and the ever-popular trigger mayhem. And if you stay for the after-credits sequence you may encounter the evil twins, duplicate primary keys!
Speaker(s):
- Rob Volk
Track and Room: Design/Architecture - N/A
Title: 2012 Blitz
Abstract: How many SQL Server 2012 features can Aunt Kathi show you in an hour? Attend this session to find out. Demos, demos, demos…
Speaker(s):
- Kathi Kellenberger
Track and Room: DBA - N/A
Title: Windowing Functions in SQL Server 2012
Abstract: SQL Server 2012 brings with it nearly full ANSI compliance with the windowing functions. Come to this code filled session to learn about all of the windowing functions in SQL Server 2012: Ranking functions, changes for windowing in the Aggregate functions, and the new Analytic and Sequence functions. We’ll examine how this latest implementation of the windowing functions allows us to perform running and sliding aggregations; retrieve data from adjacent rows in the partition, and much more – all without self-joins back to the source table.
Speaker(s):
- Wayne Sheffield
Track and Room: Advanced DBA - N/A
Title: Professional Networking for IT Pros
Abstract: Want to invest in your long term career success? You need to network. C’mon give it a try! It’s not that bad! This presentation will explain some in-person networking tips and some do’s and don’ts for networking on LinkedIn. Takeaways include: -How to find events -Tips on getting to most out of attending events -How to develop and maintain your network of contacts -A Review of Linkedin networking best practices and profile optimization strategies.
Speaker(s):
- Craig Purnell
Track and Room: Prof. Growth - N/A
Title: Getting Start with SQL Server Profiler
Abstract: Learn how to use SQL Server Profiler to troubleshoot, audit, and tune your SQL Server. Includes creating custom templates, integrating with Performance Monitor data, and creating scripts for creating server-side traces.
Speaker(s):
- Jack Corbett
Track and Room: Developer - N/A
Title: Women in Technology Session
Abstract: Whether you are searching for a new job or simply needing to relocate your desk, you need the right tools to make your request effective. Come hear how our Women in Technology (WIT) panel of experts have tackled these issues, and learn how you can give yourself the best opportunity to negotiate for what you want. Our panelists include Sarah Barela, Kevin Kline, Kathie Kellenberger and Deana Ritter. And this is not just for women!!
Speaker(s):
- Sarah Barela
Track and Room: Prof. Growth - N/A
Title: Transitioning from SQL Trace to Extended Events
Abstract: Extended Events were introduced with SQL Server 2008, but without a UI, which meant using T-SQL to create and manage them and using XPath and XQuery to parse the output. Microsoft has added an Extended Events UI in SQL Server 2012 and also added additional events. With the announcement that SQL Trace/Profiler is being deprecated now is the time to begin learning Extended Events. This session will show you how to take existing Traces and convert them to Extended Event Sessions.
Speaker(s):
- Jack Corbett
Track and Room: DBA - N/A
Title: Don’t Panic, DBAs! Databases on VMware made easy.
Abstract: More and more companies are virtualizing with VMWare, and databases are the next logical step. This presentation will explore the fundamentals of monitoring databases running in a VMWare environment because it can be much different than when running on a physical machine. You will learn business and technical benefits of virtualization, master new terms and concepts, pick up useful planning tips and tricks, and cover best practices for maintaining optimum performance in a VMWare environment.
Speaker(s):
- Janis Griffin
Track and Room: DBA - 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.
Sarah Barela
Twitter: - @sarahspace
Contact: http://www.sqlsarah.net
Sarah Barela is a Senior Manager at CBeyond Cloud Services, formerly MaximumASP. She has a Master’s degree in Information Science from the University of Texas, where she specialized in Database Management Systems. Sarah has spent over 15 years focusing on the administration of enterprise environments with large numbers of SQL Servers. Sarah is currently responsible for a rapidly growing environment with more than 2000 SQL Server instances. Her latest interests are in applying cloud technologies to SQL Server environments. Sarah has been a guest speaker at a number of PASS Chapter meetings, SSWUG Virtual Conferences, SQL Connections, SQLSaturday events, and the 2007, 2009, and 2010 PASS Summits.
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
Louis Davidson
Twitter: - drsql
LinkedIn: Louis Davidson
Contact: https://www.red-gate.com/simple-talk/author/louis-davidson/
Louis Davidson has worked in the IT industry for over 25 years as a corporate database developer and architect. He has been a Microsoft SQL Server MVP for 15 years and has written five books on database design, and contributed to many other SQL Server books as an author and tech editor. He has a bachelor’s degree in Computer Science from the University of Tennessee at Chattanooga. You can read more about Louis at http://drsql.org.
Kevin Kline
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.
Rob Volk
Twitter: - sql_r
LinkedIn: Rob Volk
Contact: http://weblogs.sqlteam.com/robv/
Rob Volk is a SQL Server DBA in the Metro Atlanta area since 2001. He also moderates and answers the forums on SQLTeam.com. While an old-time cranky DBA, he no longer considers quot;business intelligencequot; an oxymoron or quot;the cloudquot; as merely atmospheric moisture, and is delightedly dipping his toes into both of these new oceans, and loves to do things in new and and unusual ways.
Mark Rosenberg
Contact: http://geekswithblogs.net/markrosenberg
Mark Rosenberg has been writing software with Microsoft technologies since 1997. He has been speaking to user groups and at code camps since 2005 and been a certified trainer Since 2007.
Mark likes to talk to developers and has been talking to anyone who will listen. He is very active in the community, both speaking at user groups and on the board of 2 user groups in Southern California.
He currently is working as an senior development instructor at New Horizons in Austin, TX
Sanil Mhatre
Twitter: - sqlsuperguru
LinkedIn: Sanil Mhatre
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.
Jack Corbett
Twitter: - http://twitter.com/unclebiguns
LinkedIn: Jack Corbett
Contact: http://www.wisemanorwiseguy.com
JJack Corbett began working with SQL Server, Access, and VB in 1999, when he served an apprenticeship with a good friend who was the software development manager at the local paper mill. He found his niche and has concentrated on SQL Server development and administration since late 2000. He has worked with SQL Server through version 2017 and was a Microsoft Data Plaform MVP from October 2011 to October 2016.
Jack is passionate about helping companies architect, design, and develop high performance applications based on the Microsoft Data Platform. He also has a passion for seeing database developers get the core application code (the database) protected under source control.
Jack has presented at many user groups and SQLSaturday even
Jason Thomas
Twitter: - @SqlJason
LinkedIn: Jason Thomas
Contact: http://www.SqlJason.com
Jason Thomas is a Microsoft Certified SQL Server professional with over 10 years of Microsoft BI experience. He is a BI Consultant for BlueGranite, based in Charlotte, NC. When he#39;s not at work, Jason likes sharing his time between the MSDN forums (for which he was recognized with the Microsoft Community Contributor award), blogging about MSBI (www.SqlJason.com), speaking at SQL Server events, and watching movies with his wife (not necessarily in that order).
Craig Utley
Contact: http://www.learnmicrosoftbi.com
Craig Utley is a Senior Architect with CTS and a former Program Manager with the SQL Server Customer Advisory Team (SQLCAT), where he focused on business intelligence. Craig has been involved in the Microsoft BI space since the betas of SQL Server 7.0 and has consulted on over 50 BI implementations worldwide, including the largest Microsoft data warehouse in the world. He is a former MVP in both SQL Server and C# and has written three books and more than 35 articles.
Tim Chapman
Contact: http://blogs.msdn.com/b/sql_pfe_blog/
Tim Chapman is a Microsoft Certified Master (MCM) and works as a dedicated field engineer (PFE) at Microsoft specializing in performance tuning and high availability. Originally from Louisville, KY Tim now resides in Columbus, OH Tim has over 12 years of database architecture, programming, and administration experience.
Kevin Boles
Twitter: - @TheSQLGuru
LinkedIn: Kevin Boles
Kevin Boles is a SQL Server expert, working exclusively with the product since v6.5. With over 25 years of database experience and over 45,000 man hours of SQL Server engine experience, he holds many related certifications, is an MCT and was a SQL Server MVP from 2007 to 2012. Kevin has been a very successful independent consultant for over 20 years. His passion is the relational engine, especially designing, building, analyzing and tuning high-performance database applications.
Sarah Barela
Twitter: - @sarahspace
Contact: http://www.sqlsarah.net
Sarah Barela is a Senior Manager at CBeyond Cloud Services, formerly MaximumASP. She has a Master’s degree in Information Science from the University of Texas, where she specialized in Database Management Systems. Sarah has spent over 15 years focusing on the administration of enterprise environments with large numbers of SQL Servers. Sarah is currently responsible for a rapidly growing environment with more than 2000 SQL Server instances. Her latest interests are in applying cloud technologies to SQL Server environments. Sarah has been a guest speaker at a number of PASS Chapter meetings, SSWUG Virtual Conferences, SQL Connections, SQLSaturday events, and the 2007, 2009, and 2010 PASS Summits.
Kevin Boles
Twitter: - @TheSQLGuru
LinkedIn: Kevin Boles
Kevin Boles is a SQL Server expert, working exclusively with the product since v6.5. With over 25 years of database experience and over 45,000 man hours of SQL Server engine experience, he holds many related certifications, is an MCT and was a SQL Server MVP from 2007 to 2012. Kevin has been a very successful independent consultant for over 20 years. His passion is the relational engine, especially designing, building, analyzing and tuning high-performance database applications.
Wayne Sheffield
Twitter: - @DBAWayne
LinkedIn: Wayne Sheffield
Contact: http://blog.waynesheffield.com/wayne
Wayne Sheffield, a Microsoft Certified Master in SQL Server and Microsoft Most Valuable Professional, started working with xBase databases in the late 80’s. With over 25 years in IT, he has worked with SQL Server (since 6.5 in the late 90’s) in various dev/admin roles, with an emphasis in performance tuning. He is the author of several articles at www.sqlservercentral.com, a co-author of “SQL Server T-SQL Recipes”, and enjoys sharing his knowledge by presenting at SQL events worldwide and blogging at http://blog.waynesheffield.com/wayne
Kevin Kline
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.
Colleen Morrow
Twitter: - @ClevelandDBA
LinkedIn: Colleen Morrow
Contact: http://colleenmorrow.com
Colleen Morrow is a database professional living in Cleveland, OH who has been working with database systems since 1996. For more than 12 years, she was a Database Administrator at a large law firm where she developed an appreciation for auditing, automation, and performance tuning. Since that time she has worked with clients in the healthcare, manufacturing, software, and distribution/freight delivery industries. Colleen is currently a Senior Consultant at Fortified Data. She is an active member of the Ohio North SQL Server User Group and has presented at many SQLSaturday events as well as PASS Summit 2014 and 2015.
Sarah Barela
Twitter: - @sarahspace
Contact: http://www.sqlsarah.net
Sarah Barela is a Senior Manager at CBeyond Cloud Services, formerly MaximumASP. She has a Master’s degree in Information Science from the University of Texas, where she specialized in Database Management Systems. Sarah has spent over 15 years focusing on the administration of enterprise environments with large numbers of SQL Servers. Sarah is currently responsible for a rapidly growing environment with more than 2000 SQL Server instances. Her latest interests are in applying cloud technologies to SQL Server environments. Sarah has been a guest speaker at a number of PASS Chapter meetings, SSWUG Virtual Conferences, SQL Connections, SQLSaturday events, and the 2007, 2009, and 2010 PASS Summits.
Jack Corbett
Twitter: - http://twitter.com/unclebiguns
LinkedIn: Jack Corbett
Contact: http://www.wisemanorwiseguy.com
JJack Corbett began working with SQL Server, Access, and VB in 1999, when he served an apprenticeship with a good friend who was the software development manager at the local paper mill. He found his niche and has concentrated on SQL Server development and administration since late 2000. He has worked with SQL Server through version 2017 and was a Microsoft Data Plaform MVP from October 2011 to October 2016.
Jack is passionate about helping companies architect, design, and develop high performance applications based on the Microsoft Data Platform. He also has a passion for seeing database developers get the core application code (the database) protected under source control.
Jack has presented at many user groups and SQLSaturday even
Janis Griffin
Twitter: - DoBoutAnything
LinkedIn: Janis Griffin
Janis Griffin has over 30 years of DBA/database experience including design, development and implementation of many critical database applications. Before coming to Quest Software, Janis primarily worked in the Telecom/Network Industry, working with both real-time network routing databases and OLTP business to business applications. Janis also held positions as a Principal Architect and Senior Manager, mentoring other DBAs on best practices in database performance tuning.
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.
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.
William E Pearson III
Twitter: - @Bill_Pearson
LinkedIn: William E Pearson III
Contact: https://mvp.support.microsoft.com/profile=02C5CD07-7511-4151-A678-3A4A3451F85E
Bill Pearson created Island Technologies Inc. in 1997, and has developed a large and diverse customer base since. Bill#39;s background as a CPA, Internal Auditor, Management Accountant, and SQL Server MVP (BI) enables him to provide value to clients as a liaison between Accounting / Finance and Information Services. Bill has implemented enterprise business intelligence systems over the years for many Fortune 500 companies and focuses his practice upon the integrated Microsoft Business Intelligence
Arie Jones
Twitter: - @programmersedge
LinkedIn: Arie Jones
Contact: http://www.programmersedge.com
Arie Jones (quot;AJquot;) is one of the owners and Vice President of Emerging Technologies for Indy Data Partners, Inc. in Indianapolis, IN. AJ is a frequent speaker at national conferences and local user groups. With over 15 years of experience in application development and database administration on various platforms, he specializes in developing cross-platform solutions with an emphasis on .NET and SQL Server technologies. He blogs extensively at http://www.programmersedge.com.
Rameshdurai Palnisami
Contact: http://www.vsoftconsulting.com
Rameshdurai Palanswami is senior architect with V-Soft having 11+ years of expertise in bringing software products from concept to release based on SQL Server. Involved in designing software products based on .Net SQL Technologies to automate business processes. Involved in implementing business process automation to monitor and improve Service Level Agreements (SLA) using software tools for major BPO and KPO clients in India
Louis Davidson
Twitter: - drsql
LinkedIn: Louis Davidson
Contact: https://www.red-gate.com/simple-talk/author/louis-davidson/
Louis Davidson has worked in the IT industry for over 25 years as a corporate database developer and architect. He has been a Microsoft SQL Server MVP for 15 years and has written five books on database design, and contributed to many other SQL Server books as an author and tech editor. He has a bachelor’s degree in Computer Science from the University of Tennessee at Chattanooga. You can read more about Louis at http://drsql.org.
Dave Fackler
Twitter: - @sqlbiguru
LinkedIn: Dave Fackler
Contact: http://davefackler.blogspot.com/
Dave Fackler is a business intelligence architect, focusing on enterprise data warehouse and business intelligence solutions using Microsoft technologies. Dave has helped organizations design and implement large-scale data warehouses, exploiting SQL Server enterprise database features using dimensional modeling design principles and best practices. He has also architected and developed several enterprise ETL processes using SSIS and its robust set of high-performance tasks and transformations. Dave has delivered various end-user reporting solutions using SSAS and SSRS, often coupled with SharePoint and Office components. Dave speaks about business intelligence at numerous technical conferences, user groups and professional groups each year.
Arie Jones
Twitter: - @programmersedge
LinkedIn: Arie Jones
Contact: http://www.programmersedge.com
Arie Jones (quot;AJquot;) is one of the owners and Vice President of Emerging Technologies for Indy Data Partners, Inc. in Indianapolis, IN. AJ is a frequent speaker at national conferences and local user groups. With over 15 years of experience in application development and database administration on various platforms, he specializes in developing cross-platform solutions with an emphasis on .NET and SQL Server technologies. He blogs extensively at http://www.programmersedge.com.
Jim Deppen
I am current servicing as a Data Architecture specialist to the US Army as a contractor for HP Enterprise Services.
Andy Thiru
Andy aka Abhi has several years of BI experience including planning, design, development and implementation in business database applications.Andy has worked primarily as a consultant holding positions primarily in the Energy,Banking,Media,Consulting. Currently Working on Cloud development Project.
Kyle Neier
Twitter: - @Kyle_Neier
LinkedIn: Kyle Neier
Contact: http://sqldbamusings.blogspot.com/
Kyle has been working professionally with computers since 1995, the past 10 years being dedicated to SQL Server. He currently works as an Engineer for Apparatus (apparatus.net) where he continues to chase his passion to automate DBA processes. He is a proud father of 5, a leader of the local PASS chapter (www.indypass.org), a Microsoft Certified Master (MCM), and enjoys sharing his passion for SQL Server with others by speaking and mentoring at local and regional events.
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.
Rob Volk
Twitter: - sql_r
LinkedIn: Rob Volk
Contact: http://weblogs.sqlteam.com/robv/
Rob Volk is a SQL Server DBA in the Metro Atlanta area since 2001. He also moderates and answers the forums on SQLTeam.com. While an old-time cranky DBA, he no longer considers quot;business intelligencequot; an oxymoron or quot;the cloudquot; as merely atmospheric moisture, and is delightedly dipping his toes into both of these new oceans, and loves to do things in new and and unusual ways.
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.
Andy Thiru
Andy aka Abhi has several years of BI experience including planning, design, development and implementation in business database applications.Andy has worked primarily as a consultant holding positions primarily in the Energy,Banking,Media,Consulting. Currently Working on Cloud development Project.
Sponsors
The following is a list of sponsors that helped fund the event: