featured – Drsql's Database Musings

Drsql's Database Musings

Tag: featured

Is a broken clock really right twice a day?

2026-09-28
Interesting things about T-SQL in a Fabric Data Warehouse: A bit each of clustering and performance information (Part 7)

2026-09-25
Lack of confidence is my super power

2026-09-21
Interesting things about T-SQL in a Fabric Data Warehouse: Query Plan and Statistics Tools (Part 6)

2026-09-17
Is a broken clock really right twice a day?

2026-09-14
Interesting things about T-SQL in a Fabric Data Warehouse: Schema Locks and Time Travel (Part 5 )

2026-09-09
Interesting things about T-SQL in a Fabric Data Warehouse: Atomicity and Isolation (Part 4)

2026-09-02
The Stages of My Layoff Grief – Part 3 – Beyond Grief

2026-08-31
Interesting things about T-SQL in a Fabric Data Warehouse: Metadata and Temp Tables (Part 3)

2026-08-26
Is all this “AI Slop” deliberate?

2026-08-24
Interesting things about T-SQL in a Fabric Data Warehouse: Surrogate Key values (Part2)

2026-08-19
My new love of markdown

2026-08-17
Simplest way to make a query faster

2026-08-13
T-SQL Tuesday #201 – Temp Tables, Friend, Foe, None, or All of the Above?

2026-08-11
Is it bad that I don’t want to dive deep into AI? Or is it that I actually can’t?

2026-08-10
Interesting things about T-SQL in a Fabric Data Warehouse: Dataypes and Constraints (Part 1)

2026-08-05
Changing mindset when using the same tools

2026-08-03
Interesting things about Optimized Locking in SQL Server 2025

2026-07-29
Music City Data User Group Roundup

2026-07-28
I have had it with blogging and social media

2026-07-27
What you find in the weeds

2026-07-20
Speaking at Music City Data User Group Next Week

2026-07-16
A short myth to look at: subqueries in the SELECT clause

2026-07-15
The best laid plans of mice and bloggers

2026-07-13
T-SQL Tuesday #200 – Concerning query traits

2026-07-07
Being convincing

2026-07-06
Do you disconnect on vacation?

2026-06-29
An interesting concept: Splitting queries with OR for performance

2026-06-24
The myth and the truth of filtering early

2026-06-18
Theory and Practice

2026-06-15
The logical lifecycle of a query

2026-06-10
Scenic City Summit 2026 Roundup

2026-06-09
What exactly does normal mean?

2026-06-08
Scenic City Summit 2026

2026-06-01
Raleigh Day of Data 2026 Roundup

2026-05-26
I have NULL issues with NULL

2026-05-20
Raleigh Day of Data 2026 this week

2026-05-19
All of your code is right

2026-05-18
T-SQL Tuesday #198 – How Do You Detect Data Changes?

2026-05-12
Day of Data Jacksonville 2026 Roundup

2026-05-11
The Fun of Aging

2026-05-06
Day of Data Richmond 2026 Roundup

2026-04-30
FABCON/SQLCON and SQL Saturday Atlanta BI Roundup

2026-04-29
Day of Data Jacksonville 2026 is this weekend

2026-04-28
Taking a short break…

2026-04-22
The second (and most important) software test

2026-04-20
T-SQL Tuesday #197 – An impactful session or two from a conference

2026-04-14
SUBSTRING Optional Length In SQL SERVER 2025

2026-04-08
Day of Data Richmond is THIS WEEK!

2026-04-07
Two often forgotten, yet important tracks at a tech conference

2026-04-06
Read/Write Ratio in a SQL Server database

2026-04-01
(Satire) New vlog series: Blogging for AI

2026-04-01
Define the question before writing the query

2026-03-30
DATE_BUCKET performance versus conventional methods

2026-03-25
The Opposite of Mental Rest

2026-03-23
SSMS Updating and a new Grid Export Feature

2026-03-19
Expert in one thing, dunce in another

2026-03-15
Datatype precedence and performance in SQL Server

2026-03-11
T-SQL Tuesday #196: What Risks Have You Taken in Your Career?

2026-03-10
Data Tune 2026 Roundup

2026-03-09
Datatype precedence and finding the datatype of an expression

2026-03-04
Heading to Atlanta for a pair of conferences

2026-03-03
The goal of naming standards

2026-03-02
Creating data from literal values in SQL Server

2026-02-25
Speaking at DataTune 2026

2026-02-24
Idle hands…can be great learning tools

2026-02-23
A SQL method for computing rolling totals without window functions

2026-02-18
The slop in this post is all mine

2026-02-16
OK, SELECT * doesn’t belong in EXISTS either

2026-02-13
The evil (and value) of DISTINCT

2026-02-11
T-SQL Tuesday #195 – How has your code aged

2026-02-10
Generating a set of sequential numbers, part 2

2026-02-04
This post is not only about SELECT *

2026-02-02
Performance test of generating a set of sequential numbers

2026-01-28
T-SQL Tuesday #194 – Roundup – Learning from Mistakes

2026-01-27
Cool features in SQL Server I missed…DATE_BUCKET

2026-01-21
T-SQL Tuesday #194 – Learning from our mistakes

2026-01-20
You don’t need to know anything because AI exists?

2026-01-19
How indexes are used with COUNT in SQL Server

2026-01-14
T-SQL Tuesday #194 Invitation – Learning from mistakes

2026-01-13
I am not a guru, and neither are you (probably)

2026-01-12
Looking forward at 2026

2026-01-06
That’s a wrap on 2025

2025-12-30
This year’s Blogging for Programmer Tipmas Event is complete!

2025-12-24
T-SQL Tuesday #193 – A Note to Your Past, and a Warning from Your Future

2025-12-09
Feedly Friday – Feeds I Read #14

2025-12-05
Using TRANSLATE in SQL Server instead of REPLACE

2025-12-03
Vlogmas 2025 – Writing tips for Programmers

2025-12-01
New Article: SQL Prompt AI Versus Smart Quotes

2025-11-25
Thankfulness Week!

2025-11-24
Feedly Friday – Feeds I Read #13

2025-11-21
Rejoining Redgate Ambassadors

2025-11-20
Awesome Use of RegEx in SQL Server – Multiple Filters

2025-11-19
AI, Crazy Quoted Identifiers, and comparing column names between tables

2025-11-18
Feedly Friday – Feeds I Read #12

2025-11-14
Using FORMATMESSAGE in SQL Server to Enhance my Temporary Procedure

2025-11-12
T-SQL Tuesday #192 – SQL Server 2025 Excitement

2025-11-11
Throwing Stuff at the Wall

2025-11-10
25 Years

2025-11-07
SQL Strategies for Comparing Sets of Data

2025-11-05