SQL Code

New Writing SQL Video Series

I am officially an author for Apress Publishing. My first video series was released today on writing a T-SQL SELECT statement. This is the first…


Restore vs Recovery

It is time for T-SQL Tuesday #85 and this month the party is being hosted by Kenneth Fisher from SQL Studies.This month’s topic is Backup and Restore and…


XML on SQL Tutorial

Here is a short 13 minute tutorial I put together on how to use XML within SQL Server. While I made this for the Born…


What are Locks?

When Transactions are processed they must pass the ACID test. The isolation part of the process is handled by Locks which ensure that Transactions do…


Transactions and Errors

In a previous post we discussed how to work with batches where we created a table named Accounting.BankAccounts and inserted two records. When the two records…


What are Transactions?

Transactions are used to ensure that a series of statements written to modify data pass the ACID test that enforces the data integrity, accuracy, concurrency,…


Working with Batches

In this demonstration we are going to look at working with batches. To begin our example we will need to run both the CREATE SCHEMA…


Working with Schemas

In a previous post we discussed the four part name of a SQL Server object in 2005 and later that included the SCHEMA as part of…


SQL Four Part Names

As part of the T-SQL naming convention in SQL Server every object (Table, View, etc…) has a four part name used to reference that object….