When Have You Used MOT Tables? T-SQL Tuesday #117
Steve Jones (b/t) is our host for T-SQL Tuesday and in case you didn’t know has taken over running T-SQL ... Continue reading
2019-08-13
223 reads
SQLStudies
Temporary stored procedures
tl;dr; Temporary stored procedures are excellent for testing pieces of code that are going to go into (or come from) ... Continue reading
2019-08-21 (first published: 2019-08-07)
913 reads
SQL Homework – August 2019 – Getting the data out
Everything else aside two of the most important tasks of a database are to get data in, and get data ... Continue reading
2019-08-16 (first published: 2019-08-05)
324 reads
Header Query Crossword
I did an interesting form of crossword recently and since I haven’t done one in a while I figured this ... Continue reading
2019-07-31
56 reads
Optional vs Required parameters in Stored Procedures
If you are executing a stored procedure with a bunch of parameters it can be a bit of a pain ... Continue reading
2019-07-29
172 reads
Custom error messages
I’m sure lots of you have used the function RAISERROR to handle an error caused by your code. The problem ... Continue reading
2019-07-24
35 reads
Current database vs database locks
I have a lot of co-workers who use sp_who and sp_who2 to see who’s in a given database. This is ... Continue reading
2019-07-22
298 reads
Is it just me or does msdb feel a lot like a user database?
When you think of system databases, tables, etc there are a number of things you might think of. Necessary to ... Continue reading
2019-08-07 (first published: 2019-07-17)
657 reads
Short circuiting an AND
The other day I did a post on how an OR short circuts. It was a somewhat unusual type of ... Continue reading
2019-08-06 (first published: 2019-07-15)
713 reads
Learning Powershell with Show-Command
Years ago I blogged about how I like to use the SSMS scripting feature to learn how to do things. ... Continue reading
2019-08-01 (first published: 2019-07-11)
864 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