Build Schedule

Advanced Filters:
  • Track

    clear all










  • Speaker


  • Level


  • Session Type


Sessions Found: 30
Co-presented with Pete Moore.

Do you hold data on EU citizens? If so GDPR applies to you.

From the 25th May 2018 organisations who fail to implement appropriate technical and organisational measures that ensure and demonstrate that they are compliant will be liable for a fine of €20M or 4% of annual global turnover – whichever is GREATER. Also, prison.

As a professional who works with data it is wise to ensure that you understand GDPR.

DISCLAIMER: I am not a lawyer.

Let me repeat: I AM NOT A LAWYER.

I am not qualified to give legal advice. However, I do know a thing or two about delivering software. In this talk I will bring your attention to the main aspects of GDPR and discuss some of the consequences this has on the use of production data and database lifecycle management (DLM).

I will focus on technical problems that we need to address. You can (and should) hire your own lawyers to provide legal advice.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Strategy and Architecture

Level: Beginner

Session Code:

Date: October 07

Time: 12:30 PM - 1:30 PM

Room: CUST 0.01M

Where do the estimated rowcount values come from? Look inside SQL Server’s distribution statistics to see how they are used to come up with the estimates. We’ll also discuss changes in the cardinality estimator in recent versions and look at some new metadata that gives us more statistics information.

Goals:
•	Explore the output of DBCC SHOW_STATISTICS
•	Describe when the density information is useful
•	Look at some problem scenarios for which the statistics can’t give good estimates
•	Understand why cardinality estimation involves more than just the statistics
Speaker:

Session Type:
Extended Session (90 minutes)

Track:
Enterprise Database Administration & Deployment

Level: Advanced

Session Code:

Date: October 07

Time: 1:45 PM - 3:15 PM

Room: CUST 0.01M

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:

Accompanying Materials:

Session Type:
Extended Session (90 minutes)

Track:
Strategy and Architecture

Level: Advanced

Session Code:

Date: October 07

Time: 10:00 AM - 11:30 AM

Room: CUST 0.01M

Deploying SSIS projects is a daunting manual task we do every time in SQL Server Data Tools. Rebuild/Deploy/Validate/Execute. Add version control to it, branch, merge, add packages to projects, switch between DEV/TEST/PROD environments - it's getting even more boring.

On this session I will show you how to put all that tasks to the server side. You'll see how to use Powershell and API available in .NET. Or MSBuild. I will add a bit of TFS to it to automate all things and you'll see that testing and deployment of subsequent project versions doesn't have to be so bothersome.

You will see what to look at when designing your own solution, what resources to use, what limitations await and how to overcome them.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
BI Platform Architecture, Development & Administration

Level: Intermedia

Session Code:

Date: October 07

Time: 4:30 PM - 5:30 PM

Room: CUST 1.11M

Since April 2017 another fascinating PaaS in the Microsoft Cloud reached general availability: Azure Analysis Services. 
But why should you switch from your existing on-premise solution to the cloud or plan your new approach with it? What are the big advantages of Azure Analysis Services? And what actually are the differences to PowerBI? Why is Azure Analysis Services an important step to enhancing the possibilities for BI in the cloud? 
This session offers answers to your questions and provides insight to support the positioning of Azure Analysis Services in your Business Intelligence strategy.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
BI Platform Architecture, Development & Administration

Level: Beginner

Session Code:

Date: October 07

Time: 3:15 PM - 4:15 PM

Room: CUST 0.02M

In this demo-heavy session, you will learn about the basic concepts of increasing productivity by creating your SSIS packages using Biml.

We will look into manual Biml code to understand the general idea of Biml, then take it from there and generate a whole staging area from scratch and end with a complete manageable solution to completely maintain your staging process using SQL tables.

Have you ever spent hours fixing your SSIS due to a schema change on the source? Ever wanted to add a "load timestamp" to 370 tables in your staging area but refrained because it would have taken you weeks to do so? If so, this is the session for you!
Speaker:

Accompanying Materials:

Session Type:
Regular Session (60 minutes)

Track:
BI Platform Architecture, Development & Administration

Level: Intermedia

Session Code:

Date: October 07

Time: 8:30 AM - 9:30 AM

Room: CUST 1.11M

