Checking for Excessive Permissions in SQL Server - Syndication – WaterOx Consulting
Who can do what? One of the key things that a DBA...
The post Checking for Excessive Permissions in SQL Server...
2015-09-02
501 reads
Who can do what? One of the key things that a DBA...
The post Checking for Excessive Permissions in SQL Server...
2015-09-02
501 reads
Thinking Like A Manager In WOxPod!, episode # 017 – “Thinking Like...
The post 017 – Thinking Like A Manager appeared first on WaterOx...
2015-08-28
904 reads
What is the real problem with the AshleyMadison data breach? Well, let...
The post The Problem With AshleyMadison appeared first on...
2015-08-26
589 reads
Me, Myself and I In WOxPod!, episode # 016 – “Me, Myself...
The post 016 – Me, Myself and I appeared first on WaterOx...
2015-08-21
798 reads
Brian Davis In WOxPod!, episode # 015 – “Brian Davis” we have...
The post 015 – Brian Davis appeared first on WaterOx Consulting.
2015-08-14
543 reads
Kon!!!!!! In WOxPod!, episode # 014 – “Kon Melamud” Today we have...
The post 014 -Kon Melamud appeared first on WaterOx Consulting.
2015-07-31
1,147 reads
Let’s Play A Game! So, just to tickle your fancy, here is...
The post Sneak Preview – Episode 014 appeared first on...
2015-07-27
478 reads
Together we can make a difference in the data world! In WOxPod!,...
The post 013 – The Start of Something Big! appeared...
2015-07-24
457 reads
But SQL Server Can Help Did you know SQL Server has a...
The post Security Isn’t Easy appeared first on WaterOx...
2015-07-22
505 reads
Someone worth getting to know in the Mid-Atlantic region! In WOxPod!, episode...
The post 012 – Carlos Chacon appeared first on WaterOx...
2015-07-17
556 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...
Comments posted to this topic are about the item Lessons from the Postmark-MCP Backdoor
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:...
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