Modern SQL Server Features That Make Life Better

Maybe your SQL Server 2005 instance is running just fine. Why mess with a good thing, right? Well, there is so much your business could be taking advantage of if a newer version of SQL Server was behind those applications. Maybe you're on a recent version of SQL Server but you're not sure what it can do. Either way, this presentation is for you.

See some great new features that can improve high availability and disaster recovery, save your developers time by writing more efficient T-SQL, or make your DBA or Data Engineer happier because performance is better, and troubleshooting is easier. Updated for SQL Server 2022.

Four Focus Points In A New DBA Role

You’re a newly minted Database Administrator. You’ve landed your first DBA role or maybe you’re the new lone DBA at a company. Either way, you’re walking into the role a bit unaware of your environment. Where do you start from a technical standpoint? What should you focus on? What tasks should have your attention?

In this presentation you will learn the four areas that you should focus on first in your new role. You will be given specific steps you should take in those four areas so that you make a good impression as a competent professional who can be trusted. Not only will this help you achieve a sense of control and order to your environment, but it will help you build relationships with your fellow employees.

First delivered to the DBAVUG Meetup, which is a virtual SQL Server Meetup based in Boston.

Introduction to PowerShell for the DBA

You’re a data professional and you’ve heard about PowerShell, but you haven’t learned it yet. Perhaps you’re uncertain about how to get started. Maybe you’re not sure why you should use PowerShell to automate your SQL Server work or are not aware of all the great things you can do with it. After all, you already know T-SQL well and can do a lot with that to manage SQL Server.

In this session, you will discover several reasons you should be automating your interactions with SQL Server via PowerShell. Then, we will dive into how to get started with PowerShell, followed by practical actions you can take with PowerShell to be immediately effective.