Tag Archives: SQL Server

Unique Column that Allows Null Value in SQL

Well its been quite sometime now since our last post, was so busy with lots of things now that I manage three teams, Development, Operations and Project Management.  My programming activity drastically went down as I do a lot of juggling between three roles plus managing them, imagine a portfolio of 63 projects last year… Read More »

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 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 »