Greg Larsen Choosing between CLR and T-SQL stored procedures: a simple benchmark In this short article, Greg Larsen performance benchmarks alternative CLR-based and T-SQL stored procedure solutions for retrieving operating system file... 24 April 2007 6 min read
Doug Burns What use is a Development DBA? "I can't help thinking that unless you have a good DBA on a development team and use him or her... 12 April 2007 12 min read
Eric Brown Troubleshooting with Dynamic Management Views If you work with SQL Server 2000, then you know how painful it is to triage a server that has... 12 April 2007 5 min read
Phil Factor Reading and Writing Files in SQL Server using T-SQL SQL Server provides several "standard" techniques by which to read and write to files but, just occasionally, they aren't quite... 10 April 2007 10 min read
Allen White Automate your Database Maintenance using SMO The most important thing you can do as a database administrator is perform regular database maintenance. This includes regular backups,... 05 April 2007 33 min read
Robyn Page SQL Server XML Cribsheet If you're like me and find XML a bit of an acronym minefield, Robyn Page's Cribsheet will help sort out... 29 March 2007 17 min read
Keith Fletcher Creating Cross Tab Queries and Pivot Tables in SQL For those times when you absolutely, positively got to perform a cross tab query in SQL, Keith Fletcher's T-SQL stored... 27 March 2007 18 min read
SQL Server Mario Broodbakker in SQL Server SQL Server Wait Events and CPU Time: The YAPP Method for Performance Profiling Applying the YAPP (Yet Another Performance Profiling) method to SQL Server performance diagnosis - combining wait event data with CPU... 22 March 2007 17 min read
Pop Rivett Pop Rivett and the Case of the Rogue SPIDs A process in a complex database occasionally, and apparently randomly, manages to put table locks on vital tables. Several applications... 22 March 2007 6 min read
Phil Factor Robyn Page The Helper Table Workbench Cursors and iterations are both renowned for slowing down Transact SQL code, but sometimes seem unavoidable. In this workbench, Robyn... 16 March 2007 16 min read
Steven R. McCabe Exploring LINQ, SQLMetal and SqlTac If you're a .NET developer, working with or without a database on the back-end, your world is about to change.... 15 March 2007 23 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 Writing to Word from SQL Server Never a man to walk away from a challenge, Phil Factor set himself the task of automating the production of... 06 March 2007 7 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
Database Administration Louis Davidson in Database Administration Ten Common Database Design Mistakes Spot and avoid the 10 database design mistakes that lead to performance problems, poor scalability, and maintenance headaches. Expert guidance... 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
Robyn Page SQL Server Security Cribsheet If you've ever had brain meltdown trying to understand SQL Server users, roles, permissions, logins etc. then Robyn Page's security... 20 February 2007 21 min read
Grant Fritchey SQL Server Error Handling Workbench Grant Fritchey steps into the workbench arena, with an example-fuelled examination of catching and gracefully handling errors in SQL 2000... 20 February 2007 15 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
