SQLSaturday #145 - Nashville 2012
Event Date: 10/13/2012 00:00:00
Event Location:
- David Lipscomb University - Swang Business Center
- One University Park Drive
- Nashville, Tennessee
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: Why BI Projects Fail–And What You Can Do About It
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: Business Intelligence - N/A
Title: Custom SQL Server Transaction Log Shipping
Abstract: Using a custom database transaction log shipping process instead of the built in SQL Server transaction log shipping component. Custom database transaction log shipping has several advantages, including: a) The SQL Server instances need not have any connectivity to one another b) Applying of the transaction log backups can be suspended for weeks and then enabled, with the log shipped database being brought as current as the most recent transaction log backup. While transaction log backups are suspended, the Log Shipped Database can be placed in standby/Read Only mode, for querying. c) Using custom database transaction log shipping also allows more control over each part of the process.
Speaker(s):
- J.D. Pellerin
Track and Room: Database Administration - N/A
Title: Adventures in Project Management
Abstract: Projects that run long, run over budget, or flat out fail always get management’s attention, and not good attention. This session will cover the project management process and demonstrate how it can help deliver higher quality results on time and on budget.
Case studies and real world examples will arm managers and team leads with tools including communication management plans, requirements documentation, stakeholder management plans, and change management. These tools will help mitigate and manage common project pitfalls like status update meetings, gold plating, and scope creep.
At the end of the session attendees will be armed with the knowledge necessary to streamline projects and how to deliver a top quality work product.
Speaker(s):
- Jonathan Gardner
Track and Room: Professional Development And More - N/A
Title: Taking the Scary out of Monster Reports
Abstract: So the big wigs have come up with a “master” report that shows everything you could ever want on a single report. It includes grids and charts of varying sizes and complexities. Did I mention they want it pretty as well? In this session we will discuss how to use SQL Reporting Services to bring it all together while avoiding the pit falls and mistakes. The demonstration will show how to build a multi-page, dashboard style report to manage your report server showing a multitude of grids and charts. We will discuss the challenges with data reuse and formatting while exploring techniques for getting them to work. To get the most out of this session, you should be able to build a report in SSRS.
Speaker(s):
- Pam Shaw
Track and Room: Business Intelligence - 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: Database Administration - N/A
Title: Parameter sniffing - make it work for you !
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: Application Development - 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 yield 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: Mixed Sessions 2 - 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: Business Intelligence - N/A
Title: Hardware 301: Diving Deeper into Database Hardware
Abstract: Making the right hardware selection decisions is extremely important for database scalability. Having properly sized and configured hardware can both increase application performance and reduce capital expenses dramatically. Unfortunately, there are so many different choices and options available when it comes to selecting hardware and storage subsystems, it is very easy to make bad choices based on outmoded conventional wisdom. This session will give you a framework for how to pick the right hardware and storage subsystem for your workload type. You will learn how to evaluate and compare key hardware components, such as processors, chipsets, and memory.
Speaker(s):
- Glenn Berry
Track and Room: Mixed Sessions - 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: Mixed Sessions - N/A
Title: Virtualizing SQL Server with Windows Server 2012 a
Abstract: Windows Server 2012 has been acclaimed by industry pundits as the most ambitious release of a Microsoft Server OS since Windows 2000! Windows Server 2012 is now available, and now is a great time to start evaluating it for your next project. Attend this session to learn what’s new in Windows Server 2012 and Hyper-V in Scalability, Virtualization, Storage, Networking and Manageability and get a jump start in preparing for how best to leverage Windows Server 2012 in your environment for SQL Server database workloads.
Speaker(s):
- Keith Mayer
Track and Room: Mixed Sessions 2 - N/A
Title: You Wouldn’t Let HR Manage Your DBs…
Abstract: So don’t let them manage your career. This session will be a panel discussion with three long term IT professionals representing several different career tracks in IT. Learn about how your HR organization works, what salary levels and midpoints are, and get great career advice from our expert panel.
Speaker(s):
- Joseph D’Antoni
Track and Room: Professional Development And More - N/A
Title: Indexing Deep Dive
Abstract: Another in TheSQLGuru’s very popular “Deep Dive” series, this time covering indexing. You will learn about the internal structures of heaps, clustered indexes and nonclustered indexes. We will examine included columns and covering indexes, filtered indexes, indexed views, indexing DMVs and finding the right indexes. There are some incredibly helpful graphics as well as some nice samples to help you transition theory to practice.
Speaker(s):
- Kevin Boles
Track and Room: Database Administration - N/A
Title: Gather SQL Server Performance Data with PowerShell
Abstract: We all know how important it is to keep a baseline of performance metrics that allow us to know when something is wrong and help us to track it down and fix the problem. We don’t always know how to do this easily and consistently. This session will walk you through a series of PowerShell scripts you can schedule which will capture the most important data and a set of reports to show you how to use that data to keep your server running smoothly.
Speaker(s):
- Allen White
Track and Room: Mixed Sessions - N/A
Title: T-SQL: Beyond the Basics
Abstract: If you’ve been writing T-SQL code for a while, but have never delved into what happens after you submit your queries there is a whole world that you are missing. Taking the next step as a T-SQL developer requires understanding the basics of the SQL Server architecture and what it means to use a declarative language. Have you ever wondered why cursors are so slow, why query performance can be unpredictable, or how you can begin to analyze your queries more deeply? In this session we will cover what SQL Server has to do to turn your T-SQL code into the results you expect and how you can use this knowledge to make your code better.
Speaker(s):
- Jon Boulineau
Track and Room: Application Development - N/A
Title: Bad SQL
Abstract: Good Code, Bad Code. It can be the difference between a server running smoothly and an unresponsive piece of junk. This session digs into what makes some SQL code perform faster and scale better. Session is almost all interactive demo.
Speaker(s):
- Geoff Hiten
Track and Room: Mixed Sessions - N/A
Title: The Decoder Ring for Data Warehousing / BI
Abstract: Business Intelligence is one of the hottest job skills in the IT field. DBAs and Database Developers are being asked to implement databases with non-traditional design, and are having a lot of new vocabulary thrown their way. In this talk you will learn the concepts behind building and designing data warehouses, and cut through the buzz words so you will walk away with a clear understanding of what words like dimensions, facts, and measures mean.
Speaker(s):
- Robert Cain
Track and Room: Business Intelligence - N/A
Title: Deeper into Tabular Models - M-to-M and the “W”
Abstract: You will need to understand how many-to-many relationships work in tabular models. While different than dimensional models, you can be successful in getting many of the behaviors you will need. Understanding how filters propagate is necessary requisite. We will use a “W” diagram to understand how this occurs in tabular models. Then we will learn how to force filter propagation, called cross-filtering. Then we will cross-filter conditionally, based on what the user has chosen for filters. If time permits we will also learn how to handle large numbers of fact rows, both in development and production.
Speaker(s):
- Wayne Snyder
Track and Room: Mixed Sessions 2 - N/A
Title: Do SQL XML queries have to scare me?
Abstract: I have seen days of amazing C# XML library coding work replaced by 2 lines of a FOR XML statement in SQL. Built into SQL is the power to make XML do pretty much whatever you need it to. Learn how to use the XML data type and built-in XQuery functions. You will also see how to join (or “bind”) a SQL table to an XML stream to produce a single result set.
Speaker(s):
- Rick Morelan
Track and Room: Application Development - N/A
Title: Virtualizing Business Critical SQL Servers
Abstract: Everyone knows that SQL Server can be virtualized, but most are only virtualizing development and testing environments. Top-tier production workloads can be virtualized too, and David Klee (@kleegeek) will provide valuable insight into how to properly prepare for and implement a successful virtualization campaign for ALL of your SQL Server environments and prepare your organization for the change. Practical tips, tricks, and gotcha’s will be discussed in this dynamic dialog session.
Speaker(s):
- David Klee
Track and Room: Database Administration - 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: Application Development - N/A
Title: Database Design Throwdown
Abstract: Karen and Tom debate about options and best practices of common and advanced design issues, such as:
- Natural vs. Surrogate keys *NULL vs NOT NULL
- Agile Database Design
- Database Refactoring
- How much does Size Matter?
- Who Calls the Shots and Who Does What? …and others. Bring your votes, your debates, and your opinions.
Speaker(s):
- Karen Lopez
Track and Room: Mixed Sessions - 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: Mixed Sessions - N/A
Title: Professional Development
Abstract: Imagine trying to steer a car blindfolded. How about shooting a jump shot without being able to see the goal. It’s not easy, is it? Yet, that’s exactly what your team is doing if you are not providing clear and effective feedback about their work and behavior.
In this session, you’ll learn how to provide effective feedback to your peers and direct reports. You’ll learn how to deliver feedback that encourages the behavior that you’d like to see repeated and provides recommended changes for behavior that is subpar or not acceptable. You’ll also lean how to customize your feedback based on different personality types.
Speaker(s):
- Joe Webb
Track and Room: Professional Development And More - N/A
Title: New Models! An Introduction to Tabular Mode SSAS
Abstract: In this session, attendees will be treated to an introduction to tabular mode. Installation, configuraiton, development tips, maintance, and end user reporting options will all be introduced. A description of BISM and what it means for our beloved Multi-Dimension cubes will be discussed. Attendees wanting to know when to use tabular, and when to stick with multi-dimensional will want to attend this introductory session.
Speaker(s):
- Josh Fennessy
Track and Room: Professional Development And More - N/A
Title: Quiz Bowl
Abstract: A rough cut preview of the SQL PASS opening session game show of SQL and general trivia.
Speaker(s):
- Louis Davidson
Track and Room: Mixed Sessions 2 - 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: Database Administration - N/A
Title: BI in the Cloud
Abstract: In this session we will take a look at some strategies for building Business Intelligence solutions on the Windows Azure platform. We’ll see methods for transferring on-premises data to the cloud, report deployment to Windows Azure Reporting Services and options for performing ad-hoc analysis. We’ll look at some of the challenges faced when moving BI into the cloud, such as high-performance ETL, schema management and transient fault handling.
Speaker(s):
- David Liebman
Track and Room: Mixed Sessions 2 - N/A
Title: I Shoulda Taken That Left Turn at Albuquerque…
Abstract: The first 24 months are extremely important in our careers when we’ve been offered the opportunity to take on the ‘DBA’ role. To be successful, it takes a solid foundation of general concepts, career development, training, fearlessness, confidence, and mentorship from more experienced professionals.
Organization, planning, and having a roadmap to where you are going will be crucial to your success. This session will bring these topics together so you can set your GPS to success avenue.
Speaker(s):
- Mark Swofford
Track and Room: Professional Development And More - N/A
Title: Beginners guide to Table Expressions
Abstract: Common Tables Expressions (CTE) were introduced in SQL 2005. If you have only heard about them and would like to know more about how they work and there benefits this class is for you.
What you will learn:
- The structure and syntax of a CTE
- Benefits of using a CTE vs derived or temp tables
- Recursive CTE’s
- DML with CTE’s
Speaker(s):
- Joe Murphree
Track and Room: Professional Development And More - N/A
Title: SQL Server 2012 AlwaysOn Readable Secondaries
Abstract: One of the most talked about new features in SQL Server 2012 is AlwaysOn Availability Groups and the ability to have readable secondary replicas. In this session, we will cover the pros and cons of using AlwaysOn as well as the basics of how to set it up and take advantage of readable secondary replicas. If you want to improve the availability and performance of your applications databases, are currently using Database Mirroring, or if you’re just curious about AlwaysOn, then you won’t want to miss this session.
Speaker(s):
- Adam Belebczuk
Track and Room: Database Administration - N/A
Title: Slowly changing dimensions- an integrated approach
Abstract: There are many treatments of table design for slowly changing dimenions, and almost as many on doing ETL on an SCD. Much less has been said about building a cube around a slowly changing dimension. In this session, Mark will review the types of slowly changing dimensions, describe the performance implications of various methods of loading SCDs in SSIS (SCD task, Lookups, Merge, and Script component), and build the versioning directly into the dimension in Analysis Services
Speaker(s):
- Mark Stacey
Track and Room: Mixed Sessions 2 - N/A
Title: The Fangorn Forest - ColumnStore Indexes
Abstract: In the fantasy world of Middle-earth live the Ents. The Ents are tall tree-people who help the Fellowship by parallelizing the fight against Saruman. Come and learn how the new SQL 2012 feature, ColumnStore Indexes, can parallelize your Data Warehouse aggregations in the same way. I will be doing a deep dive into the inner workings of ColumnStore indexes.If you are a production DBA who needs to find out about some of the additional hot features that have been included with CSI’s, like batch mode processing and data segments or if you are a BI developer who needs to find out how CSI’s can increase the performance of your aggregations and star-joins by up to 40 times, then this session is for you.
Speaker(s):
- Gareth Swanepoel
Track and Room: Business Intelligence - N/A
Title: What’s new in BI for SQL Server 2012
Abstract: Many new features of SQL Server 2012 enable businesses to leverage Business Intelligence efforts. Come learn what’s new in SQL Server 2012 for BI and the new capabilities with Tabular models, PowerPivot and Power View.
Speaker(s):
- Daniel Evans
Track and Room: Business Intelligence - N/A
Title: TBA - Introductory SQL Session
Abstract: TBA
Speaker(s):
- Denny Cherry
Track and Room: Application Development - N/A
Title: Rewriting bad T-SQL Code
Abstract: This session provides 2 case studies of poorly performing T-SQL code, and works through rewrites into better performing code.
Speaker(s):
- Jeffrey Garbus
Track and Room: Application Development - 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.
Karen Lopez
Twitter: - @datachick
LinkedIn: Karen Lopez
Contact: http://datamodel.com
Karen Lopez is a Sr. Project Manager and Architect for InfoAdvisors. A frequent speaker at conferences and local user groups, she has 20+ years of experience in project and data management on large, multi-project programs. Karen is a chronic volunteer, a Data Platform MVP, and an active advocate for science, technology, engineering, and mathematics (STEM) education and data quality.
Karen’s presentations are known for their lively and interactive approach to learning. Her motto: “Love Your Data!”
Glenn Berry
Twitter: - GlennAlanBerry
LinkedIn: Glenn Berry
Contact: https://glennsqlperformance.com/
Glenn works as a Principal Consultant for Dr. DMV, LLC in Elizabeth, CO. He was a Data Platform MVP from 2007-2017, and he has a whole collection of Microsoft certifications, including MCITP, MCDBA, MCSE, MCSD, MCAD, and MCTS, which proves that he likes to take tests. His expertise includes DMVs, high availability, hardware selection, performance tuning, and Azure SQL Database. He is also an Adjunct Faculty member at University College - University of Denver, where has been teaching since 2000. He has completed the Master Teacher Program at Denver University - University College. He is heavily involved in the SQL Server community, and is a frequent speaker at user groups, SQLSaturdays, and the PASS Community Summit.
Geoff Hiten
Twitter: - SQLCraftsman
LinkedIn: Geoff Hiten
Geoff Hiten is a Technical Solutions Professional at Microsoft. Geoff began working with SQL Server in 1992 with version 4.2 and has used every version since. He specializes in highly available SQL systems, performance tuning, and systems migration. Geoff is heavily involved in the Microsoft SQL Server Community and was initially awarded MVP status in 2004. Geoff was appointed in 2011 to fill an interim Director position at the National PASS organization.
Joe Murphree
I am currently the SR DBA and Manager of the DBA team at HealthSpring which is where I have worked for the past 5 years. I have been a DBA for 7 years now managing mostly MS SQL Server. I have presented multiple times to the Nashville SQL Users group on topics such as Statistics in-depth and Indexes in-depth. I have most recently attended the SQLSkills IE2 Performance Tuning class as well.
Rick Morelan
Rick has worked more than 12 years at Microsoft and has attained over 30 Microsoft technical including certifications in applications, networking, databases and .NET development (MCDBA, MCTS, MCITP, MCAD, MOE, MCSE, MCSE+I). He has also provided training for NW University, Volt Technical Education, The DigiGirlz, and Microsoft. Rick is the Author of the 5 volume SQL Joes 2 Pros book series.
Adam Belebczuk
Twitter: - @SQLDiablo
LinkedIn: Adam Belebczuk
Contact: http://www.sqldiablo.com/
Adam Belebczuk is the Owner amp; Principal Consultant at Belebczuk Consulting Services, LLC and has more than 10 years of experience in IT, ranging from customer service to server/network administration to software and database development and administration. Adam is the Chapter Leader for the Ohio North SQL Server Users Group, a frequent speaker and volunteer at PASS events, and specializes in SQL Server development, performance tuning, high availability, and disaster recovery.
Mark Stacey
Twitter: - @MarkGStacey
Contact: http://MarkGStacey.net
Mark Stacey founded the Aphelion Software Group, and works tirelessly to cross the business/technical boundaries in Business Intelligence, working in both SharePoint and SQL. He has published two books on BI - Sharepoint 2010 BI and Visual Intelligence and frequently speaks at both SQLSaturday and SharePoint Saturday events. Mark is one of the few Microsoft PDW trainers, and has trained in Africa, India and Europe on the PDW, as well as all over the world on other technologies
J.D. Pellerin
J.D. works as a Database Administrator fo CIGNA in Nashville, Tennessee. J.D. has been developing software and databases since 1990 for a wide variety of businesses.
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.
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.
Jeffrey Garbus
LinkedIn: Jeffrey Garbus
Contact: http://mssqlperformance.blogspot.com/
Jeff has been consulting on and performing technical training for MS SQL Server since 1989, Version 4, on OS/2. Since then, he has worked extensively with each release of the product, specializing in performance and tuning, from concept through legacy system, on systems of all sizes, from small start-up company applications to multi-terabyte data warehouses.
In addition to hands-on consulting, he speaks at SQLSaturdays several times/year, has a youtube channel with free training, and has written 20 books on database management systems.
His latest book is “Transact SQL the Definitive Guide.”
Jonathan Gardner
Contact: http://jonathanagardner.com
Jonathan is a Technical Manager, PMP, and MCITP working with Insource Technology in Houston, TX. He has over 10 years of experience with a wide range of IT solutions including Database Administration, Virtualization, SAN Administration, and Windows Server environments.
Wayne Snyder
Twitter: - @sqlwayne
Contact: http://www.msbicentral.com
Wayne Snyder specializes in Business Intelligence solutions and is an international speaker, author, and PASS volunteer. He is a SQL Server MVP and author of the popular Learnkey SQL Server Training series. He is a Distinguished Architect for Mariner (www.mariner-usa.com), who on the weekend sings and plays keyboards for the regional band soundbarrier (www.soundbarrierband.com).
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.
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.
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
Joseph D’Antoni
Twitter: - jdanton
LinkedIn: Joseph D’Antoni
Contact: http://joeydantoni.com
Joseph D’Antoni is a Senior Consultant and Microsoft Data Platform MVP with over 20 years of experience working in both Fortune 500 and smaller firms. He is a Principal Consultant for Denny Cherry Associates and lives in Malvern, PA. He is a frequent speaker at major tech events like Microsoft Ignite, PASS Summit, and Enterprise Data World. He blogs about all topics technology at joeydantoni.com. He believes that no single platform is the answer to all technology problems. Joseph holds a BS in Computer Information Systems from Louisiana Tech University and an MBA from North Carolina State University, and is the co-author of the Microsoft book “Introducing SQL Server 2016”.
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.
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.
Denny Cherry
Twitter: - mrdenny
LinkedIn: Denny Cherry
Contact: https://www.dcac.com
Denny Cherry is the owner and principal consultant for Denny Cherry Associates Consulting and has over a decade of experience working with platforms such as Microsoft Azure, Amazon AWS, Microsoft SQL Server, Hyper-V, vSphere, and Enterprise Storage solutions. Denny’s areas of technical expertise include system architecture, performance tuning, security, replication, and troubleshooting. Denny currently holds several Microsoft Certifications related to SQL Server 2000 through 2019, including being a Microsoft Certified Master, Microsoft MVP and VMware vExpert Award.
Mark Swofford
Contact: http://www.fundamentals.sqlpass.org
Mark Swofford is currently a DBA Manager, and Founder/President of the PASS DBA Fundamentals Virtual Chapter. Mark was the chapter leader of the PASS Virtualization Virtual Chapter for two years, moderated sessions for the 24HOP in 2011 and 2012, and enjoys being part of the SQL community. He is dedicated to teaching the aspiring DBA as well as mentoring DBAs in their first 24 months in the field. Professionally, he has worked as a VP of Software Development, DBA, Senior DBA, and DBA Manager.
Gareth Swanepoel
Twitter: - @GarethSwan
Contact: http://mygareth.com
Gareth Swanepoel is a sysadmin-turned-SQL Server DBA. He has been working in the IT industry doing support and administration for over 25 years. He enjoys solving the complex problems that customers encounter when performance tuning SQL Server or when deploying SQL Server in large data warehouse environments. He is originally from South Africa and is currently a Dedicated Support Engineer (PFE) with Microsoft. He is a passionate member of the SQL Server community and is an accomplished author and speaker having presented at various user groups, SQLSaturdays, the PASS Summit and other technical conferences.
David Klee
Twitter: - kleegeek
LinkedIn: David Klee
Contact: http://davidklee.net
David Klee is a Microsoft Data Platform MVP and VMware vExpert with a lifelong passion for technology. David spends his days focusing on the convergence of data and infrastructure as the Founder of Heraflux Technologies. His areas of expertise include cloud, virtualization, performance, and business continuity. David speaks at a number of national and regional technology related events, including PASS Summit, VMware VMworld, SQLBits, SQLSaturday events, and many SQL Server User Groups.
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.
Jon Boulineau
Contact: http://www.newsqlblog.com
Jon Boulineau is a 12 year it veteran currently working as a DBA for a Fortune 500 company. In addition to his work as a DBA he has survived phases as a network engineer, systems administrator, and developer in his career. He resides in Columbus, GA with his wife and four children.
Craig Utley
Contact: http://www.learnmicrosoftbi.com
Craig Utley is an independent BI professional 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, when he helped write Microsoft’s first data warehousing course. Since then he has consulted at a variety of businesses worldwide on their BI solutions as an independent consultant, a ProClarity consultant, and a member of SQLCAT.
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.
Keith Mayer
Contact: http://KeithMayer.com
Keith Mayer is a Senior Technical Evangelist at Microsoft focused on Windows Infrastructure, Data Center Virtualization, Systems Management and Private Cloud. Keith has over 20 years of experience as a technical leader of complex IT projects, in diverse roles, such as Network Engineer, IT Manager, Technical Instructor and Consultant. He has consulted and trained thousands of IT Pros worldwide on design of enterprise technology solutions.
David Liebman
Twitter: - @BISQLDave
LinkedIn: David Liebman
Contact: http://www.bisqldave.com
I’m a developer specializing in .Net, SQL, and SSRS development for over five years of the eighteen years I have spent in the IT Industry. I have experience working for some big companies in Financial, Healthcare, and Insurance. I have written some custom reporting solutions and web applications for Large Companies in the Tampa Bay area using .Net, SSRS, and SQL.
Daniel Evans
Dan Evans has been working with Business Intelligence solutions for over 15 years and focuses on Microsoft platforms. He’s a TDWI certified business intelligence professional (CBIP) with mastery in business analytics, architecture, and strategy. He currently works at Avanade as a Director of the Business Intelligence Service Line and is Market Lead for the Southeast US. Dan is the President of the Memphis PASS chapter and speaks regularly at PASS chapters, TechEd and TDWI.
Josh Fennessy
Senior Business Intelligence Consultant at BlueGranite, Inc., Josh Fennessy has been working with the Microsoft BI stack exclusivley for the last 5 years. He has earned MCITP in both SQL 2005 and SQL 2008 versions of the tools. Josh is also the chapter leader of the West MI SQL Server Users Group.
When he’s not building BI solutions, he enjoys spending time with his 6 year old son, slinging lead at the range, and exercising (but never in his underwear. Promise!)
Joe Webb
Twitter: - @joewebb
LinkedIn: Joe Webb
Contact: http://theserogroup.com/blog
Joe Webb is a partner for The SERO Group, a Nashville-based SQL Server consulting company. He has over 22 years of industry experience and has consulted extensively with companies in the areas of business process analysis and improvements, database design and architecture, and technical and leadership training. Joe is an 8-time recipient of the Microsoft MVP Award and served on the PASS Board of Directors for 8 years, culminating his tenure as EVP of Finance.
Robert Cain
Twitter: - https://twitter.com/arcanecode
LinkedIn: Robert Cain
Contact: http://arcanecode.com
Robert C. Cain (http://arcanecode.com) is a Microsoft MVP, MCTS Certified in BI, and is the owner of Arcane Training and Consulting, LLC. He is also a course author for Plurasight, author for Red Gate’s SImple Talk website, and co-author of 4 books. A popular speaker, Robert has presented at events such as the SQL PASS Summit, TechEd, CodeStock, and numerous SQLSaturdays. Robert has over 25 years experience in the IT industry, working in a variety of fields ranging from manufacturing to telecommunications to nuclear power.
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.
Pam Shaw
Twitter: - @PamShaw
LinkedIn: Pam Shaw
Contact: http://sqlpam.wordpress.com/
Pam Shaw has been in IT for over 30 years. Since 2001, Pam has been working with SQL Server, first 2000, then 2005, 2008, 2008 R2, 2012 and now 2014. Pam currently works as a BI Developer as an independent contractor. Pam is also the Chapter Leader of the Hillsborough SQL Users Group PASS chapter and organizer of SQLSaturday Tampa.
Sponsors
The following is a list of sponsors that helped fund the event: