More SQL Server blogs
There is a new site for SQL Server blogs, SQLBlog.com. "Brought to you by Peter DeBetta & Adam Machanic," it has...
2006-07-29
1,312 reads
Brian Kelley
- Interests: Chess, Reading, Soccer (Football), Baseball, Animals, Theology
New Windows Vista Security Blog
If you're keeping up with Windows Vista and you're interested in the
security aspects of it, there's a new blog, with...
2006-07-29
1,385 reads
Connecting With Perl Using Win32 : ODBC
Perl has been a popular language for Unix administrators for years. It is flexible, easy to learn, and capable of doing some very powerful things with relatively few lines of code. In this article by Brian Kelly, he shows you how to connect to SQL Server via Perl.
2006-07-28 (first published: 2002-12-03)
42,229 reads
Haidong Ji blogs on a tip for learning Perl
Haidong Ji, co-author of Professional SQL Server 2005 Integration Services, blogged on Learning Perl using the Perl Debugger. Haidong posts...
2006-07-27
1,590 reads
Interview with Craig Mundie on Channel 9
Channel 9 has posted a 25 minute interview with Craig Mundie, Chief Research and Strategy Officer for Microsoft. You can...
2006-07-27
1,647 reads
New SQL Server 2005 Books Online download available
As reported in several other places... there is a new Books Online (July 2006) for SQL Server 2005. You can...
2006-07-25
1,902 reads
Before you submit that incident to Microsoft...
Check out this post:
Things to consider before submitting an incident to Microsoft
Getting the information together before you make that phone...
2006-07-20
2,346 reads
Presenting at Columbia, SC DotNet User Group
I'll be presenting at the DotNet Columbia SC User Group on August 8th.
My presentation is tentatively titled, "Something old, something...
2006-07-20
1,633 reads
The Plumbing Behind MSDN 2
There is a very interesting article about how MSDN 2 utilizes SQL
Server 2005 technologies, specifically Service Broker and CLR
integration. The...
2006-07-20
1,513 reads
Free Data Models
I saw this on a Channel 9 forum thread:
Library of Free Data Models
There are quite a few starter data models...
2006-07-19
1,911 reads
Blogs
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...
SELECT *
SELECT * feels convenient, but in SQL Server it bloats I/O, burns network bandwidth,...
Forums
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
The Maximum Value in the Identity Column
Comments posted to this topic are about the item The Maximum Value in the...
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