Welcome to EMC Consulting Blogs

January 2011 - Posts

• Intellisense for T4 templating with .tt files in Visual Studio

  There's 2 products (both with free versions) you can use for T4 intellisense: One is by Clarius at http://www.visualt4.com/ . But best to go with Tangible's T4 editor at http://t4-editor.tangible-engineering.com/T4-Editor-Visual-T4-Editing.html (available Read More... Posted 27 January 2011 14:43 by merrick.chaffer | 0 Comments Filed under: Microsoft, C#, .NET, code, Guidance Automation Extensions, .NET 3.5, Howto, WPF, .NET4.0

• SQL Server Query Optimization Rules of Thumb

  Just came across this very helpful article http://msdn.microsoft.com/en-us/library/aa964133(v=sql.90).aspx . The main highlights are at the bottom as follows… Good candidates for clustered indexes are: Primary keys of the lookup/reference/dimension/master Read More... Posted 26 January 2011 13:20 by merrick.chaffer | 0 Comments Filed under: Microsoft, Performance, SQL 2005, SQL Express, SQL 2008

• Iterating files in DOS using FORFILES.exe

  Just came across a nice little command line utility called forfiles.exe. Very useful for batch file scripting, for example you can use this to schedule deletes of log files from your continuous build output. C:\Temp>forfiles /C "cmd /c echo @file" Read More... Posted 12 January 2011 15:10 by merrick.chaffer | 0 Comments Filed under: code, batch, dos