Availability Group Database Reports Not Synchronizing / Recovery Pending After Database Log File Inaccessible

First published on MSDN on Nov 29, 2017

You may find that one or more availability group databases is reported

‘Not Synchronizing / Recovery Pending’ on the primary replica

or

‘Not Synchronizing’ on one of the se… Continue reading Availability Group Database Reports Not Synchronizing / Recovery Pending After Database Log File Inaccessible

Changes to hashing algorithm for self-signed certificate in SQL Server 2017

First published on MSDN on Nov 08, 2017

Starting with SQL Server 2005, a self-signed certificate is created automatically during the startup to be used for channel encryption. By default, credentials in the login packet that are transm… Continue reading Changes to hashing algorithm for self-signed certificate in SQL Server 2017

“Unexpected error from external database driver (1). (Microsoft JET Database Engine)” after applying October security updates.

First published on MSDN on Oct 18, 2017

UPDATE: As informed, the security patches with the fix was rolled-out yesterday 11/14. We would request you to test this and verify that the issue is addressed. If not, please let us know. Pl… Continue reading “Unexpected error from external database driver (1). (Microsoft JET Database Engine)” after applying October security updates.

ARM Resource Manager Template Deployment with Azure Analysis Services

First published on MSDN on Sep 27, 2017

Analysis Services model can be deployed in Azure in different ways like from SSDT or by running the JSON create script from SSMS.

We can leverage the richness of template deployment in ou… Continue reading ARM Resource Manager Template Deployment with Azure Analysis Services