SQLSaturday #51 - Nashville 2010
Event Date: 08/21/2010 00:00:00
Event Location:
- 120 White Bridge Road
- 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: Take the Awesomeness Home: the Data Collector
Abstract: Conferences provide insight into how to query your SQL Servers’ performance, configuration, and needs. But there is a problem for the DBA: how do we quickly apply our new knowledge and scripts to multiple production servers? How do we collect the data we need regularly and query which instances need the most attention? How can we easily create reports proving ROI? In this session, attendees will learn to set up performance data collection with the SQL 2008 Management Data Warehouse (MDW). We will demonstrate how fast it is to create and configure custom data collections, giving examples from simple to complex scripts. This is the tool you need to automate collection for the awesome insights you’ve learned at the SQLSaturday!
Speaker(s):
- Kendra Little
Track and Room: Database Administration - N/A
Title: Database Design for Developers
Abstract: This session is for software developers tasked with database development. Attend and learn about patterns and anti-patterns of database development, one method for building re-executable Transact-SQL deployment scripts, a method for using SqlCmd to deploy re-executable Transact-SQL deployment scripts, and fodder for a lively discussion about NULLs.
Speaker(s):
- Andy Leonard
Track and Room: Session Mix - N/A
Title: Data Dude - Making DB developers more productive
Abstract: Whether you are a dedicated database developer, or a DBA/.Net Developer for whom database development is a secondary job, Visual Studio Database Developer edition, aka “Data Dude” can be a boon to you. In this session we’ll start by reverse engineering an existing database into complete scripts to create the tables, indexes, stored procedures, and more. Deployment strategies will be covered, as well as refactoring and unit testing. Finally we’ll look at the powerful data generation capabilities built into “Data Dude”.
Speaker(s):
- Robert Cain
Track and Room: Database Development - N/A
Title: Design and Implement Like Edison!
Abstract: As the most prolific inventor in American history, Thomas Edison was a master of “Best Practices!” Edison’s creations were not just novel and commercially successful, but many launched entire new industries including electric light and power, sound recording, motion pictures and industrial cement and concrete manufacture. At the heart of Edison’s remarkable record of innovation was his categorization of the innovation process into “competencies,” or bundles of skills supporting the achievement of success in a particular area of endeavor. In this session, we will look at ways that we can use many of these broad success secrets to bring powerful tools and strategies to the recurring implementation of business intelligence solutions.
Speaker(s):
- William E. Pearson III
Track and Room: Database Development - N/A
Title: The Dirty Dozen: PowerShell Scripts for Busy DBAs
Abstract: You’ve heard it said, “If you have to do it twice, automate it.” Cut the learning curve and get a real handle on this powerful automation tool. This session walks you through a dozen scripts to simplify and easily automate time-consuming and tedious elements of your day to day job. This isn’t stuff you’ll use SOMEDAY, these are scripts you can use when you get home tonight. Harness the power of Power Shell to easily find Servers short on space. Script out tables and constraints across all of your databases at once. Backup databases and restore them to a different environment. These tricks and many others will allow PowerShell to simplify your job like no other tool.
Speaker(s):
- Aaron Nelson
Track and Room: Database Administration - N/A
Title: Data Mining with PowerPivot 2010
Abstract: Excel provides a compelling and ubiquitous interface for Microsoft Data Mining. With new features available through PowerPivot, business users can apply the technology through a well-designed infrastructure of Microsoft technologies. This presentation will welcome any newcomers to data mining, and provide interactive demos which highlight data mining through these technologies.
Speaker(s):
- Mark Tabladillo
Track and Room: Professional Development - N/A
Title: What Are You Waiting For?
Abstract: It’s a simple question, right? But how often do you have the answer, especially for your SQL statements? Thomas LaRock from Confio Software will teach you how proper response time analysis plays a key part in the overall performance tuning process. You will learn how to define, measure, and analyze performance issues as well as implementing changes and how to make sure those changes continue to have the desired effects.
Speaker(s):
- Thomas LaRock
Track and Room: Database Administration - N/A
Title: Working with Spatial Data in SQL Server 2008
Abstract: Spatial data is being pushed more and more into the forefront of our application universe. With the advent of MapPoint and Google Maps companies are consistently pushing the boundaries of what traditional databases can do. Now with SQL Server 2008 we have built in spatial data types that will make your life a little easier in the days to come. This session will focus on utilizing these native types to store, analyze, and retrieve spatial data so that you can become the spatial data pro in your organization.
Speaker(s):
- Hope Foley
Track and Room: Database Development - N/A
Title: DBA Survivor
Abstract: Congratulations! You have accepted a position as a Database Administrator. What’s that? Oh, you were told that you were going to be the new DBA? No worries, I am certain you were carefully selected to be the best…of the best…of the best. Now that you have the job, what’s next? What is your action plan? What do you take care of first? And how much more will you get paid?
Speaker(s):
- Thomas LaRock
Track and Room: Cafeteria - N/A
Title: Realizing ROI for Business Intelligence Projects
Abstract: Business Intelligence (BI) is IT that IT should never pay for; it should always be aligned and driven by the business. Statistics for failed data warehousing and BI projects are discouraging, but you can prevent this in your organization. In this session we cover how to assess and agree on realistic return on investment (ROI) calculations before, during and after a BI project in addition to other critical considerations that will assure your BI project remains focused on the needs for all stakeholders.
Speaker(s):
- Douglas McDowell
Track and Room: Business Intelligence - N/A
Title: Are You Following Your Own Best Practices?
Abstract: Everyone has their own best practices that they try to follow. But often times we aren’t sure how well we are following our own or industry best practices. In this session we’ll go into monitoring and managing best practices throughout your environment. The session will look at how to create a solution using policy based management and other tools to report on your compliance to best practices.
Speaker(s):
- Jason Strate
Track and Room: Database Administration - N/A
Title: Stump the “Experts”
Abstract: A group of “experts” will attempt to answer your burning questions about SQL Server, or pretty much anything you want to ask.
Speaker(s):
- Louis Davidson
Track and Room: Cafeteria - N/A
Title: Data Mining in Action: A case study
Abstract: This session will focus on using real world data ( no Adventureworks) taken through the life cycle of a data mining application. Topics will include the details of data mining methodology fine tuyning mining models and validating discoveries
Speaker(s):
- Drew Minkin
Track and Room: Professional Development - N/A
Title: From Access To SQL Server
Abstract: This session is designed to assist the user in migrating from an Access database to SQL Server. A primer is included that describes the differences between databases, relational databases and relational database management systems (RDBMS). Additional background is included to acquaint attendees with various aspects of SQL Server that are often missing from formal training classes. Various reasons are examined for either migrating or not migrating. Required FrontEnd modifications are discussed as well as some pitfalls that a user may experience.
Speaker(s):
- Jack Cannon
Track and Room: Database Development - N/A
Title: The Social DBA: Resources for Career Building
Abstract: Careers in Information Technology (including database professionals) are often viewed as solitary endeavours pursued by hunched-over people in darkened cubicles; the focus of this presentation is to provide the audience with an exposure to a rich social environment of other database professional, including social media, face-to-face interactions, and how (and why) to step into the conversation.
Speaker(s):
- Stuart Ainsworth
Track and Room: Professional Development - N/A
Title: Common TSQL Mistakes
Abstract: As a long-term relational engine consultant, I have seen just about everything. Here is a colleciton of many of the most commonly found problems. We are going to examine a variety of oopsies MANY developers fall prey to - some obvious, some fairly subtle and some down right sneaky! Lots of code examples with the bad AND good code presented.
Speaker(s):
- Kevin Boles
Track and Room: Database Development - N/A
Title: XQuery Basics
Abstract: With the introduction of the XML data type in SQL Server 2005 a new level of flexibility has been introduced to relational database environments to support loosely structured data. To get that data back requires an understanding of XQuery, the powerful query language written for XML specifically. This session will cover the basics of XQuery and help you get up to speed on this new environment.
Speaker(s):
- Allen White
Track and Room: Database Development - N/A
Title: Introduction to SQL Server Statistics
Abstract: This beginner to intermediate level session will introduce you to statistics, including how to create, manage, troubleshoot, and more! Statistics are a key part of getting solid and repeatable performance and is easily just as important as having indexes. Whether you’re a DBA or trying to get by without one, this session will give you the information you need to know.
Speaker(s):
- Andy Warren
Track and Room: Session Mix - N/A
Title: Creating Custom Components for SSIS
Abstract: SSIS data flows are great tools for moving data. But what if you need to go beyond the out-of-the-box components provided with SSIS? Custom components are a great way to encapsulate and reuse functionality for the data flow in SSIS. We will discuss what it takes to create and deploy custom components in SSIS, review the pros and cons of using custom components instead of scripts, and discuss some of the common challenges and issues with creating them.
Speaker(s):
- John Welch
Track and Room: Professional Development - 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: Database Administration - N/A
Title: Keynote
Abstract: TBA
Speaker(s):
- Louis Davidson
Track and Room: Cafeteria - N/A
Title: Building a Professional Development Plan
Abstract: A good professional development plan has to go far beyond ‘learning more technology’, it has to encompass the wide variety of skills you need to build the next step in your career, and it has to include a variety of learning methods. We’ll discuss how much time and money you should budget when building your plan, and how the distribution of time and money changes as your career evolves. We’ll look at the growth phases you’ll encounter, learning how you learn best, how to keep up with new technology without burning out, and even how things like blogging and Twitter can be an interesting part of your plan.
Speaker(s):
- Andy Warren
Track and Room: Professional Development - N/A
Title: Analysis Services 2008 End-to-End
Abstract: Are you interested in designing, building, and deploying an Analysis Services database that follows best practices and best delivers value to your organization? This session goes through the process of optimizing cube creation through the proper design of dimensions, measure groups, aggregations, calculations, perspectives, security, and more. The areas of source code control, deployment, promotion from test to production, processing efficiency, and other areas will be discussed. Craig Utley has experience designing, implementing, and troubleshooting Analysis Services databases at dozens of companies worldwide through his more than 11 years of experience with the Microsoft BI stack.
Speaker(s):
- Craig Utley
Track and Room: Business Intelligence - N/A
Title: Make Reporting Services Work For You
Abstract: Are you frustrated with building reports in SQL Server Reporting Services? Tired of telling your users that you can’t give them the perfect report due to limitations in the product? If so, this session will calm your nerves and make you a guru by showing how to utilize custom code and expressions to shine up your new or existing reports. Specifically, we will show how to create dynamic data groups, use paging techniques, add color and formatting, and more. This session is best suited for people with some knowledge of SSRS.
Speaker(s):
- Jessica Moss
Track and Room: Business Intelligence - N/A
Title: Introduction to MDX for SQL Programmers
Abstract: This 100-level session will provide SQL programmers with the tools to begin querying SQL Server Analysis Services (SSAS) databases. Through examples, including the creation of an SSAS database from the AdventureWorks example database, students will have a primer of knowledge to begin using SSAS to the fullest.
Speaker(s):
- Barry Ralston
Track and Room: Business Intelligence - N/A
Title: Fundamentals of SQL Server Internals
Abstract: Want to know what makes SQL Server tick? Ever wonder what SQL Server is doing when you run a query? Ever wonder which parts of SQL Server are responsible for specific functionality? Want to know what a HOBT is? I can’t promise answers to every question, but I can set you on the path to knowledge about the inner workings of SQL Server.
Speaker(s):
- Jeremiah Peschka
Track and Room: Session Mix - N/A
Title: Taking Control of Your Career
Abstract: Raises, promotions, and job offers don’t happen by accident; you need a plan. Through careful planning you can create and reach impressive goals. But what’s the point of reaching your goals if nobody notices? “If you build it, they will come” doesn’t apply when you’re building your career.
Speaker(s):
- Jeremiah Peschka
Track and Room: Professional Development - N/A
Title: Information Visualization - Designing great Charts
Abstract: This session will provide you with some surprising and interesting insights into how dashboards should be designed. Called Information Visualization, there is a whole line of thinking which maps how the brain interprets what the eyes see. We will translate this into best (and worst) practices related to visualization in dashboard, scorecard, table, and report design. Both funny and informative, you will probably learn, as I did, that you have been designing your dashboards/scorecards and reports badly. We are going to take a visualization test, and learn how to convey information in a clearer, better way. You will be surprised. Join me - this session is going to be hoot!
Speaker(s):
- Wayne Snyder
Track and Room: Business Intelligence - N/A
Title: DMV Emergency Room!
Abstract: If you have ever been responsible for a mission critical database, you have probably been faced with a high stress, emergency situation where a database issue is causing unacceptable application performance, resulting in angry users and hovering managers and executives. This session will show you how to use DMV queries to quickly detect and diagnose the problem, starting at the server and instance level, and then progessing down to the database and object level. This session will show you how to assemble and use an emergency DMV toolkit that you can use to save the day the next time a sick database shows up on your watch in the Database ER!
Speaker(s):
- Glenn Berry
Track and Room: Session Mix - N/A
Title: SQL Server 2008 R2 Utility and Data-tier Apps
Abstract: SQL Server 2008 R2 introduced two new features that improve your ability to manage Database Engine instances. The SQL Server Utility makes it easier to find, consolidate, and manage many instances. Data-tier applications are new units for designing, deploying, and managing databases. Learn how the utility and DACs work together to make it easier for you to track and manage your instances and databases.
Speaker(s):
- Alan Brewer
Track and Room: Session Mix - N/A
Title: Fortress SQL Server
Abstract: In this session we’ll look at how to lock down SQL Server installation starting from the operating system and diving in to SQL Server itself. We’ll take on the mindset of someone in the business of breaking into systems for pay and how they would attack SQL Server. This will lead us to consider the appropriate defenses we need to have in place. Finally, we’ll look at how to take this information and come up with reasonable costs for breaches as well as the defenses we want to put in place to it in order to present to the business side for additional funding/time to secure our systems properly.
Speaker(s):
- Brian Kelley
Track and Room: Session Mix - N/A
Title: Monitoring Data Changes with Change Data Capture
Abstract: Most modern enterprise database environments require some measure of auditing their data. Previously, the DBA would need to put together a complicated web of triggers and history tables in order to properly track data changes. Now in SQL Server 2008, Change Data Capture allows the DBA to readily enact a very straight-forward method for tracking the changes and understanding easily how they took place. In this session, we will examine how to set-up, configure, use, and administer the Change Data Capture process in your environment.
Speaker(s):
- Arie Jones
Track and Room: Database Administration - 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.
Jack Cannon
Jack Cannon holds a bachelor degree in computer science as well as the equivalent of a dual degree in electrical engineering; has over 40 years experience in both hardware and software engineering; worked for 21 years in IBM’s advanced technology laboratories and think tanks; holds three patents; published over 40 articles describing state-of-the-art improvements in computer design; and has achieved the 4th Level Invention Achievement Plateau.
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).
Drew Minkin
Contact: http://dataminkin.blogspot.com
Drew Minkin has been a speaker at the MS Business Intelligence Community, North Texas SQL Server User’s Group and SQLSaturday events across the country , for four years, He worked at Microsoft in SQL Support and in Premier Field Engineering for over six years. After leaving Microsoft, Drew has designed and supported cubes for dozens of Fortune 1000 companies. he has designed data mining models on pricing optimization, fraud detection, customer retention and marketing campaigns
Mark Tabladillo
Contact: http://marktab.net
Mark Tabladillo provides consulting and training for data mining with Solid Quality Mentors. He has taught statistics at Georgia Tech and for the graduate business school of the University of Phoenix. In addition to his Microsoft certifications (MCAD .NET and MCT), Mark has years of deep experience with the SAS System, and has presented at many local, regional, and national technical conferences. Mark produces a data mining resource and blog at http://www.marktab.net
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.
Andy Warren
Twitter: - @sqlandy
Contact: https://sqlandy.com
Andy Warren is a SQL Server consultant and trainer based in Orlando, FL. Focusing on administration, performance tuning, and SQL Server patterns and practices, he’s been a SQL Server MVP since 2008. Andy served two terms on the PASS Board of Directors, was a founding principal in SQLServerCentral, and created both the SQLSaturday and SQLRally event models.
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.
Hope Foley
Contact: http://www.hopefoley.com/
Hope Foley has over 10 years experience in the IT world, she has worked across many industries with small business enterprises, start ups, and Fortune 500 companies. Hope joined PTI in 2007 as a SQL Server Database Administrator/Analyst and last year took over as Principal Microsoft Consultant, where she now leads a team of expert Database Administrators and Developers. More recently Hope has added presenter to her resume, and presents for both PTI and various user groups around the country.
Andy Warren
Twitter: - @sqlandy
Contact: https://sqlandy.com
Andy Warren is a SQL Server consultant and trainer based in Orlando, FL. Focusing on administration, performance tuning, and SQL Server patterns and practices, he’s been a SQL Server MVP since 2008. Andy served two terms on the PASS Board of Directors, was a founding principal in SQLServerCentral, and created both the SQLSaturday and SQLRally event models.
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.
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.
John Welch
Twitter: - @john_welch
LinkedIn: John Welch
Contact: http://agilebi.com/jwelch
John Welch joined SentryOne in spring 2018 as VP of Engineering with the acquisition by SentryOne of the software division of Pragmatic Works. John leads the development of a suite of products that make developing, managing, and documenting data solutions easier. John has been successfully delivering IT solutions to business problems since 1994, and has been focused on business intelligence and data warehousing technologies since 2001. He is a Microsoft Most Valued Professional (MVP), and a frequent presenter on SQL Server and data topics. He also contributes to several open source projects and community initiatives targeted toward making data professionals work more productive.
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.
Barry Ralston
Barry Ralston is Chief Architect for Business Intelligence with Birmingham-based ComFrame Software. Barry is also Microsoft’s Virtual Technical Specialist (VTS) for Business Intelligence, responsible for assisting in Alabama, Mississippi and Northwest Florida sales efforts including customer meetings, software demonstrations and Proof of Concept efforts. Barry’s client successes include: ACIPCO, Georgia Tech Research Institute, Bank of Hawaii, Honda Manufacturing of Alabama and Aflac.
Jessica Moss
Twitter: - @jessicammoss
Contact: http://www.jessicammoss.com
Jessica M. Moss is a well-known architect, speaker, author, and Microsoft MVP of SQL Server Business Intelligence. Jessica#39;s expertise includes data warehouse modeling, Integration Services ETL, Analysis Services semantic modeling, Reporting Services report design, and helping customers across industries successfully implement and enhance their BI solutions. She enjoys sharing her knowledge with the SQL community and has co-authored numerous technical books.
Robert Cain
Contact: http://arcanecode.com
Robert C. Cain is a Microsoft MVP in SQL Development, and works as a Senior BI Architect for ComFrame. In his role he works with clients all over the world, creating global delivery solutions focusing on the Microsoft SQL Server Business Intelligence platform. He is also a contributing author to the book “SQL Server MVP Deep Dives”. Robert has over 20 years experience in the IT field, working in a variety of fields ranging from manufacturing to telecommunications to nuclear power.
William E. Pearson III
Contact: https://mvp.support.microsoft.com/profile=02C5CD07-7511-4151-A678-3A4A3451F85E
Bill created Island Technologies Inc. in 1997, and has developed a large and diverse customer base since. Bill’s background as a CPA, Internal Auditor, Management Accountant and SQL Server MVP (BI) enable 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 solution.
Arie Jones
Contact: http://www.programmersedge.com
Arie Jones ‘AJ’ is the Principal Technology Manager for Perpetual Technologies, Inc. in Indianapolis, IN. Arie leads PTI’s team of expert consultants in planning, design, development, deployment, and management of database environments and applications to achieve the best combination of tools and services for each client. Additionally, AJ is a community speaker, has written several books such as “Learn SQL in 24 Hours”, and blogs extensively at http://www.programmersedge.com
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.
Jeremiah Peschka
Contact: http://brentozar.com
Jeremiah 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 when you need to reinvent something, or get unblocked, you should talk to Jeremiah.
Kendra Little
Contact: http://littlekendra.com
Kendra Little is a Senior DBA in the online advertising industry with seven years of DBA experience and ten years experience with SQL Server. Kendra creates tools to automate database maintenance, implements custom perf monitoring, tunes production servers, and builds SQL Reports for trending. She works closely with an Agile development team to plan and deploy weekly changes. Kendra is passionate about helping build the DBA profession as a dynamic, necessary function for successful businesses.
Stuart Ainsworth
Twitter: - @codegumbo
LinkedIn: Stuart Ainsworth
Contact: http://codegumbo.com
Stuart Ainsworth (MA, MEd) manages a team of Service Reliability Engineers for the Gladiator Enterprise Information Security Services section of Profitstars, a division of Jack Henry and Associates. He’s a former DBA, developer, consultant, and public speaking professor. He’s one of the chapter leaders for AtlantaMDF, and a long-time organizer of SQLSaturday’s. He tweets infrequently (@codegumbo) and blogs even less often at http://codegumbo.com.
Aaron Nelson
Twitter: - SQLvariant
LinkedIn: Aaron Nelson
Contact: http://sqlvariant.com/
Aaron Nelson is an author, public speaker, blogger, and leader in the community. He has over 15 years of experience in architecture, Business Intelligence, development, and performance tuning of SQL Server. Aaron has received many certifications and is a six time winner of the Microsoft MVP Award.
Aaron leads the PowerShell Virtual Group of PASS (SQLPS.io), is a board member of PowerShell.org, and is a volunteer at his PASS Local Group, AtlantaMDF.
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.
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.
Brian Kelley
Twitter: - kbriankelley
LinkedIn: Brian Kelley
Contact: https://truthsolutions.wordpress.com/
Brian Kelley is an author, columnist, Certified Information Systems Auditor (CISA), accredited CISA trainer, and former Microsoft Data Platform (SQL Server) MVP (2009-2016) focusing primarily on SQL Server and Windows security. Brian currently serves as a data architect as well as an independent infrastructure/security architect concentrating on Active Directory, SQL Server, and Windows Server. He has served in a myriad of other positions including senior database administrator, data warehouse architect, web developer, incident response team lead, and project manager. Brian has spoken at 24 Hours of PASS, the Marathon of PASS, IT/Dev Connections, SQLConnections, the SSWUG Virtual Conferences, the Techno Security and Forensics Investigation
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.
Douglas McDowell
Twitter: - @douglasmcdowell
LinkedIn: Douglas McDowell
Douglas McDowell is Chief Strategy Officer for SentryOne. He is a 10-year recipient of Microsoft’s MVP award for Data Platform (and SQL Server), has served as a PASS volunteer (Chapter Leader, Regional Mentor, Board member) since 2001 and a member of the Microsoft Partner Advisory Council for Business Data Platform and Business Analytics (DPBA PAC) since 2005. He has lots of degrees and constantly applies his dry, cutting self-deprecating humor to most situations,
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.
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.
Jeremiah Peschka
Contact: http://brentozar.com
Jeremiah 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 when you need to reinvent something, or get unblocked, you should talk to Jeremiah.
Alan Brewer
Contact: http://msdn.microsoft.com/en-us/library/ms130214.aspx
Alan worked on the Microsoft SQL Server support team from 1992 to 1997, and since 1997 has worked as a senior writer on the SQL Server documentation team. He has helped define and write the Books Online for every release since SQL Server 7.0.
Sponsors
The following is a list of sponsors that helped fund the event: