Dave Bland

As the industry changes, the need for Database Administrators that can support multiple database systems has increased. Of the many database systems that are available, PostgreSQL is becoming more and more popular. In this session we will cover a number of the most common DBA tasks that a SQL...

In this session you will learn how to perform a complete performance assessment on a SQL Server using SSMS and SSRS. We will complete this using a suite of over 140 SSRS reports that includes easy navigation to all report.

During this session we will cover the basics of PowerShell and how we can use it to help us do our job. We will go over the fundamentals of PowerShell including some basic commands.

Protecting the data is one of the prime responsibilities of the DBA. During this session we will cover some of the features of Azure and Azure SQL Database that will help make our data more secure.

During this session we will cover the basics of PowerShell and how we can use it to help us do our job. We will go over the fundamentals of PowerShell including some basic commands.

For many of us, audit time is not only a necessity but can also be a source of a great deal of stress. Since many of us are extremely busy, knowing how to prepare for and survive an audit is essential.

This session will provide a high level overview of Azure Data Studio and highlight some of the differences from SQL Server Management Studio. We cover saved connections, how to get both the actual and estimated Execution plans, workspaces and one of my favorite features, Notebooks.

Extended Events are an essential part of properly monitoring and every DBA should know what they are and how to use them. This session will cover the basics of Extended events as well as an introduction to the system_health session.

This session will provide a high level overview of Azure Data Studio and highlight some of the differences from SQL Server Management Studio. We cover saved connections, how to get both the actual and estimated Execution plans, workspaces and one of my favorite features, Notebooks.

Completing a full assessment on a SQL Server is essential to learning about not only the current state of the server, but also any area that may be impacting performance or security. If you have more than one DBA, it is also important to have all the DBA team members review the same areas when completing an assessment.

This is a introductory session on how a DBA and developers can use Execution plans to find performance bottlenecks. This will cover the fundamentals and cover some of the basic techniques that can be used to find hidden performance problems.

Extended Events are an essential part of properly monitoring and every DBA should know what they are and how to use them. This session will cover the basics of Extended events as well as an introduction to the system_health session.

Extended Events are an essential part of properly monitoring and every DBA should know what they are and how to use them. This session will cover the basics of Extended events as well as an introduction to the system_health session.

Extended Events are an essential part of properly monitoring and every DBA should know what they are and how to use them. This session will cover the basics of Extended events as well as an introduction to the system_health session.

As we all know, SQL Server loves memory and will use as much as it can get. However, when there is memory pressure we need to use our DBA skills to identify what is causing the pressure.

This is a 100 level sessions intended for the folks that are just starting their career as a data professional working with SQL Server. In the session we will go over the common data types and limitations associated with each of them.

This is a introductory session on how a DBA and developers can use Execution plans to find performance bottlenecks. This will cover the fundamentals and cover some of the basic techniques that can be used to find hidden performance problems.

As we all know, SQL Server loves memory and will use as much as it can get. However, when there is memory pressure we need to use our DBA skills to identify what is causing the pressure.

In this session you will learn the basics of statistics and what they are used for. You will learn how to gather information about the statistics and how to use the information to improve performance.

When looking at the options in SQL Server Management Studio, you can easily wonder what they all are. In this session we will cover how to use these options properly and what the impact might be if you change them.