Event Date: 16-03-2019 - Session time: 08:30:00 - Track: Business Intelligence
Now, after more than a year in live operation, a short summary and evaluation on the subject of BI in Azure.
Event Date: 16-03-2019 - Session time: 08:30:00 - Track: Development
Event Date: 16-03-2019 - Session time: 08:30:00 - Track: DBA
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 ;)
Event Date: 16-03-2019 - Session time: 09:40:00 - Track: Business Intelligence
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
Event Date: 16-03-2019 - Session time: 09:40:00 - Track: DBA
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.
Event Date: 16-03-2019 - Session time: 09:40:00 - Track: Development
Event Date: 16-03-2019 - Session time: 10:50:00 - Track: Development
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.
Event Date: 16-03-2019 - Session time: 10:50:00 - Track: Business Intelligence
This session is not for the Enterprise rather has a more DIY approach.
Event Date: 16-03-2019 - Session time: 10:50:00 - Track: DBA
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.
Event Date: 16-03-2019 - Session time: 12:50:00 - Track: DBA
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.
Event Date: 16-03-2019 - Session time: 12:50:00 - Track: Business Intelligence
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
Event Date: 16-03-2019 - Session time: 12:50:00 - Track: DBA
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.
Event Date: 16-03-2019 - Session time: 14:00:00 - Track: DBA
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.
Event Date: 16-03-2019 - Session time: 14:00:00 - Track: Development
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.
Event Date: 16-03-2019 - Session time: 14:00:00 - Track: Business Intelligence
• 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
Event Date: 16-03-2019 - Session time: 15:10:00 - Track: Development
This session will provide an overview of challenges and opportunities, notably including:
Event Date: 16-03-2019 - Session time: 15:10:00 - Track: DBA
There’s gotta be a better way, right?
Good news – there is, and you’re about to learn how the pros do it. In one all-demo session, you’ll watch Brent Ozar use sp_WhoIsActive, sp_BlitzFirst, and sp_BlitzCache to solve several common emergencies. You’ll walk away with a written checklist to solve typical performance emergencies.
Event Date: 16-03-2019 - Session time: 15:10:00 - Track: Business Intelligence
Event Date: 16-03-2019 - Session time: 16:20:00 - Track: DBA
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.
Event Date: 16-03-2019 - Session time: 16:20:00 - Track: Development
Event Date: 16-03-2019 - Session time: 16:20:00 - Track: Business Intelligence
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