Authoring SSAS tabular models using the standard tools (SSDT) can be a pain when working with large models. This is because SSDT keeps a connection open to a live workspace database, which needs to be synchronized with changes in the UI. This makes the developer experience slow and buggy at times. Tabular Editor is an open-source alternative, that relies only on the Model.bim metadata and the Tabular Object Model (TOM). Compared to SSDT, making changes to measures, calculated columns, display folders, etc. is lightning fast, and the UI provides a "what-you-see-is-what-you-get" experience, making it much easier to manage and author large models. Combined with scripting functionality, a Best Practice Analyzer, command-line build and deployment, and much more, Tabular Editor is a must for every SSAS Tabular developer. This PowerPoint-free session will focus on demoing the capabilities of the tool.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
BI Platform Architecture, Development & Administration

Level: Intermedia

Session Code:

Date: October 07

Time: 3:15 PM - 4:15 PM

Room: CUST 1.13M

Learn how to build a bot that will answer questions asked by users. Learn how to customise it and embed it on your website. Learn how to do all of this without having to write a single line of code.

I’ll be using Microsoft’s qnamaker.io site to build an FAQ bot and the putting it live with an Azure Bot Service and the Skype Web Control. The end result is a little snippet you can add to any web page, making implementation a breeze.

You can follow along as I build the bot live, or just soak it all in. Either way, you’ll see how easy it is to build a bot and you’ll know the next steps to follow to start building more complex bots.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Cloud Application Development & Deployment

Level: Beginner

Session Code:

Date: October 07

Time: 1:45 PM - 2:45 PM

Room: CUST 1.13M

With the emergence of SQL Server 2017 vNext on Linux, new challenges arise for High Availability and Disaster Recovery solutions. What kind of features and add-on's exists in Linux that provide this type of solutions and the interoperability between instances in hybrid scenarios (with Linux and Windows) ? How can we configure all the scenarios we know of Windows on Linux and additionally how we can implement such hybrid scenarios ? Join me in this session where we will discuss all these points, as well as possible architectures and best practices in implementing HA \ DR scenarios in SQL Server 2017 vNext on Linux.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Enterprise Database Administration & Deployment

Level: Intermedia

Session Code:

Date: October 07

Time: 8:30 AM - 9:30 AM

Room: CUST 0.02M

For the last few years Microsoft have been promoting declarative, model-based database development with tools like SSDT. For many this is the way forward – gone are the days of managing endless upgrade scripts and manual deployments. 

At the same time, leaders and shakers of our industry including Jez Humble, Pramod Sadalge and Paul Stovell promote an iterative, migration script driven approach asserting that deployment scripts should be tested early and not generated by a tool. 

I'm irritated whenever I go to a “how to do database continuous delivery” session and the speaker presents one way as good and the other as bad. Like most things, it depends.

I’ll illustrate the limitations of each approach with a simple scenario. I’ll describe which projects are better suited to a model or a migrations approach, and whether it’s possible to get the best of both worlds.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Application & Database Development

Level: Intermedia

Session Code:

Date: October 07

Time: 3:15 PM - 4:15 PM

Room: CUST 1.01M

DevOps is a movement focused on improving quality and time to deliver value by tackling the thorny issues of infrastructure, testing, integration, and deployment.

These are big issues that have faced the data & analytics world for years, and tools have been slow to be delivered. This is changing though, so now we can start using the concepts from DevOps and applying them to analytics.

Taking you through the principles, the tools, and the journey to DataOps, this session will help you do work with data.
Speaker:

Accompanying Materials:

Session Type:
Regular Session (60 minutes)

Track:
Strategy and Architecture

Level: Beginner

Session Code:

Date: October 07

Time: 8:30 AM - 9:30 AM

Room: CUST 0.01M

CosmosDB service is a NoSQL is a globally distributed, multi-model database database service designed for scalable and high performance modern applications. CosmosDB is delivered as a fully managed service with an enterprise grade SLA. It supports querying of documents using a familiar SQL over hierarchical JSON documents. Azure Cosmos DB is a superset of the DocumentDB service. It allows you to store and query noSQL data, regardless of schema.
In this presentation, you will learn:
•	How to get started with DocumentDB you provision a new database account. 
•	How to index documents 
•	How to create applications using CosmosDb (using REST API or programming libraries for several popular language) 
•	Best practices designing applications with CosmosDB
•	Best practices creating queries.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Cloud Application Development & Deployment

