Hi, I’m Ashlin Ferguson, and I like Microsoft SQL Server.
This blog is ramblings, musings, and notes about my experience and career related to SQL database. It will be updated sporadically, when I feel like it.
I’ve been learning Microsoft SQL Server for a couple of decades and there’s still always an interesting new challenge to tackle. Most recently I have been specializing in query and index performance tuning.
Posts
-
Quick Hit List of Best Practices for SQL Queries
-
OPENJSON - What do you do when the first normal form is ignored?
-
The Power of Dynamic SQL - A Quick Look at a Useful T-SQL Snippet
-
Uncovering the SQL Permission Conundrum: When ChatGPT’s Oracle Fails in MS SQL
-
NOT IN vs NOT EXISTS, Who Would Win?
-
Query Trace
-
Dynamic SQL to Search All Tables and Columns In a Database For a Particular String
-
SQL Server in a Docker Container Quick Start
-
Understanding Floating Point Data Types and the Impact of Parallelism on Query Results
-
My Resume
-
What Broke Today?
-
What is the difference in roles and responsibilities between various Database Administrator job titles?
-
Test Post: It’s Been a while!
-
Advent of Code Challenge Day 3
-
Advent of Code Challenge Day 2
-
Python Training References
-
Powershell Related Notes and Resources
-
Code Snippets
-
SQL Link Repository
-
Database Design, Normalization, and Diagramming
-
Interview Notes
-
SQL Conferences
-
Advent of Code Challenge
-
Learn SQL Server for free on your PC at home!
subscribe via RSS