Click here to monitor SSC


Damon Armstrong

SharePoint 2010 to 2013 Search Service Application Upgrade Issue–Action Fails


During the course of upgrading a search application database from SharePoint 2010 to SharePoint 2013 we encountered an error in PowerShell: Microsoft.SharePoint.Upgrade.SPUpgradeException: Action of Microsoft.Office.Server.Search.Upgrade.SearchAdminDatabaseSequence failed And we traced it back down to this error in the ULS: SqlError: ‘The CREATE UNIQUE INDEX statement terminated because a duplicate key was found for the object […]

22 April 2014 1:29 pm by

Looking for participants for deployment process feedback


UPDATE April 22 2014 – Thanks to everyone who got in touch, we now have enough people participating in the UX session so signups are now closed. Thanks again! The Red Gate Database Delivery team is looking for people willing to participate in UX sessions for an exciting, brand new product, with $50 Amazon vouchers […]

16 April 2014 4:39 pm by
Phil Factor

Silos and Monoliths – Moving On to the Past


The presenter positively glowed with enthusiasm as she showed us how easily the schemas collections of documents in MongoDB could follow the changes in the way you structure the data in your application. I was at an interesting presentation recently of MongoDB with .NET. The presenter explained, brightly, that using MongoDB was a liberating experience […]

11 April 2014 1:27 pm by
Simple-Talk Editorial Team

Simple-Talk Roundup April 11


Heartbleed is the big issue of the day, we hope that everyone has changed their passwords and updated their certificates. If you aren’t sure what to do or if you’ve been living under a rock, Troy Hunt’s written a pretty exhaustive blog post about it which you should check out. For a significantly shorter overview, […]

11 April 2014 1:26 pm by
Louis Davidson

What Counts For a DBA – Attire


So, clearly there were a few unrealistic parts of this blog. First, I don’t own a tuxedo. I wore one to a wedding 20 years ago, but that was rented. I don’t even own a suit coat that I would wear. I telecommute and the only thing proper about the way I dress for work […]

1 April 2014 12:00 am by
Simple-Talk Editorial Team

Roundup from Simple-Talk and Beyond – March 31 2014


New Articles We’ve always liked the idea of mixing our more in-depth articles with others that just give  simple answers to  simple questions, or a list of nuggets:  Articles like Plamen Ratchev’s  ‘Ten Common SQL Programming Mistakes’;  Grant Fritchey’s  ‘The Seven Sins against TSQL Performance’, SQL Server Statistics Questions We Were Too Shy to Ask […]

28 March 2014 4:19 pm by
Tony Davis

D.R.Y. with SQL Scripts


Developers strive to write well-tested, reusable code with well-defined interfaces so that when they need to update the functionality, they need do so in one place only. It is the principle of ‘Don’t Repeat Yourself’ (D.R.Y.). However, it is common for developers to be poor at applying D.R.Y. to their own past work. When it […]

28 March 2014 3:54 pm by
Phil Factor

Including timings, I/O and XML Execution plans in your SQL Test rigs


Sometimes, when developing SQL code, you need to run an automated test and benchmark over and over again. In this test run 'with bits',  you want a lot of diagnostic information such as the CPU,  IO,  which can be saved, parsed and compared between runs.  You want the results of the SQL so you can […]

14 March 2014 4:37 pm by
Tony Davis

Build, Buy or Rent?


In the pioneering years of the PC industry, people mainly created for themselves whatever tools they needed, because there wasn’t much of an option. I’ve lost count of the number of developers who claim to have invented their own text editor. These days, we simply buy the product or editing module that best suits our […]

14 March 2014 3:41 pm by
Simple-Talk Editorial Team

Roundup from Simple-Talk and Beyond – March 14 2014


Simple-Talk Updates …in which we give a short review of the latest articles on Simple-Talk  in the past fortnight, dig up some old favourites, and mention some of our favourite articles and blogs from around the InterWebs. This week on Simple-Talk we published the first article by a new author,  Joshua Feierman on ‘Applying The […]

14 March 2014 1:42 pm by
Older posts