Build Schedule

Advanced Filters:
  • Track

    clear all






  • Speaker


  • Level


  • Session Type

Sessions Found: 21
2,4,8 & 16 - these aren't just numbers to count or calculate. These are years that how SQL Server evolved as number of years!

Why Upgrade? 
Data Platform Upgrade topic has been a popular session that I've presented in major conferences like Microsoft Tech-Ed (North America, Europe & India) and SQLbits since 2008. 

In this session, we will overview in depth end-to-end upgrade process that covers the essential phases, steps and issues involved in upgrading  SQL Server (2000 to  2012),  SQL Server 2014 (with a good overview on 2016 too) by using best practices and available resources. 

What to-do and what not-to-do?

A popular session that I have been presenting since the year 2008, in MS Tech-Ed, SQL Saturday & SQLbits UK.
We will cover the an end-to-end upgrade cycle, including the preparation tasks, upgrade tasks, and post-upgrade tasks. Real-world data store and examples from my Consulting experience expanding on why & how such a solution.
Speaker:

Session Type:
Regular Session (75 minutes)

Track:
Database Administration

Level: Advanced

Session Code:

Date: March 23

Time: 10:15 AM - 11:30 AM

Room: CEB205

Let me show you how easy it is to use PowerShell to accomplish many everyday tasks straight from the command line with the community developed module dbatools.

Afraid of PowerShell? 
Worried its too complicated?
Don't want to go through the learning curve?

Let me show you with plenty of demos how easy and straight forward it can be and I will save you time starting Monday

Want to restore an entire servers databases to the latest available point in time of the backups in just one line?
Be useful to know the Last DBCC Check for your entire estate in only one line of code?
Need to test your restores but its complicated?
and many many more
All this in a fast paced, fun session
Speaker:

Session Type:
Regular Session (75 minutes)

Track:
Database Administration

Level: Beginner

Session Code:

Date: March 23

Time: 12:30 PM - 1:45 PM

Room: CEB105

While we are engineers, we are still people full of assumptions, biases and unchecked preconceptions about society and other people.  This impacts our design patterns for software and databases. When we design architecture that is limited based on our assumptions, we can find our products limiting and creating user experience problems.  In this session, we will discuss common antipattern assumptions that cause these limitations in our architecture design.  We will also talk through the importance of creating a diverse team to help broaden perspectives and increase innovation which can help counter these antipatterns to pave the way for higher quality products.
Speaker:

Session Type:
Regular Session (75 minutes)

Track:
DevOps/DataOps

Level: Beginner

Session Code:

Date: March 23

Time: 2:00 PM - 3:15 PM

Room: CEB205

TSQL is a necessity when interacting with SQL Server so knowing can be half the battle. Performance is always good as the database starts to grow, but building in resilience when you begin is a greater advantage than refactoring. I will go over 5 key things to know when you write TSQL, use DataTypes and/or variables in comparisons and you will also learn about the procedure cache and how to avoid pitfalls there. This is a beginners session but the concepts in this session are a great foundation to begin with. If you are looking for a solid foundation to build on and need the basics to start, this session is definitely for you.
Speaker:

Session Type:
Regular Session (75 minutes)

Track:
Database Development

Level: Beginner

Session Code:

Date: March 23

Time: 12:30 PM - 1:45 PM

Room: CEB205

This session will demonstrate deploying Azure Data Factory and Data Analytics solutions using Azure DevOps.

Using DevOps practices for ETL and analytics:
	• Eliminates manual and error prone steps increasing quality,
	• Reduces effort required to deploy,
	• Enables smaller and more incremental changes,
	• And a number of other advantages.

We'll cover practices required including configuration and testing to insure successful deployments.
Speaker:

Session Type:
Regular Session (75 minutes)

Track:
DevOps/DataOps

Level: Intermedia

Session Code:

Date: March 23

Time: 2:00 PM - 3:15 PM

Room: CEB105

Let's face it: Microsoft Data Platform is not just SQL Server anymore. Azure has added a dozen of other data related products to the menu. Being a cloud DBA means dealing with these new options when needed. 
In this session packed with demos you will see how to cross the bridge between SQL Server and Cosmos DB back and forth; how to related items from both sides and what is required to design a CosmosDB deployment.
Speaker:

Accompanying Materials:

Session Type:
Regular Session (75 minutes)

Track:
Database Development

Level: Intermedia

Session Code:

Date: March 23

Time: 12:30 PM - 1:45 PM

Room: CEB106

On a given project, data scientists can spend upwards of 80% of their time preparing, cleaning, and correcting data. In this session, we will look at different data cleansing and preparation techniques using both SQL Server and R. We will investigate the concept of tidy data and see how we can use tools in both languages to simplify research and analysis of a small but realistic data set.
Speaker:

Accompanying Materials:

Session Type:
Regular Session (75 minutes)

Track:
Database Development

Level: Beginner

Session Code:

Date: March 23

