Event Date: 18-03-2017 - Session time: 08:30:00 - Track: DBA
In this session we will examine Query Store, it's architecture, configuration and how it can be used to solve performance problems.
Event Date: 18-03-2017 - Session time: 08:30:00 - Track: DevOps
Cognitive services are becoming increasingly powerful and easy to address. With the focus on suggestions (Customers who bought this product also bought ...) I compare Azure ML and Cognitive Servies Recommendations. The result is the same for both, a proposal which could also be interesting. Only the how is for the developer significantly different.
Event Date: 18-03-2017 - Session time: 08:30:00 - Track: Business Intelligence
During this session I will go through and explain some examples on generating a SSAS tabular model by using the new TSML. I will spend some time showing and about explaining a real world example on pushing measure creation to the key business stakeholders to ensure quick time to market.
The last thing i will show is how you speed up your development free up up to 50% of the time you spend building tabular models with the simple an advanced features of Tabular Editor 2.0
Event Date: 18-03-2017 - Session time: 09:40:00 - Track: DevOps
This session takes you behind the basics of Temporal Tables and answers - after a short introduction - the following questions:
You are interested in the answers to all the above questions (and more). This session will answer EVERY question about Temporal Tables.
Event Date: 18-03-2017 - Session time: 09:40:00 - Track: Business Intelligence
In this talk, we'll explore the Power BI Dashboard, getting started with the setup, and a deep dive into the technical components that power this solution. We'll also cover the pricing model and suggestions for right-sizing the components that I've used to help several customers with this amazing solution.
Solution details can be found here: https://powerbi.microsoft.com/en-us/solution-templates/brand-management-twitter/
Event Date: 18-03-2017 - Session time: 09:40:00 - Track: DBA
Event Date: 18-03-2017 - Session time: 10:50:00 - Track: DevOps
Microsoft Azure has the ability to move, store and analyze data within the cloud. It is essential to evaluate multiple opportunities and options with Microsoft Azure data insights. In this session let us talk about strategies on data storage, data partitioning and availability options with Azure. A tour on how best these Azure components can help you achieve success for your Big Data platform.
Event Date: 18-03-2017 - Session time: 10:50:00 - Track: Business Intelligence
Event Date: 18-03-2017 - Session time: 10:50:00 - Track: DBA
Each problem can have many solutions, but not every solution is simple to write, understand and maintain, and not every solution is good in terms of performance. In this session, we will look at real world problems and solve them using T-SQL. We won’t settle for just A solution, but show elegant, simple solutions that will yield optimal performance.
Event Date: 18-03-2017 - Session time: 12:30:00 - Track: Business Intelligence
Event Date: 18-03-2017 - Session time: 12:30:00 - Track: DevOps
Come and learn the differences of space allocation/deallocation between Clustered Indexes and Heaps in this demo oriented session. It will answer these questions:
What is the difference of data page allocation for heaps and clustered indexes? What is the amount of transaction log when you update data in a heap and/or in a clustered index? What are the differences when data are delete from a heap and clustered index? Can ETL processes be improved by usage of the right strategy for INSERTS and DELETES? What performance drawbacks have Page Splits and Forwarded Records for my application design?
Event Date: 18-03-2017 - Session time: 12:30:00 - Track: DBA
In this session we'll see a few 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), 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 (Jedi level). Disclaimer: No actual state secrets will be revealed. Please do not send agents to my house again.
Event Date: 18-03-2017 - Session time: 13:40:00 - Track: DBA
Event Date: 18-03-2017 - Session time: 13:40:00 - Track: DBA
Event Date: 18-03-2017 - Session time: 13:40:00 - Track: Business Intelligence
Event Date: 18-03-2017 - Session time: 14:50:00 - Track: DBA
Attendees will be taken through the following: -
Defining what containers are (benefits and limitations) Configuring Windows Server 2016 to run containers Installing the docker engine Pulling SQL images from the docker respository Running SQL Server containers Committing new SQL Server images Exploring 3rd party options to run containers on previous versions of Windows Server (real world example)
This sessions assumes that attendees have a good background in SQL Server administration and a basic knowledge of Windows Server administration
Event Date: 18-03-2017 - Session time: 14:50:00 - Track: Business Intelligence
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.
Event Date: 18-03-2017 - Session time: 16:00:00 - Track: DevOps
However, your deployments are still expensive and risky. You find it hard to keep track of what has been deployed to each environment. You don’t have a great deal of confidence that the production database is still in line with source control. You may have heard of the automated deployment functionality in VSTS or Octopus Deploy but you haven’t tried it yet… at least not for SQL Server.
In this session I’ll automate a deployment pipeline in a couple of different ways. I’ll discuss the importance of your database model as well as repeatable upgrade scripts and discuss the pros and cons of different approaches to automation. I’ll also discuss how to monitor for and protect yourself from database drift.
Event Date: 18-03-2017 - Session time: 16:00:00 - Track: Business Intelligence
Event Date: 18-03-2017 - Session time: 16:00:00 - Track: DBA