2023-09-06
355 reads
SQL Server 2016
Has SQL Server Performance Improved?
This week Steve found a question of whether SQL Server 2019 uses more CPU than 2016.
2023-04-01
720 reads
2021-09-08
823 reads
Fixing "Login failed for user" error in SQL Server
In this article, I am going to explain fixing a problem related login failure error with SQL Server. The Problem One of the common error in the SQL Server error log is "Login failed for user 'DomainName\ServerName$'. Reason: Could not find a login matching the name provided. [CLIENT: <local machine>]". Even though it says that […]
2025-12-31 (first published: 2020-11-24)
54,687 reads
Converting a History Table into a System-Versioned Temporal Table
Temporal tables were introduced with SQL Server 2016. To take advantage of this feature, you might start fresh with a brand new table. It is possible, however, to convert an existing table with accumulated history to the new functionality. In this article, Mala Mahadevan explains how to create temporal tables for both scenarios.
2019-04-01
Approaches to Import JSON in SSIS (SQL Server 2016+) Part 2
In this article, 2nd of 2-part series, we will look at the 3rd approach to import JSON, recap both parts of the series and form a conclusion.
2020-03-20 (first published: 2018-08-27)
6,542 reads
Approaches to Import JSON in SSIS (SQL Server 2016+) Part 1
In this article, 1st of 2-part series, we will look at 2 approaches to import JSON in SSIS using 2 methods: the new functionality of SQL Server 2016 and the Json.NET library.
2020-03-13 (first published: 2018-08-20)
32,570 reads
2018-03-13
970 reads
2018-02-15
909 reads
Live Query Plans and Blocking
Erik Darling looks at how SQL Server 2016's live query plans react when they're blocked.
2017-11-01
3,227 reads
Blogs
SQL Server Journey Part 2: Modern Era (2017 – 2026) – AI/Cloud First
By Vinay Thakur
Following up on my Part 1 baseline, the journey from 2017 onward changed how...
Google Moves Up Post-Quantum Cryptography Timeline
By Brian Kelley
In cryptography, the RSA and ECC algorithms which we use primarily for asymmetric cryptography...
The Book of Redgate: No Politics
By Steve Jones
In today’s world, this might mean something different, but in 2010, we had this...
Forums
An Unusual Identity
Comments posted to this topic are about the item An Unusual Identity
Prompt Requests
Comments posted to this topic are about the item Prompt Requests
T-SQL in SQL Server 2025: JSON_OBJECTAGG
Comments posted to this topic are about the item T-SQL in SQL Server 2025:...
Question of the Day
An Unusual Identity
What values are returned when I run this code?
CREATE TABLE dbo.IdentityTest2
(
id NUMERIC(10,0) IDENTITY(10,10) PRIMARY KEY,
somevalue VARCHAR(20)
)
GO
INSERT dbo.IdentityTest2
(
somevalue
)
VALUES
( 'Steve')
, ('Bill')
GO
SELECT top 10
id
FROM dbo.IdentityTest2 See possible answers