Microsoft Common Data Services, Model, Analytics, Pools? What? Stop!

Well, we all are already aware that with Evergreening every day new services in Azure appear or every month new features in Power BI will be introduced. But the stuff that is next will be massive for Power BI, Power Apps, for Dynamics, for Master Data, Data Catalogs even for Data Lakes: Common Data Service, […]

Read more

dbachecks – Checking SQL Server environments with PowerShell

dbachecks is a framework created by and for SQL Server pros who need to validate their environments. It is a free, open source module (created by dbatools team) that allows data pros to crowdsource our checklists using PowerShell’s open source testing framework, Pester. We all share similar checklists and mostly just the server names and […]

Read more

Open Knowledge Platform Use-Cases

Many of Open Knowledge International’s projects are technical in nature. Its most prominent project, CKAN, is used by many of the world’s governments to host open catalogues of data that their countries possess. CKAN is a tool for making open data websites. (Think of a content management system like WordPress – but for data, instead […]

Read more

From Data Lake to DAX Query

Collecting data from and combining data out of different data sources is the essential requirement for BI. In times of cloud services this is getting a lot easier. Azure offers a variety of services that work hand in hand and can be fully automated using PowerShell or.NET. In this session we will show an example […]

Read more

Azure SQL DB Managed Instances – Built to easily modernize application data layer

Managed Instances is the latest fully managed deployment model for Azure SQL Database that enables friction-free migration for SQL Server applications running on-premises. Come and learn why Managed Instance is the best PaaS destination for all SQL Server workloads and how to start your cloud modernization at scale now, using Azure SQL Database Managed Instances. […]

Read more

Laying Down the Law with SQL Server Resource Governor

Interactive business workloads, batch workloads and administrator activity often overlap. Resource Governor is a SQL Server tool for tracking and provisioning resources which can be used to great effect in traditional on-premise systems, virtualized systems, and in the cloud. In this session, we’ll explore various strategies for Resource Governor classification functions. With demos and design […]

Read more

Multi-Cloud Deployment and Automation

In this talk I will go over how to automate a multi cloud deployment with Terraform. After that we will use Cassandra as an application that is also deployed in an automated fashion (using Ansible). I will not only go over the automation tools used (Terraform and Ansible) but also the pitfalls to avoid in […]

Read more

Azure SQL Data Sync – Internals

In this session we will deep dive into the components and they work together to track changes and sync data. Based on this we will be able to understand the requirements, performance, best practices and how to troubleshoot.

Read more

Embrace and Extend: First-Class Activity and 3rd Party Ecosystem for SSIS in ADF

This session focuses on the deeper integration of SQL Server Integration Services (SSIS) in Azure Data Factory (ADF) and the broad extensibility of Azure-SSIS Integration Runtime (IR). We will first show you how to provision Azure-SSIS IR – dedicated ADF servers for lifting & shifting SSIS packages – and extend it with custom/3rd party components. […]

Read more