sqlsathistory

Nr: 971

Back to Main list

SQLSaturday #971 - Oslo - Virtual 2020

Start Time (24h) Speaker Track Title
09:30:00 Jess Pomfret Enterprise Database Administration Deployment (Cloud/Hybrid/On-prem) Life Hacks: dbatools edition
09:30:00 Halvar Trøyel Nerbø BI Platform Architecture, Development Administration (Cloud/Hybrid/On-prem) From 0 to hero. Azure data factory CI/CD experiences
09:30:00 Marco Russo BI Platform Architecture, Development Administration (Cloud/Hybrid/On-prem) My Power BI Report is Slow: What Should I Do?
09:30:00 Ben Weissman Enterprise Database Administration Deployment (Cloud/Hybrid/On-prem) SQL Server 2019 Big Data Clusters: Make SQL Server your Data Hub for everything
10:45:00 Oskari Heikkinen BI Platform Architecture, Development Administration (Cloud/Hybrid/On-prem) Best Practices for building a Data Lake with Azure Databricks
10:45:00 Gianluca Sartori Enterprise Database Administration Deployment (Cloud/Hybrid/On-prem) Benchmarking in the Cloud
10:45:00 Alexander Klein Analytics and Visualization (Cloud/Hybrid/On-prem) Monitoring service quality with Artificial Intelligence
10:45:00 Ida Bergum BI Platform Architecture, Development Administration (Cloud/Hybrid/On-prem) Power Automate your BI
12:00:00 Dennes Torres BI Platform Architecture, Development Administration (Cloud/Hybrid/On-prem) Why Synapse Analytics is beyond Azure SQL Datawarehouse
12:00:00 Marius Sandbu Enterprise Database Administration Deployment (Cloud/Hybrid/On-prem) Azure Arc and Providing Data Platform Services - MSSQL and PostegreSQL
12:00:00 Hugo Kornelis Application Database Development (Cloud/Hybrid/On-prem) From adaptive to intelligent: query processing in SQL 2019
12:00:00 Marc Lelijveld Analytics and Visualization (Cloud/Hybrid/On-prem) Use parameters to add extra flexibility to your Power BI content
13:15:00 Andreas Hope Enterprise Database Administration Deployment (Cloud/Hybrid/On-prem) Launch: dbWatch Control Center launch – announcement and live dem
13:45:00 Kevin Chant Enterprise Database Administration Deployment (Cloud/Hybrid/On-prem) Azure DevOps duet (60 minutes version)
13:45:00 John Martin Enterprise Database Administration Deployment (Cloud/Hybrid/On-prem) Four Steps to Securing your Data Platform
13:45:00 Magnus Ahlkvist Application Database Development (Cloud/Hybrid/On-prem) Statistics, an unreliable friend.
13:45:00 Marthe Moengen Enterprise Database Administration Deployment (Cloud/Hybrid/On-prem) Data is all around - so how do you control it? ​
15:00:00 Andrew Pruski Enterprise Database Administration Deployment (Cloud/Hybrid/On-prem) Chaos Engineering for SQL Server
15:00:00 Erland Sommarskog Application Database Development (Cloud/Hybrid/On-prem) SQL Titbits for the Inexperienced
15:00:00 Per Christopher Undheim Enterprise Database Administration Deployment (Cloud/Hybrid/On-prem) Beyond instance tuning: Optimizing and managing a SQL Server Farm
16:15:00 Brent Ozar Application Database Development (Cloud/Hybrid/On-prem) Watch Brent Tune Queries
16:15:00 Margarita Naumova Enterprise Database Administration Deployment (Cloud/Hybrid/On-prem) Consolidation best practices

SessionID: 103366

Life Hacks: dbatools edition

Back to calendar

Event Date: 29-08-2020 - Session time: 09:30:00 - Track: Enterprise Database Administration Deployment (Cloud/Hybrid/On-prem)

Speaker: Jess Pomfret

Title: Life Hacks: dbatools edition

Abstract:

