Phil Factor Can Code Review Be Automated? I was scanning the API of DacFx, the ‘engine’ of SSDT, and became interested in the facility it contains for... 17 July 2015 3 min read
Simple Talk Editorial Team Caption Competition 33 – Not All Hat An idyllic stroll in the countryside, in the rain. What could be better? Many things, clearly. But what’s going on... 16 July 2015 1 min read
Damon Armstrong An Odd Behavior with the ServerRelativeUrl Property in CSOM I was attempting to build a query using the ClientContext.LoadQuery method because it has some performance benefits that make it... 16 July 2015 3 min read
Carly Meichen It's time to share your top .NET performance optimization tips You’ve probably been there. There’s an issue with the performance of your .NET application, you don’t know what’s causing it,... 16 July 2015 2 min read
Damon Armstrong How to Start JavaScript Debugging at Just the Right Time Here is the scenario: you have inherited a project and you need to debug some issues with JavaScript on a... 09 July 2015 2 min read
Dennes Torres Identify Object Name from Page ID Sometimes, while searching the root cause of database problems, we face page IDs and need to find to which object... 06 July 2015 3 min read
Tony Davis The Railmap Towards Easier Query Tuning? Recently, I’ve been getting more and more engrossed in SQL Server Execution plans for various reasons, including editing the forthcoming... 03 July 2015 4 min read
Simple Talk Editorial Team Caption Competition 32 – A Moment Of Levity We all feel groundless sometimes, but this fellow more than most. What caused his current woes? The funniest answer wins... 03 July 2015 1 min read
Louis Davidson Temporal Tables – Part 2 – Changing history After my post yesterday, I had planned to take a break for Independence Day holiday, but a commenter asked a... 30 June 2015 8 min read
Louis Davidson Temporal Tables – Part 1 – Simple Single Table Example In my first entry in my series of posts on DB Design Book Topics, I want to start with a... 29 June 2015 14 min read
James Duffy Locking objects in SQL Source Control The beta of SQL Lock has now been retired and Redgate have rolled the object locking feature into the SSMS... 29 June 2015 2 min read
Dennes Torres How to use ObjectProperty to locate problems in tables There are plenty of very useful object properties that can help us to find problems in our databases. We can... 22 June 2015 2 min read
Louis Davidson Speaking this week at #sqlsatChattanooga and for the PASS Performance Virtual Chapter The topic for both sessions will be: How In-Memory Database Objects Affect Database Design and the following is the abstract:... 21 June 2015 2 min read
Tony Davis We Don’t Need Any More Heroes Where do I start? It’s a question each of us asks when faced with any learning goal, whether it’s how... 17 June 2015 3 min read
Simple Talk Editorial Team Caption Competition 31 – The Amazing-ish Race These olde-timey vehicles wait for nothing – except your comments. Tell us what’s going on here – as ever, the... 17 June 2015 1 min read
Louis Davidson Time to Start Plotting My 2016 Database Design Book Note: A new version has been talked about for years, but it is not a guarantee. This post is my... 16 June 2015 8 min read
Damon Armstrong Incorrect Client ID in SharePoint App Package Interesting issue today. I was attempting to install a SharePoint app today and ran into the following error: 8fff7a1f-f0ea-4d73-8c7d-aa97279b6d20 Stack... 16 June 2015 1 min read
Melanie Townsend Change Scripts Research How do you use change scripts for your database deployments? This is the question Redgate’s SQL Source Control team is... 15 June 2015 1 min read
Louis Davidson ANY and ALL, Two Keywords I Had Never Taken the Time to Understand As I am starting to prepare for an upcoming blog series on database designs and associated query patterns (stay tuned!)... 13 June 2015 12 min read
Rodney Landrum A Very Quick Post on SQL Server 2016 Dynamic Data Masking *** Update – Just wanted to say that dynamic data masking has the potential of being a great feature and... 10 June 2015 4 min read