Build Schedule

Advanced Filters:
  • Track

    clear all











  • Speaker


  • Level


  • Session Type

Sessions Found: 25
Your Always On Availability Group just failed. Quick! What do you do? Many of us go straight to the SQL Server log and the Availability Group dashboard. That makes sense - both are great troubleshooting tools, and the answer is often found in one of them. However, they don't always have the answer we seek. What then?

As a consultant, I've been able to troubleshoot a number of less-common scenarios first-hand. Join me as we walk through some of these scenarios to show you how to detect and correct them. Along the way, we'll also discuss alerts you can put into place on your servers to give you immediate feedback when something in your availability group goes wrong.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (75 minutes)

Track:
Enterprise Database Administration & Deployment

Level: Beginner

Session Code:

Date: June 23

Time: 2:15 PM - 3:30 PM

Room: 2523

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.
Demos are included during several parts of the presentation.
Speaker:

Accompanying Materials:

Session Type:
Regular Session (75 minutes)

Track:
Cloud Application Development & Deployment

Level: Intermedia

Session Code:

Date: June 23

Time: 12:50 PM - 2:05 PM

Room: 2520B

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

Session Type:
Regular Session (75 minutes)

Track:
Cloud Application Development & Deployment

Level: Advanced

Session Code:

Date: June 23

Time: 3:40 PM - 4:55 PM

Room: 2390

The cardinality estimator in SQL Server is a massively complex piece of software that is responsible for calculating the estimated number of rows for query plans. We will derive some of the simplest and most important rules for cardinality estimation. Armed with that knowledge, we will address errors in cardinality estimates which can cause poor query performance. Demos include filtering on multiple columns, using local variables, dealing with ascending keys, and more.
Speaker:

Session Type:
Regular Session (75 minutes)

Track:
Application & Database Development

Level: Intermedia

Session Code:

Date: June 23

Time: 12:50 PM - 2:05 PM

Room: 2523

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:

Session Type:
Regular Session (75 minutes)

Track:
Enterprise Database Administration & Deployment

Level: Beginner

Session Code:

Date: June 23

Time: 8:45 AM - 10:00 AM

Room: 2520B

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

Session Type:
Regular Session (75 minutes)

Track:
Application & Database Development

Level: Advanced

Session Code:

Date: June 23

Time: 3:40 PM - 4:55 PM

Room: 2523

Having a good understanding what security features are available and what configurations are considered best practice can be crucial to your  company's data security.  Learn to view security differently and how key builtin security features can be leveraged to make your systems both more maintainable and more secure.  This is very much a HOW TO session, both in terms of how to decide what feature combinations work best for your environment and how to implement those features.
Speaker:

Session Type:
Regular Session (75 minutes)

Track:
Strategy and Architecture

Level: Beginner

Session Code:

Date: June 23

Time: 12:50 PM - 2:05 PM

Room: 2520D

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

Accompanying Materials:

Session Type:
Regular Session (75 minutes)

Track:
Strategy and Architecture

Level: Intermedia

Session Code:

Date: June 23

Time: 3:40 PM - 4:55 PM

Room: 2520D

Come to this session to get your toes wet with machine learning. What are the types of questions it can answer? What are the types of models it can produce? What are some the of techniques used? There will be practical demos using Azure Machine Learning as well. Enough info to get you started, or enough to quit while you're ahead, either way, you'll come out with some concrete ideas of what ML is all about.
Speaker:

Accompanying Materials:

Session Type:
Regular Session (75 minutes)

Track:
Analytics and Visualization

Level: Intermedia

Session Code:

Date: June 23

Time: 8:45 AM - 10:00 AM

Room: 2390

Many DBA's have the same outlook on Powershell - we all know we should use it, but we don't think we have time to learn one more tool that isn't even really part of SQL Server anyway.  I was one of these DBA's for many years, but recently I have come to respect the *power* of Powershell.  Come learn the basics of Powershell, how Powershell and SQL Server interact with each other, and finally how to use Powershell to automate common SQL Server tasks such as maintenance and SQL Server installations.  If you need to interact with Windows or Active Directory, odds are Powershell is the right tool for the job - come learn how to use it!
Speaker:

Session Type:
Regular Session (75 minutes)

Track:
Enterprise Database Administration & Deployment

Level: Beginner

Session Code:

Date: June 23

Time: 10:10 AM - 11:25 AM

Room: 2520B

Have you ever setup a new instance and realized later that you skipped a configuration step? Did you get handed a database from another team and want to see how much work you have to do to clean up it’s configuration? Don’t you wish there was an easy way to validate that every instance in your environment was configured correctly?

In this session we’ll be learning about an exciting new powershell module called dbachecks which seeks to solve these problems. Built upon the backbones of dbatools and pester, this is a unit testing framework with over 100 predefined checks to validate your instances.
Speaker:

Session Type:
Regular Session (75 minutes)

Track:
Enterprise Database Administration & Deployment

