SQL Server 2014 – A new and exciting journey !!! “Into the cloud”
Today Microsoft announced their next major version of SQLServer, SQL Server 2014 at Tech-Ed NA 2013.
This version of SQLServer is indeed a reflection...
2013-06-03
1,368 reads
Today Microsoft announced their next major version of SQLServer, SQL Server 2014 at Tech-Ed NA 2013.
This version of SQLServer is indeed a reflection...
2013-06-03
1,368 reads
Today I will talk about a book titled ” Windows PowerShell 3.0 Step by Step” by Ed Wilson;O’Reilly Media, Inc.
When I...
2013-05-23
925 reads
That was indeed a great day at Redmond. I had a great time talking to some of the best SQLServer minds...
2013-05-20
694 reads
This is my first SQLSaturday and I’m super excited to attend this event.
SQLSaturday’s are always a great opportunity to learn something exciting,...
2013-05-16
627 reads
I’m generally not a great fan of Activity Monitor which is built in with SSMS,however today I wanted to check...
2013-05-02
3,404 reads
Today I will discuss about an issue which was observed while creating a linked server via script.
The existing linked server was scripted...
2013-04-19
1,312 reads
A short and sweet post for a gorgeous morning -
Have you seen a file with extension .wrk in the log shipping copy folder...
2013-03-29
4,274 reads
Here comes CU 3 (Build 11.0.3349.0.) for SQLServer 2012 SP1. You can download the same from
http://support.microsoft.com/kb/2812412
Similar to CU2 there...
2013-03-21
1,429 reads
CU2 for SQLServer 2012 SP1 is one key update which you should review and deploy if found necessary. I have...
2013-03-19 (first published: 2013-03-15)
2,437 reads
Adding a linked server is an easy task which can be done at any point of time. I was under...
2013-03-13
2,922 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