Louis Davidson Just over a week until SQL Saturday Atlanta I am looking forward to being both a speaker and an attendee at this year’s SQL Saturday in Atlanta (it... 11 May 2016 2 min read
Louis Davidson Temporal Tables – Part 4 – Synchronizing changes across tables So way back in June of last year, when I started this series on Temporal Tables: Part 1 – Simple... 09 May 2016 10 min read
Dennes Torres How to identify contention in TempDb TempDb database is used to store all temp tables created for our applications. Whether explicit or implicit created, all temp... 09 May 2016 5 min read
Other Simple Talk Editorial Team in Other Caption Competition 54 – Balancing Books Teamwork, tomfoolery, or tug-of-war? Leave a caption in the comment and the best answer will win an Amazon giftcard worth... 05 May 2016 1 min read
Tony Davis 9 Clickbait Simple Talk Titles You Won’t Believe Exist! At Simple-Talk, we specialize in practical, down-to-earth technical articles, and usually choose our titles to match. There’s no mistaking what... 05 May 2016 3 min read
Ben Emmett Azure Database and Query Store support in ANTS Performance Profiler Azure SQL DB support After identifying a slow-running SQL Server query, ANTS Performance Profiler allows you to view its execution... 03 May 2016 2 min read
Louis Davidson Temporal Tables – Part 3 – Syncing Multiple Modifications Back last June, I started this series on temporal tables, and in my head, I had enough information to make... 02 May 2016 9 min read
Dennes Torres How to find blocked processes Blocked processes are often a big problem to DBA’s. They are difficult to monitor. We receive desperate calls saying “Everything... 02 May 2016 4 min read
Dennes Torres Are the statistics being updated? The auto-update statistics configuration updates statistics when the amount of row changes in the table achieves 20% of total rows.... 27 April 2016 3 min read
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
Other Dennes Torres in Other 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
Other Simple Talk Editorial Team in Other 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
