Archive

So in case you’re like me and assumed you’d do this through the SQL Server Management Studio interface, you’re unfortunately wrong.  This is actually accomplished through the far less logical process of “Uninstalling a Program”.  I’ll help you through the steps here. Go to your Control Panel, and under Programs and Features, find your SQL …

Using a SQL Server alias, you’ll be able to change the database server in your SharePoint farm.  In addition, setting an alias should really be a best practice for most new farm builds.  This technique is useful when moving or virtualising your database server, setting up a test environment, or especially when migrating from SQL …

The article below describes how if your underlying SQL server’s IO performance is crap, you can expect that your SharePoint performance will suck too. http://searchcontentmanagement.techtarget.com/feature/SharePoint-performance-sinks-swims-with-SQL-Server-throughput

Much has been blogged about SQL Server 2008 / 2008 R2 Antivirus exceptions when using SharePoint 2010, but no one seems to have blogged the SQL Server 2012 exceptions.  That being the case, I figured I might as well be the one to do it.  Below you’ll find a list of all the files. **Important …