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 Capgemini Solutions Architect discusses common customer challenges, program trends & initiatives. Prashant Bhargava
Industries ranging from government, healthcare, education, travel and finance. Capgemini’s Prashant Bhargava, shares his experience on typical customer challenges, pain points, trends and patterns. A minimum; you’ll see you’re not alone. At best; you might learn strategies for addressing common obstacles in these programs and initiatives. Join us for a thought-provoking discussion.
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.
Accelerate Release Velocity and Quality with Modern DevOps Test Data Management Practices Corey Brune
Join the session hosted by Dan Graves, Delphix CTO, to learn modern best practices for delivering on-demand, ephemeral data into application development and analytics pipelines, whilst maintaining data compliance and governance. Data is a critical enterprise asset, but leveraging it fully poses challenges due to data sprawl, regulatory requirements, and volume. Learn pragmatic approaches for automating the delivery of on-demand, compliant data in the Microsoft data ecosystem, including the Microsoft Intelligent Data Platform, to safely reduce data friction in software development and analytics programs.
The video is not available to view online.
Banishing Slow Queries with Intelligent Query Processing John Morehouse
An overview of the performance enhancing Intelligent Query Processing features in SQL Server 2019 as well as including some new SQL Server 2022 items,
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.
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.
Columnstore Index Compression in a Nutshell Edward Pollack
Improve analytic queries by unlocking the secrets of columnstore compression!
The video is not available to view online.
Data Observability with HEDDA.IO Tillmann Eitelberg
Are you able to fully understand the state of your data in your systems? Are you able to evaluate the quality of your data in all processes? In this session you will learn how easy it is to integrate HEDDA.IO into your existing processes, how it can provide you with a continuous view of the quality of your data and how it can inform you directly in the event of errors, warnings or major changes to individual parameters. HEDDA.IO brings data observability to your process and platforms.
The video is not available to view online.
Don’t Let Your Permissions Be Hijacked! Erland Sommarskog
Learn how malicious users can lure a power user such as sysadmin to run code that performs action to the benefit of the evil user by something I call permission hijacking and what means you can take to prevent this from happening.
The video is not available to view online.
Hear me out - Don't go offline because of your index deployment strategy Cláudio Silva
Want to avoid downtimes or big blocking operations when managing indexes on busy systems? In this session, we will talk about some common problems that can lead to unexpected downtimes and how we could avoid them.
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.
Knee-Deep In Tech Live @ SQL Bits Alexander Arvidsson
Be part of a live audience recording of an episode of Knee-Deep in Tech!
The video is not available to view online.
Lessons learned from refactoring multi terabyte databases for the last 10 years Sergey Olontsev
Database refactoring could be tricky sometimes. To learn more about it come to my session, where I will tell you about different situations and scenarios I've came across during the last 10 years. I will share my experience; traps, you easily can get into, and what solutions did I choose to come over it.
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.
Security is not a feature Robert Hartskeerl
You should not have to wait for a spefic feauture to be secure. A lot of the security features are not limited to the latest versions. Let's go back in time and match modern day security features in a SQL version from way back when.
The video is not available to view online.
Security techniques for cross database access Uwe Ricken
Security is given too little attention in the database environment and many times more rights are given than are necessary. Especially with CROSS DATABASE access, the goal is often overshot. Learn how to securely access data in other databases without breaking the bank.
The video is not available to view online.
<<1234567>>