Test if a SQL table exists with PowerShell
Use Case Occasionally when managing large numbers of SQL Instances and thousands of databases, you have to do some checks prior to running a query against them. One of the …
Recovering a SQL 2012 cluster from a corrupt master database
Emergency support can be a bit stressful, especially out of hours on a system you’ve never worked on before. We recently needed to step in to help a customer …
Error while trying to restore SQL database to a cluster
After a major round of engineering work on a large SQL cluster the DBA’s noted that they were unable to restore databases on one the clustered SQL instances. When …
Edition downgrade for SharePoint Search Server Express 2010 from SQL 2008 R2 Enterprise to SQL 2012 Express
This is just a quick post to highlight issues with two SharePoint Search Server Express 2010 databases when downgrading from SQL 2008 R2 Enterprise to SQL 2012 Express (although applies …
When cliconfg.exe didn’t work for changing the SharePoint DB
Everyone knows that using SQL connection alias’s are a pretty good idea, as are A records in DNS for when you want to be able swap around your SQL server …
Issue while installing SP1 on a SQL 2008 R2 Cluster–Resolved
Came across this odd issue yesterday while patching a SQL 2008 R2 failover cluster. After moving over all the services to the passive node the service pack failed to install …
Installing the SQL Server 2008 R2 Service Pack 1 Community Technology Preview
This week saw the CTP release of SQL Server 2008 R2 SP1 which combines all fixes to date for SQL 2008 R2 up to Cumulative Update 6 (CU6), and fixes …
Microsoft Partner Business Briefings – Transitioning to the Cloud
5/10 @ https://partner.microsoft.com/UK/40127070 – ‘Transitioning to the Cloud’ featuring Steve ‘Developers!’ Ballmer As a UK Microsoft Gold partner (www.thefullcircle.com) staying up to date with the latest trends in technology, and …
Training: 44CO175 – SharePoint 2010 Administrator Bootcamp
44CO175 – SharePoint 2010 Administrator Bootcamp (BPIO) Summary Step-by-step understanding is key to successfully implementing and deploying SharePoint 2010. This 15-module course will guide you through each critical stage, giving …
Training – SQL Server MasterClass (Kim Tripp & Paul Randal – www.SQLskills.com)
As posted many times before, continous professional development through training and education is absolutely core of our IT consulting business, The Full Circle (www.thefullcircle.com). Today is a good day for …