Build Schedule

Advanced Filters:
  • Track

    clear all







  • Speaker


  • Level


  • Session Type

Sessions Found: 24
SQL and SQL Server has a lot in common with Othello - fairly easy to learn, but takes a lifetime to master. Many times overt abuse is not even necessary - an incorrectly configured database is surprisingly capable of destroying any semblance of performance all by itself. 
The database is very good at doing some things - and exceptionally bad at others. Combine these facts with a general lack of understanding of the database engine and the road to perfomance hell is truly plotted. 
Join Alexander for a session of examples how developers can and do abuse SQL Server - both intentionally and unintentionally.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Application & Database Development

Level: Intermedia

Session Code:

Date: September 23

Time: 10:45 AM - 11:45 AM

Room: Room B

Building robust and resilient Data Platform solutions can be complex and costly, building out for both High Availability and Disaster Recovery. The Always On technologies incorporated in the Microsoft SQL Server stack help Data Platform Engineers to do just this. Creating solutions that span multiple locations, in an effort to protect the data that we are tasked to manage on a daily basis.

Together we will walk through the architecture patterns, technology requirements, and configuration options that you need to know in order to build a solid Data Platform. Understanding the implementation differences between on-premises and cloud based deployments is important. Especially as there are specific requirements that need to be met for up-time SLAs to be applicable, as well as mitigating for region failures.

All of these elements mean that it is more than just simple wizards to follow in order to have a solid, reliable, and robust SQL Server Data Platform.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Strategy and Architecture

Level: Advanced

Session Code:

Date: September 23

Time: 12:00 PM - 1:00 PM

Room: Room D

Temporal Tables are a new feature in SQL Server 2016. This session will start with an overview of the basic functionality of Temporal Tables based on a real world scenario. After the core concepts of Temporal Tables have been implemented the session will dive deeper into the functionality of it with all its really great benefits but there is no lunch for free. This session will demonstrate what's not working fine with Temporal Tables and its common drawbacks when you will work with this feature of SQL Server 2016. Fasten seat belts and get an overview of the core concept of Temporal Tables and decide for yourself, whether you would use it or kick it away :)
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Application & Database Development

Level: Beginner

Session Code:

Date: September 23

Time: 2:00 PM - 3:00 PM

Room: Room B

Azure Machine Learning plays a central role in Cortana Intelligence: discovering useful patterns in all the collected data is essential in advanced analytics.
To get started with Azure machine learning you don't need to be  an expert: Microsoft provides ready made models that can be used immediately (Cognitive Services). For other business problems (e.g. churn) Microsoft provides a template, but we need to tune this template to our business data. And for some analysis problems we need to build machine learning solutions from scratch.
In this demo-oriented session you will see demonstrations of these three ways of working with Machine Learning in the Azure cloud.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Cloud Application Development & Deployment

Level: Beginner

Session Code:

Date: September 23

Time: 9:15 AM - 10:15 AM

Room: Room A

Azure SQL DWH is based on MS SQL Server and supports T-SQL. It helps to DB/DWH developers start using it without many efforts. Unfortunately, there are several limitations that could bring difficulties in your job. For example, we can't use MERGE statement for Upsert tasks in DWH, there is no IDENTITY or SEQUENCE, differences in implementing partition switching  and so on. In this session, I'm going to cover several tips and tricks how we can handle with this limitations using available possibilities.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
BI Platform Architecture, Development & Administration

Level: Intermedia

Session Code:

Date: September 23

Time: 2:00 PM - 3:00 PM

Room: Room C

Change Tracking came out with SQL Server 2008, but SS2012 almost eclipsed it with Change Data Capture. Change Tracking is now the red-headed step child, but in many cases may be the best solution for data ETL movement from an SQL Server OLTP database to a data warehouse or reporting database. This session will provide a review of change tracking syntax and implementation with detailed demos. It will then dive into an actual ETL subset implementation from the AdventureWorks database to a data warehouse solution (modified AdventureWorksDW) with detailed code discussion and demos using TSQL only (no SSIS).
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
BI Platform Architecture, Development & Administration

Level: Intermedia

Session Code:

Date: September 23

Time: 4:30 PM - 5:30 PM

Room: Room A

Tuning your SQL queries is one of the most important task of your daily business but how can we achieve this for existing execution plans?
This session is about the difference of the database tuning advisor and the missing index database management views of the query engine. 
You will learn the limitations of both approaches in order to avoid applying wrong indexes.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Application & Database Development

Level: Intermedia

Session Code:

Date: September 23

Time: 9:15 AM - 10:15 AM

Room: Room D

In this session, we’ll see in detail how to create nodes and edges tables designed for graphs traversal in SQL Server 2017. After a summary of the underlying graph theory and its implementation in databases, we’ll see how to create graph tables in SQL Server 2017, and how to query them with the match operator. This session will give you a kickstart on using graphs in SQL Server 2017.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Application & Database Development

Level: Beginner

Session Code:

Date: September 23

Time: 4:30 PM - 5:30 PM

Room: Room B

What is GDPR, who is affected and how does it affect me as a database professional? This session will explain the general data protection regulation at a high level and how to make SQL Server and Azure SQL Databases compliant to the new regulation. Different techniques like Row level security, data masking, transparent data encryption will be demonstrated.  The session will also cover some basic tools for finding data breaches.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Application & Database Development

Level: Intermedia

Session Code:

Date: September 23

Time: 2:00 PM - 3:00 PM

Room: Room A

This session is for DBAs specifically, but will be relevant to any technicians who use checklists

I was required to prove that I had successfully installed and configured a backup solution across a large estate. I had a number of success criteria that had to be met. Checking all of these by hand (eye) would have been error prone, so I wrote a test to do this for me and an easy for management to read HTML report using PowerShell and Pester.

The session has come from that situation and is about enabling you to provide an easy to read output to quickly and repeatedly show that infrastructure is as expected for a set of checks, also known as  Operational Validation using Pester. There are many use cases for this type of solution; DR testing, installation, first line checks, presentation setups

After this session you will have a basic understanding of how Pester works and the capability to examine your checklists and create your own validation tests and provide some reporting for manager
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Enterprise Database Administration & Deployment

Level: Beginner

Session Code:

Date: September 23

Time: 4:30 PM - 5:30 PM

Room: Room C

How easy is it to hack a SQL Server? 
In this session we'll see examples on how to exploit SQL Server, modify data and take control, while at the same time not leaving a trace.
We'll start by gaining access to a SQL Server (using some "creative" ways of making man-in-the-middle attacks), escalating privileges and tampering with data at the TDS protocol level (e.g. changing your income level and reverting without a trace after payment), hacking DDM, and more. 
Most importantly, we'll also cover recommendations on how to avoid these attacks, and take a look at the pros and cons of new security features in SQL Server 2016.
This is a demo-driven session, suited for DBAs, developers and security consultants.
Disclaimer: No actual crimes will be committed. Please do not send agents to my house again
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Enterprise Database Administration & Deployment

Level: Intermedia

Session Code:

Date: September 23

Time: 3:15 PM - 4:15 PM

Room: Room A

When it comes to performance, we often focus on waits and how to solve them.
However, in most cases, solving the real problem with the code, gives you the performance you want.
In this presentation I will show you how to spot the performance blockers.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Application & Database Development

Level: Intermedia

Session Code:

Date: September 23

Time: 9:15 AM - 10:15 AM

Room: Room C

In this session you will learn the difference between the internal and external index and heap fragmentation and how to detect it.
You will get a deep understanding of the reasons of fragmentation like

-	page split
-	index fill factor
-	ghost record
-	forwarding record
-	heap PFS insert algorithm
-	batch insertions
-	database shrink / auto growth
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Application & Database Development

Level: Advanced

Session Code:

Date: September 23

Time: 12:00 PM - 1:00 PM

Room: Room A

