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
Maxx Dopp Maxx at TechEd: Dispatch 4–Day Two at TechEd Maxx Dopp here. Today is day two of TechEd. When compared to yesterday, it seems much slower paced. I don’t... 05 June 2007 2 min read
Maxx Dopp Maxx at TechEd: Dispatch 3–An Exhausting Day at TechEd Finally Ends Maxx Dopp here. Wow, today has been exhausting, and it is still only Monday, with four more days to go.... 05 June 2007 2 min read
Maxx Dopp Maxx Dopp at Tech Ed: Dispatch 1 Maxx Dopp here. TechEd 2007 began this morning in Orlando, Fl. The sun was shining and the weather perfect. But... 05 June 2007 2 min read
Phil Factor Why do we call them ‘Bugs’? I’ve read a great deal about the origin of the word ‘Bug’ in computer software. You’d have thought the argument... 01 June 2007 3 min read