Brian Kelley

Brian Kelley is an author, columnist, and Microsoft SQL Server MVP focusing primarily on SQL Server security. He is a contributing author for How to Cheat at Securing SQL Server 2005 (Syngress), Professional SQL Server 2008 Administration (Wrox), and Introduction to SQL Server (Texas Publishing). Brian currently serves as an infrastructure and security architect. He has also served as a senior Microsoft SQL Server DBA, database architect, developer, and incident response team lead.

Interests: Chess, Reading, Soccer (Football), Baseball, Animals, Theology

More on that Cyberwar

by Brian Kelley

Databases – Infrastructure – Security

As a follow-up to my post on being at war, cyberwar:
State Department Hacked
If the experts are correct, this trend is...

2014-11-18

576 reads

Generalists vs. Specialists

by Brian Kelley

Databases – Infrastructure – Security

I’ve stated quite often that being a generalist has generally been beneficial for my IT career (pun intended). That’s why...

2014-11-13 (first published: 2014-11-06)

7,233 reads

We’re at War – Cyberwar

by Brian Kelley

Databases – Infrastructure – Security

In case you’ve not been following the news with regards to *government* breaches:
White House computers hacked – Russia suspectedUS Postal Service...

2014-11-13

747 reads

Speaking at SQL Saturday #354 – Charleston, SC

by Brian Kelley

Databases – Infrastructure – Security

If you’re looking to warm up for the winter, come on down to Charleston, SC, on December 13, 2014. Charleston...

2014-11-12

642 reads

Consolidating Email Accounts

by Brian Kelley

Databases – Infrastructure – Security

I am consolidating my professional email accounts into one place. If you’ve previously contacted me using my linchpinpeople.com or either...

2014-10-21

526 reads

SQL Server Security Benchmarks

by Brian Kelley

Databases – Infrastructure – Security

If you’re not familiar with the Center for Internet Security, here’s the organization’s mission statement:
The Mission of the Center for...

2014-10-20

865 reads

#TSQL2sday #59 – My Heroes

by Brian Kelley

Databases – Infrastructure – Security

Here is my list of heroes for #TSQL2sday. None of them are directly tied to technology, much less SQL Server....

2014-10-14

537 reads

Slides and Code for SSIG Talk

by Brian Kelley

Databases – Infrastructure – Security

Thank you for those who made it out to the SQL Server Innovators Guild last night in Greenville, SC. I...

2014-10-08

599 reads

The Fallacy of Internal Access Only

by Brian Kelley

Databases – Infrastructure – Security

In the wake of Shell Shock, I’ve seen some vendor advisories indicate that while their product is vulnerable, it’s only...

2014-10-07 (first published: 2014-09-30)

7,112 reads

Carolina Technology Conference: Presentation Materials

by Brian Kelley

Databases – Infrastructure – Security

For those able to attend my session at this year’s Carolina Technology Conference, thank you! As promised, here are the...

2014-10-06

793 reads

Blogs

A New Word: Ecstatic Shock

ecstatic shock – n. a surge of energy upon catching a glimpse from someone...

The CDO’s Playbook for AI Driven Decision Making

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

By davidfowler-42596

Presenting you with an updated version of our sp_snapshot procedure, allowing you to easily...

Read the latest Blogs

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

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Cleaning Up the Cloud

Visit the forum

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-06

I 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