Build Schedule

Advanced Filters:
  • Track

    clear all








  • Speaker


  • Level


  • Session Type

Sessions Found: 30
As a principal consultant for one of the major provider of medicinal and patient data worldwide I am daily confronted with the problems encountered when dealing with patient data and sensitive information. Apart from the European legislation there are many hurdles in using and analyzing data containing information such as social security numbers, names and addresses, diagnosis and medicinal informations. SQL Server 2016 introduces Always Encrypted  which provides a clean separation between those who own the data (and can view it) and those who manage the data (but should have no access). In this session we will have a look at different setups for Always Encrypted (Hybrid solutions, pure on-premises and 100% cloud based)  as well as how to get started with it and what kind of encryption to apply. 
At the end of this session you will know about the Driver Process of Always Encrypted, how to set it up and how to deploy it and maintain it in on-premises, hybrids and cloud solutions.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
DEV

Level: Intermedia

Session Code:

Date: December 12

Time: 9:00 AM - 10:00 AM

Room: P-217: DEV

RML Utilities is a tool that will allow you to normalise the queries that your application sends to the database and do some deep analysis on them. We will find out how you can find patterns like finding all queries that touch a specific table. We will use read trace and automate getting the estimated query plan against a test database for the whole trace. We can even go through the list of parameters for one query and find the selectivity based no the statistics. (this all takes place on a test db, not on production). Do you use an ORM and can't tune individual queries because you have a lot of them and they're all fast? Use my technique to find patterns and tune your application in a way you've probably not thought of before.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
DEV

Level: Intermedia

Session Code:

Date: December 12

Time: 1:30 PM - 2:30 PM

Room: P-217: DEV

When queries against your tabular model run slowly, you need deeper insight into the problem to come up with the correct solution. Your first step should be to review the DAX query plan, but what exactly are you looking for? In this session you’ll learn how to access the query plan and what types of information the logical and physical plans contain. You’ll also learn which elements in the query plan are most important in your troubleshooting process and, just importantly, what type of information you cannot glean from the query plan.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
BI

Level: Intermedia

Session Code:

Date: December 12

Time: 11:30 AM - 12:30 PM

Room: P-005: BI

Ask a panel of internationally known experts any question on SQL Server and related topics. 
Questions will be answered, debates will be had, general awesomenest will ensue.

This is a popular interactive session format on many conferences.
With you attending we can make it really great. Don't miss out.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
BI/DEV

Level: Intermedia

Session Code:

Date: December 12

Time: 1:30 PM - 2:30 PM

Room: P-006: BI/DEV

Have you ever started developing a product and found out that none of the available databases aren’t suitable for your use case?  

What was your next step? In our case we were crazy enough to create our own database engine. In this session I will present our problem and what led us to the creation of new database engine. We will have a quick overview of how database engine is working and why it is the most suitable database for our case. Maybe you will find out that it may suit also for your needs. A closer look will also explain how our database engine handles automatic shading.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
DBA/DEV

Level: Intermedia

Session Code:

Date: December 12

Time: 9:00 AM - 10:00 AM

Room: P-215: DBA/DEV

Give your queries a multidimensional makeover. In this session we'll look at the structure and basics of MDX, the Multi Dimensional query eXpression language for querying Analysis Services OLAP cubes.

MDX can seem a very daunting language, but when it's broken down into the basics it's easier than you think.

We'll start at the beginning, so you need no previous MDX experience, but it does help to have some experience with cubes. If you already write MDX but struggle with the syntax, then you need to attend this session!

We'll walk through the difference between a member, measure, tuple, set and dimension. Well describe how to decipher a [] from a {} or a (), and we'll look at some of the awesome power that MDX can provide to our reporting.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
BI

Level: Beginner

Session Code:

Date: December 12

Time: 9:00 AM - 10:00 AM

Room: P-005: BI

Join this session to learn how you can build your own mobile BI dashboards with Datazen, the new visualization tool complementing your existing Microsoft BI stack.
Datazen enables you to deliver mobile solutions rapidly: it allows you to develop KPIs and dashboards targeted for mobile devices like tablets and phones in a quick and easy way.  The dashboards render in native applications for all flavors of phone or tablet operating systems, but also can be viewed in browsers and/or embedded into applications. 
Join this session to see how simple it is to build a Datazen dashboard and publish it to the Datazen server. During the demo, you'll be able to follow how the dashboards change - on your own device!
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
BI

Level: Beginner

Session Code:

Date: December 12

Time: 1:30 PM - 2:30 PM

Room: P-005: BI

Business analytics platforms have always been tools built for statisticians and data scientists. However, these tools are increasingly being directed at business analysts, and Gartner's rankings on its well-known "completeness of vision" and "ability to execute" axes now ride as much on "ease of use" as they do on offering advanced analytical algorithms.
How does this change in landscape affect businesses? Are you new to the world of business analytics? Are you taking over an existing analytics program, or starting one from scratch? This session will help you to understand how to craft a strategy, provision the right business analytical capabilities, and move towards actionable results. We’ll identify common pitfalls to avoid as you start or reinvigorate your business analytics program. In particular, we’ll explore how companies are using self-service and data discovery techniques to deliver more agile analytics using Azure Machine Learning.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
BI

Level: Advanced

Session Code:

Date: December 12

Time: 4:00 PM - 5:00 PM

Room: P-005: BI

Continuous Integration is not normally associate with data warehouse projects due to the perceived complexity of implementation.  John will be showing how modern tools make it simple to apply continuous integration techniques to data warehouse projects.  In particular, the session will cover: 
* Automating your build and deployments with SQL Server Data Tools
* Auto-code generation within SSDT using T4 templates and DacFx
* Harnessing the power of BIML
* Automated Integration and Regression testing of your Data Warehouse
* Deploying and on-going management of OLAP databases using the SSAS Partition Manager
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
BI/DEV

Level: Intermedia

Session Code:

Date: December 12

Time: 4:00 PM - 5:00 PM

Room: P-006: BI/DEV

Have you ever been in the situation that an application performed well the last day and - suddenly - you run into problems? Although you have Index Maintenance jobs and statistics up to date you will monitor a big degrade of performance! This session will demonstrate in a over 80 percent demo based presentation the following scenarios which happend this way in real life!
- Why performance degradation in spite of maintenance jobs?
- just one more database in the result set and the query runs really bad - why?
- usage of literals is completely different from the usage of variables - why?
- identical data types but the query runs in part perfect and in part bad...
- your execution plan shows an INDEX SEEK - but the table will be scanned!
- you get a query from the business which performs really bad but when you test it it runs pretty cool - why?
Speaker:

Accompanying Materials:

Session Type:
Regular Session (60 minutes)

Track:
DBA

Level: Intermedia

Session Code:

Date: December 12

Time: 9:00 AM - 10:00 AM

Room: P-007: DBA

So you are a developer or a systems admin and you've just been handed a SQL Server database and you've got no idea what to do with it.  I've got some of the answers here in this session for you.  During this session we will cover a variety of topics including backup and restore, recovery models, database maintenance, compression, data corruption, database compatibility levels and indexing.

While this session won't teach you everything you need to know, it will give you some insights into the SQL Server database engine and give you the ability to better know what to look for.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
DBA/DEV

Level: Beginner

Session Code:

Date: December 12

Time: 2:45 PM - 3:45 PM

Room: P-215: DBA/DEV

You are a Windows Phone developer or just a mobile developer and you need a database locally, on the device, a database, what are your options? And really how do you sync you data with the big database? What you can do, what you cannot do, and how? How cloud is changing this story?  These are a few of the questions this presentation will try to answer, the focus be on Windows Phone (the easiest to demo, but not ignoring the “others”). The actual industrial devices will be also covered. 
And of course all with as much demoes and code as possible.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
DEV

Level: Intermedia

Session Code:

Date: December 12

Time: 11:30 AM - 12:30 PM

Room: P-215: DBA/DEV

Can ETL be fun? Unfortunately, very often creation of ETL layer is time-consuming, tedious, error-prone task. What’s more, any change in requirement needs most of the work to be redone. In our session we’ll present new approach to creating BI solutions using Biml language and Mist programming environment. They greatly simplify the process, allowing for amazing flexibility, and make the ETL work more pleasant. We will show real examples of how Biml and C# generates hundreds of usable SSIS packages in just couple of minutes. We will also cover integration of ETL with TFS and CI for ETL. Everything with 100% compatibility with unmodified SQL Server. Join us and see how BI just became fun again
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
BI/DEV

Level: Intermedia

Session Code:

Date: December 12

Time: 11:30 AM - 12:30 PM

Room: P-006: BI/DEV

We all know that ‘Indexing’ is KING when it comes to achieving high levels of performance in SQL Server. 
When Indexing also combines 2 of the Enterprise features: Partitioning & Compression, we can often see substantial gains.

Learn how to identify those objects that benefit greatly from being Partitioned or Compressed, OR combining both of these features to even greater effect.

Using Demos to illustrate the performance gains with real-world examples, Take away advanced scripts for use in your own environments.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
DBA/DEV

Level: Intermedia

Session Code:

Date: December 12

Time: 1:30 PM - 2:30 PM

Room: P-215: DBA/DEV

So between your management and Microsoft, it’s been decided that you are moving your SQL Server workloads to the cloud. Whether it’s Microsoft Azure SQL Database or running SQL Server in a VM, there are unique performance tuning challenges that are different in a cloud environment. Just like when you moved your SQL Servers from physical to virtual environments, you will learn new techniques for tuning workloads. In this session you will learn about:

•	Optimizing TempDB in an Azure VM
•	Reducing latency between application VMs and database VMs
•	Right sizing Azure VMs for performance and cost
•	Striping I/O across devices in Azure VMs
•	Performance Tuning in Azure DB

You will learn about techniques that will not just improve your system performance, but save you company money, which can be easily quantified just in time for your performance review. 
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
DBA

Level: Beginner

Session Code:

Date: December 12

Time: 4:00 PM - 5:00 PM

Room: P-007: DBA

Making PowerShell useful for your team

You have heard about PowerShell and may be spent a little bit of time exploring some of the ways in which it will benefit you at work. You want to be able to perform tasks more specific to your organisation and need to share them with your team.
I will show you how you can achieve this by demonstrating
An easy way to learn the syntax
How to explore SQL Server with Powershell 
How to turn your one off scripts into shareable functions
How to ensure that your team can easily and quickly make use of and contribute to PowerShell solutions
Where else to go for help
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
DBA/DEV

Level: Beginner

Session Code:

Date: December 12

Time: 4:00 PM - 5:00 PM

Room: P-215: DBA/DEV

For developers with good knowledge of SQL using a micro ORM seems like an obvious choice. But is it? In the session we will discover the features of  the micro ORM called Dapper and how can it simplify your way of communicating with the database. Then we will compare it to the Entity Framework and analyze when you should use one or the other - or neither. But wait! There is more! At the end you will see how easy it is to write a Dapper extension where the classes in your code will magically receive super SQL querying powers.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
DEV

Level: Intermedia

Session Code:

Date: December 12

Time: 10:15 AM - 11:15 AM

Room: P-217: DEV

Focus of this session will be explanation of algorithms available for predictive analytics in Azure Machine Learning service.  Algorithms will be grouped by learning style (Supervised, semi-supervised and unsupervised) and will take a look into 1) regression algorithms, 2) Regularization algorithms, 3) Decision trees algorithms, 4) Naive Bayes algorithms, 5) Dimension reduction algorithms, 6) Associated learning (not Kernel) Algorithms  and 7) Clustering algorithms. With theory explained we will look into data samples and later examples in ML for these algorithms.
Within this session we will explore, which algorithm is used and useful for what kind of empirical problem and which is suitable for particular data-set.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
BI

Level: Intermedia

Session Code:

Date: December 12

Time: 10:15 AM - 11:15 AM

Room: P-005: BI

SQL Server transaction log is one of the most critical components of the database and in the same time one of the most misunderstood. While being neglected it can easily become a bottleneck for our system. Are you interested in learning how to avoid issues with the transaction log and streamline its work? In these sessions we will explore how to optimize it, configure it and keep it under control.
Speaker:

Accompanying Materials:

Session Type:
Regular Session (60 minutes)

Track:
DBA

Level: Advanced

Session Code:

Date: December 12

Time: 10:15 AM - 11:15 AM

Room: P-007: DBA

Power BI - I bet you already know what it is - also offers a nice API set that allows you to program it directly from you application so that you can push data directly to Power BI Dashboards and have them updated in real time. Or, even better, you can create a little bit more complex solution that will live in the cloud and uses Azure Event Hubs to ingest data, Stream Analytics to do some streaming query and finally Power BI to visualize it. And you can even put Azure DW in the game (and probably you should)
In this session we'll all this stuff, how it works together and how it can help us to create a very cool and useful Cloud Modern BI solution.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
BI/DEV

Level: Intermedia

Session Code:

Date: December 12

Time: 9:00 AM - 10:00 AM

Room: P-006: BI/DEV

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