Webinar Library

There isn’t a magical solution to the challenges that DBAs face on a daily basis. Instead, you need to become proficient in the use of a number of different tools to achieve your aims.  The panel will discuss tools of the past, their favorite new tools, and overall, why you need database monitoring tools.

In this webinar, we’ll take you through the important server settings and configuration options, show you which to change and which to ensure are not changed, and share a toolkit of T-SQL scripts to automate the process.

It’s no secret that SentryOne was recently acquired by SolarWinds. What you probably don’t know is how many people and how much effort went into migrating our ticketing system in the SentryOne Salesforce tenant to the SolarWinds Salesforce tenant.

Modern database administrators have many responsibilities, including perhaps their most important responsibility of performance tuning. Performance tuning takes many forms. It might include tuning server settings, improving database designs, or even extensively tuning queries and query code.

Do you suspect that SQL Server tempdb is dragging down your database performance? You're probably right. Tempdb, a system database in Microsoft SQL Server that stores data used in various active processing routines, can be a notorious performance killer if not monitored and managed properly. For one thing, tempdb is a single point of contention for an instance. What’s worse is that there are a lot of activities going on in tempdb that you might not be aware of.

In this webinar, we'll help you determine whether tempdb is affecting SQL Server performance so you can fix the problem. We'll look at operations that happen in tempdb, examples of performance-hampering implicit activities in tempdb, and little-known performance optimization techniques.

Concurrency control, aka locking and blocking, is one of the central tenets of the ACID properties of transactions in a relational database. And yet, when done poorly, locking issues can slow down or bring any database application to a standstill. In part 5 of this webinar series, Kevin and Torsten take you through a variety of demos to teach you all of the ins and outs about locking, blocking, and transactions in SQL Server and Azure SQL.

Concurrency control, aka locking and blocking, is one of the central tenets of the ACID properties of transactions in a relational database. And yet, when done poorly, locking issues can slow down or bring any database application to a standstill. This webinar takes you through a variety of demos to teach you all of the ins and outs about locking, blocking, and transactions in SQL Server and Azure SQL.

Maybe you are an accidental DBA who has recently been assigned responsibility for the SQL Server, on-premises or in the cloud. Maybe you are a generalist who can keep the SQL Server up and running, but don’t know much about how it works. Or maybe you are just starting in your career and want to learn more. Whatever situation applies to you, there are a handful of very important lessons you will have to learn if you administrate a SQL Server. Whether you learn them the easy way, by study or by attending this session, or the hard way, by experiencing these problems first hand, is your choice. 

In the session, noted industry experts Denny Cherry and Kevin Kline will take you through five surprising situations where what you don’t know WILL hurt you. But if you learn these in advance so you are not surprised by them, you will be in control when they eventually occur.