Playing with Always Encrypted – SQL 2019
After a reading about Always Encrypted, I was curious to see if there would be any performance impact by enabling it for any type of...
Author: admin
“[DbId:XX] ADR enabled for the database.” logged all the time in ErrorLog – BUG SQL 2019
We were testing ADR in a two SQL Server 2019 CU 4 Developer Edition servers, with a AG setup. After enabling ADR for every database...
Multisubnet Failover – Sqlcmd: Error: Microsoft SQL Server Native Client 11.0 : Connecting to a mirrored SQL Server instance using the MultiSubnetFailover connection option is not supported..
We are setting up an AG in AWS. Our setup includes a listener with 3 different subnets, therefore to speed up the client re-connection in...
DBCC CHECKDB – Object being checked
I was struggling to find which object the CHECKDB was processing. If there is a latch, we can get the waitresource and find out, but...
SQL Server 2019 – Polybase MongoDB
Hi Guys, Following the release of new SQL Server 2019 and it’s new feature, Polybase MongoDB connector, I decided to give it a try. I...