This was an interesting thing I saw in a Question of the Day submission. I hadn’t thought about the issue, but apparently DATEADD truncates values rather than rounding them....
2025-03-19
106 reads
Learn how to deploy schema changes in an always-online SQL Server environment without a maintenance window. This utility reduces blocking and improves deployment success.
The problem
I attempted to deploy a...
2025-03-19 (first published: 2025-03-07)
177 reads
We get it. There’s no budget for a DBA on staff, or even a contract support firm like Dallas DBAs. You are not alone! There are thousands of firms...
2025-03-19 (first published: 2025-03-07)
527 reads
Don’t Panic! It’s a vague but common complaint, frequently with no additional details. Before blindly restarting SQL Server, let’s walk through quick checks that don’t require deep DBA skills....
2025-03-19
198 reads
I’m not looking for a job, but I ran across an article about using AI tools for a job search. So I decided to try it out. I followed...
2025-03-18 (first published: 2025-03-17)
13 reads
I live for questions and this was an interesting one. Can you see Table Valued Parameters that have been passed in to Extended Events? I literally have no idea....
2025-03-18 (first published: 2025-03-17)
29 reads
EightKB is back! The biggest online SQL Server internals conference is back in 2025…it’s all happening on August the 21st! We’ve open our call for speakers, you can submit...
2025-03-18 (first published: 2025-03-17)
18 reads
Want to blend your love of marketing with the power of data? Becoming a marketing analyst is the way to go. This job is all about measuring how well campaigns actually work, understanding...
2025-03-18
16 reads
I received a sobering reminder this week of a lesson we all have learned or should have learned long ago. Something I said online came back around months later...
2025-03-18 (first published: 2025-03-17)
14 reads
This may or may not be helpful in the long term, but since I’m doing it to be super cautious, I figured I would blog about it. We migrated...
2025-03-18 (first published: 2025-03-14)
26 reads
By Steve Jones
Often we find out about a problem reported by a customer after the incident...
Let’s face it, most of the time, you probably don’t want your SQL Server...
By Steve Jones
I was asked about state-based deployments in Flyway Teams, so I decided to show...
Comments posted to this topic are about the item The Table Backup
Comments posted to this topic are about the item Dynamic T-SQL Script Parameterization Using...
Comments posted to this topic are about the item Monoliths and Microservices
I run this code in SQL Server 2022. What happens?
BACKUP TABLE beercount TO DISK = 'beercount.bak'See possible answers