Build Schedule

Advanced Filters:
  • Track

    clear all
















  • Speaker


  • Level


  • Session Type


Sessions Found: 33
In our connected world, the threat landscape is rapidly increasing. Phishing is leading to severe and crippling ransomware attacks. Malicious outsiders (and insiders) have cost much downtime. Not to mention the "traditional" threats such as "oops deletes" or site crashes. How do we protect against all of this? Is this even the DBA's role?

In this session, we'll explore 4 types of active threats to your data and organization. We'll talk about the various solutions available and help you see which threats you are vulnerable to if you've not gone far enough as we match threats and answers. Sadly, we'll share real stories of folks who've lost it all from these threats.

It's more than "take your backups, verify them, and periodically test them!" Ransomware and malicious outsiders (or insiders) eat your online backups for breakfast. 

Leave prepared, not scared, as you adopt a "Default: Secure" posture and lead the charge, even if we are "only" DBAs.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (75 minutes)

Track:
Data Security

Level: Intermedia

Session Code:

Date: July 20

Time: 8:30 AM - 9:45 AM

Room: LC04

When is Time Period based calculations useful in Power BI? Quick answer - ALWAYS! Business users need to know measures such as: What was Sales, what was the change compared to last-year, year-to-date? Did our Expenses go down, compared to similar period last year? etc.

In this session you will learn how to use and apply DAX functions in Power BI, to 
develop Time and Date based dimensions and measures that will help answer such 
questions.
Speaker:

Session Type:
Regular Session (75 minutes)

Track:
Business Intelligence

Level: Intermedia

Session Code:

Date: July 20

Time: 3:30 PM - 4:45 PM

Room: LC21

In the last releases,  SQL Server development was enriched with new T-SQL features, such as STRING_AGG, STRING_SPLIT, TRANSLATE array of Ranking and Windowing functions (ROW_NUMBER, RANK, DENSE_RANK, TILE), MERGE statement, OUTPUT clause, EXCEPT and INTERSECT just to name a few. For various reasons some DBA/Developers do not utilize these new features. In this session, the audience will see demonstrations of the different practical use cases where these features can make T-SQL coding more efficient. This 100% code-based demo session highlights efficiency to utilize the latest T-SQL functions over conventional methods with the same functionality. The session will cover in depth live scenarios where these features have proven performance efficiency, code re
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (75 minutes)

Track:
Database Development

Level: Intermedia

Session Code:

Date: July 20

Time: 8:30 AM - 9:45 AM

Room: LC04

Negotiating a downtime for a release can be difficult in this modern, 24x7 world.  When downtime means lost revenue, the price of taking a downtime to deploy code can run up quickly.  This talk will show you a way to reduce the cost of deployment by reducing or even eliminating required downtime for database code deployment.  We will show how to release new database code, update existing stored procedures, refactor and restructure tables, and even perform systemic re-architecture with no downtime and minimal blocking.  We will use as a case study one release in which we modified the primary key column on 180 tables and updated over 550 stored procedures without end users noticing a thing.  If you want to hit that three nines (or better) service-level agreement, this talk will help get you on the road to reduced downtime.
Speaker:

Accompanying Materials:

Session Type:
Regular Session (75 minutes)

Track:
Database Development

Level: Intermedia

Session Code:

Date: July 20

Time: 12:30 PM - 1:45 PM

Room: LC19

This is an open session where you may show up any time and ask any technical or professional questions of our panel of speakers.

Ask the Experts is an opportunity to find answers and resources to address ongoing challenges, learn more about our speakers, and maybe stump them : )
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (75 minutes)

Track:
Panel

Level: Beginner

Session Code:

Date: July 20

Time: 3:30 PM - 4:45 PM

Room: LC20

Azure Databricks is the hottest new service being offered on Azure! Designed in collaboration with Microsoft and Databricks, the creators of Apache Spark, Azure Databricks combines the best of Databricks and Azure to help customers accelerate innovation with one-click set up, streamlined workflows and an interactive workspace that enables collaboration between data scientists, data engineers, and business analysts. Databricks was founded by the creators of the Spark big data platform to make creating creating and managing clusters a snap and provide a first class secure data science team collaboration environment. In this presentation, we'll explain key concepts and features while demonstrating this amazing service.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (75 minutes)

Track:
Data Science

Level: Intermedia

Session Code:

Date: July 20

Time: 8:30 AM - 9:45 AM

