Build Schedule

Advanced Filters:
  • Track

    clear all




  • Speaker


  • Level


  • Session Type

Sessions Found: 21
Extended Events, Dynamic Management Views, and Query Store are highly useful tools that give you a lot of data when analyzing performance problems. The challenge is which tool to use for which problems and how to correlate the data.

You are troubleshooting a performance problem in a business-critical database, a query is not completing, the users are complaining, and you are trying to understand what is happening. You have data from Extended Events, you are looking in the execution related DMVs, and now you are trying to find the query in Query Store. How do you put it all together?

In this session, we will look at how the tools work in different scenarios, how to correlate the data, and how you can use them in your performance troubleshooting.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
DBA

Level: Intermedia

Session Code:

Date: March 16

Time: 12:50 PM - 1:50 PM

Room: DEV

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:
Business Intelligence

Level: Beginner

Session Code:

Date: March 16

Time: 10:50 AM - 11:50 AM

Room: BI

This session will cover the basics of dynamic SQL; how, why and when you may wish to use it with demos of use cases and scenarios where it can really save the day (trying to perform a search with a variable number of optional search terms, anyone?). We will also cover the performance and security impacts touching on the effect on query plans, index usage and security (SQL injection!) along with some best practices.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Development

Level: Beginner

Session Code:

Date: March 16

Time: 4:20 PM - 5:20 PM

Room: DEV

How can you bring your existing on prime data warehouse and reporting into the cloud? That is precisely what the question was more than a year ago. The aim was to use everything as a service. Azure offers many possibilities with Azuer SQL DB / Azuer SQL DW / Azure Data Factory / Logic Apps / Streamanalytics / Power BI. 

Now, after more than a year in live operation, a short summary and evaluation on the subject of BI in Azure.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Business Intelligence

Level: Beginner

Session Code:

Date: March 16

Time: 8:30 AM - 9:30 AM

Room: BI

Learn how to leverage the latest SQL and .Net Core offerings to develop and deploy low-cost (including potentially license free), effective back-end application services on contemporary Linux platforms.

This session will provide an overview of challenges and opportunities, notably including:
- migrating existing SQL databases to Linux platforms
- working with Entity Framework (EF) Core
- simplified webAPI development on .Net Core with EF Core and SQL
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Development

Level: Intermedia

Session Code:

Date: March 16

Time: 3:10 PM - 4:10 PM

Room: DEV

On the current Microsoft Data Platform we have several options to move our data to the cloud.
However, finding the right fit for your environment is not that straightforward.
During this session, we will be showing you all the options you have for choosing your own cloud data strategy.
We will be handling Azure SQL databases, Azure Managed Instances, Azure VM’S and hybrid solutions.
We will show you what options you have and how you can move your on-prem systems to the cloud.
After this session you will be ready to start moving your environment to the cloud in an efficient manner.
Speaker:

Accompanying Materials:

Session Type:
Regular Session (60 minutes)

Track:
DBA

Level: Intermedia

Session Code:

Date: March 16

Time: 2:00 PM - 3:00 PM

Room: DBA

Docker has taken the world of IT by storm and looks to be ushering in the greatest platform paradigm shift since virtualisation and the public cloud. The transient nature of Docker containers makes them the perfect fit for spinning up and then tearing down SQL Server instances as part of continuous integration pipelines. Jenkins is the most popular build automation engine in the open source community, it has phenomenal plugin support, it is used by the likes of Netflix and eBay and excels in its ability to handle build pipelines as code. In this session you will learn how a simple build pipeline that takes a SQL Server data tools project checked out from source code control, built into a DACPAC which is then deployed to a SQL Server instance can be extended to use containers, multi-branch build pipelines, tSQt testing and much much more.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Development

Level: Intermedia

Session Code:

Date: March 16

Time: 8:30 AM - 9:30 AM

Room: DEV

Power BI started out as a set of Self-Service BI tools in Excel and has now been merged into Power BI Desktop with the possibility to deploy reports to the Power BI cloud service. At the same time Power BI has become a grownup Corporate BI platform.

This session will give you the full overview of all the different ways to bring and use Power BI in the enterprise including how to setup content workflow, security, auditing and governance. The session will cover on-premises only and hybrid scenarios and how to combine Self-Service BI with Enterprise Reporting with the benefit of both control and agility.

The session is build from experience from implementing Power BI in several large Danish enterprises
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Business Intelligence

Level: Intermedia

Session Code:

Date: March 16

Time: 4:20 PM - 5:20 PM

Room: BI

Azure is ready to receive all your event and device data for storage and analysis. But which options in the Azure message handling portfolio should you use to receive and manage your data? In this session I will explain the different options, take a closer look at how they work and what this means for you. Furthermore, I will take a closer look at the Azure Stream Analytics (ASA) language. You will learn how to develop both simple and complex ASA queries, and how to debug. We will look at the possibilities, limitations and pitfalls in the Azure Stream Analytics language. And finally, look at the different input and output choices and when to use which one. This includes a look at how to build a live stream dashboard with Stream Analytics data in PowerBI. The session is based on real world project experiences and will use real world data in the demos.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Development

Level: Intermedia

Session Code:

Date: March 16

Time: 9:40 AM - 10:40 AM

Room: DEV

SQL (the language) is not a third generation language, where the developer tells the computer every step it needs to take. It is a declarative language that specifies the required results. SQL Server itself will figure out what steps it takes to get to those results. Most of the time, that works very well.

But sometimes it doesn't. Sometimes a query takes too much time. You need to find out why, so you can fix it. That's where the execution plan comes in. In the execution plan, SQL Server exposes exactly which steps it took for your query, so you can see why it's slow.

However, execution plans can be daunting to the uninitiated. Especially for complex queries. Where do you even start?

In this session you will learn how to obtain execution plans. and how to start reading and understanding them.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
DBA

Level: Beginner

Session Code:

Date: March 16

Time: 9:40 AM - 10:40 AM

Room: DBA

Data Quality is one of those things that we don't pay attention to until it comes and bites us, and when it does, its usually a customer that notices it. As always, the poor beleaguered dev/database guys pay the price and work long hours and over the weekend to track things down and sort things out.

In the good old days we could rely on things like MS Data Quality Services to come to the rescue, however, now we operate in the cloud with a mixture of Vendor products, database types and at different scale, so what are the options open to us, especially on a limited budget?

This session will examine using basic Data Science and AI techniques along with open source solutions and tools, to help improve your data quality, no matter the format of the data and where it is stored. It will also demonstrate a new Open Source Data Validation/Quality toolkit Allen is developing that runs naively in the cloud for both data at rest and live streaming data at rest and live streaming data in moti
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Business Intelligence

Level: Intermedia

Session Code:

Date: March 16

Time: 9:40 AM - 10:40 AM

Room: BI

Aure Data Lake is an umbrella term consisting of multiple Azure services, most notably Azure Data Lake Store and Azure Data Lake Analytics. As the name implies, these services are built for big data processing purposes. During this session, you will gain the understanding of the use cases you should consider using these in particular. I will introduce both Data Lake Store and Data Lake Analytics, and how they have been built under the hood. In addition, I will do a couple of demos to show you how you actually can get started with them.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Business Intelligence

Level: Beginner

Session Code:

Date: March 16

Time: 3:10 PM - 4:10 PM

Room: BI

Dataflows are an important new data preparation and loading feature in Power BI. In this session you will learn:
•	What dataflows are and when you might want to use them
•	The advantages and disadvantages of using them over Power BI Desktop's data loading features
•	Configuring incremental refresh
•	Additional features available in Power BI Premium
•	Integration with Azure Data Lake Store, the Common Data Model, AI-related services and other Microsoft services
Speaker:

Accompanying Materials:

Session Type:
Regular Session (60 minutes)

Track:
Business Intelligence

Level: Beginner

Session Code:

Date: March 16

Time: 2:00 PM - 3:00 PM

Room: BI

It seems like that every month we hear about another company having a major data breach. GDPR raises the stakes with huge fines for those that lose or don't keep data safe.
Ensuring that your data is secure has become more important than ever.

With this in mind, in SQL Server 2016, Microsoft gave us three new features that have the potential to improve the security of your SQL database, either on premises or in the cloud.
These are:
Dynamic Data Masking which allows us to obfuscate data in real time
Always Encrypted which helps protect data both at rest and in motion with a master key 
Row Level Security that gives us control over who can see which rows in a table based on the user's rights

In this session we will have an overview of these important security features and demos on how to configure them and make them work.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Development

Level: Intermedia

Session Code:

Date: March 16

Time: 10:50 AM - 11:50 AM

Room: DEV

