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...
“[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...
What time did you start to work today?
Following the same idea and structure of the previous post, with this one we will get the first time in the current day our machine...
Monitor Event Viewer Security Log – Powershell
These days, in a corporate environment, more people than you think have access to your PC. They could access it via RDP or even as...
[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...