Time: 10:15 AM - 11:30 AM

Room: CEB104

Failing to deliver a well-designed Power BI Report is perhaps the most common reporting pitfall.  What good is quality data if it is not presented in a way that is meaningful or easily understood? Someone without any prior knowledge should be able to quickly understand a report without explanation and be quickly drawn to the key elements you want them to view.  This talk will walk through many elements of bad report design. Learn about visual cues and how certain chart types can convey data more accurately than others. Also, learn about the basic dos and don’ts of report design and layout, using easy-to-learn techniques that bring data to life.
Speaker:

Session Type:
Regular Session (75 minutes)

Track:
Business Intelligence/Machine Learning

Level: Beginner

Session Code:

Date: March 23

Time: 2:00 PM - 3:15 PM

Room: CEB104

In 2009 John Allspaw and Paul Hammond delivered the session "10 deploys per day - Dev & ops cooperation at Flickr." In forty six minutes they changed the way millions of people would think about the software delivery process for years to come. It didn't have a name yet, but DevOps was born. DevOps folk preached about the cloud, automation, rapid delivery and any database technology that wasn't relational.
 
In 2013 Kenny Gorman declared "The DBA is Dead".
 
For the record, I don't believe that, but a lot of people do. What is certain is that the world of IT is changing and traditional roles are changing with it. We all need to adapt.
 
In this interactive talk I'll explain what DevOps is, where it came from, and its implications for SQL Server. I'll demo example solutions to some of the foundational technical challenges (source control and test/deployment automation) and will leave plenty of time at the end to answer your questions.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (75 minutes)

Track:
DevOps/DataOps

Level: Beginner

Session Code:

Date: March 23

Time: 10:15 AM - 11:30 AM

Room: CEB105

You might have heard "don't use cursors, they are slow!". In this presentation, you will learn what this actually means: you should normally write set-based statements instead and I will explain why they generally are faster than writing your own loops. But I will also look at situations where using a loop for one reason or another is preferrable, and you will learn that the best way to run a loop in most cases is exactly a cursor, provided that you implement it properly. The presenation also gives some tips how you can troubleshoot performance problems with loops.
Speaker:

Session Type:
Regular Session (75 minutes)

Track:
Database Development

Level: Intermedia

Session Code:

Date: March 23

Time: 2:00 PM - 3:15 PM

Room: CEB106

According to the Economist magazine, data is the world’s most valuable resource.  So, it makes sense that Data Science, Azure Machine Learning, and Analytics are all becoming core pieces to the success of every business.  As data professionals, we need to know how these core pieces will affect what we do, and how we can use the Azure AI suite to help our clients.  Microsoft’s AI suite is the central hub for learning and implementing each of these core pieces.  Using an easy to follow example, I will show the flow from problem to solution.  Multiple demonstrations of the different pieces will show use cases of the AI suite.  This overview of Azure AI will use the various pieces like a puzzle which, when brought together, will form a seamless picture of the whole so that participants can see that the individual pieces were meant to work together.
Speaker:

Session Type:
Regular Session (75 minutes)

Track:
Business Intelligence/Machine Learning

Level: Beginner

Session Code:

Date: March 23

Time: 8:30 AM - 9:45 AM

Room: CEB106

"If there’s one thing that we, as SQL developers don’t do, it’s use transactions as often as we should.

Transactions are critical when multiple changes need to be made entirely or not at all, but even given that it’s rare to see transactions used at all in most production code

In this session, we’ll look at what transactions are and why we should use them. We’ll explore the effects transactions have on locking and the transaction log. We’ll investigate methods of handling errors and undoing data modifications, and we’ll see why nested transactions are a lie.

1) Understand what transactions are and what they do.

2) Learn how to use transactions in combination with error handling to roll back changes on errors

3) Learn how transactions affect logging and locking.

"
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (75 minutes)

Track:
Database Development

Level: Beginner

Session Code:

Date: March 23

Time: 3:30 PM - 4:45 PM

Room: CEB205

Learn how powerful the new PowerShell tools for SSRS are and how they can help you administer your reporting environment!  This presentation will give a brief overview of the new tools that are being actively supported by Microsoft and then show many many ways to use them in your daily life.  Come away with scripts to help you implement the tools in any environment!
Speaker:

Session Type:
Regular Session (75 minutes)

Track:
Database Administration

Level: Beginner

Session Code:

Date: March 23

Time: 3:30 PM - 4:45 PM

Room: CEB105

Power BI reports are typically used for descriptive analysis: a historical look of what has happened. But what if your report could visualize what is likely to happen and recommend what you can do about it now? This session will cover how to shift from descriptive to predictive analysis and leverage the power of machine learning to enhance your business intelligence solutions. The basics and best practices of predictive modeling will be introduced, and these concepts will be applied to create three predictive models in R using three different techniques. We will then walk through the three different ways to integrate the predictive power of these models into a Power BI report.
Speaker:

Session Type:
Regular Session (75 minutes)

