Build Schedule

Advanced Filters:
  • Track

    clear all











  • Speaker


  • Level


  • Session Type

Sessions Found: 57
Interested in becoming a consultant? Think it's too overwhelming? Want to be your own boss? Wish to expand your clientele? 

The hardest thing about being your own boss is getting in the right mindset and to truly understand that your past doesn’t equal your future.

In this 60 minute session, I cover 3 keys to being a successful consultant. I share techniques used to help others get in the right mindset and tackle the mental blocks to achieving success in their entrepreneurial pursuits.

Whether you are interested in starting your own business, or a consultant wanting to expand your clientele, this session will position you for future success as an entrepreneur.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Professional Development

Level: Beginner

Session Code:

Date: June 01

Time: 8:30 AM - 9:30 AM

Room: 2.103

Over the past several years, we have seen a resurgence of interest in functional programming languages, particularly with the success of Scala and R in the marketplace.  Although object-oriented (oo) design remains the dominant software development paradigm, even oo-first languages have seen a shift toward the functional mindset with the emphasis on LINQ in C# and lambdas in Java.  This move toward a functional style should be particularly welcome for data platform specialists, who already have a leg up in understanding  functional programming concepts thanks to their work with SQL.

In this talk, we will focus on one functional programming language, F#.  We will look at some of the basics of the language and see how you can translate knowledge of SQL into a pipeline-driven functional programming language.  We will also see areas where F# integrates smoothly with SQL, creating a powerful way to extend your SQL skills beyond queries.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Application & Database Development

Level: Beginner

Session Code:

Date: June 01

Time: 1:15 PM - 2:15 PM

Room: 2.106

Do you know what makes a great data model?  What does it mean to be Third Normal Form or a Star Schema?  When would you use one over the other and why?  How can you identify bad designs?  In this presentation you will be exposed to good and bad models and learn what you should do in order to create a perfect ten model of your own!
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
BI Platform Architecture, Development & Administration

Level: Beginner

Session Code:

Date: June 01

Time: 9:45 AM - 10:45 AM

Room: 2.103

Are you curious about Visual Recognition and Object Detection in Azure?  Are you wondering what the difference is between the Computer Vision API and the Custom Vision API?  Do you want a quick introduction to get you up to speed on both, so that you can quickly build and deploy a Cognitive Services model?

Join us for an introduction to the Cognitive Services Computer Vision and Custom Vision APIs on Azure.

In this session, we will look at the basics of Cognitive Services Vision.  First learn how to create your Cognitive Services model.  Then you can see how to train and improve accuracy.  Finally, we will step through python code in Azure Notebooks to call the APIs.

After this session, you will get up and running in Cognitive Services Vision in under an hour!

Prerequisites: Attendees who would like to follow along should have an Azure account, as well as an account on Azure Notebooks.  Experience with coding in python is helpful, but not required.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Analytics and Visualization

Level: Beginner

Session Code:

Date: June 01

Time: 11:00 AM - 12:00 PM

Room: 1.117

Coming from the Excel world, DAX can look like Excel formulas on steroids. However, to be successful with DAX and Powerpivot, you'll need a completely different mental model. In this introduction to DAX, we won't spend too much time on the basics. Instead, we'll focus the concepts that make DAX unique. This will help you avoid the stumbling blocks of working with DAX. We will cover calculated columns, measures, aggregations, filtering, and iterators.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
BI Information Delivery

Level: Beginner

Session Code:

Date: June 01

Time: 2:30 PM - 3:30 PM

Room: 1.117

What exactly does it mean to have optimistic concurrency? What is the alternative? Is SQL Server 2012's SNAPSHOT Isolation optimistic?  How can SQL Server 2016's In-Memory OLTP provide truly optimistic concurrency? 
In this session, we'll look at what guarantees the various isolation levels provide, the difference between pessimistic and optimistic concurrency, and the new technology added in SQL Server 2014 that allows the enormous benefits of having totally in-memory storage with no waiting!
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Enterprise Database Administration & Deployment

