sql – Drsql's Database Musings

Drsql's Database Musings

Tag: sql

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

2026-09-02
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
Simplest way to make a query faster

2026-08-13
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
A short myth to look at: subqueries in the SELECT clause

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

2026-07-07
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
Learning beyond your comfort zone (032)

2026-06-04
I have NULL issues with NULL

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

2026-05-19
Simple Relatable Examples and Stories (030)

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

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

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

2026-04-01
Datatype precedence and performance in SQL Server

2026-03-11
Data Tune 2026 Roundup

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

2026-02-25
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
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
How indexes are used with COUNT in SQL Server

2026-01-14
Clickbait reels them in, if the catch is worth it (012)

2025-12-12
If you aren’t sure you are right, are you? (008)

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

2025-12-03
Rejoining Redgate Ambassadors

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

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

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

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

2025-11-05
Temporary Stored Procedures: Outputting Status in Scripts

2025-10-29
Temporary Stored Procedures in SQL Server

2025-10-22
Concatenating values as character data including in SQL Server 2025

2025-10-15
Feedly Friday – Feeds I Read #11 – Tales from the Field

2025-10-10
Fun with COUNT aggregate calls

2025-10-08
Fun solving a SQL problem (that I will never use in production)

2025-10-01
Feedly Friday – Feeds I Read #9 – Glenn Berry’s SQL Server Performance

2025-09-26
Time Zones and Time Zone Conversions in SQL Server

2025-09-24
Feedly Friday – Feeds I Read #8 – Andy Leonard

2025-09-19
And the rest – REGEXP_INSTR, and REGEXP_COUNT

2025-09-17
Do your DBA Skills translate to your life?

2025-09-15
Feedly Friday – Feeds I Read #7 – T-SQL Tuesday

2025-09-12
REGEXP_ Functions in SQL Server 2025 – REGEXP_SUBSTR

2025-09-10
Feeds I Read – Feedly Friday #5 – Niko Neugebauer

2025-08-29
REGEXP_ Functions in SQL Server 2025 – REGEXP_REPLACE

2025-08-27
Feedly Friday – Feeds I Read #4 – Brent Ozar Unlimited

2025-08-22
What Counts for a DBA: Focus

2025-08-18
Viewing Multiple Matches in SQL Server Regular Expression Functions

2025-08-06
Negating Character Classes and Class Shortcuts in SQL Server RegEx

2025-07-31
My Current Favorite Thing in SSMS – Presenter Mode

2025-07-29
Using IS [NOT] DISTINCT FROM to compare data with NULL values

2025-07-22
Repeating Pattern Matching with SQL Server Regular Expressions

2025-07-16
Simple Pattern Matching with SQL Server Regular Expressions

2025-07-11
Cardinality and REGEXP_LIKE

2025-07-02
SQL Server REGEXP_LIKE features augment, not replace, LIKE

2025-06-26
Scenic City Summit Roundup

2025-06-22
ChatGPT’s Attitude is interesting

2025-06-19