Track:
Business Intelligence/Machine Learning

Level: Intermedia

Session Code:

Date: March 23

Time: 3:30 PM - 4:45 PM

Room: CEB104

We'll start with a quick tour of the Azure Data Studio before diving into the basics of T-SQL. In this interactive and demo heavy session we'll look at basic queries and filter operators as we build out some single table queries and multi table joins. We'll also cover some basic data aggregations and talk a little bit about what the SQL engine is doing under the covers to return your results as quickly as possible.
Speaker:

Accompanying Materials:

Session Type:
Regular Session (75 minutes)

Track:
SQL 101

Level: Beginner

Session Code:

Date: March 23

Time: 8:30 AM - 9:45 AM

Room: CEB205

This session aims to take attendees through what containers are and what benefits they bring.
After this demo based session, attendees will be able to go back to their respective companies and be able to evaluate container technology to determine whether or not it will be of benefit.

Attendees will be taken through the following: - 
The definition of containers
Virtual Machines vs Containers
Pulling SQL images from the docker hub
Running SQL Server containers 
Creating custom container images 
Sharing container images
Persisting data in SQL Server containers
A real world implementation of containers
Speaker:

Session Type:
Regular Session (75 minutes)

Track:
Database Administration

Level: Intermedia

Session Code:

Date: March 23

Time: 10:15 AM - 11:30 AM

Room: CEB106

No one wants to tell a report user that while running a report in Power BI they have time to go get a cup of coffee…in another town.  Although data sets will often be the focus of performance issues, it’s important to know how to locate performance problems in Power BI and how to eliminate them.  

This session will take the Power User through how to identify time consuming processing in Power BI and how to address it through step-by-step and proven methods used to optimize in multi-tier environments.  This method removes frustration and finger-pointing and gets to the heart of the problem with a goal of correcting performance challenges.  The results are satisfied end users who get the information they need, when they need it.

Take Aways:
Learn how to identify what is taking the time in a Power BI data set and report.
Understand the logging and tracing mechanisms and capabilities in the environment.
Understand when a problem is really a problem.
Speaker:

Accompanying Materials:

Session Type:
Regular Session (75 minutes)

Track:
Business Intelligence/Machine Learning

Level: Intermedia

Session Code:

Date: March 23

Time: 8:30 AM - 9:45 AM

Room: CEB104

Test Driven Development (TDD)  is a design approach which has enabled application developers to write cleaner code. 
It is relevant for database development as it ensures that code produced using TDD and unit tests will be of higher quality which means interactions with data will be safer. 
TDD is not a new method of unit testing, it is an essential design practice for improving the quality of your deployed code.
In this session it will be shown how we can use TDD to design and write better unit tests using open-source frameworks and industry standard tools. These tools can be run within SQL Server Management Studio which means DBAs can also take advantage of TDD and unit test, to ensure more reliable code is deployed to databases. 
TDD can result in code that can be deployed more reliably and faster when using DevOps processes such as Continuous Integration and Continuous Delivery. 
A comprehensive DEMO will reveal how Test Driven Development can help you deploy database code safer.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (75 minutes)

Track:
Database Development

Level: Intermedia

Session Code:

Date: March 23

Time: 8:30 AM - 9:45 AM

Room: CEB105

For years user defined functions (UDFs) have been the nemesis of the DBA focused on performance, but they have been loved by developers due to their ability to help with code re-usability and abstraction of business rules.
SQL Server 2019 introduces techniques that help eliminate some of the performance issues related to UDFs. Learn how and in what cases scalar UDF In-lining can improve your performance reducing the historic performance problems with UDFs.
We will explore how in-lining improves performance, along with what you can do and what prevents in-lining of UDFs.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (75 minutes)

Track:
Database Development

Level: Intermedia

Session Code:

Date: March 23

Time: 2:30 PM - 3:45 PM

Room: CEB106

The Analytics service in Azure DevOps Services provides all-over insights to your DevOps data: work item tracking, CI/CD pipelines, testing process etc. 
	 
Built on top of columnstore indexes, the Analytics service has to deal with 100s of millions records and daily growth in 10s of millions, only a few minutes delay from operation store, sub second query performance for in-product experiences as well as 3rd party extensions, Power BI integration and ad-hoc queries.
	 
Working on it, I've learned a lot of DOs and DON'Ts about columnstore indexes. Session covers how to:
* partition columnstore indexes in a multitenant environment
* maintain columnstore indexes in case of updates and/or purge to keep segment elimination possible
* evolve database schema without downtimes and maintenance windows
* design to benefit from predicate and aggregation pushdown
* deal with edge case like ad-hoc queries for raw data and paging
* choose between CCI and NCCI based on usage patterns
Speaker:

Session Type:
Regular Session (75 minutes)

Track:
Database Development

Level: Advanced

Session Code:

Date: March 23

Time: 3:30 PM - 4:45 PM

Room: CEB106

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