Simple Talk Editorial Team Caption Competition 34 – Bold As Brass This man has some fine, fine whiskers. But that’s not really why we’re here – we want you to tell... 30 July 2015 1 min read
Carly Meichen Time's running out to share your .NET performance optimization tips We’re on the lookout for the best .NET performance tips. The kind that can save hours of work and loads... 30 July 2015 2 min read
Dennes Torres A few more about translation of cube dimensions Translations are a very usefull feature in multidimensional cubes. We can translate not only the cube structure, but also the... 26 July 2015 2 min read
Louis Davidson Utility to reset a sequence next value based on a table/sequence relationship So I was building a database the other day, and I used sequence objects for all of the defaults because... 22 July 2015 11 min read
Ben Emmett ANTS Performance Profiler 9.2 and ANTS Memory Profiler 8.7 Released We just released ANTS Performance Profiler 9.2 and ANTS Memory Profiler 8.7. The headline new capability for both is support... 20 July 2015 2 min read
Louis Davidson Upcoming Speaking Engagements in Indianapolis and Louisville Mercy, July is flying past at breakneck pace isn’t it? The best part of July passing into the history books... 18 July 2015 3 min read
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