2013 Carolina Code Camp Presentations
As promised, here are the presentations and sample code I used at the 2013 Carolina Code Camp. If you attended...
2013-05-06
1,011 reads
As promised, here are the presentations and sample code I used at the 2013 Carolina Code Camp. If you attended...
2013-05-06
1,011 reads
On Saturday, May 4, the Enterprise Developers Guild in Charlotte will hold their annual Carolina Code Camp. There's a number...
2013-04-23
876 reads
For this month's T-SQL Tuesday, Bob challenges us to discuss how we came to love presenting. Here's my story.
I developed a...
2013-04-19 (first published: 2013-04-09)
1,954 reads
This should go without saying, because most of us have been on the receiving end of poor customer support. However,...
2013-04-05
1,027 reads
There was an interesting conversation on Twitter today about security awareness and why the training so often fails. From my perspective, here's...
2013-04-05 (first published: 2013-03-28)
3,322 reads
Here are some training events you might be interested in for the coming week:
Tuesday, April 2
11:00-12:00 EDT, Introduction to SQL...
2013-03-29
1,596 reads
When it comes to workstations within most organizations, the solution when one gets infected is to wipe it and re-image...
2013-03-27
2,657 reads
If you're located relatively near the Atlanta, Georgia area, I wanted to bring your attention to data warehousing training on...
2013-02-18
1,102 reads
I used to compile a list of online training for the following week and posting it on Fridays. I stopped...
2013-02-14
1,006 reads
I was recently asked by a project manager to lay out when DBAs would accomplish certain tasks for a particular...
2013-02-07
1,410 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