Reminder: #SQLChat at lunch today
This is a reminder that we’ll having a #SQLChat this afternoon at 12 PM EDT. Here are the details:
SQLChat: Do...
2016-09-07
427 reads
Brian Kelley
- Interests: Chess, Reading, Soccer (Football), Baseball, Animals, Theology
SQLChat on Wednesday, Webinar on Thursday!
I’m participating in two community activities this week. One is a #SQLCchat on Twitter and the other is a webinar...
2016-09-06
356 reads
I wrote a SQL Server auditing whitepaper!
I recently collaborated with Idera to produce a short whitepaper on the top 5 things to audit in SQL Server...
2016-07-27
1,019 reads
Not More Than 16 Characters?!?
Microsoft, you’re killing me. This is the warning I received when typing in a password for Office 365:
I blinked when...
2016-06-16 (first published: 2016-06-10)
4,066 reads
Protecting Against Delete without Where
If I’m doing any manual work with T-SQL, I always begin every set of data change operations with BEGIN TRAN...
2016-06-13 (first published: 2016-06-09)
3,627 reads
A Different Type of Currency
Recently, a member of the community lamented that folks weren’t willing to provide an email address for free training. This...
2016-06-09
443 reads
Sights that just scream, “No!”
I’m at a conference, specifically a security conference. So I looked at the available WiFi connections. Among the conference and hotel specific...
2016-06-07
451 reads
Slides from 2016 Techno Security & Mobile Forensics Conference
I’ve completed both of my presentations at the 2016 Techno Security and Forensics Investigation Conference (#technosecurity). If you were able...
2016-06-07
513 reads
Congrats to MSSQLTips on 10 Years!
MSSQLTips has posted about their 10 years as a resource to the SQL Server community. It’s where I do the...
2016-06-06
546 reads
Stored Procedures and SQL Injection
Why do stored procedures help with security? In this piece, MVP Brian Kelley explains why SQL Injection and information gathering are hampered with stored procedures.
2015-06-12 (first published: 2013-02-18)
21,016 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