Level: Advanced

Session Code:

Date: October 07

Time: 10:00 AM - 11:00 AM

Room: CUST 1.13M

This session is tightly coupled to Visual Studio Online (VSO) as the central component to orchestrate the path to an automated deployment process. The tool itself is so much more than just a code repository, and once we have unlocked the power of VSO, you will quickly realize the sky is the limit. Focus in this session will mainly be delivered on processes around SSAS, SSIS and SSRS and we will also briefly touch on Continuous Delivery for the underlying Data Warehouse. Come join this session, if you are ready to take the first few steps towards automation of your deployment processes and want to know how Microsoft tools can help you. 
 
In detail we will be looking at these components:
Visual Studio Online
3rd. Party Add-Ons
Build Agents
Powershell
Codeplex projects
 
And these processes:
Build
Test
Release
Speaker:

Session Type:
Extended Session (90 minutes)

Track:
Advanced Analysis Techniques

Level: Intermedia

Session Code:

Date: October 07

Time: 10:00 AM - 11:30 AM

Room: CUST 1.01M

How to move the classic SSIS packages to the cloud for the ETL process? Azure offers Data Factory, Runbooks, Logic App, or Functions. What is hidden behind the individual services and what can I do with them? The examples here show how these components can be assembled to manage a DWH's management in the cloud.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
BI Platform Architecture, Development & Administration

Level: Intermedia

Session Code:

Date: October 07

Time: 12:30 PM - 1:30 PM

Room: CUST 1.11M

Seeing a potential in jumping on board the latest and greatest we decided to start using Azure Analysis Services from the start to supplement/replace our ‘old’ SSAS Tabular 2012 production setup.
Promises of using level 1400 features, easy/better sharing to our customers, no management overhead, and all the usual cloud benefits, well, being a small company, the decision seemed like a slam dunk. After the initial test deployment, reality set in and we had to deal with:
Deployment, Processing, Security, Monitoring, Debugging, Stability, Performance and Capacity.
Without having all the answers I’ll share our experience in terms of benefits, challenges and how we made it work.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
BI Platform Architecture, Development & Administration

Level: Intermedia

Session Code:

Date: October 07

Time: 12:30 PM - 1:30 PM

Room: CUST 1.13M

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:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Enterprise Database Administration & Deployment

Level: Intermedia

Session Code:

Date: October 07

Time: 10:00 AM - 11:00 AM

Room: CUST 0.02M

Are you a DBA or Developer and would like to get started with AzureML the EASY WAY?
AzureML isn't just for "data scientists"... Anyone can use it! And after this session you'll be using it too...
Disclaimer: Sadly, AzureML still can't predict what's on your girlfriend's mind. Nothing ever will.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Advanced Analysis Techniques

Level: Beginner

Session Code:

Date: October 07

Time: 12:30 PM - 1:30 PM

Room: CUST 1.01M

Who does not know the problem, you sit in the bar and just don't know which cocktail to order?
The Cogntive services offer here with face, emotion and recommendation three APIs that can help you. How do you best combine these services to get a suggestion for your cocktail?
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Cloud Application Development & Deployment

Level: Beginner

Session Code:

Date: October 07

Time: 4:30 PM - 5:30 PM

Room: CUST 1.13M

The task seems to be easy. Maintenance of a database project in the code repository, treat it as a master-version and do deployment evenly and frequently. Simple? Seemingly. The things become more complex when the number of objects in the database grows. While instead of one database, we have over a dozen. When databases have got references to each other. And how about dictionary tables? Where to keep them and how to script? Additional issues are coming whilst we would like to control instance-level objects.
I will explain all these topics on the session focused on practical aspects of work with Microsoft Visual Studio Data Tools.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Application & Database Development

Level: Intermedia

Session Code:

Date: October 07

Time: 4:30 PM - 5:30 PM

Room: CUST 1.01M

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:

Session Type:
Regular Session (60 minutes)

Track:
Application & Database Development

Level: Beginner

Session Code:

Date: October 07

Time: 4:30 PM - 5:30 PM

Room: CUST 0.01M

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