Event Date: 14-12-2019 - Session time: 09:00:00 - Track: DBA
Plan forcing is a very powerful feature, but a bit controversial. This session will demystify it; you’ll see what Query Store exactly does when an execution plan is forced when it is respected, when and why isn’t, and the most important – when you have to force a plan in the production system, and when forcing can bring additional troubles. We’ll also cover in detail the automatic tuning. You will understand benefits and potential issues you can have with this feature and how to leverage it with no or minimal risk.
Event Date: 14-12-2019 - Session time: 09:00:00 - Track: DEV/DBA
This is where Terraform from Hashicorp can step in, one solution that has a provider model that will interact with Azure, AWS, Google, and others. Meaning that you only need to learn one syntax. Add that to the automation potential and now we have something that can really help get us down the road to infratructure as code.
This session will take an introductory look at how infrastructure can be defined as code and be shipped to standardise the deployment process and minimise the chance of mistakes creeping in when deployed by different memebers of Development or Operations.
Event Date: 14-12-2019 - Session time: 09:00:00 - Track: DEV
Event Date: 14-12-2019 - Session time: 09:00:00 - Track: BI
In this session, we will discuss how different types of visuals are perceived and which charts are best suited to each category. We’ll cover a basic introduction into colour theory, how to use colour effectively in reports, and how to create Power BI themes for your enterprise. Finally, you will learn an introduction to the design approach and how it helps us to tell a good data story.
Event Date: 14-12-2019 - Session time: 09:00:00 - Track: BI/DEV
Event Date: 14-12-2019 - Session time: 10:15:00 - Track: DBA
The intention of these improvements is to fix plans for poor performing queries due to wrong cardinality estimations and other sub-optimal plan decisions, and hereby enhance query performance with no code changes. This session will cover briefly all 2019 features: Batch Mode on Rowstore, Batch and Row Mode Memory Grant Feedback, Scalar UDF Inlining, Table Variable Deferred Compilation, and Approximate Query Processing. If time permits, you’ll see also Batch Mode Adaptive Join and Interleaved Execution. After the session, you’ll understand how much improvements you should expect in your workloads, but also which of these features, and under which circumstances, can cause significant performance regression and how to overcome those issues.
Event Date: 14-12-2019 - Session time: 10:15:00 - Track: DEV/DBA
In this session, I will show a few ways to approach problem solving in a practical and concise manner. Using real-world scenarios that I have run into in the past I will explain how I approached each issue. Sometimes by finding simple solutions, but sometimes having to be creative and employ methods that may not be so intuitive.
You will leave the session with a better understanding on how to approach solving any technical issues you experience at work.
Event Date: 14-12-2019 - Session time: 10:15:00 - Track: BI/DEV
How can you use these API's if you don't want to send your data to an Azure Data Center? Not every data set should leave your company. That's why Microsoft now offers the whole thing as a docker image, which you can run on your own hardware. As a company, you regain control over your data.
Event Date: 14-12-2019 - Session time: 10:15:00 - Track: DEV
Event Date: 14-12-2019 - Session time: 10:15:00 - Track: BI
Exciting times of endless possibilities and fast shifting demands of modern BI are proving to be a big challenge for products with nowhere near as long of a history as the one that Excel has. But if history taught us anything, it's that Excel will persevere and transform to fulfill all the user's needs. This is a story of how Excel went from a single piece of data (a cell) focused application to a Rows (records), Columns and Tables focused application in a span of ten years with an explosion of possibilities in the last two. We will breeze past the early staples like Power Query and Power Pivot to submerge ourselves into the world of New data types in Excel and finish on a high note of Dynamic Arrays in Excel showing how incredibly agile (considering the long tail it's got (history)) Excel is with a transformation of its core to open up the world of incredible possibilities.
Event Date: 14-12-2019 - Session time: 11:30:00 - Track: BI/DEV
Before you decide on designing an advanced analytics solution on-premises, why not give it a go on a platform that only charges money for the time you are actually using it? Azure Machine learning is a cloud service that enables you to easily build, deploy and share analytics solutions with all the flexibility of the cloud. The perfect platform to start with advanced analytics without having to invest a lot of money! In this session we are going to take a close look at AzureML, from how you can build your first machine learning model, to connecting AzureML to your on-premises SQL Server database!
Event Date: 14-12-2019 - Session time: 11:30:00 - Track: DEV/DBA
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 will Page Splits and Forwarded Records have for my application design?
Event Date: 14-12-2019 - Session time: 11:30:00 - Track: BI
After some usage, users have reacted that it's a bit sluggish in usage, and they're not keen on using it anymore.
Starting off with the new Performance Analyzer Pane, we'll demonstrate how you can pinpoint bottlenecks in your report, and take actions on these insights.
With the myriad of root causes that are out there, an elimination approach might suit us very well. Some of the main causes will be explained, and we'll get you going on how you can fix it for yourselves.
Be it DAX-measures, modelling issues, or an overload of visuals. Every report can be tuned to handle like a dream, and you can do it too!
Event Date: 14-12-2019 - Session time: 11:30:00 - Track: DEV
With grouping and ranking functions you can calculate in your query grandtotal, running totals, find islands in intervals, select the last-not-null value, etc. Windows functions apply directly on a set of rows defined by the OVER clause ("a window"). Windows function do not perform aggregation on group level and do not hide row details. So they allow mixing detail and total elements in the same query. The session is mainly based on a copious array of demos, to make explicit every concept introduced taking into account the impact on performances for every solution.
Event Date: 14-12-2019 - Session time: 11:30:00 - Track: DBA
Event Date: 14-12-2019 - Session time: 13:30:00 - Track: DBA
This demo heavy session will walk through some of the challenges around managing container environments and how Kubernetes orchestration can help alleviate some of the pain points.
We will be talking about what Kubernetes is and how it works and through the use of demos we will:
Event Date: 14-12-2019 - Session time: 13:30:00 - Track: BI/DEV
Event Date: 14-12-2019 - Session time: 13:30:00 - Track: DEV
In this presentation we will demonstrate a scenario which is relevant to organizations that need a scalable and elastic architecture for online order processing or more specifically e-commerce and retail point-of-sale transactions such as orders, payments and bills.
This scenario takes an event sourcing approach, using a functional programming model implemented via Azure Cosmos DB change feed processor and additional Azure Services. This approach enables high availability and resiliency, geo-replication, and fast performance.
Event Date: 14-12-2019 - Session time: 13:30:00 - Track: BI
Event Date: 14-12-2019 - Session time: 13:30:00 - Track: DEV/DBA
Event Date: 14-12-2019 - Session time: 14:45:00 - Track: DBA
We will cover installing Azure Data Studio. What a SQL Notebooks is. Numerous use cases for you to use SQL Notebooks in your daily workload such as creating a Notebook for Glenn Berry's Diagnostic queries.
and some gifs ;-)
Event Date: 14-12-2019 - Session time: 14:45:00 - Track: BI/DEV
You get to decide how far you want to go, from cost-effective to penny pinching. Don't worry if you've never used any of these technologies, I will start at the beginning.
Event Date: 14-12-2019 - Session time: 14:45:00 - Track: DEV
You can solve this by operating on the data in chunks. Implementing chunking is not that difficult, but there are still pitfalls you can run into. In this session, I will discuss in what situations you may want to use chunking. I will give some best practices for how to implement chunking for good performance and I will highlight some things you need keep in mind, for instance, recovering from interruptions.
I will also look at how you can use chunking for error handling: You want process many rows and you want the good rows to succeed even if some rows yield errors – something you cannot do in a single set-based statement.
Event Date: 14-12-2019 - Session time: 14:45:00 - Track: BI
Even if not today, certainly in the future (yes, believe me) you will face a case: how to move my data from on-premise Data Warehouse to Azure. This session will reveal the ideas of how to do that, how to recognise if you are ready, what the best practices are and other important things we should be aware of. I will describe potential issues and give you hints on how to avoid them. Finally, I will present one tool that can help you in preparation and also we will see what speed we can achieve during a migration.
Event Date: 14-12-2019 - Session time: 14:45:00 - Track: DEV/DBA
In this session, you’ll learn about the challenges that we, as technology professionals, face in our software development and administrative work. Learn compliant DevOps strategies for reducing your attack surface area by ensuring you know where sensitive data is located and avoid copying that data to non-production environments.
Event Date: 14-12-2019 - Session time: 16:00:00 - Track: DBA
In this session we will combine multiple open source tools (InfluxDB, Telegraf , Grafana, DbaTools and many more) to collect important performance metrics, analyze the data they collect, set up alert for the critical events, troubleshoot issues and plan for the future. Join me and you will see how monitoring is not a business for billionaires.
Event Date: 14-12-2019 - Session time: 16:00:00 - Track: DEV
Event Date: 14-12-2019 - Session time: 16:00:00 - Track: BI
Extracting, transforming and loading with the help from Functions, Data Factory, Data Lake Store, Polybase, SQL Data Warehouse, SQL Database, Automation Runbooks, Analysis Services and Power BI Embedded.
A look into the overall architecture and the different components and how they work together.
Event Date: 14-12-2019 - Session time: 16:00:00 - Track: BI/DEV
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.
Event Date: 14-12-2019 - Session time: 16:00:00 - Track: DEV/DBA
DevOps is transforming software development, with many organizations and individuals adopting lean development practices, implementing Continuous Integration (CI), Continuous Deployment (CD), and performing on-demand deployments to their production environments. However, the database is largely ignored and seen as a bottleneck for a DevOps software development process. We will discuss the challenges of database development and deployment and examine why many developers find the database to be an impediment. We examine the risks of sensitive data in the development process and how you can ensure that data security concerns do not get in the way of the need for speed and agility. We’ll look at how you can adopt a Compliant Database DevOps approach that removes the database bottleneck while ensuring compliance with regulations governing the use of data within your organization such as GDPR, HIPPA or SOX. We’ll discuss the techniques used to include the data