Writing SARGable Expressions in T‑SQL
Learn about Writing SARGable Expressions in T‑SQL to maximize SQL Server performance and efficiency with your queries.
T-SQL
Similarity Matching in SQL Server 2025
Explore similarity matching in SQL Server 2025 to manage data inconsistencies, such as spelling variations, effectively.
Using Database Instructions with GitHub Copilot
Learn about using database instructions with GitHub Copilot to enhance your SQL experience and boost query accuracy.
Dynamic Data Masking in SQL Server
Discover how Dynamic Data Masking in SQL Server protects sensitive data without complex changes and rewriting code.
Understanding SQL Server Page Types
Explore SQL Server Page Types and their roles in optimizing performance and managing data storage within your database.
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…
What is SQL?
What is SQL? What is the difference between SQL the language and SQL the server?
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.
Columns and Records
In this post, we discuss what columns and records are in a SQL table including an explanation of objects and entities.