red@work Survey: Using Product Accounts Just a quick request from Red to help us by participating in a survey! At Red Gate we’ve set up... 15 September 2014 1 min read
Phil Factor Calculating Public Holidays based on the Day of the Week Occasionally, I like updating old articles that I’ve written on Simple-Talk. Since I used to help Robyn Page with hers,... 11 September 2014 5 min read
Simple Talk Editorial Team Caption Competition 11 – A Coat for all Seasons Update: Congratulations to Dimitrios Kalemis with his caption “I asked all of you to gather here today, because I have... 11 September 2014 1 min read
Tony Davis Locating business logic in applications One of the most pernicious and pervasive myths in business-application development is that all business logic must be kept from... 11 September 2014 3 min read
Jonathan Allen Getting Windows power options under control I work from a laptop, both at work and at home. In both cases the laptop is either plugged in... 11 September 2014 4 min read
Chris Smith Tackling database drift with DLM Dashboard Red Gate’s upcoming product DLM Dashboard (formerly SQL Lighthouse) gives you the What, the Who, the When and the How... 10 September 2014 4 min read
Tom Are you bad enough to join The DBA Team? Steve Jones and Grant Fritchey have emerged from their hide-out in the Cheyenne Mountains to hunt for their next DBA... 05 September 2014 3 min read
Ben Emmett ANTS Performance Profiler v8.6 release, and what's coming next A couple of months ago, we released a new version of ANTS Performance Profiler, v8.6. As a user, the main... 04 September 2014 2 min read
Jonathan Allen How to set PowerShell_ISE as your default PowerShell editor when working with files in tfs projects Every good DBA and Developer keeps their code under source control. What? You don’t? Well, read this and then go... 03 September 2014 3 min read
Melanie Townsend It came to me in a dream – dealing with clients There are many ways to think about clients. Sometimes they feel like the enemy, ignoring your brilliant ideas and insisting... 29 August 2014 3 min read
Simple Talk Editorial Team Caption Competition 10 – Double Digits Congratulations to Doug Tucker who won this week’s caption competition with: The keyboard is so last-century (just like your outfits).... 29 August 2014 1 min read
Tony Davis When you really need to know why your SQL Query’s slow It is useful to know that a SQL Query is slow, but it is even better to know why. To... 28 August 2014 3 min read
Damon Armstrong SharePoint Farm Admin Cannot Add Tenant Level App We ran into an issue today where a Farm Administrator could not add an app to a SharePoint site. When... 27 August 2014 1 min read
Louis Davidson SQL Saturday Birmingham #328 Database Design Precon In One Week On *August 22, I will be doing my “How to Design a Relational Database” pre-conference session in Birmingham, Alabama. You can... 14 August 2014 5 min read
Jonathan Allen Checking who is connected to your server, with PowerShell. There are many occasions when, as a DBA, you want to see who is connected to your SQL Server, along... 14 August 2014 7 min read
Simple Talk Editorial Team Caption Competition 9: Carry on Captioning Update: Congratulations to Louis Somers who won the caption competition with “It’s all about having the right tools… Finding Bugs... 14 August 2014 1 min read
Melanie Townsend Conference networking for the socially awkward Do you approach a room full of strangers with excitement at all the new people you’re going to chat to... 13 August 2014 4 min read
Ben Emmett New .NET Library for Accessing the Survey Monkey API I’ve used Survey Monkey’s API for a while, and though it’s pretty powerful, there’s a lot of boilerplate each time... 10 August 2014 5 min read
Louis Davidson How In-Memory Database Objects Affect Database Design: Hybrid Code In my first attempts at building my code, I strictly went with either native or on-disk code. I specifically wrote... 08 August 2014 6 min read
Louis Davidson What Counts For a DBA – Decisions It’s Friday afternoon, and the lead DBA, a very talented guy, is getting ready to head out for two well-earned... 07 August 2014 3 min read
