A look back from the future. – TSQL Tuesday #100
The date is July 14th, 2026 and it’s TSQL Tuesday #200. We are still using SQL Server, and in fact...
2018-03-13
292 reads
The date is July 14th, 2026 and it’s TSQL Tuesday #200. We are still using SQL Server, and in fact...
2018-03-13
292 reads
2018-03-07
525 reads
My very first SQL Homework post was about taking a backup. The vast majority of people who work with databases...
2018-03-05
292 reads
If you are a Sr DBA or developer you have probably had some variation of this conversation at multiple points...
2018-02-28
411 reads
tl;dr; SQLCMD v2014 and up has special requirements for Kerberos.
One of the problems with linked servers (no rude noises please)...
2018-02-26
2,082 reads
Did you know SQL Server has a thing called a synonym? It’s not something you see used very often even...
2018-02-26 (first published: 2018-02-15)
3,350 reads
It’s T-SQL Tuesday again! And in fact it’s the 99th one! Given that T-SQL Tuesday runs once a month that...
2018-02-23 (first published: 2018-02-13)
2,007 reads
If you’ve never worked with windowing functions they look something like this:
SELECT name, max(create_date) OVER
-- No this isn't meant to...
2018-02-21
1,470 reads
You know you can have multiple filegroups right? You might have a separate filegroup for the data (the clustered index...
2018-02-19
518 reads
I’ve said before that backups are at once one of the easiest things DBAs do, one of the most important,...
2018-02-15 (first published: 2018-02-07)
1,811 reads
By Steve Jones
dolorblindness – n. the frustration that you’ll never be able to understand another person’s...
By Steve Jones
I had a customer ask about analyzing their Test Data Manager (TDM) usage to...
By Steve Jones
I had an idea for an animated view of a sales tool, and started...
Comments posted to this topic are about the item GPX distance and time analysis...
Comments posted to this topic are about the item The DBA is Dead; Long...
Comments posted to this topic are about the item 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