What goes around comes around : T-SQL Tuesday #129
I almost died. I’m sure a lot of you already know this but just to be clear, I should have. ... Continue reading
2020-08-11
25 reads
SQLStudies
HAL0004 – I don’t feel well Dave
It’s another HAL! Every once in a while (4 times now) I come up with a terrible terrible idea for ... Continue reading
2020-06-29
49 reads
Azure SQL Database Query Editor
I was working on a couple of Azure databases the other day. One was an Azure SQL DB and the ... Continue reading
2020-06-24
167 reads
I created a table and SQL created a schema and a user.
Demo first and then I’ll explain what happened. First thing I did was run this script: CreateUsers.bat It’s a quick ... Continue reading
2020-07-08 (first published: 2020-06-22)
400 reads
Adding people’s names to a blog post can be rather tedious.
I blog a fair amount and do you want to know what the most annoying part of the process is? ... Continue reading
2020-06-18
21 reads
Non-SQL Tips and tricks – #tsql2sday 127 Rollup
I was thrilled to host TSQL Tuesday this month (#127) and I my prompt was non-SQL tips and tricks. Now ... Continue reading
2020-06-26 (first published: 2020-06-16)
496 reads
End an ALTER DATABASE immediately if anyone is in the database.
The development team has told me they’ve shut down the application, there are no more connections and I can go ... Continue reading
2020-06-30 (first published: 2020-06-11)
675 reads
The Azure Portal search bar : T-SQL Tuesday #127
Happy T-SQL Tuesday! Number 127. Wow. Over 10 and a half years. Talk about incredible. I’m actually hosting this time ... Continue reading
2020-06-09
68 reads
SQL Homework – June 2020 – DML Triggers
Triggers. Blech. Triggers are a really really cool feature of SQL Server, that are continuously misused and cause all kinds ... Continue reading
2020-06-18 (first published: 2020-06-04)
339 reads
TSQL Tuesday #127 Invite – Non SQL Tips and tricks
How about for this months TSQL Tuesday let’s do another month of tips and tricks. But just to be a ... Continue reading
2020-06-02
25 reads
Blogs
Claude AI Convinced Me Not to Build an iPad App
By Steve Jones
I coach volleyball and I do a lot of stat stuff on paper. I...
A New Word: Dolorblindness
By Steve Jones
dolorblindness – n. the frustration that you’ll never be able to understand another person’s...
Claude Code Helps Analyze Test Data Manager Log Files
By Steve Jones
I had a customer ask about analyzing their Test Data Manager (TDM) usage to...
Forums
Data Warehouse Toolkit meets Star Schema: The Complete Reference
Is there a good syllabus for reading these two together? (Yes, it's called the...
GPX distance and time analysis in SQL Server
Comments posted to this topic are about the item GPX distance and time analysis...
The DBA is Dead; Long Live the DBA
Comments posted to this topic are about the item The DBA is Dead; Long...
Question of the Day
Changing the AG Listener
In SQL Server 2025, if I want to remove an IP from a listener, what do I do?
See possible answers