1 DBA's Professional Blog
It is quite common to be required to investigate performance issues on the server. With this, it is occasionally necessary to be able to interpret an obfuscated job name. Learn how to do that in this article.
In this article, we will explore database backups. More specifically, how do you truly know if you have a successful backup? Here’s a hint: it has to deal with restores.
In this article I explore the basic of querying backup history data as a foundation to reporting on essentials such as storage and job management.
In this article I explore the basics around how to determine when a database was last restored.
Login failed. The login is from an untrusted domain and cannot be used with Windows authentication.
With the evolution of SQL Server, there is an evolution in Extended Events. New features in SQL Server also means there may be some additional default sessions.
Of all the fundamental concepts within SQL Server, this one drives me a bit batty from time to time. Think about that statement for just a moment.
Of all the fundamental concepts within SQL Server, nothing is potentially more basic and fundamental than the often overlooked Select statement.
Find yourself struggling to determine the outcome of attempted compression settings in your database? This should help!
The joys of inheriting a new database and being thrown into the fire to quickly assimilate as much information about the database as possible can be troublesome. This script will help with that!