Tomorrow – Webcast on SQL Server Administration
I will be giving another Microsoft SQL Server-based webcast, this time on the administration of Microsoft SQL Server. The webcast is scheduled for March 26, 2024 at 1 PM...
2024-03-25
16 reads
I will be giving another Microsoft SQL Server-based webcast, this time on the administration of Microsoft SQL Server. The webcast is scheduled for March 26, 2024 at 1 PM...
2024-03-25
16 reads
I will be giving another Microsoft SQL Server-based webcast, this time on the administration of Microsoft SQL Server. The webcast is scheduled for March 26, 2024 at 1 PM...
2024-03-15 (first published: 2024-03-08)
307 reads
I try to keep an eye on the Humble Bundle bundles for books. The bundles serve two great purposes: I was able to grab the Cybersecurity bundle, but by...
2024-02-26
124 reads
Last week, the Cybersecurity & Infrastructure Security Agency (CISA) put out an emergency directive which ordered federal agencies to pull Ivanti Connect Secure and Ivanti Policy Secure installations from...
2024-02-23 (first published: 2024-02-05)
190 reads
I first saw this at Schneier on Security. David Kahn, author of The Codebreakers, has passed away at 93. The Codebreakers was considered the best book on the history...
2024-02-05
40 reads
The first issue of 2024 for the ISACA Journal has been published and the articles are available both in written and on-line format. I have a regular column on...
2024-02-02
21 reads
I’ve known Eugene Meidinger (SQLGene) for a number of years and we share a lot of interests outside of technology. We’re both avid boardgame and card game players, though...
2024-01-31
59 reads
If you aren’t familiar with the ATT&CK framework and knowledge base, it’s a tool to help classify and understand cyberattacks. Recently (Oct 2023), ATT&CKcon 4.0 was held and MITRE...
2024-01-29
10 reads
Understanding query plans is key to successful query tuning in Microsoft SQL Server. Randolph West of the Microsoft docs team posted on Thursday that the logical and physical showplan...
2024-01-26
41 reads
So what did I learn? I think a better question is, "What did I re-learn?"
2024-01-26 (first published: 2024-01-09)
233 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