A Disturbing Trend: Government Sponsored Malware
It is understandable that nations may undertake operations against other nations. This is believed to be the origin of StuxNet...
2011-10-13
935 reads
Brian Kelley
- Interests: Chess, Reading, Soccer (Football), Baseball, Animals, Theology
Piiiiiiiigs, er DBAs, in Space!
If you don't get the reference, it was a set of skits on the old Muppet Show and it starred...
2011-10-13
988 reads
Learn to Help Yourself
I used to work with a guy who was adamant that before you asked him for help, you had done the...
2011-10-11
1,295 reads
PASS Summit Attendees: Remember to Network and Maintain
Previously, when I had attended conferences, I had used them to attend as many seminars or talks as I could...
2011-10-10
1,410 reads
Advanced Persistent Threats and Us
In a blog post from last year, Richard Bejtlich (blog | twitter) talked about a concept called an Advanced Persistent Threat...
2011-10-07
1,316 reads
Detecting Security Updates on Vista/Windows 7/2008/2008R2
When trying to detect whether updates have been installed or not, there were several places we investigated:
HKLM\Software\Microsoft\Windows\CurrentVersion\UninstallHKLM\Software\Microsoft\WindowsNT\CurrentVersion\HotFixHKLM\Software\Microsoft\UpdatesSome updates still write to...
2011-10-06
2,698 reads
Two Great Talks on the State of Internet Security
Recently I've started following the public work of Mikko Hypponen (blog | twitter), the Chief Research Officer of F-Secure. I've known...
2011-10-05
1,034 reads
Have end users who need an introduction to SQL Server book?
At the beginning of this year, my introductory text to SQL Server, appropriately titled Introduction to SQL Server, became available for sale....
2011-09-19
1,320 reads
Looking to interact with those proficient in Japanese
In the 1970s my mother and her younger sister married U.S. Marines. Both came to the States when their husbands...
2011-09-12
785 reads
Don't Wait to Start Blogging
I was reading a post by Jonathan Fields (blog | twitter) about making bad guitars. Okay, so what does that have to...
2011-08-15
2,245 reads
Blogs
A New Word: Ecstatic Shock
By Steve Jones
ecstatic shock – n. a surge of energy upon catching a glimpse from someone...
The CDO’s Playbook for AI Driven Decision Making
By Chris Yates
The New Arena of Leadership The role of the Chief Data Officer is no...
sp_snapshot – The easy way to take database snapshots of one or more databases – V3.0
Presenting you with an updated version of our sp_snapshot procedure, allowing you to easily...
Forums
Lessons from the Postmark-MCP Backdoor
Comments posted to this topic are about the item Lessons from the Postmark-MCP Backdoor
Arc Enabled SQL Server
Just saw the "Azure Extension for SQL Server" Does anyone has experience with it?...
Recursive Select - What is this really doing
I've noticed several instances of what looks like a recursive insert with the format:...
Question of the Day
The Maximum Value in the Identity Column
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 OFF
I now run this code.
DBCC CHECKIDENT(TravelLog)
GO
INSERT dbo.TravelLog
(
CityID,
StartDate,
EndDate
)
VALUES
(4, '2025-10-14', '2025-10-17')
GO
What is the value for TravelLogID for the row I inserted for CityID 4 and dates starting on 14 Oct 2025?
See possible answers