CLR Strict Security in SQL 2017
SQL Server 2017 has enhanced the security requirements for using CLRs. Read on to see what I ran into, and how I was able to get CLRs to work!
The...
2019-01-21
14 reads
SQL Server 2017 has enhanced the security requirements for using CLRs. Read on to see what I ran into, and how I was able to get CLRs to work!
The...
2019-01-21
14 reads
Automate All the Things
I had a strange thing happen to me this week. My IFTTT applet that sends me an...
2019-01-08
170 reads
From a DBA's perspective, automation is something that is absolutely necessary. This post shows just a few areas where I use automation in my life.
The post T-SQL Tuesday #110...
2019-01-08
7 reads
Influence Somebody
Ahh, December. What a wonderful time. Snow all around (many along the eastern seaboard of the United States were...
2018-12-12
152 reads
Influence Somebody Ahh, December. What a wonderful time. Snow all around (many along the eastern seaboard of the United States were hit Sunday by a snowstorm… I had 7?...
2018-12-12
4 reads
Next, Advent of Code 2018 – Day 6
As I explained in a recent post, I’m participating in this year’s Advent of...
2018-12-07
236 reads
Next, Advent of Code 2018 – Day 6 As I explained in a recent post, I’m participating in this year’s Advent of Code challenge, with the twist of doing...
2018-12-07
7 reads
Advent of Code 2018 – Day 3
As I explained in a recent post, I’m participating in this year’s Advent of Code...
2018-12-06
224 reads
A T-SQL approach to solving the 2018 “Advent of Code” programming challenge. This solution includes a physical tally table.
The post Advent of Code 2018 – Day 3 (Slicing) appeared...
2018-12-06
3 reads
Advent of Code 2018 – Day 5
As I explained in a recent post, I’m participating in this year’s Advent of Code...
2018-12-05
849 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