Brad McGehee How to Identify Blocking Problems with SQL Profiler Many SQL Server developers and DBAs have, in the past, had their own favourite diagnostic Stored Procedures for investigating blocking... 13 March 2009 11 min read
Roger Hart Good Wow / Bad Wow – The SQL Compare Development Process Roger points out the difference between a good 'Wow!' and a bad 'Wow!', when uttered by users trying to find... 13 January 2009 4 min read
Robert Sheldon Using Powershell to Generate Table-Creation Scripts For all of us who learn best by trying out examples, Bob Sheldon produces a PowerShell script file for SQL... 04 October 2008 19 min read
Richard Morris SQL Response: The dim sum interview Richard Morris met David and Nigel of the SQL Response team, in a dim sum Restaurant in Cambridge. They had... 30 September 2008 13 min read
Brian Harris SQL Response: Choosing Our Words Carefully Historically, the profession of "technical author" emerged from the nascent aerospace and technology industries following the war, and brought with... 17 September 2008 9 min read
Brian Harris SQL Response: Does Everything Need a Name? Our overriding goal at Red Gate is to make our software more usable by "doing whatever works". That means to... 17 September 2008 5 min read
Brian Harris Ziggurats, Batman and the Town Crier We asked Brian for a description of the Help System for the software he's working on and ends up quoting... 19 August 2008 11 min read
Richard Morris SQL Toolbelt 2008: Predominantly an Engineering Task The conversion of the Red-Gate tools to be compatible with SQL Server 2008 might not seem, on first impression, the... 18 August 2008 16 min read
Jason Cook Installing SQL Backup on Multiple Servers using SQL Multi Script Jason Cook shows you how you can use SQL Multi Script to install or upgrade your SQL Backup server components... 06 June 2008 12 min read
David Connell Towards a Better Beta David Connell describes how the team that developed Red-Gate's SQL Data Generator tool came to realise that database developers and... 31 March 2008 11 min read
Arthur Fuller The Database From Hell In which Arthur Fuller comes to the aid of a friend who is doing his best to administer The Database... 19 February 2008 10 min read
William Brewer Audit Crosschecks In this short article, the second of a 2-part series, William suggests a solution, using SQL Data Compare 6.1, for... 24 January 2008 7 min read
András Belokosztolszki SQL Refactor and the Table Splitting Headache SQL Refactor is well-known as a way of formatting, and beautifying, SQL Code from within SSMS, but few users seem... 31 August 2007 13 min read
András Belokosztolszki Discovering Security Uses for SQL Compare Much of the security of SQL Server is implemented as part of the database schema. This provides some bonus uses... 06 August 2007 10 min read
Greg Larsen Custom reports in Management Studio, using the Performance Dashboard If you are using SSMS and SQL Server 2005 sp2 You've probably tried out the database reports that are available... 18 July 2007 11 min read
Phil Factor The Simple Talk SQL Prettifier Tired of struggling through dull, monchrome SQL, C# and VB code in website blogs and forums? Then check out the... 22 May 2007 11 min read
Phil Factor The Ultimate Excuse Database Is your IT project in trouble? Do you need to create a smokescreen so that no-one can pin the blame... 15 January 2007 11 min read
Richard Mitchell A Database Development Model Using SQL Compare Richard Mitchell and Steven Davidson describe how they used Red Gate's database schema-comparison tool, SQL Compare, to develop the latest... 19 December 2006 9 min read
William Brewer Towards the Self-Documenting SQL Server Database William Brewer investigates an unsung hero in SQL Server, extended properties, and shows how to use them to create self-documenting... 01 December 2006 16 min read
Tony Davis SQL Bundle 5: the developer’s perspective Last month saw the release of the SQL Bundle 5. Here, some key members of the Red Gate development team... 17 May 2006 11 min read
