SQL servers

Strong authentication is required for this operation

I was in the middle of creation of new Master Data Services (MDS) web application in Master Data Services Configuration Manager when accidently received following error in the log – “Strong authentication is required for this operation”

Continue reading…

Kerberos encryption protocol

In article you will learn how to solve Kerberos encryption protocol related errors. “An error was encountered in the transport layer” or “The target principal name is incorrect. Cannot generate SSPI context.”

Continue reading…

6 reasons to use Azure Data Studio

Azure Data Studio (ADT) is tool for managing SQL Server databases on-prem and Azure SQL databases. There are multiple reasons to use Azure Data Studio. Seems like Microsoft did not want to rewrite its nice and powerful tool SMSS, so they decided to develop new one from scratch with focus on DevOps style of work. After spending some time with it i came up with 6 reasons why use Azure Data Studio.

Continue reading…

Move Registered Servers from SSMS into Azure Data Studio

Azure Data Studio is new cool cross-platform tool. It has several nice features like: connection to different type of databases, run different type of code, integration with version control, create notebooks which can be type of documentation with built in code. But before you start work with this nice tool you probably want to move registered servers from SSMS into Azure Data Studio.

Continue reading…