Simple Talk Editorial Team Caption Competition 21 – Journey Into Mystery We leave cosy Victoriana behind for the thrilling frontiers of space. We still need you to come up with funny... 30 January 2015 1 min read
Damon Armstrong SharePoint Apps and Fixing the “Provided App Differs from Another App with the Same Version and Product ID” Issue I’ve seen a number of people posting about this issue on forums and in blogs, and the resolution tends to... 23 January 2015 1 min read
Simple Talk Editorial Team Tribal Awards 2014 Winners Announcement Throughout December, Simple-Talk and SQLServerCentral hosted the second annual Tribal Awards. With these awards, we let the technical community choose... 20 January 2015 1 min read
Tony Davis Prettier, But Less Usable When the original window-based user-interface was first being developed by Palo Alto, the team was driven by the idea that... 15 January 2015 3 min read
Simple Talk Editorial Team Caption Competition 20 – The Size of the Matter We present a whimsical scene. The best (funniest) suggestion for what’s going on wins $50 in Amazon credit. As always,... 15 January 2015 1 min read
Damon Armstrong C# – Getting the Directory of a Running Executable I was trying to remember how to get the directory of a running executable and I ran across this stack... 14 January 2015 2 min read
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
Other Phil Factor in Other Levenshtein Distance in SQL Server: Edit Distance and String Similarity Calculate string similarity in SQL Server using edit distance and the Levenshtein algorithm. Covers Arnold Fribble's T-SQL implementation, a CLR-based... 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
