SQLSaturday #724 - Madison 2018
Event Date: 04/07/2018 00:00:00
Event Location:
- The Pyle Center, University of Wisconsin-Extension
- 702 Langdon Street
- Madison, Wisconsin
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: Accelerating Development and Testing Using Data Virtualization
Abstract: Constraining everything in development and testing is database size. Storage is a bottleneck, and while faster SSD/Flash is available, it is still too expensive due to the size of many databases, especially in DEV and TEST. More to the point, it takes a lot of time to push terabytes around, and time itself is expensive. The old joke about “good, fast, and cheap – pick any two” is so true with data.
Providing full databases for each developer or tester on each task of each project seems unrealistic, when each copy might require terabytes of storage, so for decades everyone has limited themselves to working in shared dev/test environments that are refreshed only every few months, where conflicts occur, quality suffers, and things move slowly.
Come learn why data virtualization is the solution to a problem everyone knows.
Good, fast, and cheap – have all three with data virtualization. Be able to clone data quickly, and remove the biggest constraint to development and testing.
Speaker(s):
- Tim Gorman
Track and Room: Application Database Development - 335
Title: How to get Microsoft Certified
Abstract: Microsoft has recently streamlined the certification process and this session focuses on what you need to know to get Microsoft Certified on SQL Server. The session is led by an expert Microsoft Certified Trainer (MCT) and Microsoft MVP who regularly teaches the SQL Server certification courses. The presenter walks you through the certifications, exams, and resources available to get you ready for success.
Speaker(s):
- John Deardurff
Track and Room: Professional Development - 226
Title: Analysis Services for the Absolute Beginner
Abstract: Publications across the globe have called “data the new oil.” However, the value of oil is what the oil can be turned into. Similarly, the value in data is in what you derive from it, not the data itself.
Regardless of the title you carry, DBA, developer, report writer, ETL developer, manager etc., now is the time to make an acquaintance of Analysis Services. Come, join in as we define basic terms, investigate a few uses cases and see some simple examples. You will soon see that if data is the new oil, Analysis Services, on-premises or in the cloud, is a key component in the new refinery.
Speaker(s):
- Peter Shore
Track and Room: BI Platform Architecture, Development Administration - 213
Title: Building the HASSP: Putting SQL Server In Space
Abstract: In today’s world, technology is a pervasive part of our lives. We have “smart” appliances everywhere: from cars, thermostats, and even refrigerators contain built-in systems to collect, store, and transmit data. Small embedded devices can also be used for scientific purposes as well, offering new and exciting ways to collect data for studies or projects at home.
The High-Altitude SQL Server Project, or HASSP, is one such project.
The HASSP team has created a high-altitude balloon that uses sensors to collect various data points and store the results in an embedded version of SQL Server!
In this session, you’ll hear about how this is possible: we’ll discuss the hardware used, the custom device that we built, and the software used to make it all work together. Best of all, you’ll see how to recreate (and hopefully improve!) the project on your own.
Speaker(s):
- Drew Furgiuele
Track and Room: Strategy and Architecture - 226
Title: Targeting Wait Statistics with Extended Events and DMVs
Abstract: When troubleshooting overall server performance, wait statistics are a great place to start. But when your SQL Server hosts a complex set of workloads, it can be difficult to narrow down which queries are causing the most wait, and what types of wait they are causing. Fortunately, SQL Server provides easy ways for targeting which queries are causing you the most wait time. In this session, we’ll learn how to use both Extended Events, and Dynamic Management Views new to SQL Server 2016 for examining wait statistics at a query level, rather than at the server level. We’ll analyze poorly performing queries using a combination of methods and show how to quickly narrow down what SQL Server is waiting for, and why.
Speaker(s):
- David Maxwell
Track and Room: Application Database Development - 226
Title: Locks, Blocks, and Snapshots: Maximizing Database Concurrency
Abstract: The ability for multiple processes to query and update a database concurrently has long-been a hallmark of database technology, but this feature can be implemented in many ways. This session will explore the different isolation levels supported by SQL Server and Azure SQL Database, why they exist, how they work, how they differ, and how In-Memory OLTP fits in. Demonstrations will also show how different isolation levels can determine not only the performance, but also the result set returned by a query. Additionally, attendees will learn how to choose the optimal isolation level for a given workload, and see how easy it can be to improve performance by adjusting isolation settings. An understanding of SQL Server’s isolation levels can help relieve bottlenecks that no amount of query tuning or indexing can address - attend this session and gain Senior DBA-level skills on how to maximize your database’s ability to process transactions concurrently.
Speaker(s):
- Bob Pusateri
Track and Room: Application Database Development - 235
Title: T-SQL Tips Tricks to Make Your Life Easier!
Abstract: Do you spend your days slinging T-SQL code? Want to improve your T-SQL game? If you answered yes, then this session is for you.
This demo-intensive session will showcase a collection of my favorite beginner and intermediate level tips and tricks. We will explore how to identify and fix some common T-SQL anti-patterns, my favorite SSMS productivity tricks, and clever solutions to some common but not easily-coded challenges.
This session targets both developers and DBAs; the only prerequisites are the desire to write better T-SQL code and aim of living an easier life!
Speaker(s):
- Andy Yun
Track and Room: Application Database Development - 313
Title: Gathering Trending Data with PowerShell
Abstract: Join me in the quest to become a PowerShell DBA! Learn how to improve your career by quickly accessing logistical information within a database rich environment. Discover how PowerShell tools can enable you to gather and store information in a functioning repository, placing views and functions from a day, a week, or even a year ago, right at your fingertips!
Speaker(s):
- Ben Miller
Track and Room: Application Database Development - 325
Title: Microsoft Machine Learning Services
Abstract: SQL Server 2017 Machine Learning Services is more than just R and Python language support for SQL Server. SQL Machine Learning Services provides analytics for any size of data, runs in SQL Server, or alongside Windows, Linux, HDInsight Spark or Hadoop clusters, is simple to administer and allows you to integrate and deploy simply. In this session, learn architecture and deployment options, stand-alone and in-database, along with some real-world use-cases. Learn how to leverage Machine Learning Services with new TSQL language support, training and deploying models, scaling beyond memory with RevoScaleR to generating millisecond predictions in-database. With any size data environment, SQL Machine Learning Services can provide analytics in both an operationally sound and easy to administer paradigm.
A beginner level understanding of Machine Learning and process is highly recommended but not required. Beyond SQL Machine Learning Services, an overview of all Microsoft Machine Learning
Speaker(s):
- Andrew Loree
Track and Room: Analytics and Visualization - 235
Title: Power BI Bookmarks: Four Business Use Cases
Abstract: So you’ve gathered the requirements, made sure the ETL is perfect, the model queries in milliseconds, and the report is both functional AND fashionable. There’s always that one person(and usually a few) that wants to see the data with a different visual, or with filters applied a certain way. In this session, we will go in depth on the bookmarking feature in a live demo using the framework of four business cases.
Power BI Pagination I’ll take an existing dataset previously used for a SSRS report and add Page forward and backward buttons to it in Power BI Change and Reset ALL filters and slicers I’ll reset/update filters and slicers across multiple tabs in a report with a single button Swapping out visuals with one click The director wants to see the visual but the VP wants to see the table Executive Presentation Create a finely tuned presentation with nothing but Power BI
Bring your own dataset and build out these scenarios with me as I demonstrate each one live from scratch.
Speaker(s):
- Eric Fait
Track and Room: Analytics and Visualization - 235
Title: SQL Data Recovery - Do you know where your DR plan is?
Abstract: We will cover some other alternatives for getting a copy of your data offsite, and what offsite could mean. Are you a smaller shop, do you have limited infrastructure, just a subset of data need to be protected ? We will review some alternative solutions to get your data copied and some cloud solutions to provide an offsite destination.
Speaker(s):
- Phil Ekins
Track and Room: Strategy and Architecture - 332
Title: Reading Execution Plans Successfully
Abstract: If you’ve seen an execution plan but didn’t know how to read it, this session is for you.
The goal of this session to learn how SQL Server is interpreting your query into an execution plan. We’ll discuss execution plan internals, how SQL Server estimates the cost of your query, and what a graphical execution plan is displaying through its operators.
Learning to read an execution plan is a great way to begin troubleshooting performance. At the end, we will take a look at how SQL Server 2016 (and 2017) provide more tools for exploring execution plans.
Speaker(s):
- Arthur Daniels III
Track and Room: Application Database Development - 326
Title: Administering and Deploying Power BI Solutions
Abstract: To create a successful data culture Business needs the freedom to explore and analyze data. At the same time IT needs to understand what is being used for a variety of reasons such as access and data security. When Power BI is used as the analytics solution, companies need a clear understanding of how to best implement Power BI and make it work for the entire organization. This session will explore key administrative functions, such as, how to monitor the environment, how why you want to control certain features, and granting access permission. We’ll also walk through several key strategies for a successful deployment within your organization and analyzing some Pros and Cons with sharing implementations.
Speaker(s):
- Seth Bauer
Track and Room: BI Platform Architecture, Development Administration - 225
Title: Difficult Queries
Abstract: Take your T-SQL skills to the next level. Regardless of your current level there will be something here you’ll be glad you didn’t miss. Basics like avoiding cursors in iterative tasks and multi-database executions are the tip of the iceberg. If queries are basic arithmetic then this is basic algebra. First we see how coding style affects maintainability then dive into several types of encapsulation, parameterization and tricks with values, cross apply, pivot and more .
Speaker(s):
- Rick Bielawski
Track and Room: Application Database Development - 225
Title: Three Steps to Lasting Encryption
Abstract: You’ve encrypted your data! You’ve used the latest techniques. It’s strong. It’s safe. You’re done, right? Not so fast. Encryption gets weaker with age - keys are lost, algorithms are cracked, techniques become obsolete. In time, the system breaks down, rendering your data either irretrievable or unprotected.
To keep your encryption at full strength, you need to add three practices to your regular maintenance schedule. First, backup your keys frequently and securely to ensure you can always retrieve the data you’ve encrypted. Second, rotate your keys regularly to limit your exposure due to a lost or compromised key. Third, add an encryption key management solution (like Azure Key Vault) to make managing large numbers of keys easier or to enable someone else to manage the keys. In this session, we’ll discuss how you can implement each of these practices in your own environment.
Speaker(s):
- Ed Leighton-Dick
Track and Room: Strategy and Architecture - 235
Title: Data Testing Integrity – BI Edition
Abstract: Unit Testing and Test-Driven Development are common practices in application development. In SQL development we’ve even got tSQLT! In the realm of BI with desperate systems, integration layers, data warehouses and even cubes we need a better approach.
In this session, we’ll discuss different problem scenarios and practical solutions. We’ll identify the need to look at the data from the business perspective and define specific integrity checks to ensure our data is accurate. Then the fun part! Using the Microsoft BI tool-set, we will walk-through a working solution demonstrating a way to efficiently centralize this process.
At the end of the session, we’ll all still agree that we can’t use a unit test or record counts to ensure that data is accurate. You will have a simple solution that you can start with to work in your environment and look at data testing integrity differently.
Speaker(s):
- Rob Long
Track and Room: BI Platform Architecture, Development Administration - 213
Title: Practical Introduction to Artificial Intelligence
Abstract: Have you ever wondered how an AI solution is built? In this session we will demystify the process and walk through how machine learning can be applied to solve a real-world problem.
Starting from a multi-year dataset of thousands of mechanical devices, we’ll review and explain the steps it took to build a machine learning model that is able to predict when a device is about to fail. Specifically we’ll cover:
- What is AI and Machine Learning?
- Defining the problem
- Feature Engineering
- Model Selection
- Model Training and Evaluation
- Production Considerations
While the use case we will cover was implemented in R, our focus will be on the overall process so you can take what you’ve learned an apply it to your toolset of choice. You’ll leave with a better understanding what AI is and how machine learning works.
Speaker(s):
- Juan Muñoz
Track and Room: Analytics and Visualization - 313
Title: Data Vault 2.0 An Introduction To A Better Data Warehouse Database Designing Method
Abstract: As Dan Linstedt, the creator of Data Vault 2.0, describes it as follows: The Data Vault Model is a detail oriented, historical tracking and uniquely linked set of normalized tables that support one or more functional areas of business. It is a hybrid approach encompassing the best of breed between 3rd normal form (3NF) and star schema. The design is flexible, scalable, consistent and adaptable to the needs of the enterprise. Data Vault 2.0 is not an app but a database modeling methodology that overcomes many of the shortcoming of DW warehouse modeling. Data vault attempts to solve the problem of dealing with change in the environment by separating the business keys from the descriptive attributes of those keys. This class will go over the basic parts of the Data Vault 2.0 model along with examples of each.
Speaker(s):
- Thomas Lane
Track and Room: Strategy and Architecture - 235
Title: Why Should I Care About … Partitioned Views?
Abstract: Partitioned tables are awesome and partitioned views are dead, right? Well, sure partitioned views are not sexy but there are still plenty of applications where they are critical. And not necessarily just for standard edition who aren’t on the new service pack yet. If your data is time stamped, do you see different queries run against older data than new data? Do you with you could segment your data across multiple columns? Do you have data you need to partition horizontally? It’s possible partitioned views may still be for you. Come hear why this is still an important topic long after cargo pants and trucker hats went away … and possibly even after 2016 SP1.
Speaker(s):
- Rick Lowe
Track and Room: Application Database Development - 326
Title: Know different AWS Database Products - their benefits and key features
Abstract: AWS offers a broad range of databases purpose-built for your specific application use cases. It offers managed Relational, Non-Relational, Data Warehouse, In-Memory Data Store, and Graph Databases. AWS fully managed database services include relational databases for transactional applications, non-relational databases for internet-scale applications, a data warehouse for analytics, an in-memory data store for caching and real-time workloads, and a graph database for building applications with highly connected data. To migrate their existing databases to AWS, the AWS Database Migration Service makes it easy and cost effective to do so. The specific session will cover all the different databases products offered by AWS and the features and the key benefits and also the key clients who all use the products and catering to their specific needs.
Speaker(s):
- Sourav Mukherjee
Track and Room: Cloud Application Development Deployment - 313
Title: XML vs JSON - Battle Royale
Abstract: Shiny new touch bar MacBook Pro under one arm, JSON strolls in with a coffee from that new place with the ethically sourced beans. Grizzled XML looks up from an old ThinkPad and grunts, remembering that the stained company mug on the cluttered desk had been empty for some time. JSON was sure to be assigned the new web features while XML would be spending another week on those legacy third party integrations…
SQL Server 2016 brings JSON support, but does that mean XML is old news? Which has more features? Do they matter? Which is faster?
We’ll review the many similarities and highlight some important differences between SQL Server 2016’s XML and JSON support. You’ll leave equipped to make the right choice for your environment.
Speaker(s):
- Riley Major
Track and Room: Application Database Development - 332
Title: Shortcuts from an Impatient DBA
Abstract: This session is about performance tuning your day.
We spend a lot of time thinking about how to write efficient code, but we don’t spend a lot of time thinking about how to be efficient with how we use our tools. In this session I will show you some lesser known keyboard shortcuts, tips, tricks, and hacks that will make your day easier. These are the tricks I’ve picked up over the years that help me get my work done quicker and easier.
Even the most seasoned Database Professionals will learn a new trick that makes SSMS even easier to use.
Speaker(s):
- Andy Mallon
Track and Room: Professional Development - 226
Title: When Low-Quality Data Strikes: Fuzzy Tools Provide Clarity in Matching and Deduplication
Abstract: You have a high-quality dataset, appropriately keyed, groomed, and trusted by business users. Then you’re asked to merge in a new, low-quality dataset. It may contain a different key structure, numerous text fields with typos, or optional fields that are empty on most records. How would you find as many accurate matches as possible? You can define multiple matching algorithms to handle the various discrepancies you find, but it can be difficult and time consuming to prevent missing matches. In this session, I will showcase how you can solve problems like this using the fuzzy tools natively available in SQL Server. I will explain how a fuzzy approach compares to other options such as exact match algorithms, weighing the pros and cons. Finally, I will demonstrate how to set up the groundwork to incorporate fuzzy tools into a data flow solution. By the end of this session, you should have another tool in your toolbelt that can aid you in any matching or data deduplication scenario.
Speaker(s):
- Jared Kuehn
Track and Room: BI Platform Architecture, Development Administration - 213
Title: COZYROC: Dynamic Data Flows in SSIS without Programming
Abstract: This session is an introduction to the unique functionality offered by COZYROC to create integration packages that dynamically map columns at runtime. The standard SSIS Data Flow Task can only use static metadata which is defined when the package is initially designed. The mapping of columns is configured and remains unchanged until the package is re-opened and design changes are made, thus costing maintenance time and effort. Data Flow Task Plus extends the capabilities of the standard Microsoft Data Flow task in that it allows you to set up dynamic data flows, thus eliminating maintenance time and effort. Changes to tables and columns are automatically incorporated at runtime without the need to change and redeploy the package. Columns and fields are mapped automatically at runtime. Furthermore, the initial design time and effort may be greatly reduced when dealing with huge amounts of data in a large number of files and/or databases.
Speaker(s):
- Diane Schuster
Track and Room: BI Platform Architecture, Development Administration - 325
Title: The SQL Server Transaction Log for Developers
Abstract: SQL Server tracks all changes to a database’s data and schema in the transaction log. This makes it the most important file in any database. Understanding transaction log architecture and behavior will help you develop code that will maximize performance and minimize resource consumption. Join me to learn about transaction log architecture, batching transactions, rollback activity, and the effect these things can have on performance.
Speaker(s):
- Frank Gill
Track and Room: Application Database Development - 332
Title: Azure SQL Database Performance Tuning
Abstract: When using Azure SQL Database, you’re paying for performance. In this session, you’ll learn what tools and techniques are now available to help you be cost-effective. You’ll see how to use features such as scaling, in-memory OLTP, and columnstore to minimize query run times and optimize resource use. Query Performance Insight and Automatic Tuning will be covered so you know how to monitor your environment and automate tuning. You’ll be ready to get the most performance for the least amount of money from SQL Database.
Speaker(s):
- Jes Schultz
Track and Room: Cloud Application Development Deployment - 335
Title: Emergency! Are You Ready for Disaster to Strike?
Abstract: Most of the time pilots are learning to fly, they’re actually learning how to recover from emergency conditions. While we as Database Administrators focus on taking backups, how much time do we actually spend practicing recovering with those backups? This session will focus on the kinds of situations that can dramatically affect a data center, and how to use checklists to practice recovery processes to assure business continuity.
Speaker(s):
- Allen White
Track and Room: Strategy and Architecture - 332
Title: JSON for the Data Mortals
Abstract: In SQL Server 2016 Microsoft has include native handling of JSON. What does that mean? What is JSON? Why do I care? Come to this session and you will learn what JSON is, where and how it is used and why as a data professional you need to know this.
Speaker(s):
- Jim Dorame
Track and Room: Application Database Development - 332
Title: Azure Analysis Services: Purpose, Migration, Benefits, and Tools
Abstract: This presentation will briefly go over the history of OLAP and Microsoft’s contribution to the technology. The bulk of the conversation will then be an introduction to Azure’s analysis services implementation - how to use it, how much it may cost, a comparison to on-premises implementations, and how to migrate from on-premises. Then more intermediate subjects will be discussed, such as analysis of best practices and automation techniques, future features Microsoft is working on, and future research considerations for a more advanced look at Azure Analysis Services.
Speaker(s):
- Turner Kunkel
Track and Room: Cloud Application Development Deployment - 335
Title: Extended Events: What are they and How do I use them
Abstract: Extended Events are an essential part of properly monitoring and every DBA should know what they are and how to use them. This session will cover the basics of Extended events as well as an introduction to the system_health session. This session will give someone who has never used Extended events before the skills to start using them!
Speaker(s):
- Dave Bland
Track and Room: Application Database Development - 225
Title: Tips and Tricks from PowerBI.Tips
Abstract: A collection of helpful tips to help you work faster and more efficiently in Power BI. Topics include, loading data, using parameters, creating date tables, Time based calculations such as Percent Change, Using R visuals, Using Report Themes.
Speaker(s):
- Michael Carlo
Track and Room: BI Information Delivery - 325
Title: Everyone Has a Story to Tell: Developing Your First Presentation
Abstract: Ever considered giving a presentation of your own? Pondered how your favorite speakers got their start? Contemplated whether you could ever do that too, but were not sure where to begin?
Well I say you can and will show you how to get started! In this session, I will teach you how to develop your idea and create session content, and share tips tricks that I have learned along the way.
You will leave armed with a wealth of resources (and hopefully some inspiration) to venture forth and develop your first presentation.
Speaker(s):
- Andy Yun
Track and Room: Professional Development - 226
Title: Women In Technology - Panel
Abstract: This year we have 4 WIT panelists joining us for a session for discussion of issues pertinent to women working in technology. We will have Gina Meronek – IT Manager – B-Cycle, Denise Gomez – Chief Nursing Information Officer – UnityPoint Health, Audrey Drake – Sr. Manager of Technology – Baker Tilly, and Heidi Rozmiarek – Director of Application Development – Stericycle.
Speaker(s):
- SQLSaturday Madison
Track and Room: Other - 335
Title: Real-time Analytics with Azure
Abstract: Ever wanted to analyze data as it happens? Azure provides an impressive suite of services to enable real-time analytics. We begin our session with an overview of real-time analytics and its role in business today, then we dive into streaming data architecture on Azure, followed by a demo where we build a fully-functional streaming data pipeline with Azure Stream Analytics and present insights in real-time with Power BI.
Speaker(s):
- Jordan Anderson
Track and Room: Cloud Application Development Deployment - 313
Title: Administering your Azure SQL Database
Abstract:
Administration tasks for a PaaS service like Azure SQL Database are different than for a regular SQL Server. This session will walk you through the unique management tasks for administering an Azure SQL Database.
Topics covered will include:
• How you manage an Azure SQL Database differently than a SQL Server
• Securing the Azure DB
• Monitoring the database
• High Availability
• Scaling
• Automation
Speaker(s):
- Mike Shelton
Track and Room: Cloud Application Development Deployment - 335
Title: Four Rules For Columnstore Query Performance
Abstract: You’ve read all the Books Online articles about Columnstore indexes for data warehouses, but everything sounds too good to be true. Can you really get the promised 10X query performance without changing any code? In this demo-packed session, you’ll learn real world lessons from deploying Columnstore indexes in production, and how you can avoid many query performance issues by following four simple rules. This is an advanced session recommended for attendees who already know the basics of Columnstore technology.
Speaker(s):
- Joe Obbish
Track and Room: Application Database Development - 225
Title: Building a Microsoft Business intelligence Solution step-by-step
Abstract: Overview of the Microsoft BI Technologies BI Solution Topology BI solution requirements Data Modeling Relational Dimensional Data Warehouse ETL Tabular and Multidimensional Models. Insights and Visualization Agile methodologies Tips for success
Speaker(s):
- Farouq Abukhamireh
Track and Room: BI Platform Architecture, Development Administration - 213
Title: SQL 2017 on LINUX
Abstract: See how SQL 2017 Looks and feels while running under various LINUX and Container (Docker) platforms. Examine the various installation scenarios as well as the tools associated with the product. Co-Existence between the Windows and Linux environments will be shown and explored.
Speaker(s):
- Charles Hyman
Track and Room: BI Platform Architecture, Development Administration - 213
Title: Polybase In Action
Abstract: Polybase is Microsoft’s newest way of integrating SQL Server with external systems such as Hadoop and Azure Blob Storage. In this talk, we will get an overview of the Polybase technology and then implement it to work with an on-premises Hadoop cluster as well as Azure Blob Storage. We will then dive into the mechanics of how Polybase works, using packet captures to understand the cross-network communication. Finally, we will look at ways of tuning common Polybase scenarios and look at a few less-common scenarios.
Speaker(s):
- Kevin Feasel
Track and Room: Application Database Development - 313
Title: In memory database… Let’s rethink that request!
Abstract: Many times users or management ask for something that they’ve heard about but don’t quite understand, in hope of solving a problem that doesn’t quite make sense. It is possible to put a SQL Server database in memory, and memory is faster than disk, so this has just got to be a good idea!
This session looks at what you can do to put a database in memory, at what problems that can help, and at what problems it won’t affect noticeably. It also looks at the recommended way to put tables into memory and the problems that will solve.
Speaker(s):
- Pat Phelan
Track and Room: Strategy and Architecture - 326
Title: SQL Server on AWS
Abstract: Presented by Brian Lewis, Solutions Architect at Amazon Web Services
Speaker(s):
- SQLSaturday Madison
Track and Room: Cloud Application Development Deployment - 326
Title: DEA (not what you think) Will Be Your New Best Friend!
Abstract: Database Experimentation Assistant (DEA) is Microsoft’s new tool to help you collect, replay, and analyze a production workload against several configurations of SQL Server to compare performance. It even provides graphs of queries that performed worse after a change so that you can revisit those before making your change! Microsoft PFE, Jared Karney, will show you how to install, configure, and run this new tool and demonstrate how easy it can make your future upgrades and configuration changes.
Speaker(s):
- Jared Karney
Track and Room: Strategy and Architecture - 326
Title: Let’s build a data app with Azure Functions!
Abstract: Are you interested in learning how to leverage Azure Functions to create an app that can scale to demand?
In this session, we will walk through the architecture and components of creating an Azure-facing video processing application that can scan videos for text and provide that information in CSV files for analysis. We will cover the architecture, data flow, and Azure technology pieces including Azure Functions, Blob Storage, Storage Queues, Azure Data Lake Storage Analytics, and Power BI.
Speaker(s):
- Joshuha Owen
Track and Room: Cloud Application Development Deployment - 325
Title: Custom Activities in Azure Data Factory
Abstract: There are a lot of impressive out of the box capabilities with Azure Data Factory. Also, just like in SSIS, you can extend these capabilities using custom code (.Net in V1 or any executable in V2). We’ll discuss the prerequisites for Azure needed to implement these activities, as well as step through some code examples in C#, including how to setup your development environment. Prior experience with Azure Data Factory is highly recommend for this session.
Speaker(s):
- Jared Zagelbaum
Track and Room: Cloud Application Development Deployment - 325
Title: Columnstore 101: The Five Ws of Columnstore Indexes
Abstract: While Columnstore Indexes were introduced with SQL Server 2012, their popularity and general use haven’t increased nearly as much as their functionality since then. If you’re someone that’s not had much experience with Columnstore Indexes and want to learn more about them, this session is perfect for you as I plan to cover the Five Ws of Columnstore Indexes: what they are, when to use them, where they are best utilized, and most importantly why they work so well. You’ll be the “who” and after the session, I expect you’ll feel more confident and excited to use this great feature.
Speaker(s):
- John Eisbrener
Track and Room: Application Database Development - 225
Speakers
This is a list of speakers from the XML Guidebook records. The details and URLs were valid at the time of the event.
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.
Pat Phelan
Twitter: - @YetAnotherSQL
LinkedIn: Pat Phelan
Pat Phelan first joined a computer user group (DECUS) in High School, and has joined many more since then. Pat worked many jobs in high school and college, and over twenty years for a major accounting firm. Pat started working for Involta in 2007 and is now the database mentor and a member of the Engineering team. Involta builds, owns and operates world class colocation datacenters and also provides managed services and support staff to clients.
Ed Leighton-Dick
Twitter: - eleightondick
LinkedIn: Ed Leighton-Dick
Contact: http://www.edleightondick.com
Ed Leighton-Dick is a Microsoft MVP, SQL Server performance and architecture specialist, and Founder/Principal Consultant of Kingfisher Technologies. He is a frequent volunteer with PASS, including current roles as a Regional Mentor, co-leader of I-380 PASS local group, and co-leader of the HA/DR virtual group. He can often be found teaching sessions at local, regional, and national events, including user groups, SQLSaturday, and PASS Summit.
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.
Jordan Anderson
Twitter: - https://twitter.com/flightsoft
LinkedIn: Jordan Anderson
Contact: http://blogs.talavant.com/
Jordan has over 10 years of experience as a consultant, analyst, and developer of business intelligence and analytics solutions. He has a proven background in business process analysis, planning, and strategic alignment across numerous business functional areas in a wide range of industries. Jordan is proficient in cross-functional team facilitation, organization, leadership, and cultivating cooperative relationships with project sponsors and stakeholders.
Jordan brings an extensive track record of delivering successful technology solutions that align with the business, engage people, and produce value. Jordan drives teams with a focus on creativity, relevance, quality, and high performance.
Jared Karney
Twitter: - jaredkarney
LinkedIn: Jared Karney
Jared Karney has been working with SQL Server since 2007. He currently works as a Premier Field Engineer for Microsoft. His specialties include performance tuning, big data, cloud, automation, internals, and overall architecture. He is an MCT and holds a number of Microsoft certifications. He is also a leader for the Chicago SQL Server Users Group.
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.
Rob Long
Twitter: - @robjlong
Rob Long is Chief Architect and Co-Founder of Talavant. Rob is passionate about developing solutions that improve the delivery of data warehousing and business intelligence solutions. He has a breadth of experience including development, network administration and database administration. For the last 8 years, Rob has focused his efforts on delivering solutions on the Microsoft BI stack. He is a proud father of four, a Certified Business Intelligence Professional, and enjoys spending time with family and keeping up with the ever changing data management industry.
SQLSaturday Madison
SQLSaturday Madison
John Eisbrener
Twitter: - @johnedba
LinkedIn: John Eisbrener
Contact: http://www.dbatlas.com
John is a DBA (Default Blame Assignee) with over a decade of experience breaking and subsequently fixing, database solutions. He maintains separate swear jars for Oracle, Postgres, and Greenplum, but keeps the largest container reserved for SQL Server. When not accumulating loose change for his children’s college funds, John can be found trying to help others with their database solutions as the Principal Consultant for DB Atlas, speaking at various SQLSaturdays throughout the Midwest, or helping out with his local PASS chapter meetings in Madison, WI.
Joe Obbish
Contact: https://orderbyselectnull.com
Joe Obbish has nearly a decade of experience with SQL Server and other database platforms. He works as a query tuning, columnstore, and scalability expert within Epic, a large EHR and analytics vendor in Madison, WI. In less than two years, he became one of the top contributors for SQL Server on the DBA StackExchange community. Joe blogs about advanced columnstore and query tuning topics on his blog, http://www.orderbyselectnull.com. In his spare time, Joe enjoys baking and sharing these treats with his coworkers.
Rick Bielawski
LinkedIn: Rick Bielawski
Rick has 35 years experience as a systems, applications and database architect having designed major systems for such institutions as NASDAQ, Bank of America, Blue Cross Blue Shield, Ecolab and Emperex. He holds multiple certifications including MCITP and MCSE in Business Intelligence and Data Platform. Rick currently designs database systems for custom software applications and likes speaking at local user groups and SQLSaturday events.
Riley Major
Twitter: - RileyMajor
LinkedIn: Riley Major
Contact: http://www.Scribnasium.com/
Riley Major is an Enterprise Architect based in the Twin Cities, MN metro area who enjoys collaborating with business leaders to design technical solutions and working with technology professionals to build them. He’s been programming and designing databases since he was a kid and doing so professionally for 20 years. He has a special place in his heart for T-SQL in SQL Server and loves to share that enthusiasm.
John Deardurff
Twitter: - SQLMCT
LinkedIn: John Deardurff
Contact: https://www.sqlmct.com
John has been a Microsoft Certified Trainer (MCT) for over 20 years teaching Azure, SQL Server, Exchange Server, and Windows Server networking courses. He is currently a SQL Premier Field Engineer for Microsoft. He is an MCT Regional Lead for the Eastern United States and a former Data Platform MVP.
Joshuha Owen
Twitter: - SQLJosh
LinkedIn: Joshuha Owen
A Data and AI Premier Field Engineer by day and tech geek at all times. I enjoy working with data technologies as well as dabbling in other areas such as VR programming.
Ben Miller
Twitter: - DBAduck
LinkedIn: Ben Miller
Contact: https://dbaduck.com
Ben has been a member of the SQL Server Community since 2000. He loves a challenge and has fixed many SQL Servers and helped hundreds of people get more out of their DBA jobs. He is a Data Platform MVP a SQL Server Certified Master (MCM). He has worked at various companies throughout the USA, as well as at Microsoft for 7 years. He is passionate about SQL Server Infrastructure, High Availability, Automation and Integration using SMO and PowerShell. He teaches DBAs how to use PowerShell to do their job and teaches SQL Server Internals. He is @DBAduck all around the web (Twitter, LinkedIn, Facebook, Blog) so let’s catch up.
Juan Muñoz
LinkedIn: Juan Muñoz
Juan began his career in the field of bioinformatics — data science applied to biologic problems. Those early experiences opened his eyes to possibilities that the technologies behind AI can accomplish. He has spent his career at the intersection of software development, data management and data science, which has given him the unique ability to design innovative intelligent software systems.
Juan is a Senior Technology Consultant at Omni where he is focused on AI offerings. Prior to Omni, Juan was a consultant focused on the life science and healthcare verticals.
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.
Sourav Mukherjee
Twitter: - https://twitter.com/sourav_tech
LinkedIn: Sourav Mukherjee
Sourav Mukherjee is a Senior Database Administrator based out of Chicago. He has more than 12 years of experience working with SQL Server Platform. His work focus in Microsoft SQL Server started with SQL Server 2000. Being a Consultant worked with different Chicago based client projects. He has helped many companies in designing and maintaining their high availability solutions and providing query performance tuning to improve the overall SQL Server performance.
He holds a bachelor’s degree in Computer Science, Master’s Degree in Project Management. He is an MCT (Microsoft Certified Trainer) and TOGAF, PMP and ITIL Certified. He writes articles and blogs in LinkedIn and other social media sites.
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.
Arthur Daniels III
Twitter: - ArthurDanSQL
Contact: https://www.DBA-Art.com
Arthur Daniels is a Premier Field Engineer (PFE) at Microsoft. He has focused on diagnosing and optimizing performance on very large databases in mission critical environments.
Jared Zagelbaum
Twitter: - @JaredZagelbaum
LinkedIn: Jared Zagelbaum
Contact: https://jaredzagelbaum.wordpress.com
With over 10 years of experience using the Microsoft Data Platform suite, Jared’s main areas of focus include data lake architecture, machine learning, and application embedded analytics. Jared regularly speaks at user groups and events across the Midwest, as well as blogs and provides technical review for SQL Server publications.
Andy Mallon
Twitter: - AMtwo
LinkedIn: Andy Mallon
Contact: http://www.AM2.co
Andy is a Data Platform MVP and SQL Server DBA that has managed databases in the healthcare, finance, e-commerce, and non-profit sectors. He has been supporting high-volume, highly-available OLTP environments with demanding performance needs since 2003.
Andy is the founder of the BostonSQL User Group, and previous co-organizer of SQLSaturday events in Boston. He blogs at am2.co.
Andy lives just outside Boston, Massachusetts, USA with his husband and their two dogs.
Jared Kuehn
LinkedIn: Jared Kuehn
Contact: https://www.skylinetechnologies.com/Blog
Jared has worked in the Business Intelligence industry for over 5 years, primarily in warehouse development and reporting solutions. He has acquired a MCSE certification in Business Intelligence and continues to do research in the realm of fuzzy logic. He’s served in multiple industries including Healthcare, Higher Education, Insurance and Retail. He firmly believes in not only learning new technologies, but sharing knowledge with one another to grow together. In his spare time, he enjoys spending his time performing in musical groups and theater productions, nerding out with video games, or spending time with his family.
Eric Fait
LinkedIn: Eric Fait
Eric cut his data teeth in finance doing ledger reconciliations and incentive compensation calculations. Always the data geek, the opportunity to join the Business Intelligence Analytics department of a Fortune 100 company came along and he dove right in. Now with Talavant, Eric enjoys working closely with clients to help them execute their Business Intelligence visions. Eric’s wife, Jamie, and his three boys, Eli, Miles, and Gavin take up most of his free time(and he likes it that way!)
Mike Shelton
Mike Shelton is a Microsoft Data Platform Technical Specialist.
As Data Platform Technical Specialist at Microsoft Corporation, Mike works with customers to understand business and technical requirements to map Microsoft solutions and technologies to address these requirements. The solution areas Mike works with include data warehouse, reporting, dashboard deliver, multi-dimension data analysis, predictive analytics and Hadoop. Mike has been with Microsoft for the past 13 years working with
Michael Carlo
Twitter: - @Javadrum82
LinkedIn: Michael Carlo
Contact: http://www.PowerBI.Tips
I’m very passionate about data and analytics. Since 2015 I’ve spend an inordinate amount of time learning PowerBI and PowerBI Desktop. Through this learning process I have determined that others may also be interested in also learning this technology to visualize their data. Thus, I have developed a website knowledge repository for all things PowerBI, (www.PowerBI.Tips). This site is uniquely set up for people to come read and learn about data modeling and visualizations within Power BI. I’ve been with Johnson Controls 10 years serving multiple departments, Engineering, Sales and Marketing and now Connected Product Offerings. Through out my career I’ve leveraged my engineering knowledge to hone my data visualization skills.
Thomas Lane
LinkedIn: Thomas Lane
Thomas has been living and breathing Microsoft databases for over twenty years and is now relishing his position as a DW Consultant at Talavant (www.Talavant.com). After receiving his Ph.D. in Chemistry and following three years as a post-doc at Marquette University, Thomas left the world of science for a career in IT. He has worked as a programming and database instructor, a VB and C# developer, and for the past fourteen years worked with SQL server as a DBA, ETL specialist, and Data Architect at various Midwestern companies. Thomas recently received his MSCE in Data Management and Analytics.
Charles Hyman
Mr. Hyman is an IT professional with over twenty years experience, currently specializing is Business Intelligence, Data Warehousing and Back-End Process IT systems. Mr Hyman currently splits his time, between consulting assignments, and mentoring/training assignments. Mr. Hyman is considered an Expert in the Microsoft SQL Server Products as well as the ETL and Reporting tools, BizTalk and SharePoint. Building Data Warehouses from disparate systems is his specialty
Jes Schultz
Twitter: - http://twitter.com/grrl_geek
LinkedIn: Jes Schultz
Contact: https://blogs.lessthandot.com/author/jes-borland
Jes Schultz is a Software Engineer with Microsoft who has experience with a wide range of SQL Server features from version 2005 through 2019, and is on the cutting edge with Azure technologies. Since graduating Fox Valley Technical College with an IT-Programmer/Analyst degree, Jes has worked as an SSRS developer, DBA, and consultant. Before joining Microsoft, Jes was a six-time Data Platform MVP, recognized for her community work. Jes tackles every project and problem with tenacity and her enthusiasm is unmatched in the SQL Server community. In her free time, Jes never stops moving, and counts fitness, coffee, cooking, and travel as essentials in life.
Turner Kunkel
Twitter: - turnerkunkel
LinkedIn: Turner Kunkel
Consulting with Talavant since September 2017.
President of the Fox Valley, WI PASS chapter.
Degrees in computer science and management sciences.
Experienced in SQL, SSIS, DevOps strategies, Azure Data Factory, Databricks, and Snowflake.
Also, beer maker, music lover, code tinkerer.
Farouq Abukhamireh
Twitter: - @AskFarouq
LinkedIn: Farouq Abukhamireh
Contact: http://www.blogger.com
Farouq Abukhamireh is a Microsoft Business Intelligence Architect and a Microsoft Certified Trainer (MCT) who is focused on Microsoft’s Business Intelligence (BI) stack (Power BI, Azure, SSAS, SSIS, SSRS, MDX, DAX, Excel Services, PowerPivot, PowerView and SharePoint). Farouq is a seasoned Information Technology professional with 21 years of experience developing innovative solutions using Microsoft technologies. Farouq works as a consultant with Dicense LTD.
Diane Schuster
LinkedIn: Diane Schuster
Diane has worked with COZYROC since 2012. She has attended numerous SQLSaturdays to shine the light on the time-saving and capability-extending components and tasks that COZYROC offers in it’s SSIS+ library. Without even having a background in databases or SQL Server, Diane successfully configures packages in live demonstrations that use COZYROC components and tasks. She believes that, if the toolkit is this easy to use for a novice, then just imagine what a SQL Server expert can do with it!
In Diane’s data networking days, Diane performed a variety of development-related and customer-facing roles for IBM, Lucent Technologies, North Carolina State University and Connectware.
Tim Gorman
Twitter: - @TimGormanTech
LinkedIn: Tim Gorman
Contact: http://evdbt.com
Tim Gorman is a senior technical consultant for Delphix who securely enables masked data virtualization to increase the agility of IT development and testing while ending decades of security risk in SDLC.
Tim has co-authored six books on data warehousing and database administration, has performed technical review on eight more books, and has an author#39;s page on Amazon.com (http://www.amazon.com/Tim-Gorman/e/B00BKCTO5E).
Seth Bauer
Twitter: - https://twitter.com/Eno1978
LinkedIn: Seth Bauer
Seth Bauer is a Technical Architect with Concurrency Inc. He is a Microsoft Data Platform MVP (Power BI) and a Microsoft Certified Professional. He is the leader of the Milwaukee “Brew City” Power BI User Group in the Milwaukee and Brookfield Wisconsin area. He has partnered with Mike Carlo and produces tools and PowerBI related content on PowerBI.tips. And is a major contributor in the Microsoft Power BI Community forum. His major focus area is Power BI, and sharing what he’s learned with the user Community. He enjoys working with clients across the Midwest implementing BI / Power BI solutions.
Andrew Loree
Twitter: - @LowOnDiskSpace
LinkedIn: Andrew Loree
Contact: http://www.andyloree.com
Andrew Loree has over nineteen years of database experience with roles in architecture, design, development, and implementation of enterprise-scale SQL Server data solutions, supporting industries from legal e-discovery to manufacturing. Areas of expertise since SQL Server 2000 include data migration and ETL/ELT solutions, disaster recovery planning, high availability service design, licensing and virtualization. Andrew holds fourteen Microsoft certifications, has both a Bachelor and Masters of Science in Computer Science from Wright State University and is a Columbus (Ohio) PASS board member.
Drew Furgiuele
Twitter: - pittfurg
LinkedIn: Drew Furgiuele
Contact: http://www.port1433.com
Drew Furgiuele is a senior DBA that lives in Dublin, Ohio who is passionate about SQL Server and PowerShell. He’s been working with SQL Server since 2002. When he’s not accidentally dropping tables in production, he likes writing automation scripts, blogging about SQL Server Replication, wiring electronics, playing board games, and spending time with his dog. He’s also not embarrassed by his Spotify playlists.
Jim Dorame
Twitter: - @DBAJD
LinkedIn: Jim Dorame
Contact: http://www.jamesdorame.com/
Jim Dorame has been working with SQL Server for over 20 years. Over those years he has learned a great deal from the SQL community. He has also given back to the community in the hopes that he may help someone in their career. He is always looking for something to learn and luckily Microsoft keeps adding to SQL Server.
Peter Shore
Twitter: - pshore73
LinkedIn: Peter Shore
Peter Shore is a seasoned IT professional with over 25 years of experience. He took the accidentally intentional DBA plunge in 2013 and has discovered that he loves to find the stories the data has to tell. Peter is comfortable working with both physical and virtual servers, where he tries to apply best practices to attain performance improvements. He is also adept at bridging the gap between technical and business language in order to bring technology solutions to business needs.
Phil Ekins
Twitter: - @SQLPhilUK
LinkedIn: Phil Ekins
Phil Ekins is a Principal Architect at House of Brick Technologies. With over two decades of experience in SQL Server, Automation, Migrations, Virtualization and HA/DR Solutions. Phil has presented at SQLSaturday’s and Local Chapters. As a AWS Certified Solutions Architect and a seasoned SQL Server Professional Phil brings a DBA’s needs to the world of cloud computing.
SQLSaturday Madison
SQLSaturday Madison
Kevin Feasel
Twitter: - feaselkl
LinkedIn: Kevin Feasel
Contact: http://www.catallaxyservices.com
Kevin Feasel is a Microsoft Data Platform MVP and CTO at Envizage, where he specializes in data analytics with T-SQL and R, forcing Spark clusters to do his bidding, fighting with Kafka, and pulling rabbits out of hats on demand. He is the lead contributor to Curated SQL (https://curatedsql.com), president of the Triangle Area SQL Server Users Group (https://www.meetup.com/tripass), and author of PolyBase Revealed (https://www.apress.com/us/book/9781484254608). A resident of Durham, North Carolina, he can be found cycling the trails along the triangle whenever the weather’s nice enough.
Rick Lowe
Twitter: - DataFLowe
LinkedIn: Rick Lowe
Contact: http://dataflowe.wordpress.com/
Rick is a Microsoft Certified Master with more than 20 years of SQL Server experience in a variety of roles. He currently lives in Washington state and works as an independent consultant providing remote performance DBA and performance tuning services for clients in the USA and Canada. His first exposure to SQL Server was as a database developer, but over time he became more and more interested in how the database engine operated… eventually specializing more on performance issues than code.
Rick will work with all things relational, but most enjoys helping smaller companies get better performance from MSSQL, as well as smoothing over relationships between DBA and development teams.
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
Bob Pusateri
Twitter: - @SQLBob
LinkedIn: Bob Pusateri
Contact: http://www.BobPusateri.com
Bob Pusateri is a Microsoft Certified Master, DBA, and systems architect with over 10 years of experience on SQL Server. His interests involve internals, performance optimization, and cloud technologies. He is an active member of two Chicago-area PASS Local Groups, a community speaker, and maintains a web presence through both Twitter (@SQLBob) and his blog (bobpusateri.com).
Sponsors
The following is a list of sponsors that helped fund the event: