SQLBits 2024

Unlocking Database Automation with dbatools: Practical Use Cases and Real-World Insights

This session focuses on how dbatools has revolutionized automation for Database Administrators (DBAs) in the SQL Server realm. It delves into the utilization of various dbatools cmdlets and practical applications. Participants will gain insights into performing migrations, setting up availability groups, data management within databases, and the backup and restoration of databases. These techniques are derived from real-world client scenarios encountered during the presenter's consulting practice.

dbatools changed the landscape of automation for DBAs, bringing automation to the SQL Server world. In this session, you will learn how to use some of my favorite dbatools cmdlets and use cases. We'll look at how to perform migrations, build availability groups, manage data in databases, and backup and restore databases. The techniques you will learn in this session is based on experiences from real-world customer scenarios from my consulting practice.

Learning Objectives
Instance and database migrations
Building and configuring SQL Server instances
Advanced data management in databases
Backing up and restoring databases

Anthony Nocentino's previous sessions

Unlocking Database Automation with dbatools: Practical Use Cases and Real-World Insights

This session focuses on how dbatools has revolutionized automation for Database Administrators (DBAs) in the SQL Server realm. It delves into the utilization of various dbatools cmdlets and practical applications. Participants will gain insights into performing migrations, setting up availability groups, data management within databases, and the backup and restoration of databases. These techniques are derived from real-world client scenarios encountered during the presenter's consulting practice.

Architecting for High Performance SQL Server on Virtual Machines

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.

Why is understanding Kubernetes important for your career as a Data Professional?

A panel discussion on why both - admins and developers - should understand the impacts and benefits of containerized applications.

Let's Talk Storage!

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.

The Cloud Never Goes Down, Right?

In this session, we'll set you on the right path towards high availability and disaster recovery for common data architectures in the cloud by the end of this session.

Deploying SQL Server in Kubernetes

Are you thinking about running SQL Server in Kubernetes and don’t know where to start…are you wondering what you really need to know? Then this is the session for you.

Practical Container Scenarios in Azure

You’ve heard the buzz about containers and Kubernetes, now let’s start your journey towards rapidly deploying and scaling your container-based applications in Azure

Container questions that Andrew and Anthony DM each other

A Q&A panel session with Andrew Pruski and Anthony Nocentino talking about all things containers! Hosted by Rob Sewell