Other Tony Davis in Other Why is Uninstalling SQL Server Such a Pain? A developer friend of mine recently, upon the briefest mention of SQL Server, descended unexpectedly into a rant about the... 30 August 2016 3 min read
Other Tony Davis in Other Software Animism The tendency to attribute malice to inanimate objects is deeply entrenched in the human psyche. In a famous account from... 11 August 2016 2 min read
Other Phil Factor in Other Creating PowerShell Stacks and Expression Evaluators To demonstrate that dynamic modules in PowerShell can be used to easily create objects with methods and properties, Phil Factor... 02 August 2016 10 min read
Grant Fritchey An Introduction to In-Memory OLTP Database Objects In-memory OLTP was introduced in SQL Server 2014, but greatly improved in SQL Server 2016. If you have a heavily-used... 01 August 2016 4 min read
Other Simple Talk Editorial Team in Other Ten Years Later Simple Talk has just celebrated its tenth birthday, has changed its platform, and has been given a make-over. The original... 29 July 2016 2 min read
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
