Tony Davis JSON-rise Microsoft was slow to meet the demand to be able to store and retrieve data in JSON, the native data... 21 April 2016 3 min read
Blogs Dennes Torres in Blogs 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... 19 April 2016 3 min read
Damon Armstrong SharePoint’s Way of Saying Your String is Too Long I accidentally defined a field in a SharePoint list as a text field instead of a multiline text field and... 19 April 2016 1 min read
Damon Armstrong How to Configure Mapped Properties for Users in O365 I was troubleshooting one of our products in O365 and ran into an issue where search results were not coming... 19 April 2016 3 min read
Blogs Simple Talk Editorial Team in Blogs Caption Competition 53 – At the Drop of a Cat What’s going on here? Leave a caption in the comments and you could win a $50 Amazon voucher, we’ll announce... 19 April 2016 1 min read
Tony Davis Goodwill and hard learning at SQL Bits 15 SQL Bits XV, the official launch event for SQL Server 2016, begins in Liverpool, UK, on May 4, 2016. Simple-Talk... 08 April 2016 3 min read
Owen Priestley How we’ve improved migrations in SQL Source Control 5 Migration scripts, which were first introduced in SQL Source Control 3, let you assign custom SQL to specific schema changes.... 07 April 2016 4 min read
Louis Davidson Row Level Security-Part 3-A few more advanced scenarios In this final entry (for now!) in my series on Row Level Security (Part 1, Part 2) I am going... 06 April 2016 9 min read
Simple Talk Editorial Team Caption Competition 52 – A Bone to Pick What’s going on at this skeletal shindig? We’ll announce our favourite caption in the Simple-Talk newsletter on Monday April 25th,... 06 April 2016 1 min read
Simple Talk Editorial Team Caption Competition 51 – Bearding the Lion This lot look utterly speechless – but that’s where you come in! Leave a caption below and the funniest will... 23 March 2016 1 min read
Louis Davidson Presenting on Concurrency Three Times This Month…Though Not Concurrently Tomorrow night, March 15, I will be at the Hampton Roads SQL Server User Group’s March meeting, then at SQL... 15 March 2016 2 min read
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