Level: Intermedia

Session Code:

Date: June 01

Time: 3:45 PM - 4:45 PM

Room: 1.118

In this session we will discuss Data Strategy around data lake ingestion and how that shapes the design of a framework to fuel Azure Data Factory. This session will take you through the development of a Metadata database designed using Data Vault modeling, the collection of the metadata, as well as building a fully automated Data Factory pipeline. We will be learning how to create a holistic solution using Azure Data Factory.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
BI Platform Architecture, Development & Administration

Level: Intermedia

Session Code:

Date: June 01

Time: 2:30 PM - 3:30 PM

Room: 2.103

In this session you will learn the best practices, tips and tricks on how to successfully use Azure SQL Database Managed Instance on production environments. You will learn how to monitor and improve Azure SQL Database Managed Instance query performance in comparison to SQL Server and Azure SQL Database. I will cover how Microsoft Support has been using the Query Store, Extended Events, DMVs to help customers monitor and improve query response times when running their databases in this Azure PaaS offering. These learnings are fruit of Microsoft support cases, and customer field engagements. This session is mostly composed of demos.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Cloud Application Development & Deployment

Level: Intermedia

Session Code:

Date: June 01

Time: 1:15 PM - 2:15 PM

Room: 1.110

As a DBA, you know the importance of having off-site database backups (in case of disaster in your data centers). Historically, the logistics for off-site database backups have been complex and expensive. Backing up to the cloud brought simplification and an economical option. In this session, we will introduce the functionality that is built-in to SQL Server for backing a database up to the Azure Cloud ("Backup to URL"). We will discuss some concepts around Azure BLOB storage, explain the process of configuring backups, and then discuss troubleshooting issues with Backup to URL.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Enterprise Database Administration & Deployment

Level: Beginner

Session Code:

Date: June 01

Time: 1:15 PM - 2:15 PM

Room: 2.115

DevOps automation can be intriguing to learn and overwhelming to implement. This session will take a real life use case of a multi-tier and complex environments, with various stake holders to a successful conclusion. The session will demonstrate the reasons to automate, along with the steps required to make it possible, offering insight into concepts that are often too vague to employ. The attendee will see multi-platform and cloud tool demonstrations on how to take the DevOps methodology and continuous delivery to actuality in their own projects, no matter if small or large.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Cloud Application Development & Deployment

Level: Intermedia

Session Code:

Date: June 01

Time: 3:45 PM - 4:45 PM

Room: 1.212

Stop wasting time going to Excel to create pivot tables when using T-SQL. 

Become a query writing ninja who uses the Pivot operator to move unique column values into multiple column names for better data insight with ease. In this demo-heavy presentation, you will learn how to build pivot tables enhanced with multiple aggregate columns and column totals using Rollup and Cube operators, and the grouping function. Attendees will also learn to use the Unpivot Operator.

Come join me, and by the end of this session, you will have the knowledge to level up your pivoting skills to that of a ninja or maybe even *Chuck Norris.
*Not Possible
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Analytics and Visualization

Level: Intermedia

Session Code:

Date: June 01

Time: 9:45 AM - 10:45 AM

Room: 1.110

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!
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Enterprise Database Administration & Deployment

Level: Beginner

Session Code:

Date: June 01

Time: 8:30 AM - 9:30 AM

Room: 1.110

The time has come where DBAs can no longer afford to ignore powershell. Not only has it become an integral part of SQL Server, but we’re being asked to do things on a much grander scale than ever before; things that can only be done with powershell. This session will take you from nothing and explain what powershell is all about. I’m going to show you how the more things change the more they stay the same and if you master the basics of powershell in this session, you’ll be able to work with powershell not only in SQL Server, but also at the file system level, in Exchange, IIS, Windows, and anything else. So in this session I’m going to show you the basics you need to get your powershell career started.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Enterprise Database Administration & Deployment

Level: Beginner

Session Code:

Date: June 01

Time: 3:45 PM - 4:45 PM

