SQLSaturday #304 - Indianapolis 2014
Event Date: 08/09/2014 00:00:00
Event Location:
- Indiana Wesleyan University North
- 3777 Priority Way South Drive
- Indianapolis, Indiana
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: Better Decision Making with Power BI
Abstract: For most organizations, business intelligence means requesting reports from IT. The IT people then go into the company’s databases to find the requested information and deliver it. If the decision-makers want the data displayed in a certain way, they have to specify it in their requests—or, as often as not, they have to return to the IT office to make another request when they realize they need the data presented differently. But Power BI is what’s called self-service business intelligence. That means for most purposes non-technical users will be able to crunch the numbers without any help from IT. And switching to different graphics and displays is so easy the main difficulty is deciding which one to use.
Speaker(s):
- Aaron Crouch
Track and Room: Stark - N/A
Title: Building Perfect SQL Servers, Every Time
Abstract: Some of the biggest challenges in any large SQL environment are maintaining consistent configurations and meeting the pressures from the business for rapid server deployments. Join us in this session to learn best practices for system settings, file system layout, and scheduling maintenance tasks.
By default, SQL Server does not install with best practices for every environment. In this session, we will discuss the best practices for most SQL Server configurations, and how to automate your SQL Server builds in both physical and virtual worlds. As you may know, completely automating the build process has great benefits, but it also has great trade-offs. We will talk about lessons learned from building a private cloud at a Fortune 100 telecommunications company with thousands of servers.
You will also learn how use these same methods to ensure your own server build consistency, whether your SQL Servers are in the cloud or on-premises.
Speaker(s):
- Joseph D’Antoni
Track and Room: Snow - N/A
Title: Women in Tech Panel
Abstract: The definition of confidence is “belief in oneself and one’s powers or abilities” but the authors of the new book “The Confidence Code” define confidence as “the quality that turns thoughts into actions.” Traditionally men have been found to have much more confidence in themselves than do women. For example, in a study at Hewlett-Packard, men applied for a promotion when they thought they could meet 60% of the qualifications while women applied only when they thought they could meet 100%. Attend this WIT session with panelists Erin Stellato, Malathi Mahadevan, Ginger Grant, Tamera Clark, Meredith Ryan, and Kathi Kellenberger to learn more about confidence and how it impacts your career and life. To prepare for the session, it is recommended that you complete The Confidence Quiz (http://theconfidencecode.com/confidence-quiz/) before the event and print out the results and recommendation. NOTE: You will not be required to share your results with the other participants during the sessi
Speaker(s):
- Kathi Kellenberger
Track and Room: Snow - N/A
Title: Making the Leap from Profiler to Extended Events
Abstract: If you’re like me, you’ve been using SQL Trace and Profiler since you started using SQL Server. They’re like old friends, tried and true. You know how they work, you know what you can capture, you know how to find the data you need. But now you’ve been told that your good friends have been deprecated in SQL Server 2012, and you need to become best friends with Extended Events. What is THAT all about? It’s ok. Really. In this session we’ll look at Profiler and Extended Events side by side to see how easy it is to transition to Extended Events. We’ll step through real world examples using Extended Events to do what you’re used to doing with Trace, and even more. You can find the time learn Extended Events…today.
Speaker(s):
- Erin Stellato
Track and Room: Targaryen - N/A
Title: Why Re-Invent the Wheel? Build One Solution to Import/ Export Data
Abstract: Most of the projects I work on or have worked on begin with importing some type of data or end with exporting some type of data or both. Why do we continue to build solutions that include the importing or exporting of data? Why have we not taken a practical look at how we solve problems in SQL Server and build our own tools to solve repetitive issues? In this session you will learn some of the practical solutions I’ve implemented so that I never have to build a SSIS package that imports data to enable me to do the real work on the data; I get to do the fun stuff to the data right away because my import process has already been written, the data has been parsed and validated, and I have my data in a form that I can work with immediately. I will demonstrate database design (tables, indexes, etc.), SSIS packages, stored procedures, views, and Columnstore Indexes to process data quickly. Also, I will show a Visual Studio MVC Web application used to manage the solution.
Speaker(s):
- Patrick Brewer
Track and Room: Drogo - N/A
Title: Getting Started With Execution Plans
Abstract: Are you just breaking into the query tuning side of managing your SQL Servers? In this session, we will cover the basics you need to start leveraging execution plans as part of your tuning process. We will discuss how SQL Server creates and uses plans, and how to collect them. Once we have the plans, we will go step-by-step through how to read them, and what the most common operators mean. We will look at the different types of operators not just from a standpoint of what they do, but how they can impact query performance. We will also cover how good database design and maintenance allow you to get better execution plans through having the right indexes and up-to-date statistics.
Speaker(s):
- Scott Fallen
Track and Room: Stark - N/A
Title: Self Service Pitfalls
Abstract: Every Business Department, BI Developer, BI Sales Consultant can put together a snazzy Power Pivot Demo and even prettier Power View Dashboard. They will wow you with capabilities and even convince you that Self Service BI can cure all that ails your organization. And while these tools are very powerful and provide huge benefit to organizations when used properly, in the wrong hands they can cause chaos and confusion. In this session we will discuss common pitfalls when implementing Self Service BI. We will discuss important issues such as Data Quality, Data Security, Properly defining Roles and Responsibilities for end users. Yes, at the end of the day Self-Service BI is very powerful and a GREAT asset to organization, however implementing it properly is more important than the pretty Power View Visualization the sales person shows you!
Speaker(s):
- David Ortiz
Track and Room: Lannister - N/A
Title: 45 min to build your first SSRS report
Abstract: Does this sound like you? You were just given access to SSRS and you want to make a report. Or, you’re a DBA and could use a daily report. Either way, I’ve got your back! You will learn everything you need to know to get that first report out the door quickly and how to tweak it once it’s deployed. We’ll even look at the differences between building a report in BIDS (Business Intelligence Development Studio) and Report Builder 3.0. We’ll use SSRS (SQL Server Reporting Services) 2012. The query makes no difference, this time it’s all about the output.
Speaker(s):
- Tamera Clark
Track and Room: Targaryen - N/A
Title: Database Unit Testing
Abstract: Learn about Database Unit Testing, how it can add value to your projects, and how to do It with Microsoft Visual Studio. Brian will be speaking about the fundamentals of what database unit testing is and the Microsoft Visual Studio Tools for implementing database unit test projects. This talk is intended for audiences who are new to database unit testing and want to learn the basics behind using Visual Studio to perform automated database unit tests.
Speaker(s):
- Brian Beswick
Track and Room: Baratheon - N/A
Title: Every Byte Counts: Why Your Data Type Choices Matter
Abstract: Ever encounter a table consisting only of BIGINT, CHAR(255), and NVARCHAR(MAX) columns? Did your gut tell you that this is bad, but you had difficulty explaining why? Did you know that these Datatype Choices can be a real performance killer? Attend this session, learn how database records are stored within SQL Server, and why all data types are not created equal. Armed with that knowledge, we will then explore several performance scenarios that may be impacting your systems right now! When you leave, you should be able to explain why datatype choices matter to your colleagues, assess your own systems, and implement some best practices to mitigate these performance killers.
Speaker(s):
- Andy Yun
Track and Room: Stark - N/A
Title: Power Power Query Query! (With Julie Smith and Rob
Abstract: Excel-erate All The Data! Power Query finishes the Microsoft Self Service (read: inside Excel) BI Stack by providing Extract-Transform-Load capabilities Come and watch Julie and Rob demonstrate this fun and useful new tool.
Speaker(s):
- Rob Volk
Track and Room: Stark - N/A
Title: Manage SQLServer Efficiently w/PowerShell Remoting
Abstract: You have more and more servers to manage and less time to accomplish everything. You’re writing scripts to automate those tasks but they still take time to run. PowerShell remoting allows you to manage servers without the overhead of Remote Desktop, and allows you to run processes on all your servers simultaneously. In this session we’ll walk through how PowerShell remoting works, how to set it up, and how you can save time getting things done more quickly.
Speaker(s):
- Allen White
Track and Room: Lannister - N/A
Title: T-SQL Window Function Performance
Abstract: Window functions were first introduced with SQL Server 2005 and enhanced with SQL Server 2012. They enable easy development and great performance…well, sometimes. Learn what you need to know to take full advantage of these features. What you don’t know can hurt you when you are using window functions.
Speaker(s):
- Kathi Kellenberger
Track and Room: Snow - N/A
Title: The User Experience of Data Systems
Abstract: The modern business is demanding advanced analytics to drive decisions. However, businesses are discovering that more data does not always equal more value. What good is a petabyte database if no one can make sense of the data? User Experience is not just the domain of mobile apps and web sites! Every developer should know how to effectively present and deliver data. This session will examine user experience principles and techniques and how to apply them to Reporting Services, Power View, and Excel.
Speaker(s):
- Bradley Nielsen
Track and Room: Lannister - N/A
Title: Branding Yourself for a Dream Job
Abstract: Everyone wants a dream job that they enjoy going to each week. However finding that job, and getting yourself hired can be hard for most people. Steve Jones will give you practical tips and suggestions in this session that show you how to better market yourself, how to get the attention of employers, and help improve the chances that the job you want will get offered to you. Learn about networking, blogging, and more.
Speaker(s):
- Steve Jones
Track and Room: Baratheon - N/A
Title: Azure Development - Soup to Nuts
Abstract: Joe Mack from Sogeti will be giving a demo of an end-to-end development scenario using Microsoft’s cloud offerings. You’ll see how to create and deploy an ASP.NET Azure Web Site for displaying data from an on-premise repository and another Azure Web Site to host a RESTful API to do all the heavy lifting. Joe will also demo an automatic deployment of code to an Azure Web Site on check-in from Visual Studio to Microsoft’s cloud-based Team Foundation Services offering.
Speaker(s):
- Joe Mack
Track and Room: Baratheon - N/A
Title: Interrogating the Transaction Log
Abstract: As a SQL Server DBA, I believe that the transaction log is the most important file in any database. Join me to learn why I believe that. You’ll learn how to see a transaction process in the log, what happens when a transaction rolls back, and what the architecture of the transaction log looks like. Plus, you will see how transactions involving SQL Server 2014’s in-memory object are handled by the log.
Speaker(s):
- Frank Gill
Track and Room: Snow - N/A
Title: Transforming Data using the T-SQL PIVOT / UNPIVOT operators
Abstract: Ever wish your horizontal data were vertical for easier data storage, or vice-versa for reporting purposes? Are you writing elaborate routines to transform data for one-time usage? Are your queries repeating “OUTER JOIN, OUTER JOIN, OUTER JOIN” or UNION, UNION, UNION” so often that you wind up back in Kansas when your read them aloud? Join Jeff Foushee as he explains SQL Server’s lesser-known PIVOT and UNPIVOT operators in SQL 2014. After this session, you will no longer need to rotate your monitor!
Speaker(s):
- Jeff Foushee
Track and Room: Baratheon - N/A
Title: Everything Columnstore!
Abstract: SQL Server 2012 introduced the revolutionary idea of columnstore indexes which basically turns the traditional table indexing strategy on its ear. Then in SQL Server 2014, Microsoft upped the ante with updateable columnstore indexes! In this session, you’ll get a deep dive into how columnstore indexes work, the performance gains, the limitations and pitfalls, and how to work around them. There will be plenty of real world examples and demos to boot.
Speaker(s):
- Arie Jones
Track and Room: Drogo - N/A
Title: How to start with XML
Abstract: XML can be a complex and confusing topic. This session will give a basic introduction to some of the XML technologies needed to work with XML in SQL Server as well as some examples of how to get started.
Speaker(s):
- Alan Dykes
Track and Room: Baratheon - N/A
Title: DBA Monitoring and Maintenance Fundamentals
Abstract: The key to becoming a great DBA is time. The best way to regain some time is by spending less time doing the daily mundane work. Let this mundane effort work autonomously. We will introduce the basics in monitoring and maintenance. The how and why certain things should be done at a minimum and what things can be done to help improve the quality of life in larger dynamic environments.
Speaker(s):
- Warren Sifre
Track and Room: Snow - N/A
Title: Creating Access 2013 web apps on SharePoint using SQL Azure
Abstract: The latest release of Access 2013 allows users to easily create web apps with a SQL Azure backend within the SharePoint environment. IT departments are better able to manage user rights to these apps, providing better security, preventing data loss and offer a more robust record set. Attendees will see a real-world app in action and learn about the pros and cons of using Access 2013 web apps.
Speaker(s):
- Andy Tabisz
Track and Room: Drogo - N/A
Title: The Guts of Data Manipulation
Abstract: The SQL Server Query Processor does a great job hiding all the dirty work necessary to display, store, modify, and delete data. When designing, coding, or tuning, however, knowing what’s happening under the hood can be the difference between fast and fail. In this demo-heavy deep-dive session, we’ll follow the query processor as it rips through a database and discover the steps it takes to deliver the results of your queries.
Speaker(s):
- Eddie Wuerch
Track and Room: Stark - N/A
Title: SQL Server Defaults SUCK!!
Abstract: If you just click next-next-next and think you have a good-to-go SQL Server THINK AGAIN!! :-) There are umpteen things you just GOTTA change right out of the box if you want your potentially very expensive and always precious SQL Server resource to perform and behave optimally. This session will cover a laundry list from High Power Setting to data file growth and many useful items in between.
Speaker(s):
- Kevin Boles
Track and Room: Snow - N/A
Title: A Better Introduction to Tabular Mode in SSAS
Abstract: Using live demos, this session will demonstrate Tabular mode in SSAS. With an emphasis on understanding why it works and behaves the way it does, you’ll have the foundational knowledge to learn how to develop effectively in this new mode.
If you’ve been left confused by filter context, nested DAX measures, or the CALCULATE() function, come and get a better introduction. It’s OK to start is a beginner, I just don’t want you stuck there.
Speaker(s):
- Scott Nei
Track and Room: Baratheon - N/A
Title: 45 Minutes to Your First SSAS Tabular Model
Abstract: Have you heard about SSAS Tabular, maybe even know a couple things about it, but haven’t had a chance to dive in and figure out how to develop one yourself? Now is the time! SSAS Tabular is a new form of business intelligence model released with SQL Server 2012, intended as an alternative to more traditional Multidimensional cubes. In this session, we will talk briefly about what Tabular is and what it does, before exploring the development process of creating a tabular model ready for ad-hoc querying.
Speaker(s):
- Kerry Tyler
Track and Room: Stark - N/A
Title: Addressing Trends In Big Data with APS
Abstract: Big Data is a concept frequently talked about, but often misunderstood. This session aims to peel back the covers on “Big Data” by talking about industry trends and focusing on the capabilities of Microsoft’s Analytic Platform System’s Parallel Data Warehouse workload.
Speaker(s):
- Anthony Mattas
Track and Room: Lannister - N/A
Title: Getting Started with Hekaton (In-Memory OLTP)
Abstract: So you’ve heard of Hekaton (In-Memory OLTP) but you aren’t sure where to start or if it’s for you or not. Maybe you’ve heard or read some information and not sure what’s true or not. There’s a number of misconceptions out there about Hekaton. By the end of this session you’ll have a better understanding of what Hekaton is and how it may be able to help you. We’ll discuss the basics of Hekaton and more as well as walking through some demos to show you how to use Hekaton and what it can do as well as help you get started diving into Hekaton on your own.
Speaker(s):
- Brian Davis
Track and Room: Drogo - N/A
Title: The Lost Science of Set Theory
Abstract: Many database developers today do not have a Computer Science degree and may also have begun their career developing software using procedural programming languages (Java, C#, etc.). As a result, they may not have the background needed to conceptualize solutions in terms of sets of data and therefore may not be able to develop efficient set-based queries. In this session, we will review the basics of set theory and how it applies to database development to enable you to turn cursors, loops, and other procedural programming practices into efficient set-based operations that make the most use of a relational database engine.
Speaker(s):
- Aaron Cutshall
Track and Room: Targaryen - N/A
Title: Change Data Capture - What is it and Why I should use it
Abstract: High level overview of Change Data Capture, including what it is, how to configure it and how I can benefit by using it to populate my data warehouse.
Speaker(s):
- Dave Bland
Track and Room: Drogo - N/A
Title: SQL Injection
Abstract: Well, we have all heard about the horror stories of data loss due to SQL Injection and how costly (in many ways) they can be. This in-depth discussion covers various forms of SQL Injection attacks and offers some guidelines on how to avoid them. Lots of code examples in both .NET and TSQL. Watch me hack a website and retrieve user data in just 3 hits on an unprotected html page!
Speaker(s):
- Kevin Boles
Track and Room: Lannister - N/A
Title: Advanced Performance Tuning Tips with Database Performance Analyzer (formerly Confio Ignite)
Abstract: Advanced Performance Tuning Tips with Database Performance Analyzer (formerly Confio Ignite)
Speaker(s):
- Carlos Parra
Track and Room: Stark - N/A
Title: T-SQL Tips Tricks Part 2
Abstract: Do you ever wonder how you can make T-SQL do what you really want? Do you want to know how to make it jump through loops, perform amazing twists and turns, and execute other wondrous performances? In this session you’ll learn even more tricks about various features such as the ever complex CTE, query windowing, and other great features that will enable you to make your T-SQL queries and stored procedures more efficient and give you the results you really want.
Speaker(s):
- Aaron Cutshall
Track and Room: Targaryen - N/A
Title: Power BI in the Fast Lane–Visualizing Formula 1
Abstract: Power BI provides a great toolkit for building data models and doing rapid analysis of data. When you combine the broad capabilities of Power Query to gather external data through a wide variety of data sources and Open APIs. In this session, you will learn about the entire Power BI toolset using data from the current Formula 1 season. You will learn how to use graphics (track maps) as icons for filtering in Power View. You will learn how to relate data in a Power Pivot data model to build complex visualizations. You will learn about Power BI QA and how it can provide answers from your data.
Speaker(s):
- Joseph D’Antoni
Track and Room: Drogo - N/A
Title: DIY Geocoding
Abstract: Do It Yourself Geocoding – Step-by-step instructions on how to build a CLR assembly that will allow you to directly query various web services for geospatial data. We will also learn how to ensure a high level of confidence in the accuracy of your geospatial data.
Speaker(s):
- Frank Murphy
Track and Room: Targaryen - N/A
Title: Writing Better T-SQL Queries with Window Functions
Abstract: SQL Server 2005 and later versions introduced several T-SQL features that are like power tools in the hands of T-SQL developers. If you aren’t using these features, you’re probably writing code that doesn’t perform as well as it could.
This session will teach you how to get great performance, avoid cursor solutions, and create simpler code by using the window functions that have been introduced between 2005 and 2012. You’ll learn how to use the new functions and how to apply them to several design patterns that are commonly found in the real world.
Speaker(s):
- Kathi Kellenberger
Track and Room: Targaryen - N/A
Title: What SQL DBAs need to know about SharePoint
Abstract: With the number of deployments of SharePoint exponentially growing every day, as a DBA, it is very likely you are going to have SharePoint databases on SQL Servers you support. This session reviews SharePoint strictly from the SQL Server perspective. You will learn how SharePoint is optimized for SQL, how to properly manage and maintain the SharePoint databases, how to optimize the SQL configuration for SharePoint, what settings in SharePoint need to be changed or not changed to maintain SQL Server performance, and supported methods for providing high availability and disaster recovery.
Speaker(s):
- JD Wade
Track and Room: Lannister - N/A
Title: DBA 911 - Database Corruption
Abstract: Database corruption is simply a fact of a DBA’s life - if you haven’t seen it yet, you will. Success or failure depends on having a solid plan to deal with different types of corruption. In this session, we will discuss usage of related DBCC commands, monitoring for corruption with SQL Agent Alerts and Jobs, and when to restore versus repair. After attending this session, you will be able to check for corruption, identify different types of corruption, and take the appropriate measures for dealing with it.
Speaker(s):
- David Maxwell
Track and Room: Snow - 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.
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.
Alan Dykes
Contact: http://www.alandykes.com
Alan is a senior quality analyst at First Databank helping to keep pharmacy data error free. He works primarily with SQL Server although he does occasionally enjoy busting out a custom web page now and then.
Patrick Brewer
I live in Central Illinois where I was born, originally from Springfield, Illinois. I started working with SQL Server in 1996 with version 4.2.1 and quickly moved into SQL Server 6.5. I’ve been a jack of all trades developing windows applications and databases, and then moved to mainly developing database solutions with DTS, SSIS and SSRS.
I’ve always said that I want to give my customers the tools to do their jobs.
While I’m not working, I’m an avid sailboat racer in the Star Class. I’ve sailed all around the United States and competed in the 1999 Star Class World Championships in Punta Ala, Italy. Check out starclass.org. I’ve been sailing since I was 5 years old and taught sailing for 8 years.
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.
Carlos Parra
Contact: http://www.solarwinds.com/
Carlos Parra has more than twenty years of DBA experience, including design, development, and implementation of many critical database applications. Before coming to Solarwinds - Confio Software, Carlos applied his skill set in roles which have included programmer, developer, analyst, and database administrator in the financial and healthcare industry.
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.
Jeff Foushee
Jeff Foushee has his MCITP certification in both SQL Server and Windows Server. He is also an Enterprise DBA at Louisville-based Humana, Inc., where he supports almost 20,000 databases on 1,800 SQL Servers. His latest endeavor has been around building a warehouse/website in C#/MVC to automate many database-related processes.
Anthony Mattas
Twitter: - amattas
LinkedIn: Anthony Mattas
Contact: http://www.anthonymattas.com
Anthony Mattas is a Sr. Solution Architect on a world wide team at Microsoft focused on helping customers with distributed data systems.
Anthony has a B.S. in Computer Science Theory and Analysis from Western Michigan University, has multiple MCSE certifications, and is a Microsoft Certified Trainer.
Prior to joining Microsoft Anthony worked as a Business Intelligence consultant for the Microsoft Partner BlueGranite, and also formerly Technical Lead and Architect for a large medical device manufacturer’s global business intelligence platform.
Tamera Clark
Twitter: - https://twitter.com/tameraclark
LinkedIn: Tamera Clark
Contact: http://tameraclark.com
Tamera Clark has been involved in the IT industry for greater than ten years, with experiences ranging from systems analysis/engineering to SQL Server and SSRS administration/development. She is an active member of the SQL Server community, participating in the Women in Technology Virtual Chapter, Co-leading the Nashville BI Chapter, assisting the Nashville PASS Chapter and serving as a Regional Mentor. Tamera is also the event chair of SQLSaturday Nashville.
Aaron Crouch
Contact: http://www.apterainc.com
Aaron Crouch is the Business Intelligence Practice Lead for Aptera. Upon graduating from Purdue University, Aaron immediately began working on Data Warehouses and Business Intelligence (BI) implementations. Throughout his career, Aaron has strategically planned, designed, and developed BI solutions for multiple Fortune 500 companies both in the United States and abroad.
Brian Beswick
LinkedIn: Brian Beswick
Contact: http://brianbeswick.com/
Brian is a Managing Consultant at Allegient. He has many years of experience in database architecture and development across multiple versions of SQL Server. He’s an accomplished Database Architect with a specialty in Business Intelligence. He’s particularly strong at understanding and designing solutions for complex requirements.
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.
Aaron Cutshall
Twitter: - sqlrv
LinkedIn: Aaron Cutshall
Contact: http://sqlrv.com
Aaron N. Cutshall is an Enterprise Data Architect with 20 years of experience in analysis, design and development for applications and databases in manufacturing and warehousing plus over 15 years in the Healthcare Informatics field. His primary focus is in designing and developing solutions for extremely large data sets that perform quite well in SQL Server. He is active in the SQL Server community and speaks at SQLSaturday sessions across the country.
Arie Jones
Twitter: - @programmersedge
LinkedIn: Arie Jones
Contact: http://www.programmersedge.com
Arie Jones (quot;AJquot;) is one of the owners and Vice President of Emerging Technologies for Indy Data Partners, Inc. in Indianapolis, IN. AJ is a frequent speaker at national conferences and local user groups. With over 15 years of experience in application development and database administration on various platforms, he specializes in developing cross-platform solutions with an emphasis on .NET and SQL Server technologies. He blogs extensively at http://www.programmersedge.com.
Frank Murphy
Twitter: - https://twitter.com/dfmurphy20
LinkedIn: Frank Murphy
Contact: http://www.baldmanrunning.com
Brotherhood Mutual is a nation-wide property/casualty insurer that focuses on churches and related organizations. Frank works in the Enterprise Risk Management department as a Geospatial Analyst, where a large portion of his duties involves manipulating spatial data.
Erin Stellato
Twitter: - erinstellato
LinkedIn: Erin Stellato
Contact: http://www.sqlskills.com/blogs/erin
Erin Stellato is a Data Platform MVP and lives outside Cleveland, OH. She has almost 20 years of technology experience and has worked with SQL Server since 2003. Her areas of interest include performance tuning, Query Store, Extended Events, and helping accidental/involuntary DBAs understand how SQL Server works. Erin is an active member of the SQL Server community, has volunteered for PASS at the local and national level, and is a regular speaker at conferences including the PASS Summit, SQLIntersection, and SQLBits. Outside of time with family and friends, she enjoys running, spinning, movies, and all things chocolate.
Andy Tabisz
Twitter: - @AccessWisdom
LinkedIn: Andy Tabisz
Contact: http://www.worksmartdb.com/blog/
Andy Tabisz is a Microsoft MVP and owner of WorkSmart Database Masters based in Grand Rapids, MI. WorkSmart provides custom database and mobile solutions for small to mid-sized corporations using Access, SQL/Azure, ASP.NET, SharePoint, Power BI, Excel and integration with many technologies. Through rapid application development, WorkSmart empowers organizations to work smarter and make better decisions by automating workflow, alerts and reporting capabilities.
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.
Warren Sifre
Twitter: - WAS_SQL
LinkedIn: Warren Sifre
Contact: http://www.broadstrokeconsulting.com/blog/, http://www.allegient.com
Warren Sifre has been in the IT community since 1998 and has worked in a variety of industries deploying solutions utilizing MS SQL Server in one capacity or another. In 2003, he decided to make SQL Server his mastery and has since developed skills in most defined disciplines of MS SQL. Currently he is a Principal Consultant and Technology Leader with Moser Consulting. He is responsible for BI Solution Architecture and the mentorship of team members. He has been a SQLSaturday Speaker since 2012, Azure Global Bootcamp, and many user groups in 2015 alone. He has a passion for knowledge transfer and solutions architecture, with a keen interested in Info Security.
Joe Mack
Joe Mack has been in leadership roles in the military and IT consulting organizations for nearly 20 years. He is an accomplished public speaker and recognized thought leader in the areas of Microsoft development, SharePoint and database/BI tools.
David Ortiz
Contact: http://www.sqlbigpapi.com
David Ortiz is a Solutions Director for The Glenture Group, an NTT Data Company. In this role I am responsible for participating and supporting all packaged solutions for our existing and potential clients. Furthermore, I am responsible for working on building out POC’s and developing potential accelerators leveraging latest technology within the Microsoft BI Stack.
Steve Jones
Twitter: - way0utwest
LinkedIn: Steve Jones
Contact: http://www.voiceofthedba.com/
Steve Jones is a Microsoft SQL Server MVP and has been working with SQL Server since version 4.2 on OS/2. After working as a DBA and developer for a variety of companies, Steve co-founded the community website SQLServerCentral.com in 2001. Since 2004, Steve has been the full-time editor of the site, ensuring it continues to be a great resource for SQL Server professionals. Over the last decade, Steve has written hundreds of articles about SQL Server for SQLServerCentral.com, SQL Server Standard magazine, SQL Server Magazine, and Database Journal.
Scott Fallen
Twitter: - @ScottFallen
LinkedIn: Scott Fallen
Contact: http://blogs.sqlsentry.com/author/ScottFallen/
Scott Fallen (@ScottFallen) is a Solutions Engineering Manager on SentryOne’s Sales team and is responsible for technical sales support. He interacts with customers and prospective customers at conferences and trade shows. He also provides demos and online webinars existing and future users of SentryOne software.
Andy Yun
Twitter: - SQLBek
LinkedIn: Andy Yun
Contact: http://sqlbek.wordpress.com
Andy Yun is a SentryOne Principal Solutions Engineer and a former Microsoft MVP. He has been working with SQL Server for nearly 20 years as both a Database Developer and Administrator. Leveraging knowledge of SQL Server Internals and extensive experience in highly transactional environments, he strives to make T-SQL leaner and meaner. Andy is extremely passionate about passing knowledge onto others, regularly speaking at User Groups, SQLSaturdays, and PASS Summit. Andy is a co-founder of the Chicago SQL Association, co-Chapter Leader of the Chicago Suburban User Group, and part of the Chicago SQLSaturday Organizing Committee.
Aaron Cutshall
Twitter: - sqlrv
LinkedIn: Aaron Cutshall
Contact: http://sqlrv.com
Aaron N. Cutshall is an Enterprise Data Architect with 20 years of experience in analysis, design and development for applications and databases in manufacturing and warehousing plus over 15 years in the Healthcare Informatics field. His primary focus is in designing and developing solutions for extremely large data sets that perform quite well in SQL Server. He is active in the SQL Server community and speaks at SQLSaturday sessions across the country.
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.
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.
Scott Nei
LinkedIn: Scott Nei
Scott Nei is a Senior Data Analytics Consultant with Allegient, focused on development and project management primarily within the Microsoft BI stack. Scott graduated from Ball State University in 2009 with a Bachelors in Economics.
Dave Bland
Twitter: - @SQLDave29
LinkedIn: Dave Bland
Contact: https://www.davebland.com
Over 20 years of SQL Server experience that includes being a DBA, BI development and Application development using VB.NET. Dave currently is the Manager of the DBA team at Stericycle. Dave is a Friend of Red-Gate for 2019. He is a frequent presenter at SQLSaturday events and user groups around the country. Has been teaching SQL Server since version 2000 and is the SQL Server instructor at Harper College in Palatine, IL. Current certifications include: • Microsoft Certified Trainer • MCTS: SQL Server 2008, Implementation and Maintenance • MCTS: SQL Server 2008, BI Development and Maintenance • MCSA: SQL Server 2008 • MCSA: SQL Server 2016 • MCSE: SQL Server 2016 - BI • MCDBA: SQL Server 2000 • MCSD • MCSE: Data Management and Analytics
Frank Gill
Twitter: - skreebydba
LinkedIn: Frank Gill
Contact: http://skreebydba.com/
Frank Gill is a Senior Data Engineer at Concurrency With 21 years of IT experience, the first 8 as a mainframe programmer, he has developed a love of all things internal. Over the past several years, he has worked extensively with SQL Server solution in Azure, including Managed Instance. When not administering databases or geeking out on internals, Frank volunteers at the Art Institute of Chicago and reads voraciously.
Kerry Tyler
Twitter: - AirborneGeek
LinkedIn: Kerry Tyler
Contact: http://airbornegeek.com
Kerry Tyler is a SQL Server, Business Intelligence, and Azure consultant. His initial IT experience was in network engineering and Windows system administration before moving into the data realm. This infrastructure background builds a firm foundation for performance tuning and cloud infrastructure design and implementation. Kerry has full-time DBA experience in SQL Server since version 2000 and business intelligence architecture since SQL Server 2005. In addition to consulting work, he delivers presentations and training on SQL Server administration, business intelligence, and Azure data and infrastructure components.
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”.
Brian Davis
Twitter: - @Brian78
LinkedIn: Brian Davis
Contact: http://blogs.sqlsentry.com
Brian Davis is a Product Integration Engineer at SentryOne and has over 15 years in the IT field in multiple areas including software development, support, user training, and as a DBA. He has been working with SQL Server since 2003 and has hands-on experience with SQL Server 2000 through 2016. Brian is also a PASS Regional Mentor and an active member and leader of the Ohio North SQL Server User Group.
Bradley Nielsen
LinkedIn: Bradley Nielsen
Bradley Nielsen is a Data Science Engineer specializing in the Microsoft BI stack. He is passionate about data driven analysis and has worked with databases since his first college internship. Brad has a Master#39;s in Human Computer Interaction and a Graduate Certificate in Data Science from Indiana University.
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.
David Maxwell
Twitter: - https://twitter.com/dmmaxwell
LinkedIn: David Maxwell
Contact: https://dmmaxwell.wordpress.com/
David Maxwell has almost 20 years of experience with SQL Server, with a keen interest in performance tuning, monitoring, and troubleshooting. He has experience in environments as diverse as health care institutions, auto manufacturers, and insurance companies. David has been a frequent presenter at SQLSaturday events around the United States since 2012, as well as a presenter for the DBA Fundamentals Virtual Group, the Performance Virtual Group, 24 Hours of PASS, and the annual PASS Summit. David participates in his local Columbus Ohio PASS Local Group, where he serves on the board of directors as SQLSaturday coordinator.
JD Wade
Twitter: - https://twitter.com/jdwade
LinkedIn: JD Wade
Contact: http://wadingthrough.com
JD Wade has been providing solutions using various Microsoft products in the St. Louis area for over 18 years. J.D.’s expertise is the architecture, design, deployment, and troubleshooting of SharePoint and Microsoft Cloud solutions as well as interfacing with the surrounding technologies (directory services, e-mail, load balancers, DNS, SQL, WAN accelerators, etc.). J.D. has worked on the deployment of various corporate intranet, extranet, and public-facing web sites.
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”.
Sponsors
The following is a list of sponsors that helped fund the event: