Sessions & Content

Search
Content Type
Conference
Tags
7 Things I wish I'd known before building a 60Tb DWH on a Dedicated Pool Steve Powell
Lots of ADF, lots of data, lots of automation and lots of lessons learned. Backups aren't as useful as they look, dedicated pools have several "interesting" features in the small print, ADF is not always your friend and how to mitigate the sometimes deadly embrace of throughput vs concurrency trade off.
The video is not available to view online.
A DBA's Guide to the Proper Handling of Corruption Brandon Leach
Corruption can strike at any time. As DBAs how we alert, investigate, and respond can have a profound impact on our company. In this session we will learn how to detect and respond to corruption when it strikes.
The video is not available to view online.
A to Z Azure SQL Security Concepts Deepthi Goguri
Planning to move your databases to the cloud but seriously doubt if your data is 100% secure? No matter if you are on-prem or in the cloud, making sure your data is protected in every angle possible is the most crucial and important step in building a secure data tier of an application. Let's dedicate this session to knowing the different multi-layer defense-in-depth security techniques and strategies available to armor your Azure SQL database. let's dive deep into each of these layers starting with the network security, Azure role-based access control (RBAC), data security at the row level, auditing, advanced threat protection, different layers of encryption, monitoring, and more. By the end of this session, you will have the knowledge to make the right security decisions for your environments and implement these techniques in securing your data. 
The video is not available to view online.
Advanced Power BI refresh with ADF/Synapse Mathias Halkjaer
After this session, you will be able to conceptualize and implement different Power BI refresh scheduling patterns in ADF/Synapse. You’ll learn what limitations in Power BI you can overcome with an “external” orchestration tool as well as the different building blocks available. Finally, we will go through an example implementation as well as a step-by-step demo of how you can set this up yourself.
The video is not available to view online.
ADX and the last crusade Frank Geisler
Introductory session to Azure Data Explorer that shows some examples how to set up ADX and how to use it.
The video is not available to view online.
Architecting for High Performance SQL Server on Virtual Machines Anthony Nocentino
Misconfigurations and default settings in your virtual machine base SQL Server environment can be causing you the performance issues you are having. Learn what you need to build to design and build a high performance virtual machine environment for your SQL Server.
The video is not available to view online.
AutomatedLab 101 in 1200 seconds or less Mikey Bronowski
Introduction to AutomatedLab PowerShell module that enables you to set up test and lab environments on Hyper-v or Azure in seconds.
The video is not available to view online.
Azure Arc in 50 Minutes Ben Weissman (he/him)
Join me on a journey to understand what Azure Arc is and how it allows you to manage your hybrid and multi-cloud estates.
The video is not available to view online.
Azure Cosmos DB Serverless Unleashed Mihail Mateev
Cosmos DB Serverless in a Nutshell
The video is not available to view online.
Azure Data Factory, Azure Databricks, or Azure Synapse Analytics? When to use what. Lisa Hoving
Have you ever found yourself at the start of an Azure data engineering project, unsure about what tool to choose? Speak no more! In this session we will discuss three often used data engineering tools on Azure: - Azure Data Factory - Azure Databricks - Azure Synapse Analytics
The video is not available to view online.
Azure SQL MI End-to-end Demo Party for DBAs and Devs Dr. Dani Ljepava
Join us for a pure, demo-driven journey of a dozen incredible features for Azure SQL Managed Instance showing you the greatest and latest innovations enabling Database Administrators and Developers to achieve more. Whether you’re a DBA, Azure Administrator, Developer, Business Intelligence developer, or of course any other data professional, these demos will show how you can achieve more with the exciting features that are available to you. Some of the topics we will cover are hybrid scenarios, performance and scale, application compatibility, workload modernization, compliance, data mobility/migration & business continuity/disaster recovery - and several more - in this fast-paced, demo-only session.
The video is not available to view online.
Azure Stack HCI and Microsoft Hybrid Data Services Robert Sonders
Join Dell and AMD and see how a Dell Integrated System for Microsoft Azure Stack HCI running 3rd generation AMD Milan-X processors can simplify your deployment and operations for running SQL Server 2022. In this session we will demonstrate its ease of use and flexibility as a DBaaS platform for addressing your database management challenges. As an all-in-one validated HCI system that includes full-stack life cycle management, native integration into Azure, and support Azure Arc on-demand services, it enables organizations to create modern cloud-native applications that deliver exceptional customer value. We will be sharing reference architecture details and performance testing results.
The video is not available to view online.
Azure Synapse Link for Dataverse Implementation Aoife Turley
The aim of this session is to highlight the process of implementing Azure Synapse Link for Dataverse and to discuss the reality of working with the data as it is incrementally updated in Azure.
The video is not available to view online.
Break five common myths about SQL Server backup Taiob Ali
In this session, I will discuss five common myths about SQL Server backup and demo each to show you the correct answer.
The video is not available to view online.
Building an Azure Data Analytics Platform End-to-End Paul Andrew
Based on real world experience let’s think about just how far the breadth of our knowledge now needs to reach when starting from nothing and building a complete Microsoft Azure Data Analytics solution.
The video is not available to view online.
Building an Open Data Lakehouse using Apache Spark, Apache Iceberg and Dremio Mike Flower
In this session, we will discuss the evolution of the big data landscape, to the data lakehouse concept. We will focus on how an Open Data Lakehouses are developed, and how to secure, govern and augment using Dremio.
The video is not available to view online.
Building trust in your data. Why data governance is the key to success. Johan Ludvig Brattås
Join us to learn why data governance is increasing in popularity and what you need to know about what data governance really is.
The video is not available to view online.
Business Continuity for Hybrid and Cloud Native SQL Server Deployments Allan Hirt
With more and more deployments of SQL Server becoming hybrid or cloud native, how do you need to think about availability? This session will give you the foundation on how to approach availability in the new world.
The video is not available to view online.
Crossing The Streams: Adding PostgreSQL to Your SQL Server Skillset Grant Fitchey
It used to be easy to ignore, but times have changed. More and more we are required to manage multiple data platforms. As this information became more apparent, Redgate started down the journey to add additional RDBMS platform support to its amazing toolset. Join Grant Fritchey as he relates both Redgate's and his own personal journey of discovery on how to use the PostgreSQL system. Learn why it's important that you develop knowledge and skills. Discover some of the mechanisms that made this journey easier. Finally, find some ways to overcome the challenges you're likely to meet. It's a multi-platform world out there, this session will help you cope with it.
The video is not available to view online.
Data Modernization in a Hybrid World Robert Sonders
Join Dell for an overview of the data journey, moving from consolidation on modern architectures, to Linux, to containers, to true native hybrid cloud for all your data “things”. We’ll touch on the realities that we see with all customers and Dell partners to further your journey with a holistic model approach.
The video is not available to view online.
DataOps 101 – A Better Way to Develop and Deliver Data Analytics John Kerski
Power BI has revolutionized the industry by accelerating our ability to deliver Data Analytics solutions. But how do we ensure the code we build is reliable and the data is produced in a timely and trustworthy manner? Enter DataOps, a better way to develop and deliver Data Analytics Solutions. In this session, I’ll cover the concept of DataOps, why it matters to Power BI, and the principles that can drive you to continuously improve.
The video is not available to view online.
Declarative ETL pipelines with Delta Live Tables Vuong Nguyen
Modern software engineering and management for ETL, so data analysts and engineers can spend less time on tooling and focus on getting value from data.
The video is not available to view online.
Dell and Azure Arc-enabled data services - SQL MI Business Critical Robert Sonders
Are you developing or expanding your data services estate and need insights on how to plan, deploy and service hybrid data solutions? Come hear from technical experts from Dell Technologies on how to meet the most demanding mission critical requirements for your business with fully-automated and consistent data solutions built around Azure Arc–enabled data services. Attendees will hear real world approaches to ensuring that solutions are successfully deployed, perf and business continuity exceed business expectations, optimize IT resources, and simplify Dev/Ops with predictability.
The video is not available to view online.
Extended Governance of Power BI with Microsoft Purview Oliver Engels
Extend your Power BI governance functionality with Microsoft Purview. This session will show you how, what's in it for your PBI Landscape in terms of data catalog, -map and -lineage, data loss prevention, life cycles management and information protection. You will see live demos, watch outs and implementation best practises.
The video is not available to view online.
FinOps, how data engineers get their cloud cost under control André Kamman
Managing cloud cost is no longer a "management approves the budget" type of thing. Cloud Engineers need to architecht their solutions in such a way that cost can be kept under control. This is not a one time thing. Monitoring, automatic downsizing, re-factoring are all parts of the yearly tasks of any cloud team. We'll discuss theory, techniques, best practices and lessons learned.
The video is not available to view online.
Go With The (data)Flow Maria Gabriel
What are Power BI Dataflows? Who is affected? Who benefits? Where is this taking place? When does it make sense? Why is this important in the big picture? How to do it? Attend this session for an overview of Power BI Dataflows and to understand how this piece fits into a Business Intelligence architecture. Some use cases will be presented, and we will let the data flow!
The video is not available to view online.
How Do I Reduce My Cloud Bill? Joey D'Antoni
Learn some of the root causes of high cloud bills and what you can do to solve them.
The video is not available to view online.
How to Architect your Data Platform for Success Ben Jarvis
In this session we will look to understand the components and patterns that are required to set your data platform up for success when defining a high-level architecture. At a high-level we will cover areas from ingestion through to transformation and serving and look to identify the key components and architectural considerations required at each stage. During the session we’ll cover areas from security to error handling and metadata-driven execution to give you an understanding of the basics required to put a successful data platform solution together. This session is suitable for anybody that has a basic understanding of the components in the Azure data stack who wants to understand how to put them together to build a best-practice solution.
The video is not available to view online.
How To Get the Auditors Off Your Butt with dbachecks Tracy Boggiano
Auditors are not fun to deal with and proving your systems meet requirements is a PITA. Come to this session to learn how to leverage dbachecks to check your SQL Servers for security compliance.
The video is not available to view online.
Identifying and Preventing Unauthorized Power BI Gateways Angela Henry
If you need to easily identify all your on-premises data gateways or prevent gateways from being installed in your Power BI tenant, then you don't want to miss this quick tip session.
The video is not available to view online.
Integrate Data Quality into your processes Tillmann Eitelberg
HEDDA.IO is a central data quality management solution that connects departments, data stewards and data engineers. It helps to easily integrate standardization, cleansing, matching and enrichment tasks into existing processes.
The video is not available to view online.
Keeping historical data in tables forever – mission (im)possible! Margarita Naumova
Let’s discover some solutions for keeping historical data in the database when you receive near to impossible requirements like storing data in same tables forever and being able to edit and query them at the same time, of course keeping the response at its best. Based on a real project case the session walks you through the design process from the start to the reaching of the final solution and making the client (and developers) happy.
The video is not available to view online.
Lift and Shift with dbatools - Azure SQL Managed Instance edition Cláudio Silva
Migrating from On-Prem SQL Server to Azure SQL Managed Instance requires a set of pre-requirements that can become much easier if we can validate and repeat the steps needed. No matter if it's an Offline or Online migration, dbatools can make your life easier.
The video is not available to view online.
Managed Instance Link - Seamless migration to Azure Manish Kumar
We, the cloud solutions architects from Microsoft, will be talking around SQL migration journey from on-prem to Azure SQL in general, taking you through all available Microsoft's migration tools like DMA, DMS, Azure Migrate, ADS, etc, and then focus on migration to Managed Instance using SQL MI Link. You should take away with you the understanding of when to use which tool and how the newly available Azure SQL Managed Instance Link can help you to achieve a minimum downtime migration of on-prem SQL Server to Azure SQL Managed Instance.
The video is not available to view online.
Managing access to data sources in your data estate with Microsoft Purview Erwin de Kreuk
One of the new applications within Microsoft Purview Governance Portal are Access Policies. Access policies in Microsoft Purview allow you to manage access to different data systems across your entire data estate. The big advantage of these policies is that you do not have to apply RBAC roles and you have an overview of all applied policies. Are you a data consumer? Then the self-service access policy is an easy way to request access to data while browsing or searching for data. Are you a data producer? Then access policies helps you to easily create and publish access to data sources In this session, I will explain and show you how to create and publish policies and how to set up a self-service access workflow.
The video is not available to view online.
Microsoft Defender for SQL: Advanced Threat Protection Rie Merritt
Microsoft Defender for SQL is part of the Azure Defender family and it protects SQL Server in two main ways. We'll cover the first way, Advanced Threat Protection. This is a feature with advanced security capabilities that detect anomalous activities that might access or exploit sql server, like SQL Injection.
The video is not available to view online.
Migrating data solutions to the cloud - a checklist. Kristina Mishra
So you’re the data person in your company and you need to look to the sky. Maybe you've been wanting to do it for a while, maybe it's a mandate coming from the top. What are the steps you need to think about? Where do you even start? What are the risks? How can you begin to wrap your head around all the different things you have to coordinate? Companies don't just need the IDEA that they should move to cloud, but a guide on how-to-do it. This session will not only give you that guide to get you going, but a foundation to take to your bosses to show just how awesome you really are.
The video is not available to view online.
Performance Tuning Azure SQL Database Monica Rathbun
Have you moved to a cloud database like Azure SQL Database and are having performance issues? While the Azure SQL services running in Azure are similar to SQL Server, they are key differences in performance tuning methodologies. In this session, you will learn about monitoring options, changes in cloud DMVs, and additional cloud tuning tools like Azure SQL Analytics and Performance Insights that can allow you quickly get to performance data across a number of instances. You will learn about what you need to keep in mind when choosing between scaling-out to readable secondaries and scaling-up to higher tier solutions. Discuss with Microsoft MVP Monica Rathbun the challenges and benefits of tuning, what to keep in mind, and what to expect in the cloud.
The video is not available to view online.
Power BI Governance quick start Ásgeir Gunnarsson
For many the mention of governance gives them images of massive effort and inconvenience for themselves and end-users. It´s a hindrance and waste of time. But it doesn´t have to be that way. In this session we will talk about how we can start to tackle Power BI governance. We will look at few things you can get started with very quickly that will get you far in setting up your governance strategy. We will look at things such as documentation, roles and monitoring. The hope is that you go back to your organization with a clear picture of where to start and a better feeling on governance.
The video is not available to view online.
Power BI governance, disaster recovery and auditing Alex Whittles
As your Power BI usage grows you need to think carefully about how to plan and manage your tenant so you don't lose control of it and end up in Power BI Hell. Including security, planning, auditing, advanced data lineage and more.
The video is not available to view online.
Securing Cosmos DB: Ready for Production! Heini Ilmarinen
Getting started with Cosmos DB is super easy and you get the scalability and global reach out of the box. For production scenarios we often have additional requirements for security, that could span from restricting public endpoints to auditing user actions on data. In this session, we will go through the different security capabilities available for Cosmos DB, focusing deeper on networking and access control. We will cover how to control networking and use private endpoints with Cosmos DB, as well as how the global nature of the service makes these different from the rest of the services in Azure. We will also explore the different options for access control on the data in Cosmos DB and particularly how the newest addition to the mix, Cosmos DB RBAC, can help keep your data secure.
The video is not available to view online.
Should We Defragment Indexes? Rob Mandeville
You may want to stop or limit defragmenting your indexes when you encounter external fragmentation because it may be causing performance degradation. Join us as we take a deeper look at modern disk architecture and what's actually happening with I/O.
The video is not available to view online.
SQL 2022 and S3 – Dell’s overview of consuming object data via Microsoft SQL Robert Sonders
Join Dell for an overview of the architecture, components, and deployment steps for the SQL Server 2022 S3 Data Analytics validated solution on Dell’s hardware stack. This solution demonstrates data virtualization by connecting SQL Server instances to external object storage using S3 protocol, enhancing data protection by backing up and restoring from Dell ECS object storage, and exploring newly introduced T-SQL functions for better analysis of data.
The video is not available to view online.
SQL Server 2022 – Time to Rethink your Backup and Recovery Strategy Robert Sonders
Join Dell for an overview of new capabilities with SQL 2022 and storage backup and recovery. At Dell Technologies we have known the power of storage snapshots for over a decade. Storage snapshots are a fundamental feature in Dell PowerStore and the rest of the Dell storage portfolio. They are a powerful feature that allows point-in-time volume copies to be created and recovered in seconds or less, regardless of size. For SQL 2022, one of the most exciting is the Transact-SQL snapshot backup feature. This is a gem that can transform your backup and recovery strategy and turbocharge your database recoveries!
The video is not available to view online.
SQL Server 2022 migrations with dbatools Jess Pomfret
Using dbatools we'll migrate our databases to a shiny new SQL Server 2022 instance.
The video is not available to view online.
Supercharge Power BI with Azure Synapse Analytics Mathias Halkjaer
In this session we will cover how to architect an end-to-end enterpise analytics platform so that we utilize the best of both worlds. The extremely versatile ETL capabilities of Synapse and the powerful data modelling in Power BI.
The video is not available to view online.
Synapse Link to SQL, bring your on-prem data alive José Barbosa
How to provision, use, and monitor Synapse Link to SQL in order to bring on-premises SQL instances data into Azure Synapse Analytics
The video is not available to view online.
Synapse Q&A with PG Mark Pryce-Maher
SQLBits' has brought members of the Azure Synapse Program Group to Wales to ask YOUR questions. Bring your questions for: Dedicated SQL Pools, Serverless SQL Pools, Spark Pools, Pipelines, Kusto and everything else Synapse related.
The video is not available to view online.
Take Control of your Azure SQL Managed Instance Migration using the Log Replay Service Rob Carrol
Join me in this session to explore the Log Replay Service. Learn how to use it to take control and customise your own migration projects to solve some of the challenges of migrating large databases to Azure SQL managed instance.
The video is not available to view online.
The accidental administrator's guide Power BI Michael Johnson
If not properly planned and managed, your Power BI environment quickly becomes a mess., making it hard to use and improve. Join this session where we will look at 6 key areas that you as a Power BI administrator will need to look at.
The video is not available to view online.
<<12345>>