Level: Beginner

Session Code:

Date: June 23

Time: 2:15 PM - 3:30 PM

Room: 2520C

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

Accompanying Materials:

No material found.

Session Type:
Regular Session (75 minutes)

Track:
Cloud Application Development & Deployment

Level: Intermedia

Session Code:

Date: June 23

Time: 2:15 PM - 3:30 PM

Room: 2520B

Multi-user systems are affected by how SQL Server locks resources to manage concurrent transactions. Understanding how SQL Server uses locks to isolate transactions from one another is important for both writing code and running maintenance tasks. 

In this session, we will discuss lock modes in SQL Server and how they impact your queries. We will show how different isolation levels change which locks are taken and for how long they are held. We will look at ways to avoid unnecessary blocking for maintenance tasks like index rebuilds. Assertions will be backed up with demo-based evidence.

After this session, you will have the understanding you need to start writing application code and maintenance jobs suitable for concurrent systems by anticipating blocking issues due to locking.
Speaker:

Session Type:
Regular Session (75 minutes)

Track:
Application & Database Development

Level: Beginner

Session Code:

Date: June 23

Time: 3:40 PM - 4:55 PM

Room: 2520B

If you've never queried an XML column you definitely want to attend.  While targeted to beginners this isn't a "Just do this" session.  After this session I'd like you to truly understand even subtle nuances of basic query syntax.  Seasoned veterans stand a fair chance of learning something new.
Speaker:

Accompanying Materials:

Session Type:
Regular Session (75 minutes)

Track:
Application & Database Development

Level: Beginner

Session Code:

Date: June 23

Time: 10:10 AM - 11:25 AM

Room: 2520C

Oh! ASYNC_NETWORK_IO just went through the roof! What just happened?

Ever wonder how common tasks such as how servers communicate, how cross-subnet Availability Group failover to your disaster recovery site work, or why ‘they’ always recommend a dedicated network adapter for your WSFC? What do I need to know to better manage my databases in the cloud? De-mystifying the networking underneath your databases makes you a stronger database professional. This deep dive technical session will cover many of the critical aspects of enterprise-level networking and how your database servers communicate with the rest of the world. Topics and demonstrations include networking technologies, quality of service, VLANs, routing, firewalls, monitoring, and trending.

By the end of this interactive session, you will be able to check your own networks for their performance and know how to converse with the networking admins to help improve the overall performance.
Speaker:

Accompanying Materials:

Session Type:
Regular Session (75 minutes)

Track:
Enterprise Database Administration & Deployment

Level: Beginner

Session Code:

Date: June 23

Time: 12:50 PM - 2:05 PM

Room: 2390

In this session, we'll discuss ways to manage execution plans inside the plan cache of busy and unpredictable SQL Servers. The plan cache keeps SQL Server healthy, but all it takes is one bad execution plan to decrease server performance.

Just like gardening, keeping a database healthy requires pruning.  Techniques to manage, remove, and improve execution plans will be shown. The Query Store gives us power tools for this work, but it's not the entire solution.
Speaker:

Accompanying Materials:

Session Type:
Regular Session (75 minutes)

Track:
Enterprise Database Administration & Deployment

Level: Intermedia

Session Code:

Date: June 23

Time: 8:45 AM - 10:00 AM

Room: 2520D

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

Accompanying Materials:

No material found.

Session Type:
Regular Session (75 minutes)

Track:
Analytics and Visualization

Level: Intermedia

Session Code:

Date: June 23

Time: 10:10 AM - 11:25 AM

Room: 2390

In this session of Getting Started with Azure Data Lake Analytics, we will learn about fundamental concepts and considerations for designing a Data Lake, how that fits into your organization, and then spend most of the time processing data with Data Lake Analytics using Microsoft's new Big Data language, U-SQL.
Speaker:

Session Type:
Regular Session (75 minutes)

Track:
BI Platform Architecture, Development & Administration

Level: Beginner

Session Code:

Date: June 23

Time: 8:45 AM - 10:00 AM

Room: 2523

Unit testing is an important part of application development and maintenance. Knowing that your latest change is not only providing the desired results but also is free from side-effects is critical to the rapid pace expected by your customers. This session will provide an introduction in to how you can easily create a library of unit tests around your database and its programmable objects.
Speaker:

Session Type:
Regular Session (75 minutes)

Track:
Application & Database Development

Level: Beginner

Session Code:

Date: June 23

Time: 3:40 PM - 4:55 PM

Room: 2520C

In this session you will learn the basics of statistics and what they are used for.  You will learn how to gather information about the statistics and how to use the information to improve performance.  It is important the statistics are maintained to work properly.  We will discuss what on going maintenance should be done on statistics.
Speaker:

Accompanying Materials:

Session Type:
Regular Session (75 minutes)

Track:
Enterprise Database Administration & Deployment

Level: Beginner

Session Code:

Date: June 23

Time: 2:15 PM - 3:30 PM

Room: 2390

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