- CASE Expression: Two Important Things
- INNER JOIN and Matching Rows
- Isolation Levels Repeatable Read
- Don't just give someone the answer
- Don't just give someone the answer
- Save as and include column headings
- Syntax Style
- Azure SQL Database vs. Fabric Database
- Help the SQL Engine Do Its Job Better
- Up and Running SQL Server 2025
- Deadlocks and the Terminator
- SQL Is a Declarative Language
- OLTP and OLAP Serve Different Purposes
- Table Size Influences Deadlock Susceptibility
- Provide SQL Reader Access with Caution
- Mistakes Equal Learning
- Use Equality Versus Inequality
- Illustrate a Deadlock
- Writing Is Thinking
- Should You Skip Repeatable Read
- Showing Query Windows Side by Side
- Reading a Technical Book
- Downsides to SELECT *
- CASE Is an Expression
- Balance Between Concurrency and Consistency
- Start to Learn SQL in a Day
- Reducing Deadlocks
- Focus on the Task at Hand
- Inserts and New Parquet Files
- Concurrency in a Fabric Warehouse
- Converting Chained CTEs to Temporary Tables Using ChatGPT
- Indexes can improve the speed of DELETE statements
- SQL Server Doesn't Like Filtered Indexes
- Lots of page reads correlate to slow queries
- An Index is a Smaller Copy of the Data
- SQL Server Management Studio 21 is a much better product
- A Database's Prime Objective is to Capture and Store Data
- Difference between Read Committed Snapshot and Snapshot