Nr: 724
SQLSaturday #724 - Madison 2018
| Start Time (24h) |
Speaker |
Track |
Title |
| 09:00:00 |
Andy Yun |
Application Database Development |
T-SQL Tips Tricks to Make Your Life Easier! |
| 09:00:00 |
Farouq Abukhamireh |
BI Platform Architecture, Development Administration |
Building a Microsoft Business intelligence Solution step-by-step |
| 09:00:00 |
Drew Furgiuele |
Strategy and Architecture |
Building the HASSP: Putting SQL Server In Space |
| 09:00:00 |
Jared Zagelbaum |
Cloud Application Development Deployment |
Custom Activities in Azure Data Factory |
| 09:00:00 |
Rick Lowe |
Application Database Development |
Why Should I Care About ... Partitioned Views? |
| 09:00:00 |
Andrew Loree |
Analytics and Visualization |
Microsoft Machine Learning Services |
| 09:00:00 |
John Eisbrener |
Application Database Development |
Columnstore 101: The Five Ws of Columnstore Indexes |
| 09:00:00 |
Riley Major |
Application Database Development |
XML vs JSON - Battle Royale |
| 09:00:00 |
Mike Shelton |
Cloud Application Development Deployment |
Administering your Azure SQL Database |
| 10:30:00 |
David Maxwell |
Application Database Development |
Targeting Wait Statistics with Extended Events and DMVs |
| 10:30:00 |
Jim Dorame |
Application Database Development |
JSON for the Data Mortals |
| 10:30:00 |
Bob Pusateri |
Application Database Development |
Locks, Blocks, and Snapshots: Maximizing Database Concurrency |
| 10:30:00 |
Jes Schultz |
Cloud Application Development Deployment |
Azure SQL Database Performance Tuning |
| 10:30:00 |
Seth Bauer |
BI Platform Architecture, Development Administration |
Administering and Deploying Power BI Solutions |
| 10:30:00 |
Arthur Daniels III |
Application Database Development |
Reading Execution Plans Successfully |
| 10:30:00 |
Rob Long |
BI Platform Architecture, Development Administration |
Data Testing Integrity – BI Edition |
| 10:30:00 |
Juan Muñoz |
Analytics and Visualization |
Practical Introduction to Artificial Intelligence |
| 10:30:00 |
Diane Schuster |
BI Platform Architecture, Development Administration |
COZYROC: Dynamic Data Flows in SSIS without Programming |
| 13:00:00 |
Kevin Feasel |
Application Database Development |
Polybase In Action |
| 13:00:00 |
Andy Mallon |
Professional Development |
Shortcuts from an Impatient DBA |
| 13:00:00 |
Peter Shore |
BI Platform Architecture, Development Administration |
Analysis Services for the Absolute Beginner |
| 13:00:00 |
Turner Kunkel |
Cloud Application Development Deployment |
Azure Analysis Services: Purpose, Migration, Benefits, and Tools |
| 13:00:00 |
Dave Bland |
Application Database Development |
Extended Events: What are they and How do I use them |
| 13:00:00 |
Ben Miller |
Application Database Development |
Gathering Trending Data with PowerShell |
| 13:00:00 |
Allen White |
Strategy and Architecture |
Emergency! Are You Ready for Disaster to Strike? |
| 13:00:00 |
Eric Fait |
Analytics and Visualization |
Power BI Bookmarks: Four Business Use Cases |
| 13:00:00 |
SQL Saturday Madison |
Cloud Application Development Deployment |
SQL Server on AWS |
| 14:30:00 |
John Deardurff |
Professional Development |
How to get Microsoft Certified |
| 14:30:00 |
Joe Obbish |
Application Database Development |
Four Rules For Columnstore Query Performance |
| 14:30:00 |
Jared Karney |
Strategy and Architecture |
DEA (not what you think) Will Be Your New Best Friend! |
| 14:30:00 |
Michael Carlo |
BI Information Delivery |
Tips and Tricks from PowerBI.Tips |
| 14:30:00 |
Sourav Mukherjee |
Cloud Application Development Deployment |
Know different AWS Database Products - their benefits and key features |
| 14:30:00 |
Jared Kuehn |
BI Platform Architecture, Development Administration |
When Low-Quality Data Strikes: Fuzzy Tools Provide Clarity in Matching and Deduplication |
| 14:30:00 |
Frank Gill |
Application Database Development |
The SQL Server Transaction Log for Developers |
| 14:30:00 |
Thomas Lane |
Strategy and Architecture |
Data Vault 2.0 An Introduction To A Better Data Warehouse Database Designing Method |
| 14:30:00 |
SQL Saturday Madison |
Other |
Women In Technology - Panel |
| 16:00:00 |
Tim Gorman |
Application Database Development |
Accelerating Development and Testing Using Data Virtualization |
| 16:00:00 |
Phil Ekins |
Strategy and Architecture |
SQL Data Recovery - Do you know where your DR plan is? |
| 16:00:00 |
Andy Yun |
Professional Development |
Everyone Has a Story to Tell: Developing Your First Presentation |
| 16:00:00 |
Rick Bielawski |
Application Database Development |
Difficult Queries |
| 16:00:00 |
Joshuha Owen |
Cloud Application Development Deployment |
Let's build a data app with Azure Functions! |
| 16:00:00 |
Pat Phelan |
Strategy and Architecture |
In memory database... Let's rethink that request! |
| 16:00:00 |
Charles Hyman |
BI Platform Architecture, Development Administration |
SQL 2017 on LINUX |
| 16:00:00 |
Ed Leighton-Dick |
Strategy and Architecture |
Three Steps to Lasting Encryption |
| 16:00:00 |
Jordan Anderson |
Cloud Application Development Deployment |
Real-time Analytics with Azure |
SessionID: 71260
T-SQL Tips Tricks to Make Your Life Easier!
Event Date: 07-04-2018 - Session time: 09:00:00 - Track: Application Database Development
Speaker: Andy Yun
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!
SessionID: 71320
Building a Microsoft Business intelligence Solution step-by-step
Event Date: 07-04-2018 - Session time: 09:00:00 - Track: BI Platform Architecture, Development Administration
Speaker: Farouq Abukhamireh
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
SessionID: 71328
Building the HASSP: Putting SQL Server In Space
Event Date: 07-04-2018 - Session time: 09:00:00 - Track: Strategy and Architecture
Speaker: Drew Furgiuele
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.
SessionID: 72137
Custom Activities in Azure Data Factory
Event Date: 07-04-2018 - Session time: 09:00:00 - Track: Cloud Application Development Deployment
Speaker: Jared Zagelbaum
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.
SessionID: 73403
Why Should I Care About ... Partitioned Views?
Event Date: 07-04-2018 - Session time: 09:00:00 - Track: Application Database Development
Speaker: Rick Lowe
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.
SessionID: 74431
Microsoft Machine Learning Services
Event Date: 07-04-2018 - Session time: 09:00:00 - Track: Analytics and Visualization
Speaker: Andrew Loree
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
SessionID: 74432
Columnstore 101: The Five Ws of Columnstore Indexes
Event Date: 07-04-2018 - Session time: 09:00:00 - Track: Application Database Development
Speaker: John Eisbrener
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.
SessionID: 74463
XML vs JSON - Battle Royale
Event Date: 07-04-2018 - Session time: 09:00:00 - Track: Application Database Development
Speaker: Riley Major
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.
SessionID: 77728
Administering your Azure SQL Database
Event Date: 07-04-2018 - Session time: 09:00:00 - Track: Cloud Application Development Deployment
Speaker: Mike Shelton
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
SessionID: 71905
Targeting Wait Statistics with Extended Events and DMVs
Event Date: 07-04-2018 - Session time: 10:30:00 - Track: Application Database Development
Speaker: David Maxwell
Title: Targeting Wait Statistics with Extended Events and DMVs
Abstract:
SessionID: 72681
JSON for the Data Mortals
Event Date: 07-04-2018 - Session time: 10:30:00 - Track: Application Database Development
Speaker: Jim Dorame
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.
SessionID: 72790
Locks, Blocks, and Snapshots: Maximizing Database Concurrency
Event Date: 07-04-2018 - Session time: 10:30:00 - Track: Application Database Development
Speaker: Bob Pusateri
Title: Locks, Blocks, and Snapshots: Maximizing Database Concurrency
Abstract:
SessionID: 73144
Event Date: 07-04-2018 - Session time: 10:30:00 - Track: Cloud Application Development Deployment
Speaker: Jes Schultz
Abstract:
SessionID: 73750
Administering and Deploying Power BI Solutions
Event Date: 07-04-2018 - Session time: 10:30:00 - Track: BI Platform Architecture, Development Administration
Speaker: Seth Bauer
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.
SessionID: 73951
Reading Execution Plans Successfully
Event Date: 07-04-2018 - Session time: 10:30:00 - Track: Application Database Development
Speaker: Arthur Daniels III
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.
SessionID: 74466
Data Testing Integrity – BI Edition
Event Date: 07-04-2018 - Session time: 10:30:00 - Track: BI Platform Architecture, Development Administration
Speaker: Rob Long
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.
SessionID: 74467
Practical Introduction to Artificial Intelligence
Event Date: 07-04-2018 - Session time: 10:30:00 - Track: Analytics and Visualization
Speaker: Juan Muñoz
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.
SessionID: 80104
COZYROC: Dynamic Data Flows in SSIS without Programming
Event Date: 07-04-2018 - Session time: 10:30:00 - Track: BI Platform Architecture, Development Administration
Speaker: Diane Schuster
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.
SessionID: 71195
Polybase In Action
Event Date: 07-04-2018 - Session time: 13:00:00 - Track: Application Database Development
Speaker: Kevin Feasel
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.
SessionID: 71275
Shortcuts from an Impatient DBA
Event Date: 07-04-2018 - Session time: 13:00:00 - Track: Professional Development
Speaker: Andy Mallon
Title: Shortcuts from an Impatient DBA
Abstract:
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.
SessionID: 71430
Analysis Services for the Absolute Beginner
Event Date: 07-04-2018 - Session time: 13:00:00 - Track: BI Platform Architecture, Development Administration
Speaker: Peter Shore
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.
SessionID: 72222
Event Date: 07-04-2018 - Session time: 13:00:00 - Track: Cloud Application Development Deployment
Speaker: Turner Kunkel
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.
SessionID: 72623
Extended Events: What are they and How do I use them
Event Date: 07-04-2018 - Session time: 13:00:00 - Track: Application Database Development
Speaker: Dave Bland
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!
SessionID: 73793
Gathering Trending Data with PowerShell
Event Date: 07-04-2018 - Session time: 13:00:00 - Track: Application Database Development
Speaker: Ben Miller
Title: Gathering Trending Data with PowerShell
Abstract:
SessionID: 74184
Emergency! Are You Ready for Disaster to Strike?
Event Date: 07-04-2018 - Session time: 13:00:00 - Track: Strategy and Architecture
Speaker: Allen White
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.
SessionID: 74239
Power BI Bookmarks: Four Business Use Cases
Event Date: 07-04-2018 - Session time: 13:00:00 - Track: Analytics and Visualization
Speaker: Eric Fait
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.
SessionID: 78595
SQL Server on AWS
Event Date: 07-04-2018 - Session time: 13:00:00 - Track: Cloud Application Development Deployment
Speaker: SQL Saturday Madison
Title: SQL Server on AWS
Abstract:
Presented by Brian Lewis, Solutions Architect at Amazon Web Services
SessionID: 71207
How to get Microsoft Certified
Event Date: 07-04-2018 - Session time: 14:30:00 - Track: Professional Development
Speaker: John Deardurff
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.
SessionID: 71361
Event Date: 07-04-2018 - Session time: 14:30:00 - Track: Application Database Development
Speaker: Joe Obbish
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.
SessionID: 72046
DEA (not what you think) Will Be Your New Best Friend!
Event Date: 07-04-2018 - Session time: 14:30:00 - Track: Strategy and Architecture
Speaker: Jared Karney
Title: DEA (not what you think) Will Be Your New Best Friend!
Abstract:
SessionID: 73388
Tips and Tricks from PowerBI.Tips
Event Date: 07-04-2018 - Session time: 14:30:00 - Track: BI Information Delivery
Speaker: Michael Carlo
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.
SessionID: 73715
Know different AWS Database Products - their benefits and key features
Event Date: 07-04-2018 - Session time: 14:30:00 - Track: Cloud Application Development Deployment
Speaker: Sourav Mukherjee
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.
SessionID: 73999
Event Date: 07-04-2018 - Session time: 14:30:00 - Track: BI Platform Architecture, Development Administration
Speaker: Jared Kuehn
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.
SessionID: 74219
The SQL Server Transaction Log for Developers
Event Date: 07-04-2018 - Session time: 14:30:00 - Track: Application Database Development
Speaker: Frank Gill
Title: The SQL Server Transaction Log for Developers
Abstract:
SessionID: 74336
Data Vault 2.0 An Introduction To A Better Data Warehouse Database Designing Method
Event Date: 07-04-2018 - Session time: 14:30:00 - Track: Strategy and Architecture
Speaker: Thomas Lane
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.
SessionID: 77571
Women In Technology - Panel
Event Date: 07-04-2018 - Session time: 14:30:00 - Track: Other
Speaker: SQL Saturday Madison
Title: Women In Technology - Panel
Abstract:
SessionID: 71261
Accelerating Development and Testing Using Data Virtualization
Event Date: 07-04-2018 - Session time: 16:00:00 - Track: Application Database Development
Speaker: Tim Gorman
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.
SessionID: 71268
SQL Data Recovery - Do you know where your DR plan is?
Event Date: 07-04-2018 - Session time: 16:00:00 - Track: Strategy and Architecture
Speaker: Phil Ekins
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.
SessionID: 71784
Everyone Has a Story to Tell: Developing Your First Presentation
Event Date: 07-04-2018 - Session time: 16:00:00 - Track: Professional Development
Speaker: Andy Yun
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.
SessionID: 71952
Difficult Queries
Event Date: 07-04-2018 - Session time: 16:00:00 - Track: Application Database Development
Speaker: Rick Bielawski
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 .
SessionID: 72082
Let's build a data app with Azure Functions!
Event Date: 07-04-2018 - Session time: 16:00:00 - Track: Cloud Application Development Deployment
Speaker: Joshuha Owen
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.
SessionID: 73933
In memory database... Let's rethink that request!
Event Date: 07-04-2018 - Session time: 16:00:00 - Track: Strategy and Architecture
Speaker: Pat Phelan
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.
SessionID: 74012
SQL 2017 on LINUX
Event Date: 07-04-2018 - Session time: 16:00:00 - Track: BI Platform Architecture, Development Administration
Speaker: Charles Hyman
Title: SQL 2017 on LINUX
Abstract:
Co-Existence between the Windows and Linux environments will be shown and explored.
SessionID: 74534
Three Steps to Lasting Encryption
Event Date: 07-04-2018 - Session time: 16:00:00 - Track: Strategy and Architecture
Speaker: Ed Leighton-Dick
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.
SessionID: 77911
Real-time Analytics with Azure
Event Date: 07-04-2018 - Session time: 16:00:00 - Track: Cloud Application Development Deployment
Speaker: Jordan Anderson
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.