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
Louis Davidson SQL Server Search Macro (plus build your own directed search!) Microsoft has built a little site for searching the books online on the web (which gives you links that are... 03 April 2007 1 min read
Richard Mitchell That makes a lot more sense now I’ll admit it, I never really got the yield statement in C# before today. However there’s a very good article... 03 April 2007 2 min read
James Moore Grayscaling transparent gifs and pngs I find that I end up custom painting a lot of the controls in Red Gate products, this is normally... 29 March 2007 2 min read
Damon Armstrong SharePoint Permission Names SharePoint 2007 has a new control called the SPSecurityTrimmedControl. It’s a container control that allows you to hide or display... 23 March 2007 1 min read
