Buzzword Bingo
Grant Fritchey (b/t) is our host for T-SQL Tuesday this month and surprise surprise he’d like to talk about DEVOPS....
2017-06-13
970 reads
SQLStudies
UDP vs TCP
If you’ve worked much with named instances you’ve probably had to deal with the question “What port is that instance...
2017-06-07
538 reads
Backup to NUL
Yes, I spelled that correctly. NUL not NULL. NUL is basically a location you can send a backup to. In...
2017-06-05
5,764 reads
SQL Crossword
I thought I’d do another crossword. Enjoy! If you need any help with it feel free to let me know...
2017-06-16 (first published: 2017-05-31)
2,805 reads
Running multiple queries at the same time.
I read an interesting question today. Someone wanted to be able to run the same stored procedure multiple times, at...
2017-06-08 (first published: 2017-05-24)
9,642 reads
What’s in a partition?
In my last post on partitioning I used the $Partition command in passing. I’ve been thinking it deserves a bit...
2017-05-22
505 reads
T-SQL FizzBuzz
I was looking around for something to write about this evening and came across one of Russ Thomas’ (b/t) old...
2017-05-17
2,864 reads
Why shouldn’t I shrink my database log file?
TL;DR: It’s pretty pointless and can cause performance issues.
Let’s start by asking why you might want to shrink your log....
2017-05-15
479 reads
Dynamic SQL and the joys of QUOTENAME
I’m a big fan of dynamic SQL. In the past I’ve written a How to, a Best Practices and even...
2017-05-11
598 reads
Continuous Integration
It’s T-SQL Tuesday again! This month we are being hosted by James Anderson (b/t). Thanks James! He has asked us...
2017-05-09
416 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