Midlands PASS Meetings for January and February 2019
Midlands PASS won’t be holding a meeting in December. Too much going on! However, we are hosting meetings in January...
2018-11-27
200 reads
Midlands PASS won’t be holding a meeting in December. Too much going on! However, we are hosting meetings in January...
2018-11-27
200 reads
Microsoft redid its Data Science Track not too long ago and they added several courses and new progress points. One...
2018-11-19 (first published: 2018-11-08)
2,779 reads
For those of us who have been on twitter for a long time, we are familiar with the #sqlhelp hashtag....
2018-11-07
285 reads
I’m always on the looking our excellent training, especially free training. Tim Mitchell, Microsoft Data Platform MVP, (twitter | website) has...
2018-10-29
267 reads
If you attended either of my presentations for this past IT/Dev Connections, here are the promised slides and scripts.
As I...
2018-10-23
241 reads
This month’s #SQLChat is hosted by Rie Irish (twitter | blog). It’s a timely topic: Making the Most of Conferences. With...
2018-10-22
209 reads
If you’re in or near the Columbia, SC area, we are rebooting the Midlands PASS Chapter. Here is our first...
2018-09-19
622 reads
With Hurricane Florence no longer a hurricane, we have rescheduled the webinar for next Wednesday, September 26, 2018.
Free sign up...
2018-09-19
212 reads
Hello! The webinar I was going to give this coming Thursday with MSSQLTips.com has been postponed. When we have a...
2018-09-11
220 reads
In six words, can you give a compelling description of your data?
I’m taking the Microsoft DAT248x course as part of...
2018-08-30
317 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,...
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
Comments posted to this topic are about the item The Maximum Value in the...
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