Tag Archives: 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 »

Step-By-Step Easy Instructions on How to Create a SQL Server 2016 AlwaysOn Availability Group

SQL Server AlwaysOn Availability Group has been existing since SQL Server 2012 and its one of the best features SQL has to offer, while I haven’t used it in production since it was launched I tried using it for only testing but now that we have an Enterprise License we can use it in Production… 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 »

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 »

Live Migration of SharePoint 2010 to SharePoint 2013

This post will give you a step by step process on how you upgrade your SharePoint 2010 to SharePoint 2013.  While this is a live migration I suggest you do proper backups of the server and the database before continuing.  Having said that live migration means that you can upgrade your SharePoint instance from one… Read More »

Transfer Users from one SQL Server to another including SID’s the easy way

Before I wrote an article regarding this one but it seem that was the hard way of doing it.  See the article here http://www.macaalay.com/2012/10/11/how-to-synchronize-loginsusers-between-mirrored-servers/ , but recently I was playing with SSIS in Visual Studio and found out that there is an easy way of doing it without complicated scripting and can all be achieved in… Read More »