Click here to monitor SSC


Simple-Talk Editorial Team

Caption Competition 48 – Out of Water


Oh dear, this lot don’t look best pleased – but you could! Leave a caption in the comments, and if we think it’s the funniest of the lot you’ll win an Amazon gift card worth $50! The winner will be announced in the next newsletter on February 29th.

12 February 2016 1:21 pm by
Tony Davis

Does Anyone Do This Stuff


“Does anyone actually do this stuff?” This question came from a member of the audience at one of Brent Ozar’s training classes on SQL Server Database Continuous Integration. Mercifully, plenty of people confirmed in the comments that Database CI was alive and well, which was a relief, since I’d been toiling for several days on […]

11 February 2016 6:00 pm by
Damon Armstrong

SharePoint CSOM and “The node to be inserted is from a different document context.”


There are a few reasons you can get the “The node to be inserted is from a different document context.” error, and most of them appear to involve updating certain types of fields multiple times in the same request.  Here is an example: using (var clientContext = new ClientContext(“UrlToYourSite”)) {    //Load all fields   […]

10 February 2016 5:16 pm by
Damon Armstrong

Fixing the "The operation took too long" Error in O365


I was attempting to deploy a provider-hosted application to my O365 instance and it was failing with an extremely helpful message reading “The operation took too long”.  In the past, we’ve seen situations where a remote event receiver took too long to execute, but the message that comes back says something about the remote event […]

5 February 2016 9:02 pm by
Carly Meichen

What’s in Your Project Folder?


I think that almost every developer likes to try out a new computer language occasionally. Many devs that I’ve spoken to tend to write the same application in each language, over and over again. An expression analyzer is one I get told about. Others like to write a pocket calculator simulator, or maybe a to-do […]

4 February 2016 4:50 pm by
Damon Armstrong

Fixing the File Not Found Error Opening a SharePoint Site with Spaces in the URL using Site.OpenWeb


I was investigating a bug in the SharePoint app I’m working on where a function was failing on sites with URLs containing spaces.  Although I’m not a fan of creating sites with spaces in the URL, SharePoint lets you do it so it’s going to happen.  At first, I thought the issue would be easy […]

28 January 2016 9:32 pm by
Tony Davis

A Database to Diagram for


I’m no database designer but I do occasionally need to build a very simple database model, no more than a small handful of tables, to test out some code for an article or presentation. The other day, I was indulging in my usual habit of slowly tapping out CREATE and ALTER TABLE statements in SQL, […]

28 January 2016 6:00 pm by
Simple-Talk Editorial Team

Caption Competition 47 – Killer Crustaceans


Looks like these two are in a bit of a pinch! But how did they end up in such decapodous danger? Where even are they? Where are they off to? And how on earth can we be expecting you to tie this to tech? Answer these questions and more by leaving a caption below! We’ll […]

28 January 2016 1:59 pm by
Dennes Torres

Are your check constraints trustable ?


SQL Server keeps a record to identify if a check constraint is trustable or not. When all the records in the database where checked against the constraint it’s trustable, otherwise it’s not. If the check constraint is trustable, it can be used by the query optimizer. For example, if the check constraint avoid values below […]

24 January 2016 4:48 am by
Phil Factor

De-duplicating Delimited Lists in SQL Server


/* In a recent article 'Removing Duplicates from Strings in SQL Server', Aaron Bertrand comes up with the interesting problem of removing duplicates from lists of strings. The example he gives is … 'Bravo/Alpha/Bravo/Tango/Delta/Bravo/Alpha/Delta'… and you want to make each word unique in the list… ‘Alpha/Bravo/Delta/Tango’. … You want just one occurrence of Bravo, for […]

19 January 2016 6:24 pm by
Older posts

Blog archive