Build Schedule

Advanced Filters:
  • Track

    clear all










  • Speaker


  • Level


  • Session Type


Sessions Found: 29
AutomatedML is the process of automating the time consuming, iterative tasks of machine learning model development. It allows data scientists, analysts, and developers to build ML models with high scale, efficiency, and productivity all while sustaining model quality. Automated ML democratizes the machine learning model development process, and empowers its users, no matter their data science expertise, to identify an end-to-end machine learning pipeline for any problem. In this session, we will talk about Automated Machine Leanring process and also will give step by step demo of Azure AutoML.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Application & Database Development

Level: Beginner

Session Code:

Date: February 29

Time: 1:20 PM - 2:20 PM

Room: Room 5

If you work with SQL Server at all, you need to know Transact-SQL, the SQL Server programming language. During this session, we’ll design and create our own table to demonstrate key concepts, query syntax, and more. If you’ve been meaning to learn T-SQL, here’s your chance!
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Application & Database Development

Level: Beginner

Session Code:

Date: February 29

Time: 8:30 AM - 9:30 AM

Room: Room 2

The SELECT statement is one of the most used tools in our SQL toolbelt. While it’s the basis for what we do with data, it’s anything but basic. In this presentation, we will first explore how SELECT statements are processed. Then we will discuss various ways we build on to our SELECTs. We'll also examine how and why we may or may not want to use them. At the end of the session, we will have a greater understanding of how SELECTS work and how we can approach them so we can be smarter as we write more complex statements.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Application & Database Development

Level: Intermedia

Session Code:

Date: February 29

Time: 9:50 AM - 10:50 AM

Room: Room 2

Just like pilots who are prepared for disaster recovery through regular practice, we as database administrators need to actually spend time practicing recovering with those backups. Ransomware has made it critical to prepare to rebuild your datacenter at any moment. 

This session will focus on the kinds of situations that can dramatically affect a data center, and how to practice recovery processes to assure business continuity.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Enterprise Database Administration & Deployment

Level: Beginner

Session Code:

Date: February 29

Time: 3:50 PM - 4:50 PM

Room: Room 2

Every expert has their own set of tools they use to find and fix the problem areas of queries, but SQL Server provides the necessary information to both diagnose and troubleshoot where those problems actually are, and help you fix those issues, right in the box. In this session we will examine a variety of tools to analyze and solve query performance problems.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Enterprise Database Administration & Deployment

Level: Beginner

Session Code:

Date: February 29

Time: 9:50 AM - 10:50 AM

Room: Room 5

As DBAs we oversee the safety and security of our databases. Integrity, Backup and ability to restore in a timely fashion are most important responsibilities. 
In addition to Microsoft's own Maintenance Plans and Ola Hallengren's awesome scripts, there are many tweaks available that can be exploited for our success; we will learn about those too. 
I will share with you my own experiments that I conducted over a period of one month. I will share supporting data, to show how I helped save several hours of downtime for my company. 
We'll also some of the best practices to help you cut down the maintenance window and give max up-time for your discerning customer.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Enterprise Database Administration & Deployment

Level: Intermedia

Session Code:

Date: February 29

Time: 9:50 AM - 10:50 AM

Room: Room 4

Do you write T-SQL for a living and want to improve its performance? Do you wish your 3rd party vendor code would magically go faster? Then you need to learn about Intelligent Query Processing in SQL Server 2019. This collection of new features is a game changer that will improve performance across the board. Come to this overview session to learn more about how these capabilities will benefit you.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Application & Database Development

Level: Beginner

Session Code:

Date: February 29

Time: 2:35 PM - 3:35 PM

Room: Room 3

We will go through Clustered and Non Clustered index internals. How Indexes are allocated and how SQL Server uses indexes in Select operations.

In that session we will use DBCC IND and DBCC PAGE and dig into pages' binary code to understand how SQL Server uses different kinds of Indexes.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Enterprise Database Administration & Deployment

Level: Advanced

Session Code:

Date: February 29

Time: 8:30 AM - 9:30 AM

Room: Room 4

In this session, we will look at the new Query Store feature in SQL Server 2016, 2017, and 2019.  Query Store tracks changes in execution plans, allowing you to easily view performance differences and revert to older plans with a few clicks of the mouse in 2016.

Then in 2017, Microsoft added wait stats per query plan and Automatic Plan Correction capabilities.  Allowing DBAs more tools to troubleshoot fires with and a way to automatically resolve issues.

In this session, we will walk through the features of the Query Store, so you can understand how to use them in SQL Server 2016, 2017, and 2019.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Enterprise Database Administration & Deployment

Level: Beginner

Session Code:

Date: February 29

Time: 2:35 PM - 3:35 PM

Room: Room 5

PowerPivotPro's Foundations curriculum is a crash course that has been crafted and refined over 10+ years to help Power BI and Power Pivot beginners to level-up their DAX skills quickly. This talk will be an introduction to Evaluation Context and the role it plays in how a DAX formula works under the hood, which is a critical concept for progressing beyond the limitations of drag-and-drop measures in Power BI and Excel Pivot Tables.
Speaker:

