programming – Drsql's Database Musings

Drsql's Database Musings

Tag: programming

A short myth to look at: subqueries in the SELECT clause

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

2026-07-07
Learning beyond your comfort zone (032)

2026-06-04
Raleigh Day of Data 2026 this week

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

2026-04-30
Do try this at home, well most of it (029)

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

2026-03-11
Blame the name on the byline (026)

2026-03-05
This post is not only about SELECT *

2026-02-02
If it isn’t fun, could it be your purpose (024)

2025-12-24
Have a little structure (021)

2025-12-21
Every app is a data app (well almost every app) (S01:E04)

2025-12-19
Keeping a schedule…that you created (018)

2025-12-18
You are not alone in this (017)

2025-12-17
Who doesn’t love some negative feedback? (015)

2025-12-15
A blog as old as time, can still be useful (014)

2025-12-14
Write your ideas down while you still can (013)

2025-12-13
Clickbait reels them in, if the catch is worth it (012)

2025-12-12
Foreshadowing the goals of your blog (011)

2025-12-11
Be your authentic self (010)

2025-12-10
Write to the code you have (009)

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

2025-12-08
It is the content that really matters (007)

2025-12-07
Why do we even build databases? (S01:E03)

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

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

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

2025-11-25
We never test in production, right? (S:01 E:02)

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

2025-11-21
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
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
T-SQL Tuesday #191 – Your Favorite String Parsing

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

2025-10-15
Fun with COUNT aggregate calls

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

2025-10-01
Testing in Production

2025-09-08
Feedly Friday – Feeds I Read #6 – Erik Darling and Eugene Meidinger

2025-09-05
REGEXP_ Functions in SQL Server 2025 – REGEXP_SPLIT_TO_TABLE

2025-09-03
REGEXP_ Functions in SQL Server 2025 – REGEXP_REPLACE

2025-08-27
Feedly Friday – Feeds I Read #3 – Andreas Wolter

2025-08-15
Flags in SQL Server Regular Expressions – Case Sensitivity

2025-08-13
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
Matching one of a set of characters with SQL Server Regular Expressions

2025-07-24
Cardinality and REGEXP_LIKE

2025-07-02
ChatGPT’s Attitude is interesting

2025-06-19