
Lee Markum
Lead Database Administrator, SQL Server
Lake Saint Louis, Missouri, United States
Lee is a SQL Server Database Administrator who got his start with SQL Server back in 2009. Back in the day, he earned an MCTS certification on SQL Server 2008. That was followed up in 2020 with the AZ-900 Azure Fundamentals and DP-900 Microsoft Azure Data Fundamentals certifications. He now spends his time as a Lead DBA on AWS.
He has presented at SQL Server Meetups, SQL Saturdays, and was an online speaker for the RedGate PASS Data Community Summit 2022.
Lee blogs at LeeMarkum.com and he loves finding and experimenting with new features in SQL Server. High availability and disaster recovery as well as performance monitoring and troubleshooting are of special interest to Lee.
Links
Area of Expertise
Topics
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.
SQLSaturday MN 2023 Upcoming
SQL Saturday Columbus 2023

Lee Markum
Lead Database Administrator, SQL Server
Lake Saint Louis, Missouri, United States