In this new world we're all developers! Whether we're writing application code or describing our infrastructure using bicep or terraform we need to keep it safe. Git and source control is our best option for developing on our own and as part of a team… but git is scary! In this 20 min session we'll go through just enough to git you comfortable with source control.
The video is not available to view online.
Power BI Design is a lot like an art form, a mythical beast to many IT professionals. We’re generally inclined to think very analytically about our jobs, and creativity does not always come naturally. Thankfully, there are some patterns we can apply to design reports which are clean, uncluttered, and user friendly. Learn the science behind design, and a series of logical steps to follow to ensure that your reports always meet the mark.
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.
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.
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.
In this session, seasoned data engineer and youtube grumbler Simon Whiteley takes us on a journey through the current industry trends and buzzwords, carving through the hype to get at the underlying ideals.
The video is not available to view online.
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.
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.
How can we test potential weaknesses in SQL Server? In this session we will explore the concept of Chaos Engineering, its core concepts, and the methodologies behind it.
The video is not available to view online.
Improve analytic queries by unlocking the secrets of columnstore compression!
The video is not available to view online.
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.
Learn the fundamentals of how to work within Git in this 20 minute session.
The video is not available to view online.
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.
In this session we will go through a number of techniques to get closer to that natural language that Q&A visuals offer.
The video is not available to view online.
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.
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.
Can we make the complex Dungeons and Dragons character sheet accessible using Power BI and low-code solutions? Lots of demos and banter between these speakers
The video is not available to view online.
Going from an machine learning model trained on your laptop in a notebook called “trainmodelV1Final_FINAL (1).ipynb” to a system ready to deploy is difficult. However, MLOps (a set of principles to prepare your model for prime time) is here to help! This talk is an introduction to all the elements you need to get your code production-ready - CI/CD, dev/UAT/prod, pipelines, and more! We'll walk through system diagrams, with a focus on Azure, but the takeaways will all be platform agnostic. Make sure your model deployment isn’t an ML-Flop!
The video is not available to view online.
Panel Discussion moderated by Richard Campbell of RunAs Radio!
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 make you reports more intuitive, by looking at how you brain processes information in two modes
The video is not available to view online.
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.
Lean about some of the worst security practices observed in the wild and have a good laugh.
The video is not available to view online.
Tired of writing the same old Insert/Update/Delete statements over and over? Is your pipelines folder overflowing? Need to get your new data warehouse up and running as fast as possible? Metadata (data about data) comes to the rescue and in this session we’ll show you how.
The video is not available to view online.
If you care about your database performance, then make sure you take care of your statistics. Join this session to learn why it is so important, and how to do it right.
The video is not available to view online.
Customers would be able to understand what exactly Polybase is, why it's useful, what are the use cases and finally how to use this feature of SQL Server. Polybase have been around for quite some time, since SQL Server 2016, however, the awareness and the way it virtualises the data may not have been understood well for some customers.
The video is not available to view online.
In this session we’ll deep-dive into the link feature, a revolutionary new hybrid capability bridging the SQL Server and Managed Instance that provides the ultimate freedom of movement between the two. 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. You don’t even need to migrate to the cloud to use it – remain running on your existing SQL Server and use the modern Azure services by offloading R/O workloads and analytics to the cloud. When ready to migrate, use it as the best possible minimum downtime migration option in Azure. 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.
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.
In this session, we'll be looking at all the various places within the application stack that data can be encrypted or hashed, so that as an application/database administrator/developer/architect you can make the best decision as to where in the application stack to do this work.
The video is not available to view online.
In this session I'll cover what the Data Lakehouse architecture is, where it fits against existing architectures like a data warehouse, and why you should build one. We'll also cover the underlying technology options to arm you with all of the information you need to plan your next data platform.
The video is not available to view online.
Some types of data are a very bad fit for a database. Join me to see how to survive with a database full of data that should not be stored there. I will demonstrate how to deal with billions of rows of logs without trashing the database, how to store millions of pictures effectively and how to deal with dynamic attributes in a sensible way.
Tired of slow performing Power BI solutions? Sick of user complaints that their report takes forever to render? If you answered “YES” to either one of the questions above, join us for this session packed with best practices and tips to avoid secret (and non-secret) killers of the Power BI performance! No slides, no long story – it’s just YOU, Power BI, and us!
A short intro to Lambda Architectures - what they mean, what they are, and how you can use them in your solutions
The video is not available to view online.
Understand the automatic performance changes in Azure SQL and SQL Server
Azure SQL DB and SQL Server introduced ground-breaking query performance enhancements under the Intelligent Query Processing family in the past few years. These make up the latest on Microsoft’s mission to make critical parallel workloads improve when running at scale, while remaining adaptive to the constantly changing world of data! Now join us to find about what's coming next in this new intelligent database world with SQL Serevr 2022 and Azure SQL!
The video is not available to view online.
Version control provides benefits beyond DevOps automation.
Oh my goodness - the BI Power Hour is back!!
In this session, join the live audience of a session that is being live streamed from the conference! You'll receive the latest updates containing all things SQL Server and Azure SQL. This not-to-miss session will include demos, special guests, and a sneak peak at the future!
The video is not available to view online.
In this session, we will cut through the marketing buzzwords to share experiences, tips, and tricks on how to be successful with Data Science and Analytics in the real world. Tune in to hear the team share real-world experience and get takeaways from industry insiders on real projects with impact. We will also discuss the ethics and fairness of Data Science and Analytics projects and how we can be more inclusive from a technology, people, and process standpoint.
The video is not available to view online.
A session for DBAs considering where their career needs to go.
Join this session for a deep dive on secure enclaves in Always Encrypted. We will explore how the SQL Server database engine uses enclaves internally. We will dissect the end-to-end query processing workflow, so that you understand how attestation and the key release protocol work. You will learn about how to optimize the performance of your enclave queries and about the latest Always Encrypted investments in Azure SQL and other Azure data services.
"Don't force me to *think*!" - how to help people find insights in information more easily by making well-informed design decisions.
The video is not available to view online.
SQL Server 2022's latest developer enhancements from the Product Group.
How you can improve performance by splitting up large operations in chunks
The video is not available to view online.
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.
Improve the quality of your T-SQL code with the free tool ScriptDom
Being data-driven is all about making decisions based on insights generated using data.​
The video is not available to view online.
Being data-driven is all about making decisions based on insights generated using data.​
The video is not available to view online.
<<12>>