All Things Microsoft AI

 One of the best kept secrets of Windows 7 is the "Shrink Volume" utility. TechNet Documentation explains it best at http://technet.microsoft.com/en-us/magazine/gg309169.aspx . Although, this link explains how to use it, it does not list all the advantages of using it.  That will be my goal for this article. The utility will shrink the current volume, leaving all files intact, without a problem.  Although I used this utility many times in the past without issue, I still highly recommend performing a full back-up before using it.  After all, a good backup is always the best insurance against any unforeseen issue. This free utility allows you to shrink a large volume on your hard drive that is not fully utilized.  For example, most developers have large hard drives.  In most cases, they probably have more than 100GB of unused space.  In addition, they most likely have a need to install additional OS for trial or multi-use purposes.  By using the Shr...

Local Events 12/04: ON SQL User Group ( www.ohionorthsqlserverug.org ) 12/11: Cleveland .Net User Group ( www.bennettadelson.com ) 12/18: Cleveland WPF User Group ( www.ClevelandWPF.info ) 12/19: Hudson Software Craftsmanship ( www.hudsonsc.com )   Regional/Online Events 12/04: Training on the T’s SQL Webinars ( www.pragmaticworks.com ) 12/08: CODODN-Columbus (cododn.wordpress.com)    

Local Events  10/02: ON SQL User Group ( www.ohionorthsqlserverug.org ) 10/09: Cleveland .Net User Group ( www.bennettadelson.com ) 10/16: Cleveland WPF User Group ( www.ClevelandWPF.info ) 10/16: Office 365 Great Lakes User Group ( http://www.havilahtech.com/ ) 10/23: Cleveland C#/VB.Net User Group ( www.ClevelandDotNet.info ) Regional Events 10/05: SharePoint UG Golf outing at Quail Hollow ( www.SharepointCleveland.com/ ) 10/06: SQLSaturday 171-Pittsburgh ( www.sqlsaturday.com ) 10/25-26: m3 conference ( www.m3conf.com ) 10/27: SQL Saturday 174-Charlotte ( www.sqlsaturday.com ) 11/8-9: Dogfood Conference ( www.dogfoodcon.com ) 11/17: 1DevDay-Detroit ( 1devdaydetroit.com )  12/08: CODODN-Columbus ( cododn.wordpress.com )  12/08: SQL Saturday 173-DC ( www.sqlsaturday.com )

Q: While editing Script.PostDeployment.sql in a database project, intellisense stopped working. How can I fix this? A: In Visual Studio 2010, intellisense has a defined limit on the file size. If the file gets too large, intellisense will no longer work on that file but the file will continue to build in the solution. Also, a message will appear in the Error List window explaing how to resolve this. The message will state "The script exceeds the Transact-SQL IntelliSense maximum script size setting. You can change the setting on the Text Editor/Transact-SQL/IntelliSense Page in the Tools/Options menu."

Q: How would use tuples in C# 4.0 to create an array of tuples containing various types of data (i.e. Employee Name, Employee ID#)? A: Listed below is a sample code snippet to implement an array of tuples. //Array of Tuples (i.e. EmpName, EmpIDNum) Tuple [] EmpRecs = { Tuple.Create("Sam Nasr", 891), Tuple.Create("Jim Smith", 358), Tuple.Create("Lisa Jones", 962) }; string FirstEmpName = EmpRecs[0].Item1; string SecondEmpName = EmpRecs[1].Item1; int SecondEmpIDNum = EmpRecs[1].Item2; More information can be found at http://msdn.microsoft.com/en-us/library/dd413854(VS.95).aspx

Tonight's Cleveland WPF User Group meeting will continue last month's discussion on MVVM. For those who missed June's meeting, the following resources are available to help prepare for tonight's meeting: • MVVM Overview (June’s Presentation): http://www.clevelandwpf.info/presentations/MVVMOverview.ppt • MVVM, a WPF UI Design Pattern(17min video): http://channel9.msdn.com/shows/Continuum/MVVM/ • Problems and Solutions with Model-View-ViewModel: http://msdn.microsoft.com/en-us/magazine/ff798279.aspx • WPF x FileExplorer x MVVM: http://www.codeproject.com/KB/WPF/WPFFileExplorer.aspx For directions to the Cleveland WPF User Group, please visit www.ClevelandWPF.info

Local Events June 22: Cleveland C#/VB.Net User Group Meeting ( http://www.clevelanddotnet.info/ ) June 23: Cleveland SharePoint User Group Meeting ( http://www.sharepointcleveland.org/ ) June 24: Cleveland IT Martini ( http://www.itmartini.com/ ) July 16: Cleveland Give Camp ( http://www.clevelandgivecamp.org/ ) July 24: TechNic 2010 (Heidi Hooper - Heidi@BoundlessFlight.com ) Regional Events June 26: SQL Saturday-Columbus ( www.sqlsaturday.com/42/schedule.aspx ) June 25-26: CodeStock ( http://www.codestock.org/ ) August 5-7: DevLink ( http://www.devlink.net/ )