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
Damon Armstrong Reclaim Microsoft Virtual PC Console that Displays Outside the Desktop I ran into a bit of a problem the other day with Microsoft Virtual PC staring outside of my viewable desktop... 30 May 2007 1 min read
Tony Davis Competition: The Great Advances in SQL Server The real advances in IT are seldom the ones that are heralded by great noise or media hype. So many... 30 May 2007 1 min read
András Belokosztolszki How to order creation SQL files in SQL Compare 6.0 Professional It is a good practice to store creation scripts for the database organized in a way that there is a... 21 May 2007 3 min read
Louis Davidson Sorting and case sensitive collations This is an addition to my book, on page 255, to the end of the section on collation (before the... 20 May 2007 5 min read
Damon Armstrong Displaying Debugging Info for SharePoint Errors in Your Browser SharePoint does a good job of hiding errors from users. Out of the box, unhandled errors in SharePoint result in... 17 May 2007 1 min read
Richard Mitchell Cut-n-paste your code nicely One thing that has annoyed me quite a lot lately is the way that cut-n-paste code from visual studio 2005... 17 May 2007 1 min read
András Belokosztolszki SQL Compare 6.0 beta – read and sync to and from SQL scripts We have just released the first public beta for SQL Compare 6.0. The full version of SQL Compare 6.0 is... 15 May 2007 2 min read
Phil Factor The ballad of the tuple relation I was peacefully pottering away at my workstation, contentedly spawning a daughter thread or something similar, when Robyn popped in. She’d... 10 May 2007 4 min read
Louis Davidson Using application locks to implement a critical section in T-SQL code This is being added to the addendum (located here) for my “Pro SQL Server 2005 Database Design and Optimization” book... 07 May 2007 8 min read
Helen Joyce SQL Backup 5.0 has been released SQL Backup 5.0 is a major upgrade including a complete redesign of the user interface. What’s new in 5.0? Complete... 01 May 2007 2 min read
James Moore Welcome to my world…SQL Backup 5 A year and a little bit ago, I sat down with Tom (head of development at Red Gate) to talk... 01 May 2007 4 min read
Phil Factor At Half-past three, it’s time for tea… ‘Look, see what I mean?’, the manager said, as a dishevelled DBA stumbled past his pig pen grunting inconsequentially to... 15 April 2007 7 min read
Louis Davidson Dynamic management function query to view index usage Last week, I presented a query to view I/O pressure, and (to me) more usefully, look at it in a... 15 April 2007 8 min read
Richard Mitchell It’s like being stoned to death with marshmallows It’s amazing what you learn reading MSDN. It has recently been my joy to have to discover everything I’ve never... 12 April 2007 2 min read
Damon Armstrong VS SDK Error Message: CTC : fatal error CTC2013: Can’t start preprocessor (2) After watching some of the demo videos of the latest Visual Studio SDK, I was excited to get started and try out... 11 April 2007 1 min read
Louis Davidson Dynamic management function query to view disk I/O pressure The sys.dm_io_virtual_file_stats dynamic management function returns I/O statistics for data and log files [MDF and LDF file], with two... 06 April 2007 7 min read
