Why Your SQL Server Backups Aren’t Enough
SQL Server backups are database insurance – you don’t really appreciate them until disaster strikes. But here’s the kicker: having backups doesn’t mean your data is safe. If you’re...
2025-04-09
136 reads
SQL Server backups are database insurance – you don’t really appreciate them until disaster strikes. But here’s the kicker: having backups doesn’t mean your data is safe. If you’re...
2025-04-09
136 reads
This month we have an interesting invite. Erik Darling is the host, and since he does a lot of video blogs, he’s asking for a video submission for T-SQL...
2025-04-08
13 reads
T-SQL Tuesday is a monthly blog party hosted by a different community member each month. This month, Erik Darling
(blog) asks us to produce a video
You can talk about whatever...
2025-04-08
4 reads
Introduction Treating your data catalog like a “data museum”—a static collection where information quietly gathers dust—is a mistake many organizations still make. While a catalog should list what data...
2025-04-07 (first published: 2025-03-26)
285 reads
This is a submission for the Pulumi Deploy and Document Challenge: Shhh, It’s a Secret!What I BuiltI built an automated infrastructure provisioning solution using Pulumi and Azure. The project leverages Pulumi’s...
2025-04-07
85 reads
Low-code solutions often accelerate development and make tasks accessible to people who can’t or don’t want to write their own code. But it’s important to remember that it’s a...
2025-04-07 (first published: 2025-03-24)
445 reads
Let’s face it, most of the time, you probably don’t want your SQL Server execution plans to go parallel. After all, that’s why, instead of adjusting the Cost Threshold...
2025-04-04 (first published: 2025-03-24)
488 reads
I was asked about state-based deployments in Flyway Teams, so I decided to show how this can work with a quick demo. This post walks through the process. I’ve...
2025-04-04 (first published: 2025-03-21)
198 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-04-02 (first published: 2025-03-17)
304 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-04-02 (first published: 2025-03-18)
291 reads
By Steve Jones
ecstatic shock – n. a surge of energy upon catching a glimpse from someone...
By Chris Yates
The New Arena of Leadership The role of the Chief Data Officer is no...
Presenting you with an updated version of our sp_snapshot procedure, allowing you to easily...
Just saw the "Azure Extension for SQL Server" Does anyone has experience with it?...
I've noticed several instances of what looks like a recursive insert with the format:...
Comments posted to this topic are about the item Cleaning Up the Cloud
I have a table with this data:
TravelLogID CityID StartDate EndDate 1 1 2025-01-01 2025-01-06 2 2 2025-01-01 2025-01-06 3 3 2025-01-01 2025-01-06 4 4 2025-01-01 2025-01-06 5 5 2025-01-01 2025-01-06I run this code:
SELECT IDENT_CURRENT('TravelLog')I get the value 5 back. Now I do this:
SET IDENTITY_INSERT dbo.TravelLog ON INSERT dbo.TravelLog ( TravelLogID, CityID, StartDate, EndDate ) VALUES (25, 5, '2025-09-12', '2025-09-17') SET IDENTITY_INSERT dbo.TravelLog OFFI now run this code.
DBCC CHECKIDENT(TravelLog) GO INSERT dbo.TravelLog ( CityID, StartDate, EndDate ) VALUES (4, '2025-10-14', '2025-10-17') GOWhat is the value for TravelLogID for the row I inserted for CityID 4 and dates starting on 14 Oct 2025? See possible answers