Updated Website
I've taken some time to update my website. In particular I have updated:
ArticlesReading ListChess Reading List
Nothing fancy or special, but...
2007-03-20
1,339 reads
I've taken some time to update my website. In particular I have updated:
ArticlesReading ListChess Reading List
Nothing fancy or special, but...
2007-03-20
1,339 reads
First saw this at Blade Watch. VMWare has released a white paper on using SANs with VMWare ESX Server 3.0....
2007-03-20
1,488 reads
Saw this first here: SQL Server 2005 Security Best Practices. It's on the blog for Microsoft UK's SQL Server Premier...
2007-03-19
1,870 reads
Saw this on the Windows PowerShell blog:
Since W2K3 SP2 is an update to W2K3 SP1, if you install Powershell on...
2007-03-19
2,534 reads
Animals are near and dear to my heart, to the point where I have a cat even though I am...
2007-03-17
1,339 reads
I'm working on a new article for SQL Server Central talking about physical security and SQL Server and I was...
2007-03-17
1,356 reads
SQL Server MVP Aaron Bertrand has posted that there is still a bug with maintenance plans for SQL Server 2005...
2007-03-15
1,443 reads
ApexSQL announced that a new version of ApexSQL doc is available.
News Announcement
The latest version is 2005.11.0203 and there are...
2007-03-14
1,514 reads
Here is a list of what was fixed:
http://support.microsoft.com/default.aspx/kb/914962
Downloads are available off of the SP2 home page:
http://www.microsoft.com/technet/windowsserver/sp2.mspx
Technorati Tags:Microsoft | Windows 2003
2007-03-14
1,461 reads
In this article, Brian looks at how Citrix MetaFrame can use SQL Server for its internal data repository. The basic operation of SQL Server in a Citrix MetaFrame installation is covered. In addition, Brian looks at how a DBA is an integral part of the support team for a successful Citrix MetaFrame farm.
2007-03-02 (first published: 2002-05-13)
26,764 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...
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:...
Comments posted to this topic are about the item Cleaning Up the Cloud
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