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?