PASS Summit 2012 Countdown Begins !!!
All roads lead to Seattle!
If you are a SQLServer professional, then you don’t want to miss this event.
Over 190 technical...
2012-10-23
1,204 reads
All roads lead to Seattle!
If you are a SQLServer professional, then you don’t want to miss this event.
Over 190 technical...
2012-10-23
1,204 reads
In development environments I prefer to use ‘detach’ database option to move around databases. It’s simple, fast and easy.
Almost all...
2012-10-04
1,278 reads
In theory we cannot backup the log of a database which is in Simple recovery model, however there is a...
2012-10-01
1,086 reads
You will hit this error Cannot assign a default value to a local variable in case you are running SQL 2005/below,and you try...
2012-09-27
2,914 reads
One of the advanced Server level options for SQL Server is Max Text Replication Size and this is really not a common...
2012-09-24 (first published: 2012-09-18)
6,891 reads
Back to back quality SQLServer sessions! Yes, you heard it right and that’s what 24 Hours of PASS is all...
2012-09-13
733 reads
The prerequisite SQLServer 2008 R2 patch level for System Center Config Manager 2012(SCCM) is SP1 with Cumulative Update 6 (CU)
For...
2012-09-05
1,677 reads
SSMS reports are one of the best ways to pull some great deal of Server level or Database level information...
2012-09-04
4,701 reads
I have been using VMware vSphere client for a while now and the person who inspired me to use this...
2012-08-15
1,416 reads
A blog post about Microsoft Assessment Planning Toolkit was in my list for quite a while and today I decided to write...
2012-08-08
912 reads
By Steve Jones
ecstatic shock – n. a surge of energy upon catching a glimpse from someone...
By Chris Yates
The New Arena of Leadership The role of the Chief Data Officer is no...
Presenting you with an updated version of our sp_snapshot procedure, allowing you to easily...
Comments posted to this topic are about the item Lessons from the Postmark-MCP Backdoor
Just saw the "Azure Extension for SQL Server" Does anyone has experience with it?...
I've noticed several instances of what looks like a recursive insert with the format:...
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 OFFI now run this code.
DBCC CHECKIDENT(TravelLog) GO INSERT dbo.TravelLog ( CityID, StartDate, EndDate ) VALUES (4, '2025-10-14', '2025-10-17') GOWhat is the value for TravelLogID for the row I inserted for CityID 4 and dates starting on 14 Oct 2025? See possible answers