Roger points out the difference between a good 'Wow!' and a bad 'Wow!', when uttered by users trying to find features in your tools. You really should listen to both kinds when you're developing your software...… Read more
For all of us who learn best by trying out examples, Bob Sheldon produces a PowerShell script file for SQL Server that can be used in either SQL Server 2005 or 2008, has error handling and prompts for user-input, is easily extended and, does something useful. He then explains how to run it and what each line does. Magic… Read more
Richard Morris met David and Nigel of the SQL Response team, in a dim sum Restaurant in Cambridge. They had just finished a new Red-Gate product called SQL Response. Away from the office, they described the fourteen month software project that had been dominating their lives; and they were still able to say that they loved writing software.… Read more
Our overriding goal at Red Gate is to make our software more usable by "doing whatever works". That means to do whatever users are most likely to instinctively understand. As we analyse and consider every use of language in our applications, this sometimes leads me as a writer to ask the following question:… Read more
Historically, the profession of "technical author" emerged from the nascent aerospace and technology industries following the war, and brought with it a military-style rigidity of approach to standards and formality. But documenting (and putting words into) software in 2008 is very different from documenting the wiring of a cockpit in a fighter jet in 1952; perhaps we need to relax more... and be more like Google.… Read more
We asked Brian for a description of the Help System for the software he's working on and ends up quoting Blake's poetry, discussing town criers, Ziggurats, security guards and the BRAD signal.… Read more
The conversion of the Red-Gate tools to be compatible with SQL Server 2008 might not seem, on first impression, the most interesting or creative project ever undertaken by the company. However, the two people most involved in the project were adamant that it was a fascinating and rewarding experience. Why? We sent the indefatigable Richard Morris to find out.… Read more
Jason Cook shows you how you can use SQL Multi Script to install or upgrade your SQL Backup server components across the network in one go, rather than installing the components manually for each server.… Read more
David Connell describes how the team that developed Red-Gate's SQL Data Generator tool came to realise that database developers and DBAs already knew what they wanted for their test data. The team wanted to use the Beta version of the program to get a clear message from them. . And then came the daunting task of working out the best way of incorporating all this wisdom into the final product.… Read more
In which Arthur Fuller comes to the aid of a friend who is doing his best to administer The Database From Hell, and manages to set up a reasonable test database with which to solve some of the headaches that only a 65 million row, 600 column, table can cause.… Read more
In this short article, the second of a 2-part series, William suggests a solution, using SQL Data Compare 6.1, for providing an independent cross-check of database transactions to determine whether they have been retrospectively altered. … Read more
SQL Refactor is well-known as a way of formatting, and beautifying, SQL Code from within SSMS, but few users seem to be aware of the Table-Splitting wizard. This wizard is explained by another, András Belokosztolszki.… Read more
Much of the security of SQL Server is implemented as part of the database schema. This provides some bonus uses for SQL Compare. Andras, the architect of SQL Compare v 4, 5, and 6, tells how.… Read more
If you are using SSMS and SQL Server 2005 sp2 You've probably tried out the database reports that are available in the Performance Dashboard, and decided how useful they are, but did you know that you can create your own dashboard reports?… Read more
Tired of struggling through dull, monchrome SQL, C# and VB code in website blogs and forums? Then check out the all-new Simple Talk code prettifier!… Read more
Is your IT project in trouble? Do you need to create a smokescreen so that no-one can pin the blame on you? No problem! Marvel at Phil Factor's versatile use of T-SQL functions in creating the "ultimate excuse database" and then start generating your excuses immediately!
… Read more
Richard Mitchell and Steven Davidson describe how they used Red Gate's database schema-comparison tool, SQL Compare, to develop the latest version of red-gate.com… Read more
William Brewer investigates an unsung hero in SQL Server, extended properties, and shows how to use them to create self-documenting SQL Server databases.… Read more
Last month saw the release of the SQL Bundle 5. Here, some key members of the Red Gate development team offer insight into some of the major new features, and the technical challenges they faced in implementing them.… Read more
Low-cost software is almost always a better solution, but if you must purchase the high-cost stuff, don't get caught with blood in the water. … Read more