A Long Overdue Database Security Rant
I've been dealing with a security product from a security company in recent days that breaks best practices with respect...
2008-01-30
2,297 reads
Brian Kelley
- Interests: Chess, Reading, Soccer (Football), Baseball, Animals, Theology
First Heroes Happen Here (HHH) Comic
Microsoft and Seagate have partnered togethered to put together an IT Heroes comic (daily even). The first one is here:
...
2008-01-29
1,560 reads
Ken Henderson has passed away
I know I'm not the first in the SQL Server community to post this, but Ken Henderson has passed away...
2008-01-29
1,899 reads
Part II of Troubleshooting Memory Issues
The Windows Server Performance Team has published part 2 of troubleshooting memory issues.
This one covers excessive paging and memory...
2008-01-29
1,662 reads
Citrix Presentation Server Becomes XenApp
Citrix is changing the name of its flagship product from Citrix Presentation Server (CPS) to XenApp. More from the blogosphere:
Citrix...
2008-01-28
1,988 reads
Metasploit 3.1 is out
The new version of Metasploit is out. Included is a GUI interface. It's a complete re-write in Ruby (note to...
2008-01-28
1,510 reads
Microsoft .NET Framework 3.5 Deployment Guides available
Saw this first on Aaron Stebner's blog:
.NET Framework 3.5 deployment guides have been published on MSDN
Guidance information for both...
2008-01-28
1,553 reads
Microsoft Security Webcast
This one is geared towards IT management:
IT Manager Webcast: Dynamic IT and Security (Part 4 of 5): Identity and Access...
2008-01-28
1,649 reads
Vendor Neutral Database Certification
First saw this off of Planet MySQL:
New Vendor Neutral Database Certification (Dave's Stuff)
Following the link to the CIW site, there...
2008-01-28
2,863 reads
Inexpensive Video Training from Internals Expert, Kalen Delaney
I saw this in my blog reader today:
You can pre-order the Kalen Delaney SQL Server Internals Course - Lesson 1 DVD...
2008-01-25
1,069 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
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:...
Cleaning Up the Cloud
Comments posted to this topic are about the item Cleaning Up the Cloud
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