Simple Talk Editorial Team Caption Competition 4: Fist Full of Captions Update: Congrats to rananjali who won with this week’s competition with a caption on migrations. Thanks to everyone who wrote... 06 June 2014 1 min read
Tony Davis We have our standards, and we need them The presenter suddenly broke off. He was midway through his section on how to apply to the relational database the... 06 June 2014 3 min read
Phil Factor Developing a SQL Server Function in a Test-Harness. Many times, it is a lot quicker to take some pain up-front and make a proper development/test harness for a... 04 June 2014 8 min read
Chris Smith If unexpected database changes cause you problems – we can help! Have you ever been surprised by an unexpected difference between you database environments? Have you ever found that your Staging... 30 May 2014 3 min read
Jonathan Hickford How to Automate your Database Documentation In my previous post, “Automating Deployments with SQL Compare command line” I looked at how teams can automate the deployment... 30 May 2014 5 min read
Lucy Boyes Are your personal insecurities screwing up your internal communications? I do some internal comms as part of my job. Quite a lot of it involves talking to people about... 29 May 2014 10 min read
Damon Armstrong Exporting PowerPoint Slides with Specific Heights and Widths I found myself in need of exporting PowerPoint slides from a presentation and was fairly excited when I found that... 29 May 2014 1 min read
Jonathan Allen PowerShell and SMO – be careful how you iterate I’ve yet to have a totally smooth experience with PowerShell and it was late on Friday when I crashed into... 27 May 2014 4 min read
Louis Davidson What Counts For a DBA – Depth SQL Server offers very simple interfaces to many of its features. Most people could open up SSMS, connect to a... 27 May 2014 4 min read
Simple Talk Editorial Team Caption Competition 3: Caption With a Vengeance Congratulations to Doug Tucker for winning this week’s caption competition with: Having caught yet another developer logged into a production... 23 May 2014 1 min read
Phil Factor Documentation and Test Assertions in Databases When I first worked with Sybase/SQL Server, we thought our databases were impressively large but they were, by today’s standards,... 22 May 2014 3 min read
Louis Davidson How In-Memory Database Objects Affect Database Design: The Conceptual Model This part is part of an ongoing series of blogs I am writing while preparing to give a presentation based on... 19 May 2014 3 min read
Damon Armstrong How to Enable SideLoading in a SharePoint Site I was trying to deploy a SharePoint App for the first time and ran into an error about SideLoading not... 19 May 2014 1 min read
Phil Factor Separating text strings into a table of individual words in SQL via XML. Nearly nine years ago, Mike Rorke of the SQL Server 2005 XML team blogged ‘Querying Over Constructed XML Using Sub-queries‘.... 13 May 2014 4 min read
Know your Data Lineage An academic paper without the footnotes isn’t an academic paper. Journalists wouldn’t base a news article on facts that they... 09 May 2014 4 min read
Simple Talk Editorial Team Caption Competition 2: The Captioning Update! This competition is now closed. The winner was jkeefe with “Here’s a shot of our intrepid DBA personally testing... 09 May 2014 1 min read
Michelle Taylor How SQL Server 2014 impacts Red Gate's SQL Compare SQL Compare 10.7 successfully connects to SQL Server 2014, but it doesn’t yet cover the SQL Server 2014 features which... 08 May 2014 4 min read
Tom Crossman What’s new in SQL Prompt 6.3? This post describes some of the improvements we’ve made in the latest version of SQL Prompt. You can download SQL... 07 May 2014 2 min read
Simple Talk Editorial Team Caption Competition UPDATE: Congrats to Conan who won this caption competition with: “Darling, now that you’re working from home, you can just... 25 April 2014 2 min read
Tony Davis The Body in the Trunk When one considers that the primary purpose of a modern Source Control system is to allow branches and subsequent merges,... 25 April 2014 3 min read
