Richard Mitchell What’s in a name? Until recently I wouldn’t have said much. I’m talking about software release names rather than personal names – I quite... 13 September 2007 2 min read
Brian Donahue Learning to play the symbols If you are ever tasked to figure out what’s happening inside an application, one of the essential bits of information... 08 September 2007 6 min read
Robert Chipperfield Random names and the Birthday Paradox I’m currently in the middle of giving Red Gate’s sample “Widgets” database a bit of a face lift, in preparation... 07 September 2007 3 min read
Damon Armstrong WPF: WindowsFormsHost Control Error I had the code base for my first WPF application ready to go, so I compiled a release version of software... 04 September 2007 2 min read
Bart Read Why Automatic Software Updates Suck Or, why doesn’t the Red Gate “Check for updates” service automatically download and install software updates? Disclaimer: everything in this... 28 August 2007 6 min read
Louis Davidson DMV Progress and Upcoming Events (PASS/Devlink) If you have noticed my series of posts on the DMV’s on http://sqlblog.com/blogs/louis_davidson, you may have wondered why these posts... 26 August 2007 3 min read
Louis Davidson sys.dm_db_index_operational_stats This object provides very useful stats on how many times an index has been used, locked, waited on, etc.... 26 August 2007 6 min read
Damon Armstrong Simple Code Performance Testing After posting Performance: Caching vs. Reading from an In-Memory XML Document, there have been some questions about how I actually... 24 August 2007 4 min read
Damon Armstrong Performance: Caching vs. Reading from an In-Memory XML Document I’ve been working with a number of XML documents recently. Basically I’m trying to expose configuration values stored in XML... 22 August 2007 2 min read
Damon Armstrong ADFS – Cookie Error I’ve been knee deep in Active Directory Federation Services for the past three months now, and when helping one our... 16 August 2007 2 min read
Phil Factor DBAs and the moral dilemma DBAs are often put in a difficult moral position in the course of doing their work because they have a... 10 August 2007 4 min read
Louis Davidson sys.dm_exec_query_optimizer_info Information about how queries have been optimized since the server has been restarted. Note that counters are only affected when... 06 August 2007 2 min read
Robert Chipperfield Say hello, static constructor? When does the static constructor of your .NET class actually get called? Sounds like it should be pretty obvious really... 03 August 2007 2 min read
András Belokosztolszki Do you need to be dbo to compare two databases using SQL Compare? This question comes up time to time. SQL Compare compares two database schemata, and in order to do so it... 30 July 2007 2 min read
Louis Davidson sys.dm_io_virtual_file_stats Excellent dmv that shows, for each file that SQL Server uses for the databases, stats on how frequently the file... 27 July 2007 3 min read
Bart Read **SQL Prompt 3.5 Released** Well, this is it, it’s finally out there. Download it from http://www.red-gate.com/products/SQL_Prompt/index.htm Improvements include: Visual Studio 2005 database project support... 26 July 2007 1 min read
Richard Mitchell SQL Data Compare 6 Alpha due out next week After over 3 months of hard graft we’re getting ready to give you the chance to get your fingers on... 26 July 2007 2 min read
Phil Factor The Interview with the Psychometric Test I knew there would be trouble the moment she walked in the room. Like many IT people, I have an... 25 July 2007 4 min read
Louis Davidson sys.dm_db_index_usage_stats This object gives statistics on how an index has been used to resolve queries. Most importantly it tells you the... 22 July 2007 4 min read
Bart Read Visual Studio 2005 Support in SQL Prompt 3.5 Well it’s taken me slightly longer to get around to writing this than originally planned, however… Visual Studio 2005 support,... 20 July 2007 2 min read
