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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
In this demo-rich session you will learn how you can implement a framework for data quality validation and monitoring, spanning your end-to-end data platform including Power BI!
The video is not available to view online.
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.
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.
Want to use Query Store and not sure how to make sure everything is "correct"? Tried Query Store and had issues? In this session we'll cover what you MUST know to successfully use Query Store in a production environment.
The video is not available to view online.
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.
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.
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.
In just 20 minutes you will see a demo of bidirectional database failover between SQL Server 2022 and Managed Instance, using the link feature. The feature provides never-before possible hybrid connectivity and near real-time database replication between SQL Servers 2016-2022 and Managed Instance, including industry’s first bidirectional data movement and online failover (Disaster Recovery) between SQL Server 2022 and SQL Managed Instance Need to move back from Azure to SQL Server on-premises, or anywhere else? No problem, use it all in reverse and replicate your online and near real-time from Managed Instance back to SQL Server 2022.
The video is not available to view online.
ADF Tips and Tricks which help you to speed up your Azure Data Integration solution,save operational cost and improve performance.
The video is not available to view online.
In this demo filled session, learn how to view lineage data from Databricks Unity Catalog in Microsoft Purview.
The video is not available to view online.
Discover better ways to monitor SQL Server activity with WhoIsActive
The video is not available to view online.
This session will explain why you should care and know about the checkpoint process and the different checkpoints that SQL Server does. I will show you exactly what happens during a checkpoint, how you can influence the interval of checkpoints, and changes made with checkpoint settings in SQL 2014 and SQL 2016+.
The video is not available to view online.
Join me on a journey through the different offerings in Azure Arc and how they can benefit you as a data professional!
Are you planning a migrating of your data platform to Azure Synapse Analytics? Is it currently based on Azure Databricks, Azure Data Factory, and Azure Data Lake Storage? Make sure to grab these 10 tips! We'll talk about Spark compatibilities, orchestration pitfalls and solution deployment differences.
SQL bits and London Power BI user group are brining a Q&A panel with some of Power BI CAT team members to ask everything about Power BI. Join us with your questions
The video is not available to view online.
In this 100% demo session, I will show you kql magic, kql kernel, and the recently released Azure Monitor Logs extension for Azure Data Studio to consume event logs of the Azure SQL database.
Using open source apache nifi to integrate and ingest data at scale
I will show you demos for how to implement each layer of defense. This way, if one layer is breached, you aren’t left defenseless. We will start at the outer layer with network access. Next, we will cover the authentication and authorization using Azure RBAC. Finally, we will protect the innermost layer with Data At Rest and Data In Transit encryption. Once these protections are in place, we’ll see how to monitor Azure SQL security ecosystem for intrusions with Advanced threat protection.
This session will walk you through three different ways to set up an affordable Azure based Data Warehouse solution. Covering pros and cons with each of the architectures.
Join us, as we explore the capabilities of Azure Arc-enabled SQL Managed Instances.
This session will introduce you to "What and why you should care about", and discuss "how" to apply the Security and Privacy lens for Big Data on AWS.
A short, fast dive into the specific elements of Azure Purview that work well with Data Lakes, and how you implement them yourselves
How to build a data platform in Azure
The video is not available to view online.
We'll explore delivering this framework within an enterprise and consider an architect’s perspective on a wider platform of ingestion/transformation workloads with multiple batches and execution stages.
DBA/Developer Toolset to get you out of that hole and save you some time
Azure SQL performance capabilities, how to configure and maintain your Azure SQL for higher performance. We will explore various monitoring tools and pick few scenarios for deeper troubleshooting. In this demo centric session, we will tune our database and find an optimal ground to manage cost. We will generate Power BI powered database score card for trend analysis.
Automate checking your database security model
Join us for the session where we discuss the best approaches to database monitoring including how organizations can better collaborate to isolate issues & optimize experiences by centralizing and correlating metrics across your entire database stack.
The video is not available to view online.
Two consultants, two different companies, two data professionals passionate about performance tuning. Do we like the same things? Do we have the same approach to problems? Topics will include: Trace Flags, DMVs, DBCC commands, Community Scripts and Intelligent Query Processing Features. We will talk about the features and solutions we agree on, and discuss where we disagree.
Auditing options for Azure SQL offerings
In this lightning talk I'll demonstrate how to apply the R implementation of Benford's law (which actually is not about crime or fraud) to identify possibly fraudulent invoice or other data.
The video is not available to view online.
SolarWinds Orion - Monitoring Beyond The Database
The video is not available to view online.
The video is not available to view online.
In this session, you will learn where data lives in a computer system, and the key performance metrics used to understand the health and performance of your storage subsystem.
Dynamic SQL is great, until it is used to hack your site. In this session we demonstrate how using the T-SQL "Execute AS" command can limit what can be run using dynamic SQL.
Meet SQL Server audit and compliance requirements for all instances across your enterprise with an easy centralized user interface.
The video is not available to view online.
Meet SQL Server audit and compliance requirements for all instances across your enterprise with an easy centralized user interface.
The video is not available to view online.
Join us for this discussion as we delve into the best approaches to monitoring complex SQL Server estates and lessons learned along the way.
The video is not available to view online.
SolarWinds DB Management - An Overview
The video is not available to view online.
Curious what Azure Synapse Analytics brings to the table? Bring your scuba gear, as we take a dive and explore everything it has to offer!
<<123>>