All Things Microsoft AI

Local Events 7/2: ON SQL User Group (www.ohionorthsqlserverug.org) 7/9: Cleveland .NET User Group (www.bennettadelson.com/ComingEvents.aspx) 7/16: Cleveland WPF User Group (www.ClevelandWPF.info) 7/17: Hudson Software Craftsmanship Group (hudsonsc.com) 7/23: Cleveland C#/VB.Net User Group (www.clevelanddotnet.info) 7/24: Cleveland SharePoint User’s Group (www.sharepointCleveland.com) Regional Events 7/12-13: Codestock – Knoxville, TN (http://codestock.org) 7/19-21: Cleveland GiveCamp – Cleveland, OH (http://clevelandgivecamp.org/) 8/12-14: That Conference-Wisonsin Dells, WI (http://www.thatconference.com/) 8/28-30: DevLink - Chattanooga, TN (http://www.devlink.net) 8/30: CloudDevelop – Columbus, OH (http://www.clouddevelop.org/) 9/15: SQL Saturday – Pittsburgh, PA (http://www.sqlsaturday.com/250/eventhome.aspx)

Local Events 6/4: ON SQL User Group (www.ohionorthsqlserverug.org) 6/11: Cleveland .NET User Group (ww.bennettadelson.com/ComingEvents.aspx) 6/14: CLE SharePoint Golf Outing: (http://clesharepointgolfouting.eventbrite.com/#) 6/15: Web SIG: Intro to HTML5 (http://www.gcpcug.org/websig) 6/18: Cleveland WPF User Group (www.ClevelandWPF.info) 6/19: Hudson Software Craftsmanship (hudsonsc.com) 6/25: Cleveland C#/VB.Net User Group (www.clevelanddotnet.info) 6/26: SharePoint User’s Group (www.sharepointCleveland.com) Regional Events 6/1: Pittsburgh Tech Fest (http://pghtechfest.com/) 6/8: SQL Saturday – Columbus (http://www.sqlsaturday.com/217/eventhome.aspx) 7/12-13: Codestock – Knoxville, TN (http://codestock.org) 8/12-14: That Conference - Wisonsin Dells, WI (http://www.thatconference.com/) 8/28-30: DevLink - Chattanooga, TN (http://www.devlink.net)

Question : I was putting together a small bit of SQL code the other day, and I was running into a bug. While debugging it, I was completely shocked to discover: IF 'a' < 'A' SELECT 'a < A' IF 'a' = 'A' SELECT 'a = A' IF 'a' > 'A' SELECT 'a > A' IF 'a' <> 'A' SELECT 'a <> A' displays only 'a = A'. I investigated and found out that the reason for this result is that the database's collation sequence is set to one of the "CI" values (Case Insensitive). I took a look at a couple of other databases, and they were also "CI". Oddly enough, they were slightly different collation sequence values, but definitely "CI". This includes the [master] database. Yes, I know it could have been configured the other way. That's not the point of this note. Is "CI" the expected standard configuration? In add...

 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."