The Bionic Office - V2
Fog Creek Software has a new headquarters and the offices look amazing. Steve Jones talks about the value of a beautiful space.
Conducting Service Broker Conversation Using Full Dialog Security in SQL Server 2005 Express Service
In the previous installment of our series covering the most relevant features of SQL Server 2005 Express Edition, we started an overview of Service Broker full dialog-level security. In this article, we will conclude this subject by describing the remaining prerequisites and a method to invoke a secure dialog.
Great IT Shops
Do you work in a great IT shop? Steve Jones talks about some of the things that make one and wonders if you feel you work at a great company.
Great IT Shops
Do you work in a great IT shop? Steve Jones talks about some of the things that make one and wonders if you feel you work at a great company.
Great IT Shops
Do you work in a great IT shop? Steve Jones talks about some of the things that make one and wonders if you feel you work at a great company.
Just a Second, Guv.
In which Phil hears about an extra 'leap' second added over the new year, and broods on the missing INTERVAL datatype in SQL Server
Get SSAS Database Properties with PowerShell and AMO
Learn how to use Windows PowerShell and AMO to retrieve the database properties of SQL Server Analysis Service.
Graphical Execution Plans for Simple SQL Queries
Learning how to read and analyze execution plans takes time and effort. But once you gain some experience, you will find them an essential skill for getting to grips with performance issues in SQL Server Queries. Grant here describes the range of execution plans for different simple SQL Queries.
The Bionic Office - V2
Fog Creek Software has a new headquarters and the offices look amazing. Steve Jones talks about the value of a beautiful space.
The Bionic Office - V2
Fog Creek Software has a new headquarters and the offices look amazing. Steve Jones talks about the value of a beautiful space.
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