Speaker

Lee Markum

Lee Markum

Cloud Database Administrator

Lake Saint Louis, Missouri, United States

Lee is a SQL Server Database Administrator who got his start with SQL Server back in 2009. He earned an MCTS certification on SQL Server 2008 and recently passed the AZ-900 Azure Fundamentals and DP-900 Microsoft Azure Data Fundamentals certifications.

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. He is also a co-organizer of the Saint Charles SQL Server Meetup Group.

Area of Expertise

  • Information & Communications Technology

Topics

  • SQL Server DBA
  • Database Administration
  • Database Performance
  • Microsoft SQL Server
  • Availability Groups
  • Temporal Tables
  • SQL Server Indexes
  • PowerShell
  • DBATools
  • Query Store
  • Query Performance
  • relational databases

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, keep your data safer, or make your DBA or Data Engineer happier because performance is better, and troubleshooting is easier.

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.

Lee Markum

Cloud Database Administrator

Lake Saint Louis, Missouri, United States