Room: 1.107

In this sessions, we will create measures using the DAX language to support more sophisticated data analytics. 
We'll look at measures for Time Intelligence, such as Year To Date, Previous Year, Year over Year, Moving Annual Total, Rolling Averages. 
We'll also look at measures that handle different dimensional granularities, like Forecast/Budget measures.
The DAX language is designed to look like Excel functions, so if you don't have any Power BI experience, but you are an Excel wizard, you should be able to follow.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
BI Platform Architecture, Development & Administration

Level: Intermedia

Session Code:

Date: June 01

Time: 3:45 PM - 4:45 PM

Room: 2.106

Data collection and usage is all around us, it is what we do. But is what we do with the data ethical? Are we collecting and processing biased data?  We will take a look at ethical data collection and usage, what it means to your models and forecasts, and how being aware of possible biases can impact your bottom line. You might be training on extremely biased data and not know it, skewing your forecasts in the wrong direction.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Strategy and Architecture

Level: Beginner

Session Code:

Date: June 01

Time: 8:30 AM - 9:30 AM

Room: 1.107

Database benchmarking is a task that many DBA's only perform on rare occasion - such as before adopting a new hardware and/or software platform. Yet the DBA is often asked to provide an expert opinion on the relative chance for success based upon performing database benchmarks. Yet most database benchmarking projects fail totally or provide less than accurate predictions often resulting in huge surprises. The basic or root cause is almost universally due to common myths and misconceptions. This session will prepare you to perform both repeatable and reliable database benchmarks - and how to avoid the most common problems and their associated misery.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Enterprise Database Administration & Deployment

Level: Intermedia

Session Code:

Date: June 01

Time: 8:30 AM - 9:30 AM

Room: 1.102

You're comfortable writing T-SQL, and you've built a lot of stored procedures that have a bunch of parameters. For example, you have that "product search" stored proc with parameters for product category, name, price range, sort order, etc, and you have to accept any of 'em. 

So how do we make those go fast? And how can we get 'em to use indexes?

In one all-demo hour, performance tuner Brent Ozar will show you several ways that fail in comically bad ways. You'll learn how to write dynamic SQL that's easy to tune, manage, and troubleshoot.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Application & Database Development

Level: Intermedia

Session Code:

Date: June 01

Time: 8:30 AM - 9:30 AM

Room: 1.118

Data breaches abound! Do you want to keep off of the data breach list? What are some of the data privacy laws affecting you? How will encrypting data affect your database performance? What data fields should you encrypt?  What else can you do to protect your sensitive data?

In this session, we will review each option to encrypt data within SQL Server, Transparent Data Encryption, Cell Level Encryption and Always Encrypted. The session will deep dive into setting up Always Encrypted encryption and share my experiences implementing the encryption. In addition, the session will review auditing of sensitive data usage.  

You will leave the session with a deeper understanding about SQL Server encryption options and how encryption can affect your performance.  In addition, you will gather information on how to fully protect and review your sensitive data usage.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Application & Database Development

Level: Beginner

Session Code:

Date: June 01

Time: 8:30 AM - 9:30 AM

Room: 2.115

Performance Tuning starts with looking at a plan SQL Server internally uses to execute T-SQL. There are many parts to the plan as well as additional options for performance tuning.  This session will provide real-world examples of T-SQL that can cause execution plans to not be optimal.  The plan might also expose additions in the form of new indexes that can be added to improve performance. 
There are many paths to reading these plans that need to be discussed and probably you will hear 'it depends' in this session. Explanations of why it depends will be used with examples.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Application & Database Development

Level: Beginner

Session Code:

Date: June 01

Time: 8:30 AM - 9:30 AM

Room: 2.106

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:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Enterprise Database Administration & Deployment

Level: Beginner

Session Code:

Date: June 01

Time: 11:00 AM - 12:00 PM

Room: 2.106

Sessions Found: 57
Back to Top cage-aids
cage-aids
cage-aids
cage-aids