It's like disaster recovery (and business continuity) planning is the end-of-term research paper that the professor mentioned on the first day of class, but which most students don't start...
2024-10-23 (first published: 2024-10-10)
238 reads
The slides and scripts for my session “Tackling the Gaps & Islands Problem with T-SQL Window Functions” at dataMinds Connect 2024 can be downloaded from GitHub. If you want...
2024-10-10
40 reads
Look, we all know data is king these days. But having mountains of data and actually using it to make your business better are two different things. That's where...
2024-10-10
28 reads
This topic keeps coming up with my customers so the purpose of this blog post is to keep all the useful information in one post. Think of this post...
2024-10-23 (first published: 2024-10-09)
179 reads
I realized that I hadn’t done much blogging on Window functions in T-SQL, and I’ve done a few presentations, so I decided to round out my blog a bit....
2024-10-09
2,358 reads
I realized that I hadn’t done much blogging on Window functions in T-SQL, and I’ve done a few presentations, so I decided to round out my blog a bit....
2024-10-09
238 reads
Sometimes a solution is no longer viable because there isn’t a path forward and sometimes a solution isn’t viable because there are better options out there from the organization’s...
2024-10-09
21 reads
If a technology is still viable, don’t overlook it. Don’t get caught up chasing the “shiny” or the “perfect” solution just because you can.
2024-10-08
22 reads
It’s time for the monthly T-SQL Tuesday blog party. This month a longtime friend, Tim Mitchell is hosting and he’s got a neat invite. He’s asking us how to...
2024-10-08
12 reads
It’s time for the monthly T-SQL Tuesday blog party. This month a longtime friend, Tim Mitchell is hosting and he’s got a neat invite. He’s asking us how to...
2024-10-08
49 reads
By Zikato
When I'm looking at a query, I bet it's bad if I see... a...
By Steve Jones
This month is a milestone for T-SQL Tuesday. It’s number 200, which doesn’t sound...
The DBA life is fraught with pain. Those battles that we endure are mostly...
hi, im not a dba. For a couple of years our dev sql server...
Hello, I would like to ask whether it is technically possible to redirect a...
Comments posted to this topic are about the item Calculating Geometric Mean in Power...
On my SQL Server 2025, I want to search the error log from my T-SQL code for potential issues and then inform an administrator. What is the current way to easily query the error log?
See possible answers