Dennes Torres How to identify the source of page splits in a database Page splits have the ability to slow down our queries and increase the amount of IOs needed to retrieve our... 14 March 2016 6 min read
Simple Talk Editorial Team Caption Competition 50 – By the Bucket What’s this chap up to, some kind of re-juicing? Or perhaps even sabotage? Leave a caption in the comments below,... 11 March 2016 1 min read
Tony Davis A Programmer Walks Into a Bar… Conference season is upon us. Sessions, hands-on labs, round table debates, so many opportunities for learning! Of course what they... 11 March 2016 3 min read
Phil Factor SQL Server Table Smells Table smells in SQL Server are just like code smells. They are just an indication that something may need to... 07 March 2016 8 min read
Louis Davidson Row Level Security–Part 2-Write Operations In the first entry in this series (to view, follow this link), I took a look at the how row... 04 March 2016 10 min read
Elizabeth Ayer Moving Migrations up a Gear with SQL Source Control 5 Database development processes traditionally lag behind application development, so much so that databases are often considered a blocker to Agile... 02 March 2016 4 min read
Chris Whitworth ConditionalWeakTable and dynamic properties in .NET 4+ In version 4.0 of the .NET Framework, Microsoft added a new class to the System.Runtime.CompilerServices namespace: ConditionalWeakTable<TKey, TValue>. On the... 26 February 2016 8 min read
Dennes Torres How to find blocked process Blocked processes are often a big problem to DBA’s. They are difficult to monitor. We receive desperate calls saying “Everything... 25 February 2016 4 min read
Tony Davis Push-Button Database Deployment? Much of what we do in IT seems easy, from a distance; even the modification of a live functioning database... 25 February 2016 3 min read
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
Other Phil Factor in Other 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
