Understanding SQL Server Page Types
Explore SQL Server Page Types and their roles in optimizing performance and managing data storage within your database.
SQL Server
A Deep Dive into Non‑Clustered Indexes
Unlock performance with non-clustered indexes in SQL Server and learn best practices for effective query optimization.
Creating Indexes that Cover a Query
Explore the importance of indexes that cover a query and how they can improve SQL Server performance and eliminate lookups.
Multi‑Column Indexing in SQL Server
Unlock the power of Multi‑Column Indexing in SQL Server to optimize performance and reduce expensive query costs.
Writing SARGable Expressions in T‑SQL
Learn about Writing SARGable Expressions in T‑SQL to maximize SQL Server performance and efficiency with your queries.
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…
What is SQL?
What is SQL? What is the difference between SQL the language and SQL the server?
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 Numbers
How to use the WHERE statement to filter records when the value is a number or integer data type in a T-SQL statement.