Phil Factor String Comparisons in SQL: The Longest Common Subsequence Relational databases aren’t really designed to deal easily with arbitrary sequence, though this is improving with the window functions. Strings... 09 January 2015 5 min read
Phil Factor String Comparisons in SQL: Edit Distance and the Levenshtein algorithm Sometimes you need to know how similar words are, rather than whether they are identical. To get a general measure... 05 January 2015 10 min read
Simple Talk Editorial Team Caption Competition 19 – Point and Click What a beautiful pastoral scene! If you absolutely had to caption it, what would you say? Funniest answer wins a... 02 January 2015 1 min read
Phil Factor The Eight Fallacies of Distributed Computing There are eight fallacies about distributed computing, common misconceptions that were first identified at Sun Microsystems in the 1990s, but... 30 December 2014 10 min read
Phil Factor String Comparisons in SQL: The Longest Common Substring. I’ve always wanted a SQL function that tells me the longest substring shared between two strings. As a present to... 20 December 2014 8 min read
Simple Talk Editorial Team An Origin Story for a DBA Anti-Hero If you’re old enough, you may well remember the burst of sheer joy at ripping the wrapping paper from a... 19 December 2014 3 min read
Simple Talk Editorial Team Caption Competition – A DBA Christmas Carol Old DBA Scrooge is ready lock his developers out of the server and send them to the poor house (bear... 18 December 2014 1 min read
Damon Armstrong Enabling Search Indexing on Property Bag Values in O365 SharePoint allows you to store ad-hoc values in property bags values on SPWeb objects in server-side code. You can even... 10 December 2014 2 min read
Simple Talk Editorial Team Caption Competition 17 – Duel Another conundrum, another caption required. What has set these two gentlemen at each other’s throats? Linux vs Unix? A slight... 04 December 2014 1 min read
Simple Talk Editorial Team The 2014 Tribal Awards The 2014 Tribal Awards are here again! We had so much fun and such a great response from last year’s... 21 November 2014 2 min read
Simple Talk Editorial Team The SQL Server Code Smells Drive Earlier this year Red Gate published a short PDF of 119 SQL Server Code Smells put together by Phil Factor... 21 November 2014 2 min read
Ben Emmett Understand SQL Server’s impact on .NET performance with ANTS Performance Profiler 9 Today I’m excited to share a big new release of ANTS Performance Profiler to help you with the all-too-common problem... 20 November 2014 2 min read
Simple Talk Editorial Team Caption Competition 16 – More Fish in the Sea Congratulations to Dimitrios Kalemis for winning this week’s caption competition. A strange scene! And once more, it’s up to you... 20 November 2014 1 min read
Tony Davis Please sp_help My System Stored Procedure SQL Server provides a large number of built-in stored procedures that can tell us all sorts of useful information about... 20 November 2014 3 min read
Melanie Townsend Getting Feedback If you’ve ever worked on a project that you really cared about, you might be able to relate to the... 13 November 2014 3 min read
Damon Armstrong Does Each Call to SP.ClientContext.get_current() Return the Same Instance? I was trying to figure this out for some common code that we are putting together so I ran the... 12 November 2014 1 min read
Damon Armstrong Fixing “Could not Load File or Assembly” Error for CKS Dev Copy to SharePoint Root Command I’ve got a SharePoint solution containing a standard SharePoint solution project and a SharePoint App project. While trying to use... 11 November 2014 1 min read
Matt Hilbert Slaying the beast SQL Compare is the industry standard for comparing and deploying SQL Server database schemas, and is used by 71% of... 11 November 2014 10 min read
Louis Davidson MVP/SQLPASS Summit Wrapup From a Non-Attendee (Or “How I Sort of Attended PASS This Year After All and It Wasn’t as Horrible as it Might... 09 November 2014 6 min read
Simple Talk Editorial Team Caption Competition 15 – Watson the Telly Congrats to Andre who won this week’s caption competition with: My Dear Watson, I’d wish you’d stop tipping your cigar... 07 November 2014 1 min read
