Talk to the duck.
Over the years, one of the best pieces of problem solving advice I’ve been able to give my kids is ... Continue reading
2022-04-15 (first published: 2022-03-31)
334 reads
SQLStudies
Scripting with a temp stored procedure
A few years back I learned about temporary stored procedures from a Kendra Little (blog|twitter) blog post. At the time ... Continue reading
2022-04-04 (first published: 2022-03-17)
538 reads
Scripting with a temp stored procedure
A few years back I learned about temporary stored procedures from a Kendra Little (blog|twitter) blog post. At the time ... Continue reading
2022-03-17
20 reads
Shift calculations (or same time every day)
One of the more interesting jobs I’ve had over the years was for a company that created emergency room software. ... Continue reading
2022-03-28 (first published: 2022-03-15)
314 reads
Shift calculations (or same time every day)
One of the more interesting jobs I’ve had over the years was for a company that created emergency room software. ... Continue reading
2022-03-15
5 reads
Database Code Reviews
I’ll be honest, ever since I did a SQL Homework about doing code reviews I’ve wanted to do a blog ... Continue reading
2022-03-10
137 reads
Database Code Reviews
I’ll be honest, ever since I did a SQL Homework about doing code reviews I’ve wanted to do a blog ... Continue reading
2022-03-10
8 reads
An increased opportunity. Remote user groups. : T-SQL Tuesday #148
Rie Merritt (blog|twitter) is our host this month for T-SQL Tuesday! She’d like us to give advice on running a ... Continue reading
2022-03-08
21 reads
An increased opportunity. Remote user groups. : T-SQL Tuesday #148
Rie Merritt (blog|twitter) is our host this month for T-SQL Tuesday! She’d like us to give advice on running a ... Continue reading
2022-03-08
5 reads
Saving your requests
The other day a friend of mine mentioned that they were questioned on one of the scripts they ran recently ... Continue reading
2022-03-03
278 reads
Blogs
A bespoke reporting solution doesn’t have to cost the earth
By ChrisJenkins
You could be tolerating limited reporting because there isn’t an off the shelf solution...
Presenting with Visual Studio Code
A while back I wrote a quick post on setting up key mappings in...
Advice I Like: In 100 Years
By Steve Jones
In 100 years a lot of what we take to be true now will...
Forums
Lots of FKs
Comments posted to this topic are about the item Lots of FKs
Real-time On-prem SQL Server Data in Excel – Over the Internet
Comments posted to this topic are about the item Real-time On-prem SQL Server Data...
Can You Let Go of Determinism
Comments posted to this topic are about the item Can You Let Go of...
Question of the Day
Lots of FKs
In SQL Server 2025, what are the most outgoing and incoming FK references a table can have?
See possible answers