Room: LC19

There are several ways to create a machine learning model. You can use R or Python or even other languages such as C#. Advanced coding skills are required no matter which language you choose. Once the solution is created, it’s often difficult to deploy. 

Microsoft addresses those problems with Azure Machine Learning, or Azure ML. Azure ML has built-in transforms for cleansing and munging data. It also contains a variety of configurable machine learning models that can be used without coding. Deploying the model is easy, and users can link to it directly with Excel or a custom application can be written.

If you are experienced in machine learning but haven’t seen Azure ML or if you are curious about machine learning and data science, this session is for you.
Speaker:

Accompanying Materials:

Session Type:
Regular Session (75 minutes)

Track:
Data Science

Level: Intermedia

Session Code:

Date: July 20

Time: 12:30 PM - 1:45 PM

Room: LC20

Ever wanted to start a 'blog, but have no idea how to do it?  It's easier than you think!  A number of people have become successful by writing 'blog articles.  I originally started my 'blog to supplement my presentations.  Since then, it's taken on a life of its own.

In this presentation, I'll tell you how I got started with 'blogging, where it's taken me since then, and lessons I've learned along the way.  We'll discuss 'blog platforms, how to get started, what to write about, and what to do (and what NOT to do) when writing articles.
Speaker:

Session Type:
Regular Session (75 minutes)

Track:
Professional/Personal Development

Level: Beginner

Session Code:

Date: July 20

Time: 3:30 PM - 4:45 PM

Room: LC05

You’ve just inherited a large SQL Server estate, and next month’s merger will double the number of instances you’re responsible for. Or maybe you have one big instance with thousands of databases on it. Are there backups? Are they good? Are your systems in good health?

The department just decided to reorganize and consolidate databases to prepare for an upgrade to the next release of SQL Server. How are you going to manage all this?

It's time to automate with the dbatools Powershell module. We’ll briefly talk about the project itself, then take a tour of functions commonly used to manage SQL Server environments and data. When you leave, you’ll be ready to level up your administration toolkit and start reducing your daily workload.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (75 minutes)

Track:
Database Administration

Level: Beginner

Session Code:

Date: July 20

Time: 2:00 PM - 3:15 PM

Room: LC05

We'll look at the new features that have rolled out in response to a major push at Microsoft to make Power BI reports more accessible. What some of the different areas of accessibility to think about, and some handy tools to help you make your reports more usable for everyone.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (75 minutes)

Track:
Analytics and Visualization

Level: Beginner

Session Code:

Date: July 20

Time: 2:00 PM - 3:15 PM

Room: LC20

Most developers use Power BI desktop to design the visuals and publish to the Azure service for production. 

Out of the box, Power BI has 29 visuals.  There are 208 custom visuals that can be down loaded from Appsource.Microsoft.com. 

While there are many choices, the business problem might not have an out of the box visual that can be customized the way you want.  How do you solve this problem?

This is where the custom scripting with Python visual comes in.  

At the end of the presentation you will know which libraries that you can use to extend your toolbox for both on premise and the azure service.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (75 minutes)

Track:
Data Science

Level: Intermedia

Session Code:

Date: July 20

Time: 8:30 AM - 9:45 AM

Room: LC21

When it comes to feed the modern data warehouse in Azure, we're facing new challenges. This session will explain what id the modern data warehouse and how it can be fed using ETL 2.0 methodologies. Topics like Common Data Model and services will also be talked and demonstrated.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (75 minutes)

Track:
Big Data

Level: Intermedia

Session Code:

Date: July 20

Time: 10:00 AM - 11:15 AM

Room: LC21

The session aim is to get people excited and curious more about ML without digging in coding or deep concepts. 

We will explore ML Azure offering, Some ML concepts, ML Studio, create an experiment from Scratch and show how ML can target common business challenges like demand projection or price targeting

Lots of hands-on
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (75 minutes)

Track:
Cloud Application Development & Deployment

Level: Beginner

Session Code:

Date: July 20

Time: 3:30 PM - 4:45 PM

Room: LC04

Time and time again the same misunderstandings by developers and query writers appear when query performance issues arise. In this demo heavy presentation, we will review these specific topics such as data types, implicit conversions, sargability, and some others that all have an impact on query performance. Come join me and by the end of this session you will have the knowledge to boost your query performance!
Speaker:

Session Type:
Regular Session (75 minutes)

Track:
Database Development