dbatools is an open source PowerShell module with over 500 commands to assist you with managing your SQL Server estate. This session will walk through several life hacks that you can take back to work and quickly implement to make your life easier and impress your friends.

This session’s life hacks will include, among others:

SessionID: 103742

From 0 to hero. Azure data factory CI/CD experiences

Back to calendar

Event Date: 29-08-2020 - Session time: 09:30:00 - Track: BI Platform Architecture, Development Administration (Cloud/Hybrid/On-prem)

Speaker: Halvar Trøyel Nerbø

Title: From 0 to hero. Azure data factory CI/CD experiences

Abstract:

Do you want to do CI/CD using Azure Data Factory? I have. This session will cover how to do it, showcasing the dos and don'ts and experience using Terraform and Azure DevOps to deploy and successfully use Continuous Integration (CI) and Continuous Deployment (CD) using Azure Data Factory.

We will set up a development, test and production Azure Data Factory using variables and release pipelines in Azure DevOps. Fun times guaranteed!

SessionID: 104326

My Power BI Report is Slow: What Should I Do?

Back to calendar

Event Date: 29-08-2020 - Session time: 09:30:00 - Track: BI Platform Architecture, Development Administration (Cloud/Hybrid/On-prem)

Speaker: Marco Russo

Title: My Power BI Report is Slow: What Should I Do?

Abstract:

You created a wonderful Power BI report, but when you open it you wait too much time. Changing a slicer selection is also slow. Where should you start analyzing the problem? What can you do to optimize performance?

This session will guide you in analyzing the possible reasons for a slow Power BI report. By using Task Manager and DAX Studio, you will be able to determine whether you should change the report layout, or if there is something in DAX formulas or in the data model that is responsible for the slow response.

At the end of this session, you will understand how to locate a performance bottleneck in a Power BI report, so you will focus your attention on the biggest issue.

SessionID: 104329

SQL Server 2019 Big Data Clusters: Make SQL Server your Data Hub for everything

Back to calendar

Event Date: 29-08-2020 - Session time: 09:30:00 - Track: Enterprise Database Administration Deployment (Cloud/Hybrid/On-prem)

Speaker: Ben Weissman

Title: SQL Server 2019 Big Data Clusters: Make SQL Server your Data Hub for everything

Abstract:

In the realm of data storage and processing, there are two major technologies which we deal with every day. On one side, we have relational data that is stored inside SQL Server, and on the other side, non-relational or very large datasets that do not fit the relational model which are stored on big data clusters like Hadoop or Spark.

This introduces challenges when having to combine datasets across both these technologies. SQL Server was never built to process huge datasets in a distributed fashion or to handle non-relational data very well, meaning that in many cases you would have to resort to bringing your relational data into Hadoop or Spark clusters. SQL Server 2019 has the answer with Big Data Clusters: it combines SQL Server with HDFS and Spark!

In this session we are going to explore the capabilities of the exciting new feature. How does it work and how can we work with datasets that are non-relational?

SessionID: 101891

Best Practices for building a Data Lake with Azure Databricks

Back to calendar

Event Date: 29-08-2020 - Session time: 10:45:00 - Track: BI Platform Architecture, Development Administration (Cloud/Hybrid/On-prem)

Speaker: Oskari Heikkinen

Title: Best Practices for building a Data Lake with Azure Databricks

Abstract:

Databricks is a Unified Analytics Platform making it easier than ever to do big data analytics on cloud. However, there are a lot of things you need to know and take into account before diving head first into a Data Lake. This session is intended for architects and developers who are looking to build a massive scale data storing and processing solution. I will go through the Best Practices for the purpose. In addition, I will demonstrate how to unify real-time and batch processing using Azure Databricks. As a result, you should feel comfortable building your own Data Lake for your big data processing needs.

SessionID: 102584

Benchmarking in the Cloud

Back to calendar

Event Date: 29-08-2020 - Session time: 10:45:00 - Track: Enterprise Database Administration Deployment (Cloud/Hybrid/On-prem)

Speaker: Gianluca Sartori

Title: Benchmarking in the Cloud

Abstract:

Lifting and shifting your application to the cloud is extremely easy, on paper. The hard truth is that the only way to know for sure how it is going to perform is to test it. Benchmarking on premises is hard enough, but benchmarking in the cloud can get really hairy because of the restrictions in PaaS environments and the lack of tooling.

Join me in this session and learn how to capture a production workload, replay it to your cloud database and compare the performance. I will introduce you to the methodology and the tools to bring your database to the cloud without breaking a sweat.

SessionID: 104435

Monitoring service quality with Artificial Intelligence

Back to calendar

Event Date: 29-08-2020 - Session time: 10:45:00 - Track: Analytics and Visualization (Cloud/Hybrid/On-prem)

Speaker: Alexander Klein

Title: Monitoring service quality with Artificial Intelligence

Abstract:

Since you often have the task of document recognition, text evaluation or image rating in Office 365, I show you the link to Cognitive Services, where you can generate various added values for your Office 365 project using image and text recognition methods. I use function calls for the direct call of the Cognitive Services and show you how you can directly access external API (of the Cognitive Services).

The example in this session is about the evaluation of the service quality of the #SQLKellner. It explains step by step how to assemble all components to get a "Service AI Power App" that runs on every smartphone or tablet.

The list of ingredients includes Cognitive Services (AI), Power Apps, an Azure SQL DB, a Logic App and Power BI.

SessionID: 104453

Power Automate your BI

Back to calendar

Event Date: 29-08-2020 - Session time: 10:45:00 - Track: BI Platform Architecture, Development Administration (Cloud/Hybrid/On-prem)

Speaker: Ida Bergum

Title: Power Automate your BI

Abstract:

In this session I will cover useful API operations in the Power BI API and present rich demoes on how you can use Microsoft Power Automate Flows to automate Power BI tasks; Trigger a refresh of a dataset, get refresh of dataset and post to Teams and Automation of managing Premium Capacities and show some of the news in this area relevant for monitoring.

SessionID: 101880

Why Synapse Analytics is beyond Azure SQL Datawarehouse

Back to calendar

Event Date: 29-08-2020 - Session time: 12:00:00 - Track: BI Platform Architecture, Development Administration (Cloud/Hybrid/On-prem)

Speaker: Dennes Torres

Title: Why Synapse Analytics is beyond Azure SQL Datawarehouse

Abstract:

Synapse Analytics is being announced as the new name of Azure SQL Datawarehouse, but it's not only that. There is a broader view in Synapse analytics, beyond Azure SQL Datawarehouse. Let's see in this session what was improved, what changed, and how synapse analytics fits in the data platform.

SessionID: 102507

Azure Arc and Providing Data Platform Services - MSSQL and PostegreSQL

Back to calendar

Event Date: 29-08-2020 - Session time: 12:00:00 - Track: Enterprise Database Administration Deployment (Cloud/Hybrid/On-prem)

Speaker: Marius Sandbu

Title: Azure Arc and Providing Data Platform Services - MSSQL and PostegreSQL

Abstract:

Microsoft recently announced Azure Arc which will be Microsoft way to deploy PaaS on your own datacenter. In this session we will go trough what Azure Arc is and how we can use it to deploy PostgreSQL and MSSQL Server running on kubernetes using Azure Arc and also how to design and implement an underlying Kubernetes solution to provide as a foundation for your future data platforms.

SessionID: 103607

From adaptive to intelligent: query processing in SQL 2019

Back to calendar

Event Date: 29-08-2020 - Session time: 12:00:00 - Track: Application Database Development (Cloud/Hybrid/On-prem)

Speaker: Hugo Kornelis

Title: From adaptive to intelligent: query processing in SQL 2019

Abstract:

As announced in September 2018, SQL Server 2019 expands the "adaptive query processing" features of SQL 2017 and relabels them as "intelligent query processing". This name now covers many features, such as batch mode on rowstore, memory grant feedback, interleaved execution, adaptive joins, deferred compilation, and approximate query processing.

