Simple Talk Editorial Team Caption Competition 58 – Royal Tweetment Hallucinating at the coronation, or just elaborate costumes? Tell us what’s going on here and our favourite answer will win... 30 June 2016 1 min read
Laerte Junior Invoke-SqlCmd Just Got Better! If you’ve read even just a few of my articles on Simple-Talk you know that I’m a big fan of... 30 June 2016 3 min read
Phil Factor Data Security: Time to be Grown-Up How do you quickly clear a room-full of application developers, short of shouting ‘fire’ and setting off a smoke-bomb? The... 30 June 2016 3 min read
Simple Talk Editorial Team Caption Competition 57 – Bicircling What’s going on in this week’s scene? Leave a caption in the comments before June 30th, and the response we... 16 June 2016 1 min read
Phil Factor Measure of a DBA Marketing people are often surprised when a new version of SQL Server doesn’t quite generate the atmosphere of excited anticipation... 15 June 2016 3 min read
Phil Factor Unmasking the Dynamic Data Masking /* Revised 27th June Dynamic data masking is a great product and solves some niche problems that come if... 06 June 2016 8 min read
Carly Meichen Be the first to try Redgate SQL Compare 12 I’m excited to announce the beta release of SQL Compare & SQL Data Compare 12. This is the culmination of... 03 June 2016 2 min read
Tony Davis Over-SQL-Engineering In a recent blog post, Jonathan Kehayias demonstrates a clever way to “multi-thread” maintenance tasks, when they need to run... 03 June 2016 2 min read
Simple Talk Editorial Team Caption Competition 56 – Holding the Phone These two certainly have an unconventional bedside manner, what could they be discussing? Submit a caption in the comments below... 02 June 2016 1 min read
Elizabeth Ayer How to rename a table without data loss in SQL Server Management Studio using migration scripts SQL Source Control plugs into SSMS and connects your databases to your version control system, allowing you to version control... 02 June 2016 4 min read
Elizabeth Ayer SQL Source Control 5 – we’ve solved the data problem We’ve just released SQL Source Control 5 with improved migration scripts. With this release SQL Source Control now brings modern... 02 June 2016 3 min read
Dennes Torres Identifying client timeouts Long running queries often causes client timeout in our applications. One good solution to attack this problem is to identify... 23 May 2016 3 min read
Louis Davidson Temporal Tables – Part 5 – Start and End Type Precision In this fifth (and maybe final until at least getting to the concurrency chapter prep) blog about temporal I wanted... 21 May 2016 5 min read
Tony Davis SSMS Renaissance For many good reasons, DBAs and database developers use SQL Server Management Studio (SSMS), not SQL Server Data Tools (SSDT).... 20 May 2016 3 min read
Simple Talk Editorial Team Caption Competition 55 – Lupine Liaison There looks to be shady dealings at hand between this pair, what are they up to? Leave a caption in... 18 May 2016 1 min read
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
Blogs Simple Talk Editorial Team in Blogs 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