SQLSaturday #439 - Columbus 2015
Event Date: 10/03/2015 00:00:00
Event Location:
- Troy University Riverfront Campus
- 1510 3rd Ave
- Phenix City, Alabama
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: Introducing Forensic Analytics with PowerPivot for Excel
Abstract: Despite the wealth of analytical technologies available today, 65% of fraud at public companies is detected through tips, management review, or simple accidents. Forensic Analytics combine human intuition and leading-edge technologies, and can provide superior detection methods to significantly improve the detection and investigation of illegal or unethical activities. In this session, we explore Forensic Analytics: a set of techniques we can use to uncover irregularities in financial data. We also gain an understanding of goals of Forensic Analytics: to enable us to find out how — and why — these irregularities exist, and to find out their source(s) — especially when fraudulent activity is suspected. We discuss guiding principles that are key to isolating data anomalies, and outline a standard, repeatable process to Forensic Analytics. Throughout the session, we view examples of how we can employ PowerPivot for Excel to drive Forensic Analytics via various tests and reviews.
Speaker(s):
- William E Pearson III
Track and Room: Analytics and Visualization - Room 210
Title: Revenge: The SQL! - Director’s Cut
Abstract: Pop quiz DBA: Your developers are running rampant in production. Logic, reason, and threats have all failed. You’re on the edge. What do you do? WHAT DO YOU DO?
Hint: You attend Revenge: The SQL!
This session will show you how to “correct” all those bad practices. Everyone logging in as sa? Running huge cursors? Using SELECT * and ad-hoc SQL? Stop them dead, without actually killing them. Ever dropped a table, or database, or WHERE clause? You can prevent that! And if you’re tired of folks ignoring your naming conventions, make them behave with Unicode…and take your revenge!
Revenge: The SQL! is fun and educational and may even have some practical use, but you’ll want to attend simply to indulge your Dark Side. Revenge: The SQL! assumes no liability and is not available in all 50 states. Do not taunt Revenge: The SQL! or Happy Fun Ball.
Speaker(s):
- Rob Volk
Track and Room: Enterprise Database Administration Deployment - Room 201
Title: Getting Started with Analysis Services 2012 Tabular
Abstract: The Analysis Services 2012 Business Intelligence Semantic Model (BISM) unifies Multidimensional (OLAP) and Tabular (relational) options for organizational BI. In this session, BI Architect, SQL Server MVP and Analysis Services Maestro Bill Pearson introduces Microsoft Business Intelligence 2012 and the Business Intelligence Semantic Model (“BISM”). He then overviews the Tabular model, beginning with the creation of a project with SQL Server Data Tools (“SSDT”), and continuing from the data import steps to the creation and management of calculations, measures and Key Performance Indicators (“KPIs”). Finally, he provides insight to the creation and maintenance of perspectives and hierarchies, as well as other considerations involved in working with Tabular.
Speaker(s):
- William E Pearson III
Track and Room: BI Information Delivery - Room 101
Title: Tone Analysis with HDInsight and Azure Machine Learning
Abstract: People’s sentiments and opinions are written in social networks. There are tweets, Facebook posts, book reviews, forum discussions, and more. These attitudes and feelings are communicated using text, with format depending on the social network. Twitter messages are limited to 140 characters and use hash-tags,; Facebook messages can be longer. This session reviews the different Natural Language Processing, text mining, and data mining techniques you can use for sentiment and tone analysis. Organizations can use the extracted knowledge for brand reputation, market predictions, and automatic learning. We’ll look at, Hadoop, data mining, Microsoft Big Data Hadoop distribution HDInsight and Azure Machine Learning
Speaker(s):
- Paco Gonzalez
Track and Room: BI Information Delivery - Room 101
Title: How do I Get-Started with PowerShell?
Abstract: What’s this thing called PowerShell? Why should I care? And what can it do for me? During this beginner level session, PowerShell MVP Mike F Robbins will be covering all of those questions and many more that are all too common among PowerShell noobs such as: How do I figure out what the commands are? And how do I extend PowerShell’s functionality to manage products like SQL Server? This session is designed for those people who haven’t yet embraced PowerShell and want to know how to get started. The first beta of PowerShell was released 10 years ago and with it now being part of Microsoft’s common engineering criteria, it’s not going away any time soon so what are you waiting for?
Speaker(s):
- Mike Robbins
Track and Room: Enterprise Database Administration Deployment - Room 202
Title: PS C:\gt; Get-Started -With ‘PowerShell Desired State Configuration
Abstract: In this day and age, with the virtualization of servers causing systems in your datacenter to multiply faster than rabbits on Viagra, how do you perform configuration management on all of those systems and the software that they run while operating on a shoestring budget? How do you detect and remediate configuration drift to stay in compliance with your organization’s standards? During this session, PowerShell MVP and scripting games winner Mike F Robbins will demonstrate how DSC (Desired State Configuration) can be used to perform configuration management of your systems. DSC is a new management platform in PowerShell which was introduced with WMF 4.0 that allows for the declarative configuration of systems. Prior experience with PowerShell is recommended.
Speaker(s):
- Mike Robbins
Track and Room: Enterprise Database Administration Deployment - Room 202
Title: Introduction to the Power BI Desktop
Abstract: Most of us are overwhelmed with data from all the different applications that we use on a daily basis. Bringing all the data together is often a very time-consuming and sometimes a challenging process. Even further, attempting to analyze and visualize the data poses new challenges that is sometime difficult or impossible to overcome. Now with Power BI this can all be made very simple. Individuals, ranging from novice information workers to advanced IT professionals can quickly and easily transform, analyze and visualize data using a single tool, Power BI Desktop. In this course we will work through four main topics: Shaping Data, Building a Data Model, Visualizing Data and Using the Power BI Server.
Speaker(s):
- Patrick LeBlanc
Track and Room: Analytics and Visualization - Room 202
Title: Analytics and the DBA – Using BI Power tools to visualize your SQL Infrastructure
Abstract: DBAs do not always have time to work with some of the amazing visual data tools that are becoming common place now for analysts. In this presentation I will show how in just a few very easy steps you can learn more than the basics of PowerView, PowerPivot and Data Mining using data you are already familiar with as a DBA, your SQL Server installation data. We will look at new and interesting way to load, transform, merge and analyze configuration and performance data for many servers simultaneously. I will also demonstrate how to best utilize that data for reports in Excel, SSRS and Visio to get the most out of automation, standardization and visualization with the new Power tools.
Speaker(s):
- Rodney Landrum
Track and Room: Analytics and Visualization - Room 210
Title: Balancing Work and Home to Create a Better You
Abstract: If you are a working professional there is a chance that your career has interrupted your life and you’ve forgotten about you and/or your family. How do you create a healthy balance between the two so that you are happy and everyone else is to? In the session, you will learn how to properly manage time, erase stress, advance at work, address common marriage and family Issues, and ultimately create a better you.
Speaker(s):
- Karlyn LeBlanc
Track and Room: Professional Development - Room 101
Title: Continuous Integration with SQL Server Data Tools
Abstract: After a long maturation process, SQL Server Data Tools is emerging as a huge step forward in database development. It won’t be long before Visual Studio replaces SSMS as the primary IDE for SQL Server developers. One of the greatest benefits of making the switch is the continuous integration capabilities that are now streamlined by the tool set. In this session we will discuss how SSDT works, the goal of continuous integration, and how you can put them together to dramatically improve your productivity as a database developer.
Speaker(s):
- Jon Boulineau
Track and Room: Application Database Development - Room 216
Title: How Queries Work
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 Database Development - Room 201
Title: Table Partitioning Intro and make that a sliding window too!
Abstract: A walk-through of creating a sliding window table partition on an AdventureWorks table.
Speaker(s):
- Jeff Reinhard
Track and Room: Enterprise Database Administration Deployment - Room 210
Title: Sparkhound Top Dog Challenge
Abstract: Do you have what it takes to be Top Dog? If so, come play the “Sparkhound Top Dog” challenge during our SQLSaturday lunch session. Test your Sparkhound knowledge and technical prowess in a fun, interactive game of “Jeopardy!” presented by Sparkies William Assaf, Cody Gros and John Walker. Besides bragging rights, the winner will walk away with a nice treat.
Speaker(s):
- William Assaf
Track and Room: Analytics and Visualization - Room 101
Title: SQL Server Optimization for SharePoint
Abstract: DBAs know that SharePoint just doesn’t play nice with SQL Server. SharePoint administrators know that DBAs just don’t understand SharePoint. This session will show hands-on how to get a SQL Server instance set up effectively for SharePoint 2013. It’s not black magic and it doesn’t involve undocumented trace flags. Maybe DBAs and SharePoint admins can’t get along in social circles, but at least you’ll be able to cooperate after this session.
Speaker(s):
- Sven Aelterman
Track and Room: Enterprise Database Administration Deployment - Room 101
Title: Smart Rats Leave First
Abstract: IT jobs are notoriously short-lived, with most only lasting a few years. Very few people keep a single employer for their entire career. Knowing when, why, and how to leave your job is as important a career step as finding new work. Learn about how to use job transitions as opportunities to develop your career.
Speaker(s):
- Geoff Hiten
Track and Room: Professional Development - Room 210
Title: SQL Server 2014 In-Memory Programming
Abstract: SQL Server 2014 introduces a game changer technology; in-memory objects. This session is a hands-on demo based presentation that will introduce you to what the technology is and how to use it. You will come out of this session with the knowledge and scripts that you can take back to your shop and instantly be productive. You will gain an understanding of the architecture, how to get started, indexes, natively compiled stored procedures and the limitations.
Speaker(s):
- miguel Cebollero
Track and Room: Application Database Development - Room 101
Title: Room for a SQL VIEW
Abstract: What constitutes a view? Do we really need them in database development? Do they serve their purpose? Can we make them faster? At what point have we gone overboard with views? Just some of the questions that will be asked and answered…
Speaker(s):
- Kevin Wilkie
Track and Room: Application Database Development - Room 213
Title: Windowing Functions with SQL Server 2016 (Preview)
Abstract: Windowing functions are powerful analytic functions built into SQL Server. SQL Server 2005 introduced the core window ranking functions, and SQL Server 2012 added time and statistical percentage windowing functions. These functions allow for advanced variable creation, and are of direct benefit to people creating features for data science. This talk will also recommend further reading on this topic.
Speaker(s):
- Mark Tabladillo
Track and Room: Application Database Development - Room 101
Title: Performance Tuning for Mere Mortals Part I
Abstract: In this first part of a two part series, we look at performance tuning from the very beginning. You’re a new DBA, you want to be a DBA, or you’ve been declared an “Accidental DBA” and the phone rings. Someone tells you that they believe SQL Server is having a performance issue, what now? The application is running slowly. Can you help them? Do you even know where to begin to help them? In this session we’ll cover how to handle performance tuning from the very beginning, when the user says “The database is slow.”
Speaker(s):
- Ed Watson
Track and Room: Enterprise Database Administration Deployment - Room 213
Title: Primer on Power BI
Abstract: Power BI (Business Intelligence) is a new and emerging self-service business intelligence and business analytics framework that brings together and enhances a few key Microsoft technologies. We will answer the following questions:
◾What makes Power BI different from the Microsoft Office I have known for years?
◾What are the major Power BI features in Excel 2013 and 2010?
◾What are the major features for Power BI for Office 365?
◾How can our team license Power BI?
Speaker(s):
- Mark Tabladillo
Track and Room: BI Information Delivery - Room 213
Title: Awesome PowerShell for SQL 2014
Abstract: Need to import millions of rows from a CSV in under a minute? No problem. Need to copy all the Users, Databases, and Agent Jobs from one server to another? Done. Need to update all of your development databases to have the same schema, but want to skip the update and only spit out a report if data loss might occur? Piece of CAKE!! These are some of the scenarios that we will cover in this session on how to leverage PowerShell with SQL Server 2014.
Speaker(s):
- Aaron Nelson
Track and Room: Enterprise Database Administration Deployment - Room 202
Title: Performance Tuning for Mere Mortals Part II
Abstract: This is part two of a two part series, looking at performance tuning (i.e. performance troubleshooting) from the beginning. Part II is about the next steps after taking a look at some of the free performance analysis tools. This session will go into more detail about how to capture the current transactions with tools like sp_WhoIsActive stored procedure, Wait Stats, performance counters and Extended Events.
This is a very demo intensive session some basic issues and performance analysis that will be used as a starting point for performance tuning.
There will be homework!
Speaker(s):
- Mike Lawell
Track and Room: Enterprise Database Administration Deployment - Room 213
Title: Self-Service Business Intelligence in Excel
Abstract: The Microsoft Power BI stack began as a set of tools in Excel: Power Query, Power View, Power Map, and PowerPivot. Now that Microsoft has released the Power BI Desktop Application, where do the Excel tools fit in? In this session, we’ll discuss why the Excel tools are still viable for organizations, and attendees will learn how to build reports, charts, and maps using Excel 2013.
Speaker(s):
- Theresa Eller
Track and Room: BI Information Delivery - Room 202
Title: Azure Data Factory: My Data Wandered Lonely as a CLOUD.
Abstract: This is an absolute beginner session on Azure Data Factory. I will cover basic terms and operations and show how to move your data the Azure way.
Speaker(s):
- Julie Smith
Track and Room: Application Database Development - Room 201
Title: Introduction to SQL Server Integration Services
Abstract: Take an introductory journey into the world of SSIS through the eyes of a SQL Server DBA as he navigates the Business Intelligence waters. This is an introductory course for beginners or users without any SSIS experience. Come learn how to SSIS with me!
Speaker(s):
- Ed Watson
Track and Room: BI Information Delivery - Room 216
Title: SQL + SharePoint: Friends Forever
Abstract: Learn from two subject matter experts about best practices to make your SQL Server and SharePoint servers play nice together forever. It will be a 50/50 split of best practices for administering SharePoint farms and their underlying SQL Servers. With a special section on AlwaysOn Availability Groups! William Assaf is a SQL Server MCSE and Cody Gros is a SharePoint SME, both are Principal Consultants in their fields at Sparkhound.
Speaker(s):
- William Assaf
Track and Room: Enterprise Database Administration Deployment - Room 213
Title: Windows Server 2012 R2 High Availability for SQL Server
Abstract: With the increasing adoption rate of virtualization, creating SQL Server clusters is now within reach of many more DBAs. What do you need to know about Windows Server 2012 (R2) virtualization and high availability to set up your first cluster? Come learn from a Windows Server admin and (accidental) DBA who’s been building SQL Server clusters since 2000 (the year and the version!). We’ll discuss initial planning, the process and the maintenance best practices. There will be demos too, so if you want to see a multi-node SQL cluster run on a Lenovo X230 tablet, come see (it’s pretty cool!).
Speaker(s):
- Sven Aelterman
Track and Room: Enterprise Database Administration Deployment - Room 201
Title: Self-Service ETL with Microsoft Power Query
Abstract: In this session, I will introduce you to Microsoft’s new self-service ETL tool “Power Query” for Excel. I will show you, how to source data from various data sources, how you can massage the data and consume the data for your use in the data pipeline. I will introduce you to “M” language that is used in Power Query. I will show you how you can discover and mash data from public data sources within Power Query. If you would like to do ETL quickly without writing SSIS packages, Power Query is the way go. Come and attend this session to learn “Power Query”.
Speaker(s):
- Damu Venkatesan
Track and Room: BI Information Delivery - Room 202
Title: Execution Plans for Mere Mortals
Abstract: This is a beginner session that will look at the graphical execution plan, and the important operators, properties and what to look for in an execution plan. It will discuss the ways to determine a poor cardinality estimate, parameter sniffing and spill to tempdb.
Speaker(s):
- Mike Lawell
Track and Room: Application Database Development - Room 216
Title: Introducing the SSAS Tabular Data Model
Abstract: New to SQL Server Analysis Services 2012 is the Tabular model. In this session you’ll learn about the newest way to do analytics in SQL Server. We’ll compare and contrast it with the traditional Multidimensional Model, then see how to create your first “cube” using the Tabular mode. Finally we’ll look at some of the reporting options for using your new Tabular database, including SSRS, Excel, and PowerView.
Speaker(s):
- Robert Cain
Track and Room: BI Information Delivery - Room 216
Title: Zero to Hero with PowerShell
Abstract: There are two kinds of people in the SQL Server world. Those who are using PowerShell, and those that will be. In this session you’ll learn how to become one of the “cool kids” using PowerShell.
In this session we’ll start with the basics, like cmdlets, variables, and the IDE. But we’ll quickly transition to more advanced topics like flow control, functions, and creating your own objects. By the time you are done you’ll have a good grasp on how to implement your own solutions in PowerShell.
Speaker(s):
- Robert Cain
Track and Room: Other - Room 216
Title: SQL Admin Best Practices with DMVs
Abstract: In this practical and script-focused session, we’ll discuss many best practices regarding SQL Server administration, maintenance, optimizations and monitoring using Dynamic Management Views. DMV’s are essential tools for the SQL administrator, but have a wide range of applications by developers, network engineers and DBAs. We will delve into best practices for server maintenance, index fragmentation, XEvents, wait type analysis and future features. This session will be informative and eye-opening to anyone from a junior DBA on up.
Speaker(s):
- William Assaf
Track and Room: Enterprise Database Administration Deployment - Room 210
Title: So you think MDX is hard?
Abstract: A lot of people have this perception that MDX is difficult. It really isn’t, when you understand what it is trying to accomplish under the hood. In this session we’ll begin with a fundamental understanding of what MDX will do for you. Then we’ll roll up our sleeves and dive into MDX code, starting from the simplest select statement and winding up building calculations you can put into your own SSAS Cubes.
Speaker(s):
- Robert Cain
Track and Room: Application Database Development - Room 101
Title: AlwaysOn Availability Groups Kickoff
Abstract: A run through from start to end of my experience implementing AlwaysOn Availability Groups for High Availability and read only secondary database copies
Speaker(s):
- Jeff Reinhard
Track and Room: Enterprise Database Administration Deployment - Room 201
Title: Self-Service Analysis with Power BI
Abstract: Now with Microsoft Data Platform can perform visual data exploration with any enterprise or cloud based data set today. See how to build out these types of analysis starting with familiar tools in Excel and SharePoint. Get insight into tips/tricks and lessons learned from the field to increase the value of your BI SQL investments and leverage new capabilities with Live Query, Power BI Designer and Power BI to create real-time dashboards and interactive reports on any device.
Speaker(s):
- Dan Evans
Track and Room: BI Information Delivery - Room 202
Speakers
This is a list of speakers from the XML Guidebook records. The details and URLs were valid at the time of the event.
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
William Assaf
Twitter: - william_a_dba
LinkedIn: William Assaf
Contact: http://www.sqltact.com
William Assaf, Data Platform MVP, is a principal consultant in Baton Rouge, LA. Initially a .NET developer, and later into database administration and architecture, William currently works with clients on SQL Server and Azure SQL platform optimization, management, disaster recovery and high availability, and leads a crack multi-city team of consulting SQL DBA’s. William has written for Microsoft SQL certification exams since 2011 and was the lead author of the 2017 and 2019 editions of “SQL Server Administration Inside Out” by Microsoft Press. William is a member of the Baton Rouge User Groups board, a regional mentor for PASS, and past lead of the annual SQLSaturday Baton Rouge Planning Committee, having run one of the largest SQLSaturdays.
Sven Aelterman
Twitter: - @svenaelterman
LinkedIn: Sven Aelterman
Contact: https://svenaelterman.wordpress.com
Sven Aelterman is the Director of IT for the Sorrell College of Business at Troy University; a role with a global scope. He is also a lecturer in Information Systems and teaches courses in data warehousing and information security. He continues consulting work through Adduxis, where he assists customers with various Microsoft technology implementations. Co-author of The Art of SQL Server FILESTREAM, published by Red Gate; and SQL Server 2017 Administration Inside Out, published by Microsoft Press. Cloud Software Architect at Sorrell Solutions, L.L.C. developing a Microsoft Azure-hosted Electronic Health Record system.
Theresa Eller
Twitter: - https://twitter.com/SharePointMadam
LinkedIn: Theresa Eller
Contact: http://www.techresa.com
Theresa Eller is a SharePoint and Office 365 Administrator with a passion for customer success. Her diverse background includes degrees in Public Relations and Teaching and Learning with Technology, as well as 20 years of experience providing technical support, training, and project leadership. Theresa is a leader, speaker, and blogger in the SharePoint and Office 365 Community.
Paco Gonzalez
Twitter: - @pacosql
LinkedIn: Paco Gonzalez
Paco Gonzalez is the CEO of SolidQ North America, and a Microsoft Data Platform MVP. Focused on Business Analytics and Artificial Intelligence, he specializes in helping organizations become data driven from a strategic and technical perspective. Paco is a speaker at small and large conferences such as PASS Summit, Ignite, and Business Applications Summit, and he has published several books and whitepapers. He is based in Atlanta, GA.
Jeff Reinhard
Twitter: - @SQLMajor
LinkedIn: Jeff Reinhard
I have 25 years of database development experience, mostly with SQL Server, with companies such as Ernst amp; Young, Internet Security Systems/IBM, AirWatch, WebMD, CheckFree and others. My recent focus has been on AlwaysOn availability groups and database DevOps.
Mike Robbins
Twitter: - @mikefrobbins
LinkedIn: Mike Robbins
Contact: http://mikefrobbins.com/
Mike F Robbins is a Microsoft MVP on Windows PowerShell and a SAPIEN Technologies MVP. He is a co-author of Windows PowerShell TFM 4th Edition and is a contributing author of a chapter in the PowerShell Deep Dives book. Mike has written guest blog articles for the Hey, Scripting Guy! Blog, PowerShell Magazine, and PowerShell.org. He is the winner of the advanced category in the 2013 PowerShell Scripting Games. Mike is also the leader and co-founder of the Mississippi PowerShell User Group. He blogs at mikefrobbins.com and can be found on twitter @mikefrobbins.
Julie Smith
Twitter: - @juliechix
LinkedIn: Julie Smith
Contact: http://datachix.com
Julie Smith is a Microsoft Data Platform MVP and a BI consultant for Innovative Architects in Atlanta, GA. She#39;s implemented increasingly complex Business Intelligence solutions for over a decade at various organizations. She#39;s also worn many other database “hats” in her career – production DBA and database developer–but data integration and BI are her true passions. Julie holds a BA from the University of South Carolina. She and Audrey Hammonds co-created The Datachix.com blog.
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.
Kevin Wilkie
Twitter: - Oskaruth
LinkedIn: Kevin Wilkie
Contact: http://sherpaofdata.com
Kevin has 15+ years experience with SQL Server and has worked with the product since version 6.5, although he remembers with distaste the early versions of the product. He started working with SQL Server as an “Accidental” DBA, and has moved up through the ranks as a SQL Developer, a BI Associate, and Production DBA at various parts of his career. Currently, he works as a Lead Data Analyst spreading the gospel of how great data can be to anyone and everyone who will listen.
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.
William Assaf
Twitter: - william_a_dba
LinkedIn: William Assaf
Contact: http://www.sqltact.com
William Assaf, Data Platform MVP, is a principal consultant in Baton Rouge, LA. Initially a .NET developer, and later into database administration and architecture, William currently works with clients on SQL Server and Azure SQL platform optimization, management, disaster recovery and high availability, and leads a crack multi-city team of consulting SQL DBA’s. William has written for Microsoft SQL certification exams since 2011 and was the lead author of the 2017 and 2019 editions of “SQL Server Administration Inside Out” by Microsoft Press. William is a member of the Baton Rouge User Groups board, a regional mentor for PASS, and past lead of the annual SQLSaturday Baton Rouge Planning Committee, having run one of the largest SQLSaturdays.
Ed Watson
Twitter: - http://twitter.com/SQLGator
LinkedIn: Ed Watson
Contact: http://sqlgator.com
Ed Watson is a Principal Data Platform Consultant for Improving Enterprises, a full-stack Microsoft consulting firm in Atlanta. Ed is a Microsoft Data Platform MVP since 2014 and like most children, Ed was born at an early age. Today, Ed specializes in the Business Intelligence stack and enjoys specializing in Power BI immensely. He currently lives in Atlanta and is active with the Atlanta MDF and Atlanta BI user groups and is an organizer for SQLSaturday Atlanta, Atlanta BI, and Pensacola.
Dan Evans
Twitter: - @danthebiman
LinkedIn: Dan Evans
Dan Evans is a Data and Analytics evangelist with over 25 years’ experience deploying strategic and innovative analytic solutions. He’s focused on Microsoft technologies including Data Platform, Advanced Analytics and Business Applications. Current focuses include SQL Server, Power Suite, Cognitive Services, Artifical Inteligence and other Data Platform related topics in Azure. Dan presents at many local, regional and national events including SQL PASS, DAMA, TDWI, TechEd and Ignite and supports best practices in Microsoft data and analytics across North America.
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.
Rodney Landrum
Twitter: - @SQLBeat
Contact: https://www.simple-talk.com/blogs/author/2133-rodney-landrum/
Rodney Landrum has been architecting solutions for SQL Server for over 12 years. He has worked with and written about many SQL Server technologies, including DTS, Integration Services, Analysis Services, and Reporting Services. He has co-authored 4 books on Reporting Services. He is been a regular contributor to SQL Server magazine, sqlservercentral.com and Simple-talk.com. Rodney is also SQL Server MVP
Mike Lawell
Twitter: - @sqldiver
LinkedIn: Mike Lawell
Contact: http://sqlserverassociates.com/Blog
Mike Lawell is an 19 year veteran of SQL Server, working with all versions since 6.5. He specializes in performance tuning and high availability as an independent consultant.
He is a Linchpin People Teammate, he also consults with SolidQ, Intellinet and Microsoft Consulting Services.
He is also a certified Scuba instructor with a long bucket list of dive sites.
He resides in Atlanta, GA and you can catch him at many of the SQLSaturdays in the SE region of the United States.
Jon Boulineau
Twitter: - @jboulineau
LinkedIn: Jon Boulineau
Contact: http://jonboulineau.me
Jon Boulineau works as a Data Architect and Data Engineer in Nashville, TN.
miguel Cebollero
Twitter: - SQLMiguel
LinkedIn: miguel Cebollero
Miguel is a father, husband and database professional with more than 18 years of experience. He has held positions in management, database administration, development, architect and BI development. Miguel is a regular speaker at local user groups, regional SQLSaturday and the national PASS Summit conference on various database topics. He has been an avid volunteer, chapter leader, contributor for PASS and published author of Pro TSQL Programmers Guide; ApressMedia, Published 2/27/2015
Karlyn LeBlanc
Karlyn LeBlanc is a native of Chicago, Illinois. She currently resides in the Atlanta, Georgia area. Karlyn obtained her Bachelors degree from Louisiana State University in Baton Rouge and her Masters from Tulane University in New Orleans. Her career began as licensed master social worker where she spent twelve years counseling patients, supervising master level social workers, and facilitating support groups. In addition, she’s a bestselling author of two books and motivational speaker.
William Assaf
Twitter: - william_a_dba
LinkedIn: William Assaf
Contact: http://www.sqltact.com
William Assaf, Data Platform MVP, is a principal consultant in Baton Rouge, LA. Initially a .NET developer, and later into database administration and architecture, William currently works with clients on SQL Server and Azure SQL platform optimization, management, disaster recovery and high availability, and leads a crack multi-city team of consulting SQL DBA’s. William has written for Microsoft SQL certification exams since 2011 and was the lead author of the 2017 and 2019 editions of “SQL Server Administration Inside Out” by Microsoft Press. William is a member of the Baton Rouge User Groups board, a regional mentor for PASS, and past lead of the annual SQLSaturday Baton Rouge Planning Committee, having run one of the largest SQLSaturdays.
Patrick LeBlanc
Twitter: - patrickdba
LinkedIn: Patrick LeBlanc
Contact: http://patrickdleblanc.com
Patrick LeBlanc is a currently a Principal Program Manager at Microsoft and a contributing partner to Guy in a Cube. Along with his 15+ years’ experience in IT he holds a Masters of Science degree from Louisiana State University. He is the author and co-author of five SQL Server books. Prior to joining Microsoft he was awarded Microsoft MVP award for his contributions to the community. Patrick is a regular speaker at many SQL Server Conferences and Community events.
Jeff Reinhard
Twitter: - @SQLMajor
LinkedIn: Jeff Reinhard
I have 25 years of database development experience, mostly with SQL Server, with companies such as Ernst amp; Young, Internet Security Systems/IBM, AirWatch, WebMD, CheckFree and others. My recent focus has been on AlwaysOn availability groups and database DevOps.
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.
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.
Sven Aelterman
Twitter: - @svenaelterman
LinkedIn: Sven Aelterman
Contact: https://svenaelterman.wordpress.com
Sven Aelterman is the Director of IT for the Sorrell College of Business at Troy University; a role with a global scope. He is also a lecturer in Information Systems and teaches courses in data warehousing and information security. He continues consulting work through Adduxis, where he assists customers with various Microsoft technology implementations. Co-author of The Art of SQL Server FILESTREAM, published by Red Gate; and SQL Server 2017 Administration Inside Out, published by Microsoft Press. Cloud Software Architect at Sorrell Solutions, L.L.C. developing a Microsoft Azure-hosted Electronic Health Record system.
Mike Robbins
Twitter: - @mikefrobbins
LinkedIn: Mike Robbins
Contact: http://mikefrobbins.com/
Mike F Robbins is a Microsoft MVP on Windows PowerShell and a SAPIEN Technologies MVP. He is a co-author of Windows PowerShell TFM 4th Edition and is a contributing author of a chapter in the PowerShell Deep Dives book. Mike has written guest blog articles for the Hey, Scripting Guy! Blog, PowerShell Magazine, and PowerShell.org. He is the winner of the advanced category in the 2013 PowerShell Scripting Games. Mike is also the leader and co-founder of the Mississippi PowerShell User Group. He blogs at mikefrobbins.com and can be found on twitter @mikefrobbins.
Damu Venkatesan
Twitter: - @vdamu
LinkedIn: Damu Venkatesan
Damu Venkatesan is a Business Intelligence Consultant with over 25 years of IT experience including architecting and implementing BI/DW solutions using Microsoft SQL Server, PDW, SSIS, SSAS, SSRS, and Power BI. He has been speaking at many SQLSaturdays and user groups on data analytics and is actively involved in the Atlanta SQL community for several years. He has successfully delivered several BI/DW solutions and data migrations to various clients. He is also currently serving as President of DAMA Georgia chapter in Atlanta. He is the co-organizer of BI SQLSaturday in Atlanta.
Jon Boulineau
Twitter: - @jboulineau
LinkedIn: Jon Boulineau
Contact: http://jonboulineau.me
Jon Boulineau works as a Data Architect and Data Engineer in Nashville, TN.
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.
Mark Tabladillo
Twitter: - https://twitter.com/MarkTabNet
LinkedIn: Mark Tabladillo
Contact: http://marktab.net
Mark Tabladillo Ph.D. works for Microsoft as a Cloud Solution Architect for the US CTO Customer Success Team. He has a science doctorate from Georgia Tech. Based in Atlanta, GA, Mark provides cloud enterprise solutions for companies in the US for Microsoft’s strategic clients. He is a chapter leader for the PASS Data Science virtual chapter.
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
Ed Watson
Twitter: - http://twitter.com/SQLGator
LinkedIn: Ed Watson
Contact: http://sqlgator.com
Ed Watson is a Principal Data Platform Consultant for Improving Enterprises, a full-stack Microsoft consulting firm in Atlanta. Ed is a Microsoft Data Platform MVP since 2014 and like most children, Ed was born at an early age. Today, Ed specializes in the Business Intelligence stack and enjoys specializing in Power BI immensely. He currently lives in Atlanta and is active with the Atlanta MDF and Atlanta BI user groups and is an organizer for SQLSaturday Atlanta, Atlanta BI, and Pensacola.
Mike Lawell
Twitter: - @sqldiver
LinkedIn: Mike Lawell
Contact: http://sqlserverassociates.com/Blog
Mike Lawell is an 19 year veteran of SQL Server, working with all versions since 6.5. He specializes in performance tuning and high availability as an independent consultant.
He is a Linchpin People Teammate, he also consults with SolidQ, Intellinet and Microsoft Consulting Services.
He is also a certified Scuba instructor with a long bucket list of dive sites.
He resides in Atlanta, GA and you can catch him at many of the SQLSaturdays in the SE region of the United States.
Mark Tabladillo
Twitter: - https://twitter.com/MarkTabNet
LinkedIn: Mark Tabladillo
Contact: http://marktab.net
Mark Tabladillo Ph.D. works for Microsoft as a Cloud Solution Architect for the US CTO Customer Success Team. He has a science doctorate from Georgia Tech. Based in Atlanta, GA, Mark provides cloud enterprise solutions for companies in the US for Microsoft’s strategic clients. He is a chapter leader for the PASS Data Science virtual chapter.
Sponsors
The following is a list of sponsors that helped fund the event: