What are Transactions?
Understand Transactions in SQL Server and their role in maintaining data integrity and enforcing the ACID properties.
SQL Server
Restore and Recovery
The restoration process of a SQL Server database passes through two phases: Restore and Recovery.
Writing T-SQL Queries
In late 2018, I recorded a series of videos for APRESS publishing on how to write T-SQL Queries. (I have linked to the O’Reilly website below.) There are four titles in the series with each title about 45 minutes in length. The first is how to write a T-SQL SELECT…
SQL Statement Categories
There are four main categories of statements used when writing T-SQL. What are the differences between each of these categories?
Writing a SELECT statement
What are the basics in writing a T-SQL SELECT? How to return columns and records from a table in SQL Server.
Filtering Records by Dates and Times
How to use the WHERE statement to filter records when the value is either a Date or a Time in a T-SQL statement.
Sort Records using ORDER BY
How to use the ORDER BY statement to sort records in a T-SQL statement in both ascending and descending order.
Table Constraints
Restricting data by using Table Constraints in SQL Server. What are the different table constraints in SQL Server?
Tables and Relationships
Understanding the difference between Parent Tables and Child Tables and the difference between Primary Keys vs Foreign Keys.
Integer Data Types
Explore the integer data type: learn how TINY, SMALL, REGULAR, and BIG INTEGER types can optimize data efficiency.