2021-09-08
703 reads
2021-09-08
703 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
11,831 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)
4,763 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)
24,278 reads
2018-03-13
948 reads
2018-02-15
886 reads
Erik Darling looks at how SQL Server 2016's live query plans react when they're blocked.
2017-11-01
3,227 reads
In this post, Koen Verbeeck shows how to use SQL Sever 2016's Extended Events to find the query plan for a DAX query, just like you would for a T-SQL statement.
2017-10-27
3,058 reads
SQL Server 2016 introduced a new feature called Distributed Availability Group. A Distributed Availability Group is a special type of Availability Group that spans two separate Availability Groups. Edwin Sarmiento explains.
2017-09-08
4,129 reads
By Steve Jones
I started to add a daily coping tip to the SQLServerCentral newsletter and to...
By Kamil
Hello, data friends! Let me spread a few words about the new MVP led...
By Steve Jones
I started to add a daily coping tip to the SQLServerCentral newsletter and to...
Each query in power bi report has it's own connection string. If something wrong...
Hi, I have a query like "Select tablenumber from a table" Tablenumber 1 2...
Hi there, we have SQL Server 2014 (Build - 12.0.6259.0) and my database have...