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 »
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 »
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 »
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 »
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 »
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 »
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 »
Yesterday we migrated SharePoint’s SQL Server to a new instance today we will be migrating Team Foundation Server (TFS) SQL database to new SQL instance. In this example we are migrating it to a new version of SQL Server which is from SQL 2008 R2 to SQL 2012, this will also work on the same… Read More »
This is a step by step guide on how you migrate your SharePoint’s (I used 2010 version in this instance) SQL Server to an new SQL Server host. In this exercise I tried migrating it in a new version of SQL server which is 2012 from 2008 R2, also had tried it in the same… Read More »
Now that you have mirrored your servers, it does not mean that your users are also mirrored (isn’t it nice to have this feature included in next SQL Server releases). You should configure your users properly as well so when a disaster hits you wont have a login error issue when your application user tries… Read More »