User Contains Invalid Characters – Back to Basics

While creating database users, it is possible to encounter an invalid character error message. This article will help clarify the error message.

What Agent Job is Running – Back to Basics

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.

Database Backups – Back to Basics

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.

Database Backup History – Back to Basics

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.

Last Restore of a Database – Back to Basics

In this article I explore the basics around how to determine when a database was last restored.