Andrew Clarke SSMS: The Query Window Keyboard Shortcuts Simple-Talk's free wallchart of the most important SSMS keyboard shortcuts aims to help find all those curiously forgettable key combinations... 10 June 2011 5 min read
John O'Neill, SourceGear Life After Retirement: Replacing Visual SourceSafe Source control systems aren't exciting, and they don't come less exciting than Visual SourceSafe. Developers continue to use it but... 31 March 2011 12 min read
Troy Hunt The unnecessary evil of the shared development database One of the greatest pain-points in developing a database-driven application happens when the application is in source control,but the database... 23 March 2011 16 min read
Troy Hunt Continuous Integration for SQL Server Databases When it comes to the subject of putting databases into source control, Troy Hunt is no shrinking violet. "Database source... 01 March 2011 28 min read
Tools Phil Factor in Tools RegEx-Based Finding and Replacing of Text in SSMS So often, one sees developers doing repetitive coding in SQL Server Management Studio or Visual Studio that would be much... 14 January 2011 19 min read
Troy Hunt Foolproof Atomic Versioning of Applications Bad things tend to happen to developments where the scripts for the database layer are left out of source control.... 08 December 2010 9 min read
Brad McGehee Brad’s Sure Guide to SQL Storage Compress SQL Storage Compress does just that, and encrypts as well, allowing the files associated with a live database to take... 07 December 2010 27 min read
Michael Francis SQL Source Control – Less Pain for Red Jungle As a dedicated 'twitcher', Michael's eye is caught by a 'tweet' from Red Jungle. In this case, it was not... 26 November 2010 5 min read
Corrin Lakeland Snapper’s Sweet Source Control Corrin Lakeland's busy role as a Data Manager includes supervising the work of all database development. Although he was already... 12 October 2010 6 min read
Andrew Clarke SQL Source Control: The Development Story, Part II When creating SQL Source Control, the team had to make decisions as to which source control systems the tool would... 02 September 2010 14 min read
Brad McGehee Brad’s Sure Guide to SQL Virtual Restore In the first of a series of in-depth software reviews, Brad investigates a newcomer, SQL Virtual Restore. What does it... 05 August 2010 34 min read
Bruce Armstrong Product Review: Schema Compare for Oracle One of the more important tasks in the process of rolling out incremental developments to a multi-server production system is... 23 July 2010 11 min read
Andrew Clarke SQL Source Control: The Development Story Often, there is a huge difference between software being easy to use, and easy to develop. When your pilot users... 22 July 2010 21 min read
Andrew Clarke Who Tests the Tester? It is scarcely surprising that it can take up to five years to release a new version of SQL Server... 19 February 2010 15 min read
Bob Cramblitt SQL Search- The Search and the Sequel It started out as an experiment to try to explore different ways of creating a software tool that people would... 02 February 2010 8 min read
Barry King SQL Server Partitioning without Enterprise Edition Table partitioning is a valuable technique for managing very large database tables. It has always been possible with SQL Server,... 10 December 2009 6 min read
Simon Galbraith Downloading Software: the SQL Prompt 4 Experiment What is the best way for a Software vendor to get people to try out their tools? Is dialogue with... 18 September 2009 5 min read
Shawn McGehee SQL Backup 6: Wind of Change One could be forgiven for thinking that there is little more you can do with any third-party Backup software than... 03 August 2009 15 min read
Roger Hart Continuous Integration with SQL Toolbelt Sometimes, you wish you had a tool to run a software development process exactly the way you need it to... 23 July 2009 17 min read
Bob Cramblitt William Durkin, Serial Red Gate Beta Tester An interview with William Durkin. When he has the time, William finds it useful to work as a pre-release software... 09 July 2009 4 min read