Build Schedule

Advanced Filters:
  • Track

    clear all






  • Speaker


  • Level


  • Session Type

Sessions Found: 31
Disasters happen – plain and simple. When disaster strikes a database you're responsible for, and backups and repair fail, how can you salvage data, and possibly your company and your job? This is where advanced data recovery techniques come in. Using undocumented tools and deep knowledge of database structures, you can manually patch up the database enough to extract critical data. This demo-heavy session will show you never-seen-before methods I've used extensively in the last year to salvage data for real-life clients after catastrophic corruption. You won't believe what it's possible to do!
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
DBA

Level: Advanced

Session Code:

Date: June 17

Time: 3:15 PM - 4:15 PM

Room: Room1

This session aims to give attendees an introduction into containers running SQL Server on Windows Server 2016.
Attendees will be taken through the following: -

Defining what containers are (benefits and limitations)
Configuring Windows Server 2016 to run containers
Installing the docker engine
Pulling SQL images from the docker respository
Running SQL Server containers
Committing new SQL Server images
Exploring 3rd party options to run containers on previous versions of Windows Server (real world example)

This sessions assumes that attendees have a good background in SQL Server administration and a basic knowledge of
Windows Server administration
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
DBA

Level: Intermedia

Session Code:

Date: June 17

Time: 8:00 AM - 9:00 AM

Room: Room3

This session will begin, with a high level introduction to Azure Internet of Things, Windows 10 Core and Raspberry PI. Once we have established the basics about the technology, we will be connecting the dots with a live demo on some of the parts. The focus during the demo, will mainly be on Azure IoT Hub, Windows 10 Core and the Raspberry PI and how to DIY. As visualization we will be using Power BI to present the data.
This session is not for the Enterprise rather has a more DIY approach.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Cloud

Level: Beginner

Session Code:

Date: June 17

Time: 2:00 PM - 3:00 PM

Room: Room2

What is Azure SQL Data Warehouse, why and how should I use it? Here we will look at the fundamental basics to answer these questions and more, giving you the foundation knowledge to get started. This session will arm you with the core knowledge of how the DW engine differs to the traditional SQL Server database. Helping you understand key concepts such as Distributions and the Control/Compute structure, along with many others. Allowing you to be confident as you start to asses and use Azure SQL Data Warehouse.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Cloud

Level: Beginner

Session Code:

Date: June 17

Time: 8:00 AM - 9:00 AM

Room: Room2

This session will help attendees understand how to use the latest generation of cloud-only Microsoft analytics services alongside their revenue generating systems which show no sign of leaving on-premises data centres.  Attendees will learn about the solution design patterns and technologies used in hybrid analytics platforms and what to consider when designing their own.  

It discusses common solutions that:

- Take data from on-premises SQL Server databases
- Securely transfer it to an Azure solution
- Store it in a cloud data warehouse 
- Visualise it using Power BI
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Big Data and Analytics

Level: Intermedia

Session Code:

Date: June 17

Time: 9:15 AM - 10:15 AM

Room: Room5

Anything and everything in Cloud platforms like Azure can be completely automated. Infrastructure people and Developers have embraced this methodology already, time for us Data Platform professionals to learn how to fully automate deploying our infrastructure. 
In this session we will learn how to deploy Azure resources with (partial) Azure Resource Manager (ARM) templates and Powershell. There will be a very strong emphasis on the Data Platform. Learn how to create reusable templates so you can create Production/UAT/Test/Development environments, or create Proof of Concept environments with automated tests quickly.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Cloud

Level: Intermedia

Session Code:

Date: June 17

Time: 10:30 AM - 11:30 AM

Room: Room2

This session will provide an overview of Microsoft’s approach to Artificial Intelligence and will show you how you can quickly create a bot using the Azure Bot Framework with limited coding.  From there you’ll learn how you can gain deep insights using Application Insights and Power BI
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Big Data and Analytics

Level: Beginner

Session Code:

Date: June 17

Time: 9:15 AM - 10:15 AM

Room: Room2

An introduction session for using Pester to test your PowerShell code 

Pester provides a framework for running unit tests to execute and validate PowerShell commands from within PowerShell.

I will show you can get started using Test Driven Development for your PowerShell scripting. 

We will examine Pester, the syntax and show plenty of demos and build a function that uses the Microsoft Cognitive Services Faces API to analyse Beards ??
Speaker:

Accompanying Materials:

Session Type:
Regular Session (60 minutes)

Track:
Dev

Level: Beginner

Session Code:

Date: June 17

Time: 3:15 PM - 4:15 PM

Room: Room2

U-SQL is the new kid on the SQL language block. In this session we'll look at the what, where, why and how of the language. Is it a query language? Is it a data transformation language? Will it replace T-SQL? Should you learn it? Where is it? What is Data Lake? We'll discuss all this and more.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Big Data and Analytics

Level: Beginner

Session Code:

Date: June 17

Time: 2:00 PM - 3:00 PM

Room: Room3

The system database TempDB has often been called a dumping ground, even the public toilet of SQL Server. (There has to be a joke about spills in there somewhere). In this session, you will learn to find those criminal activities that are going on deep in the depths of SQL Server that are causing performance issues, not just for one session, but that affects everybody on that instance.

You will leave this session prepared to create better architecture decisions and better code to improve the performance for all of your users.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
DBA

Level: Intermedia

Session Code:

Date: June 17

Time: 11:45 AM - 12:45 PM

Room: Room4

Come along for some banter from celebrity judges award best lightning speaker and best new speaker.

The format is fast paces five minute lightning talks with  anything goes topics across SQL Server and Data Platform
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Professional Development

Level: Beginner

Session Code:

Date: June 17

Time: 10:30 AM - 11:30 AM

Room: Room1