The JavaScript Object Notation format, known simply as JSON, has now become a standard in data interchange between client-server applications, it is also used to store information in non-relational databases and the SQL Server 2016 engine handles it natively . However, today, not everyone has passed to the latest version of SQL Server, however, it is possible to process the JSON format even with earlier versions: in this session, it is confident with this format and illustrates the non-native mode that allows you to be ready in the moment of the upgrade to 2016 (or later) with a few simple moves. Finally, with a few simple examples, you will find some tips on how to use JSON in an advanced way with SQL Server 2016.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Application & Database Development

Level: Beginner

Session Code:

Date: September 23

Time: 4:30 PM - 5:30 PM

Room: Room D

Move up to Management Studio Superstar with these great productivity tips! We’ll explore stuff like keyboard shortcuts, configuration options, how to keep your SSMS settings synchronized across multiple environments and other really useful everyday tricks and hacks. Think “hey, wait, how’d you do that!?”

Some of the things I’ll cover:

* Previewing and quick-reference stuff you can do with keyboard shortcuts
* Quickly navigating your code to find errors or bookmarks

No undocumented stuff, no registry editor, and nothing you wouldn’t put into production. Just really clever productivity tips that will take some of the burden off your everyday work.

But I’m not going to sugarcoat it. Your code may still run slow, and you’ll probably write just as many bugs – but you’ll write them a lot quicker and with so much more style and panache.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Enterprise Database Administration & Deployment

Level: Beginner

Session Code:

Date: September 23

Time: 2:00 PM - 3:00 PM

Room: Room D

Master Data Services (MDS) has been around since SQL 2008, but it's hardly ever used. Mainly because of the unfamiliarity of MDS. MDS can resolve many management issues. And especially with the new features introduced with SQL Server 2016. This session will show the important new features and  several scenario's how MDS can strengthen your BI solutions.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
BI Platform Architecture, Development & Administration

Level: Beginner

Session Code:

Date: September 23

Time: 12:00 PM - 1:00 PM

Room: Room C

We will discuss and demonstrate the MPP (massively parallel processing) architecture of Azure SQL DW and how to make best use of this exciting technology, including:
•	Getting up and running
•	Loading and migrating data
•	Designing tables and optimizing queries to extract maximum performance

This session will also include some benchmarks and Power BI demos  with different DWU and storage options on a very large data set.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
BI Platform Architecture, Development & Administration

Level: Intermedia

Session Code:

Date: September 23

Time: 10:45 AM - 11:45 AM

Room: Room C

Microsoft offers a large playground for young and old with the cognitive services. Here can be tested according to your heart's content which will be maybe tomorrow all in use. With the various building kits such as Bot Framework, Emotion, Face, Text Analytics or Recommendations, to put together in a short time Impressive applications. Come on a little trip with on this playground.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Cloud Application Development & Deployment

Level: Beginner

Session Code:

Date: September 23

Time: 10:45 AM - 11:45 AM

Room: Room A

Power BI is a great suite of tools for business analytics and reporting. You use it to create reports and dashboard to deliver insights throughout your company. 
But, what about the new licensing model recently introduced for Power BI? How it can fits to your needs?
Every organization is a complex system with rules and limitations. Users belong to groups each with visibility profile. 
So you need to know how security in Power BI works: how to configure and restrict access, how to filter data based on the logged user, how to implement static and dynamic Row-level security (RLS), how to control usage of specific features. 

Furthermore you deal with a large number of users you can’t leverage by hand. Power BI provides an admin portal that allows you to manage users and groups in the Office 365 admin center. 
Come to this session to discover what’s behind the scenes in Power BI and how to implement a solution compliant to your security and governance model.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
BI Platform Architecture, Development & Administration

Level: Advanced

Session Code:

Date: September 23

Time: 3:15 PM - 4:15 PM

Room: Room B

Explore Usage of Azure Datafactory to mesh data from various cloud/On-Premises offerings such as AWS and Google Cloud. Many vendors would have more than one cloud/On-Premises and the want to bring data together. We will explore stategies to connect data from various sources, obstacles, workarounds, trobleshooting and best practices. All hands-on.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Analytics and Visualization

Level: Intermedia

Session Code:

Date: September 23

Time: 10:45 AM - 11:45 AM

Room: Room D

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