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.
Database Backup History – Back to Basics
Tag: back to basics
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.
Login from an Untrusted Domain – Back to Basics
Login failed. The login is from an untrusted domain and cannot be used with Windows authentication.
Default Sessions – Back to Basics
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.
SQL Server CTE – Back to Basics
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.
SQL Server Select – Back to Basics
Of all the fundamental concepts within SQL Server, nothing is potentially more basic and fundamental than the often overlooked Select statement.
SQL Server Locks – Back to Basics
A fundamental component of SQL Server is locking and locks. The locking mechanism helps to control access to resources to help maintain data integrity.
SQL Server Principals – Back to Basics
A fundamental component of SQL Server is the security layer. A principle player in security in SQL Server comes via principals.
A Haunting TSQL Tuesday Tale
If you truncate a table, you cannot undo the action like you can with a delete. What is the difference between the two methods to remove data from a table?