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
Phil Factor The March of Technology In which Phil, under the influence of a surfeit of lobster, some fine wine and a large book, conjures up... 28 February 2007 9 min read
Louis Davidson Ten Common Database Design Mistakes If database design is done right, then the development, deployment and subsequent performance in production will give little trouble. A... 26 February 2007 32 min read
Arthur Fuller Database Design: A Point in Time Architecture In most relational database implementations. Update and Delete commands destroy the data that was there prior to their issue. However,... 22 February 2007 19 min read
Dan Sullivan PowerSMO At Work Part I: DBA Scripts and Functions Dan Sullivan delves deeper into PowerSMO, the versatile command line utility for managing SQL Server databases. Using a certificate strategy,... 19 February 2007 22 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
Scott W. Ambler and Pramod J. Sadalage Refactoring Databases: The Process Database refactoring can greatly improve the efficiency of your database code. However, even a seemingly simple database refactoring such as... 09 January 2007 16 min read
Pop Rivett Pop Rivett and the Suspect Database When a 'torn page' error corrupts a SQL Server database, threatening the survival of some vital data and a mainly... 08 January 2007 6 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
Phil Factor More Database Administration and Development Automation using DMO Phil Factor provides a handy DMO automation toolkit to take care of some core SQL Server administrative tasks.… 04 October 2006 2 min read
Douglas Reilly Database Geek of the Week: Kirk Haselden Author and SQL Server development manager, Kirk Haselden, talks about SSIS, gruelling interviews on an empty stomach, and his role... 07 September 2006 9 min read
Adam Machanic To SP or not to SP in SQL Server: an argument for stored procedures A seemingly never-ending battle in online database forums involves the question of whether or not database application development should involve... 06 June 2006 12 min read
Grant Fritchey SQL Server Performance Testing When faced with two viable solutions to a badly compromised database design, one using clustered indexes and the other compound... 15 May 2006 2 min read
Douglas Reilly Database Geek of the Week – Glenn Johnson Meet Glenn Johnson; he runs Glenn Johnson Technical Training and has just written "Programming Microsoft ADO.NET Applications - Advanced Topics".… 04 April 2006 13 min read
Douglas Reilly Database Geek of the Week – Tom Moreau "In grad school, I had a temporary assignment as director of the undergrad labs, where I had to manage the... 13 March 2006 13 min read
Arthur Fuller Intelligent Database Design Using Hash Keys Your application may require an index based on a lengthy string, or even worse, a concatenation of two strings, or... 17 February 2006 5 min read
Douglas Reilly Database Geek of the Week – Michael Rys Dr. Michael Rys is the program manager for the SQL Server Engine Team at Microsoft, represents Microsoft on the W3C... 06 February 2006 8 min read
Phil Factor Survival tips for powerpoint The Database Mole Presents Survival tips for PowerPoint boredom… 17 January 2006 7 min read
