Tag Archives: Microsoft SQL Server

Workaround for Adding Encrypted Databases by a Database Master Key on High Availability Groups without a password

Have you ever encountered this error when you are trying to add a database on your Always On Availability Groups? “This database is encrypted by database master key, you need to provide valid password when adding it to the availability group.” You get this on the Wizard after warning you that a Password is required… Read More »


How to create Data driven report subscriptions in SQL Server Standard Version

I guess you are here because you are looking for a solution that will send your SSRS reports via email to a dynamic recipient list related to your data in your SSRS report.  In SQL Servers Business Intelligence and Enterprise Edition this feature is included but if you use a lower edition like Standard and… Read More »


How to Archive SharePoint List Items to SQL Server

You might have reached the threshold of a SharePoint List and you’re afraid to increase the limit as you might affect the performance of you server.  Now you are thinking of other solutions and one thing came to mind, why not archive the data? Well that is a good idea but how are you going… Read More »

How to use Secure Store Service in an External Content Type in SharePoint Foundation 2013

When SharePoint Foundation 2013 was released and you saw Secure Store Service is included you almost jumped in joy as you know this will give you a lot of possibilities. You then started to tinker by creating a new page and a new external content type that can connect to your database.


Installing Integrated Reporting Services on Sharepoint 2013 in 7 easy steps

1. Install Reporting Services in SharePoint mode. Get your SQL Server installation media, go to the New SQL Server stand-alone installation or add features to an existing installation then select the following Reporting Services – SharePoint Reporting Services add-in for SharePoint Products SQL Server Data Tools Management Tools – Basic Management Tools – Complete continue… Read More »

Sorry, something went wrong error in Sharepoint 2013

You might have upgraded your Sharepoint to 2013, have this “Sorry, something went wrong error” and you don’t know whats causing it.  This was my issues several week ago when I migrated our Sharepoint.  I looked at the old version and it all works fine but on the new instance it does not work, I checked everything and compare… Read More »