Level: Beginner

Session Code:

Date: July 20

Time: 10:00 AM - 11:15 AM

Room: LC07

Do you understand how SQL Server handles I/O? If not, you should. Understanding I/O is more important than ever with increasing cloud adoption, due to cloud costing models. But even on-premises, I/O has a direct impact on T-SQL performance.

Join me for a deep dive into the storage engine to understand how SQL Server handles I/O.  Concepts will be paired with T-SQL examples to illustrate the practical impacts. 

When you leave, you'll be able to optimize your T-SQL reduce I/O and improve performance across the board.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (75 minutes)

Track:
Database Development

Level: Intermedia

Session Code:

Date: July 20

Time: 8:30 AM - 9:45 AM

Room: LC07

Seven fast-paced 10-minutes-or-less sessions on a variety of topics:

Paresh Motiwala: Use of three free MS tools for DB migration
Taiob Ali: Extended Events - How to collect the first 10 or every 4th event
Andy Yun: SQL Server Performance Troubleshooting: Bottom to Top... or Top to Bottom?
Ray Kim: Business Cards: The most important networking tool!
Michelle Guzait: How to be a rockstar resolving almost any SQL Server emergency issue.
Deborah Melkin: The Solution Isn't the Problem
Bryan Cafferky: Azure Machine Learning service and why the s is lower case
Speaker:

Accompanying Materials:

Session Type:
Regular Session (75 minutes)

Track:
Lightning Talks

Level: Beginner

Session Code:

Date: July 20

Time: 2:00 PM - 3:15 PM

Room: LC19

Most database professionals know there are two different database design patterns - normal forms for OLTP databases and star schemas for data warehouses. We tend to discuss these separately. But these two designs actually work together when we create our table schemas.

In this session, we will review the basics of both normal forms and star schemas. We'll compare and contrast the two designs. We will then discuss how a normalized database design influences a star schema design and vice versa. 

By the end of the session, you will better understand how using the two designs together gives you a greater insight to how you use your data throughout its lifecycle.
Speaker:

Session Type:
Regular Session (75 minutes)

Track:
Data Architecture & Design

Level: Beginner

Session Code:

Date: July 20

Time: 10:00 AM - 11:15 AM

Room: LC05

SQL 2019 is here to stay. Do you know how to move to SQL 2019? In this riveting session we will learn about 
1. New Features of SQL 2019
2. Why you need to migrate?
3. How to upgrade/move to SQL 2019
4. Certifying your application for SQL 2019- A tricky question and discussion
5. Compatibility level and things you normally wouldn't care for!
6. Changes in functionality and caveats
7. The holy trinity: "Database Migration Guide", "Database Experimentation Assistant" and "Query Tuning Assistant"; tools that make your life easy.
8. A direct look into the "MAP Toolkit"
Time permitting we will demo these.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (75 minutes)

Track:
Database Administration

Level: Beginner

Session Code:

Date: July 20

Time: 12:30 PM - 1:45 PM

Room: LC21

Looking to get the most out of your SQL Saturday, PASS Summit, or local user group meeting? Plan ahead!  Events aren't just about learning new things, they're about meeting new people, networking with peers, and learning different approaches to common issues.

In this session, we'll go over steps you can take before, during and after the event to maximize the amount of great stuff you'll take away at the end (besides cool vendor swag).  Not just keeping up on new technologies, but meeting new people, getting leads on solutions/opportunities, and an appreciation for the community you're in and what it has to offer.
Speaker:

Session Type:
Regular Session (75 minutes)

Track:
Professional/Personal Development

Level: Beginner

Session Code:

Date: July 20

Time: 8:30 AM - 9:45 AM

Room: LC05

Have you tried implementing source control? How has your continuous integration (CI) process gone? 

This session is for developers, database administrators, database engineers, and data architects that want to automate their database deployments. Particularly for those individuals that have hit roadblocks along that way. We will discuss the differences between migration and stated-based deployment methods. We will also discuss options with branching and merging. 

At the end of the session, attendees will know how to select the best deployment method for their environment. In addition, attendees will be familiar with branching and merging strategies that can be used as part of their continuous integration strategy.

Attendees should be familiar with general concepts about source control and be comfortable with Visual Studio or VS Code.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (75 minutes)

Track:
Database Development

Level: Intermedia

Session Code:

Date: July 20

Time: 10:00 AM - 11:15 AM

Room: LC20

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