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
Alex Kozak Numeral Systems and Numbers Conversion in SQL Numeral systems can be fascinating. In everyday programming, we are now becoming quite insulated from the need to convert between... 10 December 2007 19 min read
David Leibowitz Advanced Matrix Reporting Techniques In SQL Reporting Services, the native Matrix control provides a crosstab view of data, similar in behavior to a PivotTable... 25 November 2007 19 min read
Jonas Stawski Take Row-Level Control of Your GridView The ASP.NET GridView is great for very simple tables, but the real world is not always as straightforward as we... 27 September 2007 10 min read
András Belokosztolszki Source Control and Databases András's article on Source Control shows a lot of the thinking amongst the developers at Red Gate at that time... 29 May 2007 18 min read
Dan Wahlin Enhance your Website with ASP.NET AJAX Extensions Microsoft's ASP.NET AJAX Extensions provide developers with a quick and simple way to add AJAX functionality into any ASP.NET Website.... 01 May 2007 20 min read
Dan Sullivan PowerSMO at Work Part 2 In part 3 of Dan Sullivan's in-depth exploration of PowerSMO, the versatile command line utility for managing SQL Server databases,... 12 March 2007 19 min read
Phil Factor Robyn Page SQL Server Security Workbench Part 1 Robyn Page and Phil Factor present practical T-SQL techniques for controlling access to sensitive information within the database, and preventing... 06 March 2007 17 min read
Pop Rivett Pop Rivett and the Uncontrolled Release Pop Rivett offers a hard lesson in the dangers of an uncontrolled software release.… 15 February 2007 20 min read
Phil Factor Robyn Page SQL Server Excel Workbench The need to produce Excel reports from SQL Server is very common. Here, Robyn Page and Phil Factor present practical... 06 February 2007 15 min read
Robyn Page Robyn Page’s SQL Server Cursor Workbench The topic of cursors is the ultimate "hot potato" in the world of SQL Server. Everyone has a view on... 24 January 2007 16 min read
Jesse Liberty Controls Based Security in a Windows Forms Application Jesse Liberty demonstrates a role-based security architecture for Windows Forms applications that will allow you to restrict access to any... 22 January 2007 24 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
Nigel Rivett Creating CSV Files Using BCP and Stored Procedures Nigel Rivett demonstrates some core techniques for extracting SQL Server data into CSV files, focussing on a stored procedure approach... 20 November 2006 13 min read
Nigel Rivett Executing SSIS Packages Nigel Rivett demonstrates how to execute all SSIS packages in a given folder using either an SSIS control package, a... 30 August 2006 8 min read
Phil Factor Talking Technical Developers, programmers and designers tend to be deeply geeky types, immersed in the minutiae of the technology. In stark contrast,... 26 May 2006 5 min read
Amirthalingam Prasanna Custom Events in VB.NET 2005 Visual Basic .NET is well known for its event-driven programming capabilities. VB.NET 2005 adds new functionality for custom events that... 26 September 2005 7 min read
Phil Wilson Updates to setup projects This article explains how to install a new version of your setup project using the Windows Installer update mechanism.… 18 July 2005 10 min read
Douglas Reilly Database Geek of the Week: Bill Bach Bill Bach, whose company, Goldstar Software, is perhaps the leading source for training and support for users of Btrieve and... 05 July 2005 10 min read