In this high-paced session, we will look at all these features and cover some use cases where they might help - or hurt! - you.

SessionID: 104204

Use parameters to add extra flexibility to your Power BI content

Back to calendar

Event Date: 29-08-2020 - Session time: 12:00:00 - Track: Analytics and Visualization (Cloud/Hybrid/On-prem)

Speaker: Marc Lelijveld

Title: Use parameters to add extra flexibility to your Power BI content

Abstract:

You're probably applying a lot of steps over and over again every time you create your Power BI report. A waste of time! Apply parameters on the back-end in Power Query, but also in the front-end in your report to make your solutions much more flexible.

This session will give you examples on where you can use parameters in Power BI and which advantages this will have for you.

SessionID: 107580

Launch: dbWatch Control Center launch – announcement and live dem

Back to calendar

Event Date: 29-08-2020 - Session time: 13:15:00 - Track: Enterprise Database Administration Deployment (Cloud/Hybrid/On-prem)

Speaker: Andreas Hope

Title: Launch: dbWatch Control Center launch – announcement and live dem

Abstract:

dbWatch is announcing its new flagship product for monitoring and managing database server farms.

Short information and live demo.

Presenter: Andreas Hope, Marketing Director, dbWatch AS

SessionID: 101876

Azure DevOps duet (60 minutes version)

Back to calendar

Event Date: 29-08-2020 - Session time: 13:45:00 - Track: Enterprise Database Administration Deployment (Cloud/Hybrid/On-prem)

Speaker: Kevin Chant

Title: Azure DevOps duet (60 minutes version)

Abstract:

This session will cover the process of developing a CI/CD process starting at getting the team on board and ending with making an actual release.

We will discuss

After this session you will have the tools and knowledge to get started with DevOps and get your development process to the next level.

SessionID: 102081

Four Steps to Securing your Data Platform

Back to calendar

Event Date: 29-08-2020 - Session time: 13:45:00 - Track: Enterprise Database Administration Deployment (Cloud/Hybrid/On-prem)

Speaker: John Martin

Title: Four Steps to Securing your Data Platform

Abstract:

Data is valuable, really valuable, but in many cases security is an afterhought to getting things done. But this approach can come at a cost, quite a heavy one in the event of a GDPR or PCI-DSS breach.

In this session we will look at four key elements that are integral to data platform security and how to implement them. By adopting a 'Secure by Design' approach you will reduce risk while also delivering value.

SessionID: 102140

Statistics, an unreliable friend.

Back to calendar

Event Date: 29-08-2020 - Session time: 13:45:00 - Track: Application Database Development (Cloud/Hybrid/On-prem)

Speaker: Magnus Ahlkvist

Title: Statistics, an unreliable friend.

Abstract:

You learned that your statistics should be regularly updated. You even implemented Ola Hallengren's maintenance scripts. That should be enough, right? What if it's not?

Join me on some head-ache, a dive into statistics histograms, fun with flags and a praise to the evolution of SQL Server optimizer. Much of this session is about the "ascending key problem", and how Microsoft have made shanges to the SQL Server optimizer to improve, but not completely eliminate the problem.

SessionID: 104402

Data is all around - so how do you control it? ​

Back to calendar

Event Date: 29-08-2020 - Session time: 13:45:00 - Track: Enterprise Database Administration Deployment (Cloud/Hybrid/On-prem)

Speaker: Marthe Moengen

Title: Data is all around - so how do you control it? ​

Abstract:

Data is all around. And as the value of data has become clear for most businesses, they are eager to start using it to get better insights. Still, as the sources, users and need for data increases, the job to ensure that your data is used the way it was intended throughout the company becomes challenging. How do you enable your business to take full advantage of your data?

In this session, I will present how data governance and particularly the augmented data catalog can tackle this issue. In addition, we will have a look at how such a data catalog can act as a tool for the developers. How it can help bridge the gap between the business and the developer. And also why Gartner believes that an augmented data catalog is a key component for data lake projects to deliver value.

