There is more to being a Junior DBA than knowing SQL.  The DBA works at the intersection of the database, server, operations

Read More
Ten Things a Junior DBA Should Learn

What is a Database Trigger? A SQL trigger is special stored procedure that is run when specific actions occur within a database. 

Read More
What is a SQL Trigger?

Both TOP and OFFSET & FETCH can be used to limit the number of rows returned.  OFFSET and FETCH can return similar

Read More
What is the Difference between TOP and OFFSET & Fetch?

Its is easy to get confused between inner join vs outer join clauses. Both inner and outer joins are used to combine

Read More
Inner Join vs Outer Join Clauses

Primary Key vs Unique Key. It really not about one or the other. You actually may need both a primary key and

Read More
Primary Key vs Unique Key – Data Modeling Tips

A reader recently asked me to help them solve a problem combining data from multiple tables into a single result.  What was

Read More
Is it possible to use Joins, Subqueries, and Unions on Multiple Tables?

Use joins and UNIONS to combine data from two or more tables.  Read this article to find out each command’s strengths and

Read More
What Is the Difference Between a Join and a UNION?

In SQL Server there are a couple a ways you can delete rows from a table.   You can use the TRUNCATE and DELETE

Read More
What is the Difference between TRUNCATE and DELETE?

Table of contentsWhat are the ACID Database Properties?What’s an Example of ACID Properties? What are the ACID Database Properties? The ACID properties

Read More
SQL ACID Database Properties Explained

When modifying one table based on the contents of another it may be tempting to simply use the merge statement, but before

Read More
What is the Difference Between Merge and Update?

I’m commonly asked whether whether I can have a CASE Statement in the WHERE Clause. There are a number of examples using

Read More
Can I have a CASE Statement in the WHERE Clause?

This article is inspired by a series of questions that one of my readers, Nan, recently sent me regarding SQL DISTINCT, TOP,

Read More
SQL DISTINCT and TOP in Same Query

Sort Alphanumeric Values with SQL Server Recently a reader asked me how to sort an alpha numeric field in SQL in natural

Read More
Use SQL Server to Sort Alphanumeric Values

What is a Null Value? In databases a common issue is what value or placeholder do you use to represent a missing

Read More
What is a Database NULL Value?

A database index allows a query to efficiently retrieve data from a database.  Indexes are related to specific tables and consist of

Read More
Database Indexes Explained

A relational database is made up of several components, of which the table is most significant.  The database table is where all

Read More
What is a Database Table?

The main objective of a database management system is to store, retrieve, and process data.  In order to do this in a

Read More
Database Management System Main Parts

A SQL database is used to store and retrieve data.  The database is housed in a database server and largely controlled by

Read More
What are the Major Part of a SQL DB?