Patching SQL Server with Integration Services (SSIS) installed together with AlwaysOn Availability Group

Availability Group Upgrade in HADR Scenario

I recently ran into an issue while patching a SQL 2012 AlwaysOn Cluster. The installation of service pack 3 would fail, with the following error message(s): Database ‘SSISDB’ cannot be opened due to inaccessible files or insufficient memory or disk Continue reading Patching SQL Server with Integration Services (SSIS) installed together with AlwaysOn Availability Group

SharePoint and SQL 2012 Always On – Remember to Sync you logins across Replicas !

SQL Synchronize Logins

I recently ran into a problem at one of our customers. I won’t bother you with details and come straight to the point. Let’s say you have successfully created a SQL 2012 Always On Availability group and configure SharePoint to Continue reading SharePoint and SQL 2012 Always On – Remember to Sync you logins across Replicas !

List of links containing SQL Tuning tips for SharePoint 2013

via:SharePoint Bit Me. Tuning SQL Server 2012 for SharePoint 2013: (01) Key SQL Server and SharePoint Server Integration Tuning SQL Server 2012 for SharePoint 2013: (02) Best Practices for SQL Server Database Settings Tuning SQL Server 2012 for SharePoint 2013: Continue reading List of links containing SQL Tuning tips for SharePoint 2013

Maximizing SQL 2012 Performance for SharePoint 2013 WhitePaper

Abstact As a SharePoint Consultant I get to see dozens of SharePoint farms every year, and one of the most common complaints I get from clients – is that SharePoint is slow. A lot of people think that SharePoint is Continue reading Maximizing SQL 2012 Performance for SharePoint 2013 WhitePaper

How To Delete an “Orphan” Content Type? (The content type “CT1” is part of an application feature)

Problem I created a set of content types from a feature and after the installation, activation of this feature, I used (in list or document libraries) all content types contained in this feature but one, called CT1 for instance After Continue reading How To Delete an “Orphan” Content Type? (The content type “CT1” is part of an application feature)

Issues and Benefits Implementing SharePoint 2013 using SQL Server 2008 R2 vs SQL Server 2012 SP1

Issues and Benefits Implementing SharePoint 2013 using SQL Server 2008 R2 vs SQL Server 2012 SP1 – SammyKailini – Site Home – TechNet Blogs. As many of our customers are getting ready to deploy SharePoint 2013, choosing the appropriate version Continue reading Issues and Benefits Implementing SharePoint 2013 using SQL Server 2008 R2 vs SQL Server 2012 SP1