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
Bart Read The beginning of a more in depth look at SQL Prompt 3.5 Well I said I’d post some more detailed information about the new version of SQL Prompt so I thought I’d... 18 July 2007 3 min read
Louis Davidson sys.dm_db_file_space_usage Give space usage of objects in tempdb (most likely this will be extended to more than just tempdb in a... 14 July 2007 2 min read
Phil Factor Using BCP to export the contents of MAX datatypes to a file This is a simple way of saving SQL Server text to a file. I’ve used it for years. Just pass... 13 July 2007 4 min read
Richard Mitchell Beware ye of ancient columns I’m sure you all make changes to your schema over time adding columns to tables and occassionally dropping them. But... 12 July 2007 2 min read
Louis Davidson sys.dm_db_partition_stats For the current database, gives you space oriented statistics for each partition of indexes (even if you only have one... 11 July 2007 3 min read
Louis Davidson Blogging the DMV’s Well, I am working on a project that is going to be a book on dynamic management views (and functions,... 10 July 2007 2 min read
Richard Mitchell How to tell you’ve created something truly special. In my history as a programmer there are a few occasions that stand out when I feel I’ve written something... 09 July 2007 5 min read
Phil Factor Love amongst the computers I love to go around junk shops and second hand bookshops looking for quirky second-hand books. It was whilst browsing... 29 June 2007 4 min read
Richard Mitchell The trials of usability trials of SQL Data Compare 6 Don’t you just love them. You write your UI, you think you design you code you fix you bug fix... 22 June 2007 2 min read
Phil Factor How to Write The editor recently returned exhausted from TechEd. He tells everyone who will listen that he has worn himself out trying... 21 June 2007 3 min read
Richard Mitchell SQL Data Compare 6 Alpha on the horizon In between the bouts of champagne for new product launches, eating the yoghurts and drinking the smoothies from the ‘feel... 18 June 2007 3 min read
Maxx Dopp Maxx Dopp at TechEd: Dispatch 9–Final Day Maxx Dopp here. This is the last day of TechEd, and people are already leaving to fly home, and things... 08 June 2007 2 min read
Maxx Dopp Maxx Dopp at TechEd: Dispatch 8–TechEd is Winding Down (Slowly) Maxx Dopp here. TechEd was bustling today. A lot of vendors were giving away big prizes, and swag trolls were... 07 June 2007 2 min read
Maxx Dopp Maxx Dopp at TechEd: Dispatch 7 [imageattachment] Maxx Dopp here. TechEd has continued to pick up today. It seems odd to me that Monday and Wednesday... 06 June 2007 2 min read
Maxx Dopp Maxx Dopp at TechEd: Dispatch 6–TechEd is Picking Up Maxx Dopp here. This morning, activity at TechEd has picked up. We have been getting lots of questions about SQL... 06 June 2007 2 min read
Maxx Dopp Maxx at TechEd: Dispatch 5–What DBAs Are Asking Maxx Dopp here. Lunch has just been served, but no live band today. As I mentioned earlier, activity is much... 05 June 2007 4 min read