The Ireland and UK DevOps Roadshow
We’re taking the roadshow across the water. Hope the plane makes it. The Redgate DevOps Roadshow comes to Ireland and the Northern UK in June. We’ll be in these...
2024-05-16
13 reads
Blog Posts
Microsoft Fabric shortcuts
I talked about Microsoft Fabric shortcuts in my blog post Microsoft Fabric – the great unifier (where I have updated the picture with the newest supported sources) and wanted...
2024-05-15 (first published: 2024-05-01)
390 reads
SQL Aggregate Functions: Your Essential Guide & Cheat Sheet
SQL aggregate functions are your go-to tools for transforming raw data into actionable insights. They condense multiple rows into single, meaningful values, making it easier to grasp the big...
2024-05-15
322 reads
Will AI Replace SQL Developers? The Answer Might Surprise You!
The world of databases keeps growing, and the pressure to extract meaningful insights from that data increases just as fast. If you work with data, you know that SQL...
2024-05-15 (first published: 2024-05-01)
1,178 reads
Getting Error 64 When Trying To Connect to SQL Server or Azure
Often times when working with a client, I’ll run into issues or get emails from a client with a message like the following: A connection was successfully established with...
2024-05-14
14 reads
Friday Basics: the CIA Triad
In information security (INFOSEC), there several foundational concepts and principles. One of the ones that’s introduced almost immediately is called the CIA triad or the Information Security Triad. While...
2024-05-13 (first published: 2024-04-26)
226 reads
T-SQL Tuesday 174 - Your Favorite Job Interview Questions
T-SQL Tuesday is a monthly blog party hosted by a different community member each month. This month, Kevin Feasel
(blog | twitter) asks us about job interview questions.
What is your...
2024-05-13
8 reads
Use a slicer to filter a visual based upon a measure in Power BI
Have you ever wanted to filter a visual by selecting a range of values for a measure? You may have found that you cannot populate a slicer with a...
2024-05-13 (first published: 2024-05-01)
288 reads
5 Advanced Online SQL DBA Training Courses to Learn in 2024 and Beyond
Buckle up, database wranglers! Nowadays, SQL DBAs hold the keys to a company's most valuable asset: their information. But basic SQL knowledge won't get you far when it's time...
2024-05-11
53 reads
A New Word: ioia
ioia – n.the wish that you could see statistics overlaid on every person you encounter – checking the signal strength of their compatibility, a measure of their trustworthiness. I...
2024-05-10
17 reads
Blogs
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...
SELECT *
SELECT * feels convenient, but in SQL Server it bloats I/O, burns network bandwidth,...
Forums
FARE LABS Pvt. Ltd. is an Indian proficiency testing laboratory.
India's top proficiency testing facility is Fare Labs. We employ particular metrics or evaluations...
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