Blog Archive
Other
- February 2024 - Quick Hit List of Best Practices for SQL Queries
- February 2024 - OPENJSON - What do you do when the first normal form is ignored?
- January 2024 - The Power of Dynamic SQL - A Quick Look at a Useful T-SQL Snippet
- December 2023 - Uncovering the SQL Permission Conundrum: When ChatGPT’s Oracle Fails in MS SQL
- September 2023 - NOT IN vs NOT EXISTS, Who Would Win?
- September 2023 - Query Trace
- September 2023 - Dynamic SQL to Search All Tables and Columns In a Database For a Particular String
- August 2023 - SQL Server in a Docker Container Quick Start
- August 2023 - Understanding Floating Point Data Types and the Impact of Parallelism on Query Results
- August 2023 - My Resume
- July 2023 - What Broke Today?
- June 2023 - What is the difference in roles and responsibilities between various Database Administrator job titles?
- April 2023 - Test Post: It’s Been a while!
- December 2021 - Advent of Code Challenge Day 3
- December 2021 - Advent of Code Challenge Day 2
- December 2021 - Python Training References
- December 2021 - Powershell Related Notes and Resources
- December 2021 - Code Snippets
- December 2021 - SQL Link Repository
- December 2021 - Database Design, Normalization, and Diagramming
- December 2021 - Interview Notes
- December 2021 - SQL Conferences
- December 2021 - Advent of Code Challenge
- November 2021 - Learn SQL Server for free on your PC at home!