When loading a large amount of data, e.g. into your data warehouse, you want 
the data inserted into the table as fast as possible. You know you have to use bulk 
load, but what do you need to do to ensure that data is loaded as fast as possible? 

In this session, you will learn about the different methods for bulk loading data 
into your data warehouse; using SSIS, BCP and T-SQL. You will also learn what is 
happening behind the scene of minimal logged inserts, why they are so 
important when doing bulk load, and what is required to achieve a minimal 
footprint on the transaction log. 

And yes, there will be zombies!
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
BI

Level: Advanced

Session Code:

Date: June 17

Time: 9:15 AM - 10:15 AM

Room: Room3

This presentation will give an update on all the new features in Microsoft R Server 9.1. We will see how we can do advanced Text mining (n-grams & sentiment) and run deep learning networks for image recognition  with a few lines of R code. Spark is the new in-memory frame-work for Machine Learning and we will see examples on how we easy it is to work in Spark compute context and utilize Spark for improving performance. Many customers have requirement for running "many models" e.g. Churn model per segment etc. Microsoft have develop new functions that enables the data scientist to apply these many models scenarios.  This release includes significant innovations such as:

•	New machine learning enhancements and inclusion of pre-trained cognitive models such as sentiment analysis & image featurizers
•	SQL Server Machine Learning Services with integrated Python in Preview
•	Interoperability between Microsoft R Server and sparklyr. 
•	New machine learning models in Hadoop and Spark.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Big Data and Analytics

Level: Intermedia

Session Code:

Date: June 17

Time: 3:15 PM - 4:15 PM

Room: Room4

Discover the ins and outs of some of the newest capabilities of our favorite data language. From JSON to COMPRESS / DECOMPRESS, from AT TIME ZONE to DATEDIFF_BIG(), and from SESSION_CONTEXT() to new query hints like NO_PERFORMANCE_SPOOL and MIN / MAX_GRANT_PERCENT, as well as some other surprises, you’ll walk away with a long list of reasons to consider upgrading to the latest version or finally trying out Azure SQL Database.
Speaker:

Accompanying Materials:

Session Type:
Regular Session (60 minutes)

Track:
DBA

Level: Intermedia

Session Code:

Date: June 17

Time: 10:30 AM - 11:30 AM

Room: Room5

When you need to extract data from the database you are writing, more or less complex, T-SQL code. Often simplistic and procedural approach reflects what you have in your mind, however this could have a negatively impact about performance because the database engine might think otherwise. Fortunately T-SQL, as a declarative language, allows us to ask the "what" and delegate to the engine the "how". Everything works best as long as you respect a few simple rules and you may use special constructs. In this session, with few slides and a lot of real-case scenarios, you can see the advantages of writing the query for high performance, even when they are written by that "someone else" called ORM.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Dev

Level: Beginner

Session Code:

Date: June 17

Time: 11:45 AM - 12:45 PM

Room: Room5

How you execute your data requests can have a profound effect on performance and plan reuse. Did you ever wonder where that estimate (in the showplan) comes from? Is it correct or, is it way off? Why? You’ve probably heard that many of your problems are related to statistics. Potentially, you’ve even rebuilt statistics only to find that it fixes the problem. However, what you might be seeing is a false positive. And, it doesn’t always work. Come to this session to find out how you should be executing your statements for the best performance, caching, and reuse! We'll look at ad hoc statements, dynamically constructed statements, and sp_executesql (e.g. forced statement caching) and I’ll debunk the mysteries around estimates so that you can solve performance problems the RIGHT way! If you want to demystify SQL Server's decisions used for statement execution, query plans, and plan caching – this is the place to be!
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Dev

Level: Intermedia

Session Code:

Date: June 17

Time: 11:45 AM - 12:45 PM

Room: Room1

Join PowerShell MVP & DBA Chrissy LeMaire and PowerShell Expert & DBA Rob Sewell to learn how PowerShell can help improve your work/bacon life balance.
 
We will show you how to perform many DBA tasks easily and simply using PowerShell, from instance migrations to automated backup testing and more. Our session is aimed at DBAs, from junior to senior, who want to embrace the ease of automation and increase their toolset.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
DBA

Level: Beginner

Session Code:

Date: June 17

Time: 2:00 PM - 3:00 PM

Room: Room5

There is a vast array of material in the SQL Server community that covers the in-memory engine in great detail, this session will cover some of the internals of the in-memory engine, however what it will also do is fill in the void as to common performance issues and how they can be solved with the in-memory engine, specifically:

- Staging data as fast as possible
- Turbo charging scalar aggregate functions
- Implementing a scalable sequence
- Overcoming the performance limitations of temporary tables
- Making the critical path in your code base run faster
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Dev

Level: Intermedia

Session Code:

Date: June 17

Time: 2:00 PM - 3:00 PM

Room: Room4

Another in TheSQLGuru's Deep Dive series! Query plans - the roadmaps of how your query will be handled by the engine. TONs of information for the asute SQL Server user. Lets dig into them and see what we can learn from and about them and also talk about how they can be used to aid our query tuning efforts.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Dev

Level: Advanced

Session Code:

Date: June 17

Time: 8:00 AM - 9:00 AM

Room: Room4

Based on the acquisition of Datazen, Reporting Services now includes a new engine enabling the delivery of mobile reports. In this session you will learn about this new capability delivered with SQL Server 2016, including the architecture of the engine and the development of reports.

This session will describe and demonstrate how to prepare data for mobile reporting, and also how to develop and publish mobile reports. In addition, it will describe the architecture of the engine, and how to manage mobile reports.

This session will be of interest to a full range of professionals, including analysts, report developers, IT managers, and data architects.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
BI

Level: Beginner

Session Code:

Date: June 17

Time: 8:00 AM - 9:00 AM

Room: Room1

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