2023-09-06
344 reads
2023-09-06
344 reads
This week Steve found a question of whether SQL Server 2019 uses more CPU than 2016.
2023-04-01
640 reads
2021-09-08
767 reads
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 […]
2020-11-24
47,549 reads
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
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,198 reads
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)
31,721 reads
2018-03-13
960 reads
2018-02-15
897 reads
Erik Darling looks at how SQL Server 2016's live query plans react when they're blocked.
2017-11-01
3,227 reads
By Steve Jones
redesis – n. a feeling of queasiness while offering someone advice, knowing they might...
By Steve Jones
The Solutions Engineers at Redgate recently released an Introduction to Redgate Flyway Autopilot course...
The other day I came across an interesting repo on github, KubeDiagrams. What this...
Hi there to all SQL gurus So, here is the scenario. I have a...
Guys, I am facing problems when running a backup routine JOB in SQL Server,...
1, Customer table [TBLMEMBER] 's structure CREATE TABLE [dbo].[TBLMEMBER]( [TRANNO] [int] IDENTITY(1,1) NOT NULL,...
What is the result of this query in SQL Server 2022+?
select bit_count('7')See possible answers