Sessions & Content

Search
Content Type
Conference
Tags
A Practical Starter Guide to SQL Notebooks Deborah Melkin
Have you been hearing about SQL Notebooks in Azure Data Studio but haven't worked with them yet? Or have you played around with notebooks but not been able to figure out how to make them work for you? Let's jump into SQL Notebooks together as we figure out how we can use them in our day-to-day work!
The video is not available to view online.
Applying effective Source Control to your Database System Karim Ourtani
How can you everage SSDT in order to deploy DB changes as part of your CI/CD pipeline
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.
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.
Beware of nondeterministic T-SQL code Itzik Ben-Gan
Nondeterministic calculations are calculations that when invoked repeatedly, return different results given the same inputs. Most T-SQL developers understand what nondeterministic calculations are, but many aren’t aware of the possible implications of using nondeterministic code. This session will show you the many surprising aspects of using nondeterministic code and will provide best practices that will help you avoid getting into trouble.
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 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.
Chaos Engineering for SQL Server Andrew Pruski
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.
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.
Dave & James’ Excellent Database Adventure: From Code Errors to Reliable Releases David Ong
Join Redgate’s David Ong and James Hemson for a whistlestop adventure through time. You’ll travel to the past to discover the origins of code errors. Then return to 2023 to learn how to avoid them and set yourself up for a future of fast and reliable database changes.
The video is not available to view online.
Efficiency up, failed releases down; compliant production data for your test and dev environments Chris Hawkins
In this session, we’ll tackle the challenges that come with getting yours hands on quality data for test, QA, and CI practices.
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.
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.
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.
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.
Query Store Best Practices Erin Stellato
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.
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.
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.
<<12345678>>