Microsoft recently announced updates and fixes for SSMS 22.3. While the release included many quality-of-life fixes, it also introduced a deceptively powerful addition called Database Instructions. This feature stood out to me as it can fundamentally changes how GitHub Copilot understands your database, not just its schema, but its meaning….
Explore SQL Server Page Types and their roles in optimizing performance and managing data storage within your database.
Learn about Writing SARGable Expressions in T‑SQL to maximize SQL Server performance and efficiency with your 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 the difference between SQL the language and SQL the server?
There are four main categories of statements used when writing T-SQL. What are the differences between each of these categories?
What are the basics in writing a T-SQL SELECT? How to return columns and records from a table in SQL Server.
In this post, we discuss what columns and records are in a SQL table including an explanation of objects and entities.
How to use the WHERE statement to filter records when the value is a number or integer data type in a T-SQL statement.
How to use the WHERE statement to filter records when the value is a character data type in a T-SQL statement.