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... 24 January 2016 3 min read
Louis Davidson Is It Ever Better to Not Name Constraints? This is part 1 of my Tips and Tricks blogs for my upcoming book project. For all of my professional... 19 January 2016 3 min read
Phil Factor De-duplicating Delimited Lists in SQL Server Aaron Bertrand came up with the interesting problem of removing duplicates from lists of strings in his article 'Removing Duplicates... 19 January 2016 7 min read
Damon Armstrong Making SharePoint App Access Token Caching work in MVC I’ve put together a couple of SharePoint Apps that use MVC to run the remote web application. When you use... 14 January 2016 2 min read
Tony Davis Real Developer Heroics One of the strange paradoxes of team development is that effort beyond the call of duty is generally discouraged. Developers... 14 January 2016 3 min read
Simple Talk Editorial Team Caption Competition 46 – Do or Dye If you’re not careful, you can end up impulse-buying all sorts of things in the January sales! Leave a comment... 14 January 2016 1 min read
Damon Armstrong Utility for Renaming Visual Studio Windows Gimmal has a wide array of products, and most of those products have gone through multiple releases. This means that... 13 January 2016 1 min read
Carly Meichen .NET Core .NET Core is more interesting than the name might suggest. Whereas the .NET framework provides a consistent runtime for all... 08 January 2016 3 min read
Daniel Nolan Kicking the Habit of Shared-Database Development As application developers, it’s fairly well established that having a private environment to develop and debug changes is a good... 07 January 2016 5 min read
Damon Armstrong SharePoint CSOM: Fixing the “Value does not fall within the expected range” Error Calling GetFolderByServerRelativeUrl There are times when you just need to get a reference to a folder in the master page gallery of... 06 January 2016 2 min read
Louis Davidson Less than Two Weeks to SQL Saturday Nashville! No sooner does the official holiday season end than SQL Saturday season begins. Next week on January 9 is the... 03 January 2016 3 min read
Simple Talk Editorial Team Caption Competition 45 – Take Aim Out hunting? An execution? Self defence? Leave a comment with your best guess at what’s going on and our favourite... 31 December 2015 1 min read
Tony Davis The Genuine Article On Simple-Talk, we try to make sure that Information Technology is presented in an interesting way. We all tend to... 31 December 2015 3 min read
Dennes Torres Compress and Decompress in SQL Server 2016 SQL Server 2016 ctp 3.2 is already available with a lot of news. One of the new features available is... 24 December 2015 3 min read
Louis Davidson What Counts for a DBA – Decorations I was whistling contentedly as I hung up the Christmas Decorations. It may have been ‘Jingle Bells’, or it could... 22 December 2015 3 min read
Simple Talk Editorial Team Caption Competition 44 – All Ears Ahoy-hoy! The odd communication breakdown is unavoidable, and that certainly looks to be the case for these two, but what... 18 December 2015 1 min read
Tony Davis Workplace Politics The IT workplace can often be stressful when untoward things happen. Maybe, it is business managers who demand new platforms,... 18 December 2015 3 min read
Louis Davidson What Counts For a DBA – Manners Manners, learned as soon as possible in life, give us social skills without us having to figure them out. While... 15 December 2015 6 min read
Simple Talk Editorial Team Caption Competition 43 – Where There’s Smoke We’re back with yet another peculiar picture to quell your caption-based cravings. Give it a go and the most amusing... 03 December 2015 1 min read
Tony Davis Squaring the NoSQL Circle NoSQL was a bold new revolution. Many of these databases are schema-less, or rather the schema is implicitly defined by... 03 December 2015 3 min read
