Backing up virtual machines on VMware ESX Server
I know VMware and Virtual Server
technology is becoming more and more prevalent in organizations as both
packages can greatly reduce hardware...
2006-05-17
1,611 reads
I know VMware and Virtual Server
technology is becoming more and more prevalent in organizations as both
packages can greatly reduce hardware...
2006-05-17
1,611 reads
The May/Jone 2006 issue of TechNet Magazine has a feature on security. One of the articles is titled Deconstructing Common...
2006-05-12
1,530 reads
In this article, Brian Kelley focuses on learning the various services in SQL Server. He also covers the security needed to make them work.
2006-05-12 (first published: 2002-01-03)
50,782 reads
Back in First Impressions of Professional SQL Server 2005 Integration Services,
I indicated I felt the book was worth the buy...
2006-05-10
1,454 reads
The SQLServerAdvisor mailing from SearchSQLServer.com had a link to a
very good article on cracking SQL Server passwords. The article, by
Kevin...
2006-05-09
1,592 reads
Dave Winer announced bringing back Share Your OPML
on Friday. I wasn't keeping up with many RSS feeds back when the
original...
2006-05-08
1,549 reads
If you were putting together a security awareness training program for
developers, what aspects of SQL Server security would you include?...
2006-05-06
1,837 reads
As of right now, it looks like I'm going to TechEd 2006 in Boston. If you're going to be there...
2006-05-05
1,455 reads
This article appeared just recently on MSDN:
Scaling Out SQL Server 2005
It's a relatively high level document which covers how to...
2006-05-05
1,540 reads
The SysInternals licensing has been updated on the SysInternals website.
The new licensing is something you'll want to take a look...
2006-05-05
1,470 reads
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...
SELECT * feels convenient, but in SQL Server it bloats I/O, burns network bandwidth,...
Comments posted to this topic are about the item Cleaning Up the Cloud
Comments posted to this topic are about the item The Maximum Value in the...
Comments posted to this topic are about the item Oracle Performance Tuning: Practical Techniques...
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