Working as a DBA, I came across some creepy things in what comes to database user (abusive) rights! 
From users that were database owners, simply because they had to be able to truncate tables and read/write data to users that were Sysadmin because they needed to Bulk Insert into one table in one database!!!!
Yes... Creepy things as I said!
This is a very sensitive and (sadly) common issue, so in this session I'll be speaking about Permissions Management and demonstrate how we can address it in the best way, i.e. giving the necessary permissions without incurring into the risk of compromising the security of an entire database or SQL Server instance!
I will also show how easily this can be done ;)
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
DBA

Level: Intermedia

Session Code:

Date: March 16

Time: 8:30 AM - 9:30 AM

Room: DBA

Azure DataBricks brings a PaaS offering of Apache Spark, which allows for blazing fast data processing, interactive querying and hosting of ML models all in one place! Most of the buzz is around Data Science & AI - what about the humble data engineer who wants to harness the in-memory processing power within their ETL pipelines?

This session focuses on Azure DataBricks as your data ingestion, transformation and curation tool of choice. We will:

	• Introduce the DataBricks service & why we use Python
	• Discuss the hosting & compute options available
	• Demonstrate a sample data processing task
	• Compare against alternative approaches using SSIS, U-SQL and HDInsight
	• Demonstrate pipeline management & orchestration
	• Review the wider architectures and extension patterns
	• Compare and contrast to new Azure Data Factory Data Flows

The session is aimed at Data Engineers seeking to put the Azure DataBricks technology in the right context and learn how to use the service. We will not
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Business Intelligence

Level: Intermedia

Session Code:

Date: March 16

Time: 12:50 PM - 1:50 PM

Room: BI

Pop quiz DBA: Your developers are running rampant in production. Logic, reason, and threats have all failed. You're on the edge. What do you do? WHAT DO YOU DO?
Hint: You attend Revenge: The SQL! 
This session will show you how to "correct" all those bad practices. Everyone logging in as sa? Running huge cursors? Using SELECT * in ad-hoc SQL? Stop them dead, without actually killing them. Ever dropped a table, or database, or WHERE clause? You can prevent that! And if you’re tired of folks ignoring your naming conventions, make them behave with Unicode…and take your revenge!
Revenge: The SQL! is fun and educational and may even have some practical use, but you’ll want to attend simply to indulge your Dark Side. Revenge: The SQL! assumes no liability and is not available in all 50 states. Do not taunt Revenge: The SQL! or Happy Fun Ball.
Speaker:

Accompanying Materials:

Session Type:
Regular Session (60 minutes)

Track:
DBA

Level: Intermedia

Session Code:

Date: March 16

Time: 10:50 AM - 11:50 AM

Room: DBA

Running SQL Server in containers has huge benefits for Data Platform professionals but there are challenges to running SQL Server in stand alone containers. Orchestrators provide a platform and the tools to overcome these challenges.

This session will provide an overview of running SQL Server in Kubernetes, which is the leading orchestrator.

Topics covered will be: -
An overview of Kubernetes.
Definition of deployments, pods, and services.
Deploying SQL Server containers to Kubernetes.
Persisting data for SQL Server in Kubernetes.

This session is aimed at SQL Server DBAs and Developers who want to learn the what, the why, and the how to run SQL Server in Kubernetes.
Speaker:

Accompanying Materials:

Session Type:
Regular Session (60 minutes)

Track:
DBA

Level: Intermedia

Session Code:

Date: March 16

Time: 12:50 PM - 1:50 PM

Room: DBA

Deploying In-Memory OLTP affects the database ecosystem, including monitoring, data migration, logging, capacity planning, backup, restore, recovery, and more.

DBAs need to know optimal methods of migrating large data sets from disk to In-Memory, the differences between restore and recovery for memory-optimized databases, and many other facets of the In-Memory world.  
Attendees will gain a clear understanding of the knowledge and skills required to administer In-Memory OLTP environments.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
DBA

Level: Intermedia

Session Code:

Date: March 16

Time: 4:20 PM - 5:20 PM

Room: DBA

User-defined functions in SQL Server are very much like custom methods and properties in .Net languages. At first sight, they seem to be the perfect tool to introduce code encapsulation and reuse in T-SQL. So why is this feature mostly avoided by all T-SQL gurus?
The reason is performance. In this session, you will learn how user-defined functions feed the optimizer with misleading and insufficient information, how the optimizer fails to use even what little information it has, and how this can lead to shocking query performance.
However, you will also see that there is a way to avoid the problems. With just a little extra effort, you can reap the benefits of code encapsulation and reuse, and still get good performance.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Development

Level: Intermedia

Session Code:

Date: March 16

Time: 2:00 PM - 3:00 PM

Room: DEV

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