Simple Talk Editorial Team Caption Competition 49 – A Quack Getaway Something’s afoot amongst the foothills, but what? and why? Well have a gander and if you think you know, leave... 24 February 2016 1 min read
William Brewer The Cross Platform With the new range of cross-platform runtime-systems, based on WebKit and Node.js, we developers are once again offered the lure... 24 February 2016 3 min read
Dennes Torres How to find CPU intensive queries High CPU usage is a very common problem in SQL Servers. Any query with a bad query plan can steal... 16 February 2016 3 min read
Louis Davidson How Sure Are You of Your PASS Summit Abstract? You know who you are. You have a presentation idea that has been percolating since last October. You have asked... 16 February 2016 4 min read
Blogs Phil Factor in Blogs The Luhn Algorithm in SQL The Luhn test is used by most credit card companies to check the basic validity of a credit card number.... 16 February 2016 7 min read
Louis Davidson Row Level Security – Part 1–Simple Read operations This is part 1 of my Row Level Security blogs for my upcoming book project. Row Level Security is a... 15 February 2016 13 min read
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... 12 February 2016 1 min read
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... 11 February 2016 3 min read
Louis Davidson Target Audience – SQL Saturday 489 Tampa – “How to Design a Relational Database” Precon A few days back, I blogged an intro to my pre-con on How to Design a Relational Database. You can... 10 February 2016 5 min read
Louis Davidson Dynamic Data Masking – Part 2–Security and Incorporating into Code This is part 2 of my Dynamic Data Masking blogs for my upcoming book project. Part 1 is here: Dynamic... 08 February 2016 12 min read
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... 05 February 2016 2 min read
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... 04 February 2016 3 min read
Louis Davidson SQL Saturday 489 Tampa-“How to Design a Relational Database” Precon On February 26, I will be doing my "How to Design a Relational Database" pre-conference session in Tampa, FL. You... 04 February 2016 6 min read
Louis Davidson Dynamic Data Masking – Part 1 – The Mechanism This is part 1 of my Dynamic Data Masking blogs for my upcoming book project. Part 2 is here. An... 01 February 2016 11 min read
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... 28 January 2016 2 min read
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... 28 January 2016 3 min read
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... 28 January 2016 1 min read
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
