The Energizer Bunny
Energizer, one of the world's leading battery manufacturers, is looking to have Microsoft host much of their infrastructure.
2008-12-02
538 reads
Articles
The Energizer Bunny
Energizer, one of the world's leading battery manufacturers, is looking to have Microsoft host much of their infrastructure.
2008-12-02
508 reads
The Energizer Bunny
Energizer, one of the world's leading battery manufacturers, is looking to have Microsoft host much of their infrastructure.
2008-12-02
778 reads
Power and Deception of CTEs
A performance problem with a CTE based stored procedure, opened the developers eyes to a whole new world
2008-12-01
9,163 reads
Configuring Transport Encryption in SQL Server 2005 Express Service Broker Conversation
In the recent installments of our "SQL Server 2005 Express Edition" series we have been discussing mechanisms that facilitate authentication of distributed systems participating in Service Broker conversations. This article discusses use of digital certificates in encrypting their content on the transport level.
2008-12-01
2,512 reads
SQL Server Index Basics
Given the fundamental importance of indexes in databases, it always comes as a surprise how often the proper design of indexes is neglected. It often turns out that the programmer understands detail, but not the broad picture of what indexes do. Bob Sheldon comes to the rescue with a simple guide that serves either to remind or educate us all!
2008-12-01
6,724 reads
2008-12-01
136 reads
2008-12-01
927 reads
2008-12-01
980 reads
The Date Dimension in Analysis Services
Data warehousing author and expert, Vincent Rainardi, brings us a new article that looks at one of the most frequently used dimensions in Analysis Services.
2008-11-28
18,735 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