Accompanying Materials:

Session Type:
Regular Session (60 minutes)

Track:
BI Platform Architecture, Development & Administration

Level: Beginner

Session Code:

Date: February 29

Time: 8:30 AM - 9:30 AM

Room: Room 3

When it comes to getting your data into Excel or Power BI, M is your best choice. The M Language (A.K.A Power Query) is a powerful tool for self-service data preparation. However, it's not clear where it fits compared to tools like SSIS or TSQL. It's also not clear what it's limitations are. This session will cover the basics of M and when to use it.

In this session, we'll demonstrate how M is a linear series of transformations, just like a set of steps from a recipe. We'll show how 80% of what you will ever need to do can be done from the GUI. We'll also talk about how to write custom code for that other 20%. By the end of this presentation, you'll be able to take any manual cleanup you do today and turn it into a repeatable process with M.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
BI Platform Architecture, Development & Administration

Level: Beginner

Session Code:

Date: February 29

Time: 9:50 AM - 10:50 AM

Room: Room 3

Data > Opinion

Sentiment Analysis helps you understand what customers are feeling.  Being able to gauge public opinion is the key to understanding how your brand is being perceived in the marketplace. In this talk we will look at how to perform sentiment analysis on some Twitter data using Python in SQL Server and Machine Learning Services. No Data Science or Python experience is necessary to begin leveraging the tools Microsoft has made available to help extract meaning from your data.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Analytics and Visualization

Level: Beginner

Session Code:

Date: February 29

Time: 11:20 AM - 12:20 PM

Room: Room 3

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 (60 minutes)

Track:
Application & Database Development

Level: Intermedia

Session Code:

Date: February 29

Time: 1:20 PM - 2:20 PM

Room: Room 3

Three fast-paced 15-minutes-or-less talks, followed by a chance to have some Q&A with our speakers.

Kim StJacques - Introduction to SQL Server 2019 PolyBase
Ray Kim - Business cards: the most important networking tool
Taiob Ali - Extended Events - How to collect the first 10 or every 4th event
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Other

Level: Beginner

Session Code:

Date: February 29

Time: 11:20 AM - 12:20 PM

Room: Room 2

Three fast-paced 15-minutes-or-less talks, followed by a chance to have some Q&A with our speakers.

Deborah Melkin - Inside the UPDATE
Matt Cushing - Using PowerBI to keep your sanity
Michael Grayson - SQL Server and MongoDB: A side by side “How To"
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Other

Level: Beginner

Session Code:

Date: February 29

Time: 2:35 PM - 3:35 PM

Room: Room 2

Mapping Data Flows feature of Azure Data Factory is now generally available since October 2019.

There are many different use-case scenarios that can be covered by Data Flows, considering that Data Flows in SQL Integration Service (SSIS) projects are still playing a big role in fulfilling Extracting-Loading-Transforming (ETL) patterns for your data.

In this session, I will share my experience of populating a Data Vault repository with the help of Mapping Data Flows in Azure Data Factory.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Application & Database Development

Level: Intermedia

Session Code:

Date: February 29

Time: 11:20 AM - 12:20 PM

Room: Room 4

Do you ever find yourself executing the same unit of work over and over again?  Have you ever found that your SQL Servers have inconsistent build configurations?  Have you ever been paged in the middle of the night to resolve an issue?  With automation you can reduce the amount of mundane work you do so you can focus on more interesting things, make your environment consistent and easier to support, and finally help you get more sleep!  Please join us as we help kick-start your automation journey as we discuss the benefits, tools, tips and tricks, and best practices of automation.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Enterprise Database Administration & Deployment

Level: Beginner

Session Code:

Date: February 29

Time: 3:50 PM - 4:50 PM

Room: Room 3

Regular expressions can help you perform incredible tasks with very little effort. Need to create 1700 logins from an email request? Developers give you a single script with 300 stored procedures filled with table variables instead of temp tables? Need to move 500 databases to a different drive? Any of these tasks can take a long time to code, but regular expressions cuts that work from hours to seconds. I use regular expressions all the time and I have taken many tasks down from several days to just a few minutes. Stop writing code manually and let regular expressions do it for you. 
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.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Application & Database Development

Level: Intermedia

Session Code:

Date: February 29

Time: 11:20 AM - 12:20 PM

Room: Room 5

Mental illness is more common than you think.  One in four Americans suffers from a mental illness each year.  In the tech community, this is often not talked about.  Many times, people feel alone and isolated in the tech community with us mostly being introverted people.  It is time to start talking about mental illness out in the open and honestly about how it affects us and those around us.

In this session, we will talk about what mental illness is and what it is not.  How my mental illness has affected me.  How it effects the tech industry.  How mental illness can affect you and how you can tell if you are starting to have issues.  What to say and what not to say to people you know that are affected by mental illness.  Finally, how to get help and where reach out for help.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Professional Development

Level: Beginner

Session Code:

Date: February 29

Time: 11:20 AM - 12:20 PM

Room: Room 1

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:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Professional Development

Level: Beginner

Session Code:

Date: February 29

Time: 8:30 AM - 9:30 AM

Room: Room 1

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