SessionID: 101974

Chaos Engineering for SQL Server

Back to calendar

Event Date: 29-08-2020 - Session time: 15:00:00 - Track: Enterprise Database Administration Deployment (Cloud/Hybrid/On-prem)

Speaker: Andrew Pruski

Title: Chaos Engineering for SQL Server

Abstract:

In this session we will explore the concept of Chaos Engineering, its core concepts, and how it has been implemented at various companies.

Then we'll look at how it can be implemented with regard to SQL Server. SQL has various different high availability solutions but can you be sure that they'll react as expected to a real world issue? Has your HA architecture only ever been tested in a planned maintenance window?

We'll also have some fun by looking at KubeInvaders, a chaos engineering tool for Kubernetes...using Space Invaders!

This session is for SQL Server DBAs and Developers who want to know how Chaos Engineering works and want to learn its main principles.

SessionID: 103428

SQL Titbits for the Inexperienced

Back to calendar

Event Date: 29-08-2020 - Session time: 15:00:00 - Track: Application Database Development (Cloud/Hybrid/On-prem)

Speaker: Erland Sommarskog

Title: SQL Titbits for the Inexperienced

Abstract:

This session is directed to you who have been using SQL left-handedly a year or so. You have learnt to write the basic queries, but there are still some gaps in your SQL knowledge, and overall SQL is a little confusing to you. This session aims at filling some of these gaps by covering a few titbits about SQL and give you some tips that will be useful to you. This includes really basic things as what GO really is and the traps you can run into with NULL values. You will also learn a little about data types and how you should use UNION. Finally, I will talk about CTEs, temp tables and table variables and you will get some ideas what to use when.

SessionID: 103975

Beyond instance tuning: Optimizing and managing a SQL Server Farm

Back to calendar

Event Date: 29-08-2020 - Session time: 15:00:00 - Track: Enterprise Database Administration Deployment (Cloud/Hybrid/On-prem)

Speaker: Per Christopher Undheim

Title: Beyond instance tuning: Optimizing and managing a SQL Server Farm

Abstract:

Most DBA’s are cowboys, but there is much to learn from the world of cow herding and dairy farms that can make us manage SQL Server instances in a better way. SQL Server farms are the future of large scale database management, and we will teach you the ropes. Introducing the FarmDataLanguage brings another dimension of control to large scale database server monitoring and management.

SessionID: 101873

Watch Brent Tune Queries

Back to calendar

Event Date: 29-08-2020 - Session time: 16:15:00 - Track: Application Database Development (Cloud/Hybrid/On-prem)

Speaker: Brent Ozar

Title: Watch Brent Tune Queries

Abstract:

You’re in a dark room with an ugly query. What do you do next? Microsoft Certified Master Brent Ozar shares his time-tested method of tuning queries starting with simplifying, analyzing the execution plan, making index tweaks, and measuring improvements with statistics. You’ll learn a repeatable process you can use to make queries go faster.

SessionID: 104564

Consolidation best practices

Back to calendar

Event Date: 29-08-2020 - Session time: 16:15:00 - Track: Enterprise Database Administration Deployment (Cloud/Hybrid/On-prem)

Speaker: Margarita Naumova

Title: Consolidation best practices

Abstract:

You performed a consolidation of your databases, but you run into performance problems. Having many databases in a SQL Server Instance is a common solution. It reduces licensing and hardware costs. But to have a solution like this working according to the SLAs we need to pay a special attention on the way we implement Instance level consolidation. There are some important rules to follow from the very beginning of the project. How to group databases and which databases are not to be consolidated is just the first worth mentioning. Performance monitoring and resource usage analysis becomes even more important in a consolidated environment. In this session I will talk about important things to consider when you have to design, implement, monitor and support a consolidated SQL Server Instance which serves many apps. You will see some good and bad practices from real projects, you will have a list of practical advices and even scripts to use in your environment.

This site is open source. Improve this page.