Toolbox - Just the Basics
There are many query sets out there to collect varying groups of configuration data - the ones I most frequently use...
2018-03-29
694 reads
Nebraska SQL from @DBA_ANDY
Which Blogs Do I Recommend?
One of the most important parts of continuing learning as a DBA (or probably an IT Professional) is reading blogs. ...
2018-03-07
369 reads
Error 33206 - SQL Server Audit Failed to Create the Audit File
One of the joys of working with SQL Server is the descriptive and meaningful error messages, right?
https://vignette.wikia.nocookie.net/batmantheanimatedseries/images/a/a7/DiD_39_-_Joker_Vision.jpg/revision/latest?cb=20160610021326
Exhibit A - the 33206:
Error:...
2018-03-13 (first published: 2018-03-05)
16,395 reads
Toolbox - Which Clerk Is Busy?
A few years ago I wrote what would turn out to be my most-hit blog post (so far) titled "Error...
2018-02-07
388 reads
Toolbox - Why is My Database So Big????
I have written previously (here)about how to tell which database files have free space in them when your drive starts...
2018-01-19
3,732 reads
T-SQL Tuesday #98 – Take Small Bites!
https://media.makeameme.org/created/mega-bytes-well.jpgIt's T-SQL Tuesday time again - the monthly blog party was started by Adam Machanic (blog/@AdamMachanic) and each month someone different...
2018-01-09
545 reads
Come to SQL Saturday Providence!
Tomorrow 12/09/2017 is SQL Saturday #694 in Providence, RI.
I will be presenting by SQL Server Health Check session first thing...
2017-12-08
357 reads
PASS Summit 2017 - Live and in Living Color!
UPDATE - the feed and schedule are live at http://www.pass.org/summit/2017/PASStv.aspx
http://rochistory.com/blog/wp-content/uploads/2014/09/NBC-logo.pngNot in Seattle for some reason this week? Like maybe you stayed home...
2017-11-01
437 reads
But I Don't *Want* To "Restore from a backup of the database or repair the database!"
Do you like Log Shipping?
Before my time at Ntirety I had done quite a bit of work with failover clustering...
2017-11-02 (first published: 2017-10-23)
3,227 reads
And YOU Get a Deadlock and YOU Get a Deadlock and EVERYBODY GETS A DEADLOCK!
https://memegenerator.net/img/instances/400x/59507872/you-get-a-deadlock-everybody-gets-a-deadlock.jpgWe all get them at one point or another - deadlocks.
I have Object 1 and need Object 2, you have Object...
2017-10-26 (first published: 2017-10-18)
3,560 reads
Blogs
A New Word: Ecstatic Shock
By Steve Jones
ecstatic shock – n. a surge of energy upon catching a glimpse from someone...
The CDO’s Playbook for AI Driven Decision Making
By Chris Yates
The New Arena of Leadership The role of the Chief Data Officer is no...
sp_snapshot – The easy way to take database snapshots of one or more databases – V3.0
Presenting you with an updated version of our sp_snapshot procedure, allowing you to easily...
Forums
Arc Enabled SQL Server
Just saw the "Azure Extension for SQL Server" Does anyone has experience with it?
Recursive Select - What is this really doing
I've noticed several instances of what looks like a recursive insert with the format:...
Cleaning Up the Cloud
Comments posted to this topic are about the item Cleaning Up the Cloud
Question of the Day
The Maximum Value in the Identity Column
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 OFF
I now run this code.
DBCC CHECKIDENT(TravelLog)
GO
INSERT dbo.TravelLog
(
CityID,
StartDate,
EndDate
)
VALUES
(4, '2025-10-14', '2025-10-17')
GO
What is the value for TravelLogID for the row I inserted for CityID 4 and dates starting on 14 Oct 2025?
See possible answers