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...
Category: SQL Server
“[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...
[Unresolved] – OLAP Linked Server – Connection taking too long (60 seconds) to be established
Here is a funny issue with our OLAP Linked Server to Analysis Services. When I run “EXEC sp_testlinkedserver N’OLAP_SERVER'” or just right click on the...
The version of the report server database is either in a format that is not valid, or it cannot be read. The found version is ‘164’. The expected version is ‘165’. (rsInvalidReportServerDatabase)
It is the second time we get that message after applying a CU or SP on SQL Server 2014. Apparently, the update process does not...
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...