Nr: 774
SQLSaturday #774 - Denver 2018
| Start Time (24h) |
Speaker |
Track |
Title |
| 09:00:00 |
Tim Weigel |
Enterprise Database Administration Deployment |
Ch-ch-ch-changes! How to keep track of what's happening to your data |
| 09:00:00 |
Andrew Loree |
Analytics and Visualization |
Microsoft Machine Learning Services |
| 09:00:00 |
Glenn Berry |
Strategy and Architecture |
High Availability/Disaster Recovery 101 |
| 09:00:00 |
Rick Lowe |
Cloud Application Development Deployment |
SQL Server on Amazon Web Services - Elastic Compute Cloud vs Relational Database Service? |
| 09:00:00 |
Angela Tidwell |
Professional Development |
Become the Most Valuable Player: Soft Skills for the Hard Market |
| 09:00:00 |
Leslie Weed |
BI Platform Architecture, Development Administration |
Innovative Data Modeling: Make Data Warehousing Cool Again |
| 09:00:00 |
Todd Kleinhans |
Professional Development |
The Life Cycle of a Query in Virtual Reality |
| 09:00:00 |
John Sterrett |
Enterprise Database Administration Deployment |
Automate the Pain Away with Adaptive Query Processing and Automatic Tuning |
| 09:00:00 |
Michael Fal |
Enterprise Database Administration Deployment |
Exploring the SQL Server Powershell Module |
| 10:15:00 |
Christopher Wolff |
Cloud Application Development Deployment |
Amazon Web Services RDS with SQL Server |
| 10:15:00 |
Bob Ward |
Enterprise Database Administration Deployment |
Experience SQL Server on Linux and Containers |
| 10:15:00 |
David Maxwell |
Enterprise Database Administration Deployment |
Understanding and Handling Database Corruption |
| 10:15:00 |
Jes Schultz |
Cloud Application Development Deployment |
Azure SQL Database Performance Tuning |
| 10:15:00 |
Warren Sifre |
Advanced Analysis Techniques |
Introduction to Azure Streaming Analytics |
| 10:15:00 |
Eric Peterson |
Application Database Development |
SQL vs NoSQL: a Comparison of SQL vs MongoDB |
| 10:15:00 |
Marc Beacom |
BI Platform Architecture, Development Administration |
Implementing a Cloud Analytics Solution: Options, Costs and More |
| 10:15:00 |
Melody Zacharias |
Professional Development |
Confidence: The fuel for action |
| 10:15:00 |
TJay Belt |
Enterprise Database Administration Deployment |
Power BI, from a DBA's Perspective |
| 12:45:00 |
Marsha Pierce |
Enterprise Database Administration Deployment |
SQL Server with Docker Containers |
| 12:45:00 |
Janis Griffin |
Application Database Development |
Everything You Need to Know About SQL Server Indexes |
| 12:45:00 |
Jes Schultz |
Professional Development |
Busy is a Four-Letter Word |
| 12:45:00 |
Sean McCown |
Enterprise Database Administration Deployment |
Monster Text Manipulation: Regular Expressions for the DBA |
| 12:45:00 |
Reeves Smith |
BI Platform Architecture, Development Administration |
Master Data Management in the GDPR Era |
| 12:45:00 |
Brian Hansen |
Application Database Development |
Set Me Up: How to Think in Sets |
| 12:45:00 |
Jeff Renz |
BI Platform Architecture, Development Administration |
Fishing for Answers: Azure Data Lake |
| 12:45:00 |
Gabriel Villa |
Cloud Application Development Deployment |
Architecting an Analytics Solution on Amazon Web Services |
| 12:45:00 |
Carlos Bossy |
Advanced Analysis Techniques |
Data Science Tips and Tricks using Python and SQL |
| 14:00:00 |
Tim Gorman |
Enterprise Database Administration Deployment |
Speed Up Development and Testing Using Data Virtualization |
| 14:00:00 |
Tracy Boggiano |
Enterprise Database Administration Deployment |
Monitoring Availability Groups |
| 14:00:00 |
Paul Paiva |
Professional Development |
Consulting/contracting - is it right for me? |
| 14:00:00 |
Leslie Andrews |
BI Platform Architecture, Development Administration |
The Power of Data: The Complete Beginners Data Warehouse Kit |
| 14:00:00 |
Kris Hokanson |
Enterprise Database Administration Deployment |
That's bad mkay! |
| 14:00:00 |
Vern Rabe |
Enterprise Database Administration Deployment |
It's Time for a Change: Temporal Table Support in SQL Server 2016/17 |
| 14:00:00 |
Patrick Geselbracht |
Strategy and Architecture |
How to Realize Quantify Value from Data |
| 14:00:00 |
Amie Mason |
Advanced Analysis Techniques |
Azure Intelligent Services |
| 14:00:00 |
Konstantin Melamud |
Enterprise Database Administration Deployment |
inMemory OLTP for developers |
| 15:15:00 |
Rob Volk |
Enterprise Database Administration Deployment |
That's So Metadata: Discover Your Database From the Inside |
| 15:15:00 |
Scot Reagin |
BI Platform Architecture, Development Administration |
Data Positioning: Self-Defense or a Brilliant New Architecture |
| 15:15:00 |
Brian Carrig |
Enterprise Database Administration Deployment |
How to Manage Very Large Databases with SQL Server |
| 15:15:00 |
Adam Durazo |
Application Database Development |
Database best practices for applications |
| 15:15:00 |
Jennifer McCown |
Enterprise Database Administration Deployment |
Beginning Admin: The Care and Feeding of SQL Server |
| 15:15:00 |
Wendy Pastrick |
Professional Development |
Moving Past Imposter Syndrome |
| 15:15:00 |
Jason Horner |
BI Platform Architecture, Development Administration |
Real-World Data Movement and Orchestration Patterns using Azure Data Factory V2 |
| 15:15:00 |
Jason Brimhall |
Application Database Development |
The Anatomy of Select |
| 15:15:00 |
Bill Fellows |
Application Database Development |
What's new for Developers - SQL Server 2014-2017 |
| 16:30:00 |
Anders Pedersen |
Application Database Development |
I/O Tuning 101 |
| 16:30:00 |
Carlos Robles |
Enterprise Database Administration Deployment |
How to do a SQL Server Health Check |
| 16:30:00 |
Kevin Mackey |
Application Database Development |
Don't just code it—Generate It |
| 16:30:00 |
Martin Schoombee |
BI Information Delivery |
Power BI Development Best Practices |
| 16:30:00 |
Kellyn Pot'Vin-Gorman |
Enterprise Database Administration Deployment |
Screw DevOps, Let's Talk DataOps |
| 16:30:00 |
Kevin Feasel |
Analytics and Visualization |
Eyes on the Prize: Simple and Effective Dashboard Visualization Techniques |
| 16:30:00 |
Daniel Janik |
Enterprise Database Administration Deployment |
A DBA's guide to full stack performance troubleshooting |
| 16:30:00 |
Denver SQL Server User Group |
Other |
Sponsor Spotlight: COZYROC |
| 16:30:00 |
Denver SQL Server User Group |
Other |
#GetModern SQL Server infrastructure with DellEMC |
| 16:30:00 |
Diane Schuster |
BI Platform Architecture, Development Administration |
COZYROC: Dynamic Data Flows in SSIS without Programming |
SessionID: 78622
Ch-ch-ch-changes! How to keep track of what's happening to your data
Event Date: 15-09-2018 - Session time: 09:00:00 - Track: Enterprise Database Administration Deployment
Speaker: Tim Weigel
Title: Ch-ch-ch-changes! How to keep track of what's happening to your data
Abstract:
Join Tim Weigel for a discussion of four ways you can keep track of how your data is changing: Change Data Capture, Change Tracking, Temporal Tables, and good ol' fashioned triggers. Tim will present a quick overview of each method, including use cases and positives and negatives.
SessionID: 82219
Microsoft Machine Learning Services
Event Date: 15-09-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: 82645
High Availability/Disaster Recovery 101
Event Date: 15-09-2018 - Session time: 09:00:00 - Track: Strategy and Architecture
Speaker: Glenn Berry
Title: High Availability/Disaster Recovery 101
Abstract:
SessionID: 83756
SQL Server on Amazon Web Services - Elastic Compute Cloud vs Relational Database Service?
Event Date: 15-09-2018 - Session time: 09:00:00 - Track: Cloud Application Development Deployment
Speaker: Rick Lowe
Title: SQL Server on Amazon Web Services - Elastic Compute Cloud vs Relational Database Service?
Abstract:
Amazon web services offers a befuddling number of of different services. Among these are the two major options for running SQL Server on AWS - Elastic Compute Cloud and Relational Database Services. Why would one be picked over the other? What are the limitations and trade offs? We will discuss these questions among others while working through the process of restoring a sample database under both services.
SessionID: 84091
Become the Most Valuable Player: Soft Skills for the Hard Market
Event Date: 15-09-2018 - Session time: 09:00:00 - Track: Professional Development
Speaker: Angela Tidwell
Title: Become the Most Valuable Player: Soft Skills for the Hard Market
Abstract:
Whether you are just starting a career, advancing into senior leadership, or trying to woo a potential client, soft skills can be your ticket to success. Often times we focus on showing how smart we are instead of showing what a good team member we can be. We will discuss the role and types of soft skills needed to showcase your X-factor. Need to hone your skills? We will explore innovative and fun ways in which to do just that!
SessionID: 84504
Innovative Data Modeling: Make Data Warehousing Cool Again
Event Date: 15-09-2018 - Session time: 09:00:00 - Track: BI Platform Architecture, Development Administration
Speaker: Leslie Weed
Title: Innovative Data Modeling: Make Data Warehousing Cool Again
Abstract:
There is much more to life than 3rd normal form and dimensional modeling. Come explore how you can build a data warehouse solution or hybrid solution that is agile in nature. Discover this highly auditable modeling technique used in international banking, manufacturing, insurance and many more industries. Made a mistake? No worries, own your model. Design changes happen and it can be addressed quickly avoiding pain and project delays and ultimately keeping your business happy. Learn how to leverage Master Data Management and Azure Technologies to extend your model for performance, history and reference unstructured data. Let us bust the myth that data warehouses take too long to build and are too hard to modify by adding value to your environment and decreasing delivery time. We will explore how you can use continuous integration and delivery to further maximize value.
SessionID: 84527
The Life Cycle of a Query in Virtual Reality
Event Date: 15-09-2018 - Session time: 09:00:00 - Track: Professional Development
Speaker: Todd Kleinhans
Title: The Life Cycle of a Query in Virtual Reality
Abstract:
This presentation has taken the concept of a flow chart and a mind palace and turned it into a virtual reality (VR) experience. The ability to become immersed and walk around inside of a VR environment is a new and unique way to present and look at information. As data professionals we need to be open to novel displays of technical information and explore what VR can do that for us that we have not been able to do in the past.
The Life Cycle of a Query in Virtual Reality is built using a video game engine from Epic Games called Unreal Engine 4 (UE4).
SessionID: 84529
Automate the Pain Away with Adaptive Query Processing and Automatic Tuning
Event Date: 15-09-2018 - Session time: 09:00:00 - Track: Enterprise Database Administration Deployment
Speaker: John Sterrett
Title: Automate the Pain Away with Adaptive Query Processing and Automatic Tuning
Abstract:
SessionID: 85347
Exploring the SQL Server Powershell Module
Event Date: 15-09-2018 - Session time: 09:00:00 - Track: Enterprise Database Administration Deployment
Speaker: Michael Fal
Title: Exploring the SQL Server Powershell Module
Abstract:
A big hurdle for using Powershell and SQL Server together is the SQLPS module. Both old and new users of Powershell don’t completely understand its capabilities. In this session, we’ll talk about the cmdlets you may not know about, tricks to save time using the provider, and even a few gotchas on how the provider works that can save you some time and energy. When we’re finished, you will have a deeper understanding of how you can use SQL Server and Powershell together.
SessionID: 77547
Amazon Web Services RDS with SQL Server
Event Date: 15-09-2018 - Session time: 10:15:00 - Track: Cloud Application Development Deployment
Speaker: Christopher Wolff
Title: Amazon Web Services RDS with SQL Server
Abstract:
SessionID: 77570
Experience SQL Server on Linux and Containers
Event Date: 15-09-2018 - Session time: 10:15:00 - Track: Enterprise Database Administration Deployment
Speaker: Bob Ward
Title: Experience SQL Server on Linux and Containers
Abstract:
SessionID: 78052
Understanding and Handling Database Corruption
Event Date: 15-09-2018 - Session time: 10:15:00 - Track: Enterprise Database Administration Deployment
Speaker: David Maxwell
Title: Understanding and Handling Database Corruption
Abstract:
Database corruption is simply a fact of a DBA's life - if you haven't seen it yet, you will. Success or failure depends on having a solid plan to deal with different types of corruption. In this session, we will discuss usage of related DBCC commands such as DBINFO, CHECKDB and PAGE. You'll learn how to monitor for corruption with SQL Agent Alerts and Jobs, and when it's time to restore instead of repair. After attending this session, you will be able to check for issues such as page corruption or data purity problems, and take the appropriate measures to deal with them.
SessionID: 80361
Event Date: 15-09-2018 - Session time: 10:15:00 - Track: Cloud Application Development Deployment
Speaker: Jes Schultz
Abstract:
SessionID: 82476
Introduction to Azure Streaming Analytics
Event Date: 15-09-2018 - Session time: 10:15:00 - Track: Advanced Analysis Techniques
Speaker: Warren Sifre
Title: Introduction to Azure Streaming Analytics
Abstract:
This session will cover what is Streaming Analytics and the various use cases. We will demonstrate the creation of a Streaming Analytics process which will output the data to a dashboard for review. The intention is to provide insights in how this technology can potentially be leveraged by the SQL community.
SessionID: 84254
SQL vs NoSQL: a Comparison of SQL vs MongoDB
Event Date: 15-09-2018 - Session time: 10:15:00 - Track: Application Database Development
Speaker: Eric Peterson
Title: SQL vs NoSQL: a Comparison of SQL vs MongoDB
Abstract:
Have you heard of NoSQL, but aren't really sure what it is? Are you wondering if you're missing out on something that could satisfy that complex data model problem you haven't found a good solution for?
We'll learn about the flavors of NoSql and then dig down into MongoDB, the NoSQL database that drives many websites. Then we'll get an overview of JavaScript Object Notation (JSON) along with how and why it's used in NoSQL, focusing on its advantages and disadvantages.
You'll see how the SQL table structure compares to the NoSQL data structure. After that, we'll look at examples of storing the same data in both systems and how that data flows to the web page.
We'll discuss the factors that drive your choice of database along with the trade-offs involved. Then we'll wrap up by taking a look at Microsoft's on-premises and cloud efforts in the MongoDB NoSQL space.
SessionID: 84488
Implementing a Cloud Analytics Solution: Options, Costs and More
Event Date: 15-09-2018 - Session time: 10:15:00 - Track: BI Platform Architecture, Development Administration
Speaker: Marc Beacom
Title: Implementing a Cloud Analytics Solution: Options, Costs and More
Abstract:
If you’ve looked at the cloud, you’ve realized the large number of options you have, to implement a complete cloud analytics solution. You can deploy dashboards, data ingestion and integration and advanced analytics to the cloud that will empower data-driven decisions for your organizations. This talk will discuss and review options you have, to run Cloud Analytic Solutions on Azure.
SessionID: 84512
Confidence: The fuel for action
Event Date: 15-09-2018 - Session time: 10:15:00 - Track: Professional Development
Speaker: Melody Zacharias
Title: Confidence: The fuel for action
Abstract:
Confidence is the fuel for action. How often have you thought about wanting to do something and thought you may not be successful at it, so it then became too much work to try? The American Pastor Robert Shuler famously asked a very powerful question: “What would you do if you knew you could not fail?” Come explore this exciting topic with me, and we will see what we can accomplish together!
SessionID: 85346
Power BI, from a DBA's Perspective
Event Date: 15-09-2018 - Session time: 10:15:00 - Track: Enterprise Database Administration Deployment
Speaker: TJay Belt
Title: Power BI, from a DBA's Perspective
Abstract:
Microsoft’s Power BI is the new hotness. In this session, you will get your hands dirty and dive into PowerBI and create an actual report, with actual data. You will get to learn from examples from what a DBA has done to implement Power BI in his shop and make his data accessible.
As a DBA, we often need to collect and display data in a friendly and interactive fashion. We will play with some PowerShell to collect data from several systems, store this data in an Azure DB in the Cloud, then point Power BI at this data to display and interact with said data. You will learn a little about PowerShell, Azure SQL DB, Power BI, and how to make these work for you.
SessionID: 77701
SQL Server with Docker Containers
Event Date: 15-09-2018 - Session time: 12:45:00 - Track: Enterprise Database Administration Deployment
Speaker: Marsha Pierce
Title: SQL Server with Docker Containers
Abstract:
An overview of creating SQL Server Containers and how you can clone your databases to Linux Containers. Containers are the future of DEVOPS!
SessionID: 80124
Everything You Need to Know About SQL Server Indexes
Event Date: 15-09-2018 - Session time: 12:45:00 - Track: Application Database Development
Speaker: Janis Griffin
Title: Everything You Need to Know About SQL Server Indexes
Abstract:
You probably already know that indexes make your queries go faster. But do you know all the different types of indexes in SQL Server and when to use them? Also with each new release of SQL Server, there are new features that can impact how indexes function and are maintained. Finally, knowing how the different types of indexes work can help you make better indexing choices when tuning your queries.
This presentation will review current SQL Server index structures and options, discuss how they work, when they should be used and how to maintain them. Examples of all the index types such as hash, in-memory, columnstore, filtered, etc… will be shown.
This presentation is a must see for DBAs, Developers, Application Architects and anyone else who is interesting in maintaining high performance SQL Server applications.
SessionID: 80363
Busy is a Four-Letter Word
Event Date: 15-09-2018 - Session time: 12:45:00 - Track: Professional Development
Speaker: Jes Schultz
Title: Busy is a Four-Letter Word
Abstract:
If I ask you, "How are you?", is your default answer, "I'm so busy!"? Why do we measure our worth by how much we are doing, rather than by the value of what we do? Are we busy doing the truly important things that will bring lasting happiness? What does this have to do with a technical conference? Join Jes as she shares with you how she, too, was too busy for too long, but is learning how to do less, more productive, and have bigger impact.
SessionID: 82972
Monster Text Manipulation: Regular Expressions for the DBA
Event Date: 15-09-2018 - Session time: 12:45:00 - Track: Enterprise Database Administration Deployment
Speaker: Sean McCown
Title: Monster Text Manipulation: Regular Expressions for the DBA
Abstract:
Here you’ll learn:
• The most useful regular expression commands.
• The appropriate times to use regular expressions.
• How to use regular expressions to write code for you.
• How to incorporate regular expressions into large tasks and combine them with other methods.
SessionID: 84168
Master Data Management in the GDPR Era
Event Date: 15-09-2018 - Session time: 12:45:00 - Track: BI Platform Architecture, Development Administration
Speaker: Reeves Smith
Title: Master Data Management in the GDPR Era
Abstract:
How does GDPR effect businesses inside and outside of the EU? What is required to do business with EU citizens? There are many questions to address today, and those questions necessitate a reliable and accurate overview of not only your data but of individual customers. MDM addresses this necessity and can serve as the technical basis for GDPR compliance.
SessionID: 84352
Set Me Up: How to Think in Sets
Event Date: 15-09-2018 - Session time: 12:45:00 - Track: Application Database Development
Speaker: Brian Hansen
Title: Set Me Up: How to Think in Sets
Abstract:
SQL Server is optimized to work in sets, but this is certainly a paradigm shift for someone accustomed to row-by-row operations.
We will look at T-SQL features that can break set-based processing -- generally meaning poor performance -- and gather empirical evidence to support that assertion. We'll also look at some constructs to overcome these issues and make your T-SQL scripts run faster and use fewer resources.
SessionID: 84416
Fishing for Answers: Azure Data Lake
Event Date: 15-09-2018 - Session time: 12:45:00 - Track: BI Platform Architecture, Development Administration
Speaker: Jeff Renz
Title: Fishing for Answers: Azure Data Lake
Abstract:
This session will demo putting data into a data lake, pulling data, visualizing data, and testing data lake performance. I will evaluate the strengths, weaknesses and implementation approaches. At the end of the session everyone should have a clear picture of what Azure Data Lake is, how to implement it, and is it a good fit for your organization.
SessionID: 84517
Architecting an Analytics Solution on Amazon Web Services
Event Date: 15-09-2018 - Session time: 12:45:00 - Track: Cloud Application Development Deployment
Speaker: Gabriel Villa
Title: Architecting an Analytics Solution on Amazon Web Services
Abstract:
SessionID: 84530
Data Science Tips and Tricks using Python and SQL
Event Date: 15-09-2018 - Session time: 12:45:00 - Track: Advanced Analysis Techniques
Speaker: Carlos Bossy
Title: Data Science Tips and Tricks using Python and SQL
Abstract:
SessionID: 77472
Speed Up Development and Testing Using Data Virtualization
Event Date: 15-09-2018 - Session time: 14:00:00 - Track: Enterprise Database Administration Deployment
Speaker: Tim Gorman
Title: Speed Up 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 often too costly due to the size of many databases, especially non-production. More importantly, it takes a lot of time to push terabytes around and time itself is costly. The old joke about "good, fast, and cheap -- pick any two" is very true with data.
Because providing full databases for each developer on each project seems unrealistic, for decades everyone has limited themselves to working in shared non-production environments that are refreshed only every few months at best. Conflicts occur, quality suffers. Development is slow and fails to keep up with business needs.
Come learn why data virtualization is the solution to a problem everyone knows.
Good, fast, and cheap -- have all three with data virtualization. Clone things easily and quickly, and remove the biggest constraint to development and testing.
SessionID: 78759
Monitoring Availability Groups
Event Date: 15-09-2018 - Session time: 14:00:00 - Track: Enterprise Database Administration Deployment
Speaker: Tracy Boggiano
Title: Monitoring Availability Groups
Abstract:
You will walk away from this session with tools you need to monitor your environment and know how to respond to alerts.
SessionID: 80938
Consulting/contracting - is it right for me?
Event Date: 15-09-2018 - Session time: 14:00:00 - Track: Professional Development
Speaker: Paul Paiva
Title: Consulting/contracting - is it right for me?
Abstract:
You have probably worked as a direct hire for a company. You get medical benefits, vacation, and possibly a good 401k. On occasion you might have accepted a contract. The pay might be nicer, but you are concerned because you have less job security, no vacation, and no benefits. Yet, there are some who prefer contracts. We will cover how to negotiate a wage, appear professional, a look at finances, contractual gottchas, taxes and paperwork. Since most are experienced at being a direct hire with a company, this presentation will show the benefits of consulting/contracting, so that you can decide what is right for you and your career path. Presenter has been contracting for 18 of the last 20 years and will share many of his experiences - the successes and the falls along the way.
SessionID: 82711
The Power of Data: The Complete Beginners Data Warehouse Kit
Event Date: 15-09-2018 - Session time: 14:00:00 - Track: BI Platform Architecture, Development Administration
Speaker: Leslie Andrews
Title: The Power of Data: The Complete Beginners Data Warehouse Kit
Abstract:
SessionID: 84058
That's bad mkay!
Event Date: 15-09-2018 - Session time: 14:00:00 - Track: Enterprise Database Administration Deployment
Speaker: Kris Hokanson
Title: That's bad mkay!
Abstract:
We've all heard that things like nested views, cursors, and under/over-indexed tables are bad...but why? What is the real cost of the badness that abounds in the database world? What's really going on when you run that query against a view of a view of a view. How can you quantify what happens when that cursor ends up running the same simple query thousands of times. And how can indexes really impact the way SQL Server decides to solve your queries. In this session we'll talk about the basics of how to read query plans and use extended events to understand why all these things can be big resource drains on a SQL Server. Good times should be had by all.
SessionID: 84188
It's Time for a Change: Temporal Table Support in SQL Server 2016/17
Event Date: 15-09-2018 - Session time: 14:00:00 - Track: Enterprise Database Administration Deployment
Speaker: Vern Rabe
Title: It's Time for a Change: Temporal Table Support in SQL Server 2016/17
Abstract:
Without temporal tables (AKA history tables), we can only see the current version of data. We can’t see rows that have been deleted or rows as they existed before the latest update. The temporal table support in SQL Server 2016 gives us the ability to create system-maintained “history” tables to track all changes to the table data.
In this session we’ll discuss how you can benefit from temporal support in your tables, how to implement temporal tables in SQL Server 2016, and how to write “time travel queries” using the new FOR SYSTEM_TIME clause in a SELECT statement to easily query historical information.
SessionID: 84390
How to Realize Quantify Value from Data
Event Date: 15-09-2018 - Session time: 14:00:00 - Track: Strategy and Architecture
Speaker: Patrick Geselbracht
Title: How to Realize Quantify Value from Data
Abstract:
As we transition from the information age to the age of insights, data practitioners face the challenge of justifying investment of time, resources, and capital in data initiatives. Data and analytics professionals are increasingly being asked to practice what we preach as data storytellers and answer, what value does my data have?
We will discuss how to create business cases, value statements and return on investment for data projects and programs. We will address the approach to calculating and communicating value throughout the entire project life cycle from conception to execution to evolution with special consideration to each part of the data ecosystem including data governance, data management, data visualization, and analytics.
SessionID: 84480
Azure Intelligent Services
Event Date: 15-09-2018 - Session time: 14:00:00 - Track: Advanced Analysis Techniques
Speaker: Amie Mason
Title: Azure Intelligent Services
Abstract:
SessionID: 84634
inMemory OLTP for developers
Event Date: 15-09-2018 - Session time: 14:00:00 - Track: Enterprise Database Administration Deployment
Speaker: Konstantin Melamud
Title: inMemory OLTP for developers
Abstract:
SessionID: 77491
Event Date: 15-09-2018 - Session time: 15:15:00 - Track: Enterprise Database Administration Deployment
Speaker: Rob Volk
Abstract:
SQL Server has a number of metadata facilities available to help you with these tasks, and more. Functions, dynamic management views, and system stored procedures can illuminate details from the smallest column up through an entire SQL Server instance and everything in-between. We will demonstrate metadata techniques to help you:
- Document your database schema objects such as procedures, functions, tables, columns and indexes
- Investigate performance and look for bottlenecks
- Discover metadata to administer your databases backups, index maintenance, and security
- Apply your own metadata using extended properties
We'll also demonstrate the new SQL Data Discovery/Classification and Vulnerability Assessment features in SQL Server Management Studio.
SessionID: 78615
Data Positioning: Self-Defense or a Brilliant New Architecture
Event Date: 15-09-2018 - Session time: 15:15:00 - Track: BI Platform Architecture, Development Administration
Speaker: Scot Reagin
Title: Data Positioning: Self-Defense or a Brilliant New Architecture
Abstract:
The Cloud, streaming data, big data, self-service, machine learning, AI and the internet of things. Clearly we’re not in Data Management Kansas anymore. Data Modelers and Architects have been reacting to wave after wave of demands from these communities with new technologies and methodologies but too often remain grounded in outdated concepts of data management principles. Data Positioning is an evolution of this thinking, allowing Data Managers to deliver value today and in the future.
SessionID: 80303
How to Manage Very Large Databases with SQL Server
Event Date: 15-09-2018 - Session time: 15:15:00 - Track: Enterprise Database Administration Deployment
Speaker: Brian Carrig
Title: How to Manage Very Large Databases with SQL Server
Abstract:
Are you experiencing challenges managing Very Large Databases (VLDBs), or anticipate challenges do to future growth? In this session, I will provide practical advice on managing very large databases (databases > 1TB) with SQL server, focusing on common problem areas for new and experienced DBAs alike. These problem areas include index maintenance, integrity checks, archival, backups, and restores. We will look at new features available in SQL Server 2016 and SQL Server 2017 which make managing large databases easier, and we will explore some of the challenges and opportunities of managing large databases using SQL Server 2017 on Linux.
SessionID: 83248
Database best practices for applications
Event Date: 15-09-2018 - Session time: 15:15:00 - Track: Application Database Development
Speaker: Adam Durazo
Title: Database best practices for applications
Abstract:
SessionID: 83305
Beginning Admin: The Care and Feeding of SQL Server
Event Date: 15-09-2018 - Session time: 15:15:00 - Track: Enterprise Database Administration Deployment
Speaker: Jennifer McCown
Title: Beginning Admin: The Care and Feeding of SQL Server
Abstract:
Design and development may be exciting, but database administration is absolutely critical (and, reasonably well-paying!) The care and feeding of a server tends to get short-changed or neglected. In this class, we'll cover the basics of the big five administrator tasks:
- Backups – You must set up regular backups, to keep copies of your databases...just in case something breaks, or someone makes a bad, bad mistake.
- Integrity checks – Regularly and automatically check databases for corruption, which is when bits get scrambled, lost, and ruined.
- Index maintenance – Databases need regular upkeep so they'll continue to run well.
- Disk management – It's actually your job to find out about full disks before they happen. After all, databases grow!
- Alerting – Alerts tell you what's wrong, so you don't have to go looking for problems.
Being a database administrator is a big job, but we can cover the basics in one session!
SessionID: 83530
Moving Past Imposter Syndrome
Event Date: 15-09-2018 - Session time: 15:15:00 - Track: Professional Development
Speaker: Wendy Pastrick
Title: Moving Past Imposter Syndrome
Abstract:
We have heard a lot on recognizing Imposter Syndrome and how to address it. However, what if it’s not Imposter Syndrome after all? We will discuss working scenarios and how you approach or deal with them to determine “is it you or is it me?”
SessionID: 84284
Real-World Data Movement and Orchestration Patterns using Azure Data Factory V2
Event Date: 15-09-2018 - Session time: 15:15:00 - Track: BI Platform Architecture, Development Administration
Speaker: Jason Horner
Title: Real-World Data Movement and Orchestration Patterns using Azure Data Factory V2
Abstract:
Whether you are just getting started with Azure Data Factory or looking to make your current data factory robust and enterprise-ready this session will take you to the next level.
SessionID: 84348
The Anatomy of Select
Event Date: 15-09-2018 - Session time: 15:15:00 - Track: Application Database Development
Speaker: Jason Brimhall
Title: The Anatomy of Select
Abstract:
When was the last time you sat down to evaluate a SELECT statement? What actually goes into the processing of that teeny little word? There might be a fair bit more to this simple term than just fetching data from the database. This session covers the simplicity of the select. Then we take it a step further to dive into some of the complexities tied directly to this particular statement.
This session will help the attendee better understand the Select statement. With a more solid understanding of this statement, the attendee can return and implement some of this new knowledge to help improve processing and query response times in their own environments.
SessionID: 84475
What's new for Developers - SQL Server 2014-2017
Event Date: 15-09-2018 - Session time: 15:15:00 - Track: Application Database Development
Speaker: Bill Fellows
Title: What's new for Developers - SQL Server 2014-2017
Abstract:
Have you been too busy to explore the new developer features in 2014+? This session is for you! We're going to work through solving problems more effectively using the new capabilities built into SQL Server.
Topics covered will include JSON, string splitting and aggregation, data masking, row level security, graph processing, and too many "minor" features to mention.
SessionID: 77444
I/O Tuning 101
Event Date: 15-09-2018 - Session time: 16:30:00 - Track: Application Database Development
Speaker: Anders Pedersen
Title: I/O Tuning 101
Abstract:
One of the most common problems I have encountered as a DBA is the complaints from users that a particular query is slow, just one query. Many times one that used to run in acceptable time, but that over time has slowed down substantially.
In this session we will show some of the causes for this, with emphasis on I/O requests being too high for the query.
First part of the session will explain how to find these numbers, looking at a few queries with some major performance issues, including explaining why they have a problem.
The second part will focus on how to reduce I/O requests.
All of this can be done without the need for any 3rd party tools, all within the scope of what is available to SQL Server, all versions, all editions, including Azure.
SessionID: 77464
How to do a SQL Server Health Check
Event Date: 15-09-2018 - Session time: 16:30:00 - Track: Enterprise Database Administration Deployment
Speaker: Carlos Robles
Title: How to do a SQL Server Health Check
Abstract:
This session is about the importance of conducting regular health checks on your SQL Server instances to ensure that they are currently healthy, and continue to remain healthy.
Join me in this deep dive discussion of SQL Server best practices and guidelines about your SQL Server health.
What is a SQL Server health check?
Why we should perform a SQL Server health check regularly?
What tools we can use to perform a SQL Server health check?
SessionID: 77729
Don't just code it—Generate It
Event Date: 15-09-2018 - Session time: 16:30:00 - Track: Application Database Development
Speaker: Kevin Mackey
Title: Don't just code it—Generate It
Abstract:
Code Generators are all the rage—BIML, JS frameworks, .NET scaffolding, even the humble templates provide by SSMS for views, stored procedures, functions.
Table-driven applications allow one set of code to handle changing business needs. Metadata-driven code generation takes this a giant step further. If you can describe your code with an algorithm operating against a set of data, you can get a computer to produce the code.
- Source to Target mapping documents can be used to generate the code to effect the mapping.
- Service Broker activation stored procedures have a clearly defined structure. They can be mass-produced.
- Standard CRUD stored procedures can be stamped out cookie-cutter fashion.
- Business rules can be encoded in data and the code to implement them manufactured.
Generated code has systematic errors. Fix the errors at the generator. All the code now works. If the code is so boring that a computer can produce it, why not spend your talent doing something interesting?
SessionID: 77960
Power BI Development Best Practices
Event Date: 15-09-2018 - Session time: 16:30:00 - Track: BI Information Delivery
Speaker: Martin Schoombee
Title: Power BI Development Best Practices
Abstract:
Are you a developer or analyst, creating Power BI reports that will be shared across teams or even your entire organization? Have you given the structure of your Power BI data model any thought, what the best way is to ingest the data or whether you should have more than one table/entity in your data model?
In this session we will take a brief look at all of the considerations and best practices when developing Power BI models, reports and dashboards.
SessionID: 78563
Screw DevOps, Let's Talk DataOps
Event Date: 15-09-2018 - Session time: 16:30:00 - Track: Enterprise Database Administration Deployment
Speaker: Kellyn Pot'Vin-Gorman
Title: Screw DevOps, Let's Talk DataOps
Abstract:
DevOps is the new hot topic for IT, but only answers part of the problem. This session and demo will discuss why data creates continual friction in the DevOps environment and how it must be incorporated into the solution.
Reasons for this solution is required: -Data is getting bigger and more complex -Security concerns around critical data is becoming more evident every day -Data is created in silos in many sources, yet consumed in just as many locations, including on-premises and in the cloud.
We'll discuss the tech, the politics and the challenges of bringing data into DevOps and how to do so more successfully with culture changes, tools, scripting, and virtualization.
Takeaways from this session:
- Learn the five principles of Data Ops 2. How embracing a dynamic data platform can eliminate challenges and provide automation. 3. Learn the difference between containers, packages and data pods. 4. Learn how to bridge the gap between data and people, eliminating culture from the scene
SessionID: 80801
Eyes on the Prize: Simple and Effective Dashboard Visualization Techniques
Event Date: 15-09-2018 - Session time: 16:30:00 - Track: Analytics and Visualization
Speaker: Kevin Feasel
Title: Eyes on the Prize: Simple and Effective Dashboard Visualization Techniques
Abstract:
SessionID: 81971
Event Date: 15-09-2018 - Session time: 16:30:00 - Track: Enterprise Database Administration Deployment
Speaker: Daniel Janik
Abstract:
What if I told you that you may be doing this all wrong? What if all the work and laborious effort put into design or configuration don't improve the situation because the issue was never in SQL to begin with? Truth be told, the biggest differentiator between a good DBA and a great DBA is knowing the hardware and O/S; not just SQL.
Join me as I guide you through troubleshooting SQL Server performance from tip to toe to demonstrate the common performance problems you never knew you had.
SessionID: 84824
Event Date: 15-09-2018 - Session time: 16:30:00 - Track: Other
Speaker: Denver SQL Server User Group
Abstract:
CozyRoc highlights their products. Session topic TBD.
SessionID: 84825
#GetModern SQL Server infrastructure with DellEMC
Event Date: 15-09-2018 - Session time: 16:30:00 - Track: Other
Speaker: Denver SQL Server User Group
Title: #GetModern SQL Server infrastructure with DellEMC
Abstract:
SessionID: 85723
COZYROC: Dynamic Data Flows in SSIS without Programming
Event Date: 15-09-2018 - Session time: 16: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 run time without the need to change and redeploy the package. Columns and fields are mapped automatically at run time. 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.