<?xml version="1.0" encoding="UTF-8"?>
<?xml-stylesheet type="text/xsl" media="screen" href="/~d/styles/rss2full.xsl"?><?xml-stylesheet type="text/css" media="screen" href="http://feeds.feedburner.com/~d/styles/itemcontent.css"?><rss xmlns:atom="http://www.w3.org/2005/Atom" xmlns:openSearch="http://a9.com/-/spec/opensearch/1.1/" xmlns:blogger="http://schemas.google.com/blogger/2008" xmlns:georss="http://www.georss.org/georss" xmlns:gd="http://schemas.google.com/g/2005" xmlns:thr="http://purl.org/syndication/thread/1.0" xmlns:feedburner="http://rssnamespace.org/feedburner/ext/1.0" version="2.0"><channel><atom:id>tag:blogger.com,1999:blog-10611556</atom:id><lastBuildDate>Sat, 01 Jun 2013 02:37:14 +0000</lastBuildDate><category>promotion</category><category>VBScript</category><category>Sharepoint SDK and Best Practices</category><category>Vista</category><category>Geek Shirt</category><category>Microsoft Certification Exams</category><category>MCAD</category><category>Cleveland Sharepoint</category><category>Stephen Toub</category><category>Logitech Orbit Cam</category><category>SQL Server 2000 Support</category><category>event</category><category>Excel Services MOSS 2007 Trusted locations</category><category>Typemock</category><category>DNN Questions</category><category>VBS Script</category><category>MCSD</category><category>Lorem ipsum dolor sit amet in MS-Word 2003/2007</category><category>Patterns Practices Application Architecture Guide</category><category>Brulant Event</category><category>MCTS Certification</category><category>MCDBA</category><category>CodeStock</category><category>Book</category><category>Cleveland January .Net Events</category><category>TECHnic</category><category>.Net Framework 3.5 Source Code</category><category>SQL Server 2008 Webinars</category><category>Search Server 2008</category><category>Silverlight</category><category>Microsoft Office SharePoint Server 2007 SDK</category><category>Word 2007 Template</category><category>Windows 7</category><title>ClevelandDotNet</title><description>The ClevelandDotNet Blog is created to serve all .Net developers, both in Cleveland and elsewhere.  Various .Net questions, events, and technical topics of interest will be posted regularly.

To learn more about ClevelandDotNet, visit http://www.ClevelandDotNet.info</description><link>http://clevelanddotnet.blogspot.com/</link><managingEditor>noreply@blogger.com (ClevelandDotNet)</managingEditor><generator>Blogger</generator><openSearch:totalResults>243</openSearch:totalResults><openSearch:startIndex>1</openSearch:startIndex><openSearch:itemsPerPage>25</openSearch:itemsPerPage><atom10:link xmlns:atom10="http://www.w3.org/2005/Atom" rel="self" type="application/rss+xml" href="http://feeds.feedburner.com/blogspot/MUMi" /><feedburner:info uri="blogspot/mumi" /><atom10:link xmlns:atom10="http://www.w3.org/2005/Atom" rel="hub" href="http://pubsubhubbub.appspot.com/" /><item><guid isPermaLink="false">tag:blogger.com,1999:blog-10611556.post-7396977159642370948</guid><pubDate>Sat, 01 Jun 2013 02:32:00 +0000</pubDate><atom:updated>2013-05-31T22:37:14.108-04:00</atom:updated><title>June 2013 Local and Regional Events</title><description>&lt;b&gt;Local Events&lt;/b&gt; &lt;br/&gt;
6/4:  ON SQL User Group (www.ohionorthsqlserverug.org) &lt;br/&gt;
6/11: Cleveland .NET User Group (ww.bennettadelson.com/ComingEvents.aspx) &lt;br/&gt;
6/14: CLE SharePoint Golf Outing: (http://clesharepointgolfouting.eventbrite.com/#) &lt;br/&gt;
6/15: Web SIG: Intro to HTML5 (http://www.gcpcug.org/websig) &lt;br/&gt;
6/18: Cleveland WPF User Group (www.ClevelandWPF.info) &lt;br/&gt;
6/19: Hudson Software Craftsmanship (hudsonsc.com) &lt;br/&gt;
6/25: Cleveland C#/VB.Net User Group (www.clevelanddotnet.info) &lt;br/&gt;
6/26: SharePoint User’s Group (www.sharepointCleveland.com) &lt;br/&gt;
&lt;br/&gt;
&lt;br/&gt;
&lt;b&gt;Regional Events&lt;/b&gt; &lt;br/&gt;
6/1: Pittsburgh Tech Fest (http://pghtechfest.com/) &lt;br/&gt;
6/8: SQL Saturday – Columbus (http://www.sqlsaturday.com/217/eventhome.aspx) &lt;br/&gt;
7/12-13: Codestock – Knoxville, TN (http://codestock.org) &lt;br/&gt;
8/12-14: That Conference - Wisonsin Dells, WI (http://www.thatconference.com/) &lt;br/&gt;
8/28-30: DevLink - Chattanooga, TN (http://www.devlink.net)&lt;br/&gt;
&lt;br/&gt;&lt;img src="http://feeds.feedburner.com/~r/blogspot/MUMi/~4/tmROhanIbRY" height="1" width="1"/&gt;</description><link>http://feedproxy.google.com/~r/blogspot/MUMi/~3/tmROhanIbRY/june-2013-local-and-regional-events.html</link><author>noreply@blogger.com (ClevelandDotNet)</author><thr:total>0</thr:total><feedburner:origLink>http://clevelanddotnet.blogspot.com/2013/05/june-2013-local-and-regional-events.html</feedburner:origLink></item><item><guid isPermaLink="false">tag:blogger.com,1999:blog-10611556.post-3212650546470484839</guid><pubDate>Fri, 26 Apr 2013 17:23:00 +0000</pubDate><atom:updated>2013-04-26T13:47:37.617-04:00</atom:updated><title>SQL Server Collation</title><description>&lt;b&gt;Question&lt;/b&gt;:
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:
&lt;p&gt;
IF 'a' &amp;lt; 'A'  &lt;br/&gt;
    SELECT 'a &amp;lt; A'  &lt;br/&gt;&lt;br/&gt;
IF 'a' = 'A'  &lt;br/&gt;
    SELECT 'a = A'  &lt;br/&gt;&lt;br/&gt;
IF 'a' &amp;gt; 'A' &lt;br/&gt;
    SELECT 'a &amp;gt; A'  &lt;br/&gt;&lt;br/&gt;
IF 'a' &amp;lt;&amp;gt; 'A' &lt;br/&gt;
    SELECT 'a &amp;lt;&amp;gt; A'  &lt;br/&gt;&lt;br/&gt;

displays only 'a = A'.
&lt;/p&gt;

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.  &lt;br/&gt;&lt;br/&gt;

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?  &lt;br/&gt;&lt;br/&gt;

In addition to the crazy logic implications, I've got to believe that it's at least a bit slower to execute, since all text-based columns needs to be compared in a case-insensitive way. That character set translation can't come for free. &lt;br/&gt;&lt;br/&gt;&lt;br/&gt;

&lt;b&gt;Answer&lt;/b&gt;:  &lt;br/&gt;
The collation setting is specified during the installation of SQL Server.  As seen in Figure 1, the default settings used during the installation of SQL Server 2012 are: &lt;br/&gt;&lt;br/&gt;

  Database Engine: SQL_Latin1_General_CP1_CI_AS  &lt;br/&gt;
Analysis Services: Latin1_General_CI_AS          &lt;br/&gt;&lt;br/&gt;

&lt;a href="http://4.bp.blogspot.com/-TfelmvNwXJ4/UXq7TUt5fAI/AAAAAAAAAF0/9znuOFso_Hs/s1600/SSCollation.jpg" imageanchor="1" &gt;&lt;img border="0" src="http://4.bp.blogspot.com/-TfelmvNwXJ4/UXq7TUt5fAI/AAAAAAAAAF0/9znuOFso_Hs/s320/SSCollation.jpg" /&gt;&lt;/a&gt; &lt;br/&gt;
Figure 1: SQL Server 2012 Default Collation Settings &lt;br/&gt;&lt;br/&gt;

Technically, there is no "expected CI standard".  It all depends on the collation setting of the database.  This is not to say you're stuck with that setting forever.  If you visit &lt;a href="http://msdn.microsoft.com/en-us/library/ms143726.aspx"&gt;http://msdn.microsoft.com/en-us/library/ms143726.aspx&lt;/a&gt;, you will see the following excerpt:  &lt;br/&gt;&lt;br/&gt;
 
Setting collations are supported at the following levels of an instance of SQL Server:&lt;br/&gt;
Server-level collations &lt;br/&gt;
The default server collation is set during SQL Server setup, and also becomes the default collation of the system databases and all user databases. Note that Unicode-only collations cannot be selected during SQL Server setup because they are not supported as server-level collations.
After a collation has been assigned to the server, you cannot change the collation except by exporting all database objects and data, rebuilding the master database, and importing all database objects and data. Instead of changing the default collation of an instance of SQL Server, you can specify the desired collation at the time that you create a new database or database column.&lt;br/&gt;&lt;br/&gt;
 
Database-level collations &lt;br/&gt;
When a database is created or modified, you can use the COLLATE clause of the CREATE DATABASE or ALTER DATABASE statement to specify the default database collation. If no collation is specified, the database is assigned the server collation.  &lt;br/&gt;
You cannot change the collation of system databases except by changing the collation for the server.
The database collation is used for all metadata in the database, and is the default for all string columns, temporary objects, variable names, and any other strings used in the database. When you change the collation of a user database, know that there is the potential for collation conflicts when queries in the database access temporary tables. Temporary tables are always stored in the tempdb system database, which will use the collation for the instance. Queries that compare character data between the user database and tempdb may fail if the collations cause a conflict in evaluating the character data. You can resolve this by specifying the COLLATE clause in the query. For more information, see COLLATE (Transact-SQL).&lt;br/&gt;&lt;br/&gt;
 
Column-level collations &lt;br/&gt;
When you create or alter a table, you can specify collations for each character-string column by using the COLLATE clause. If no collation is specified, the column is assigned the default collation of the database.&lt;br/&gt;&lt;br/&gt;
 
Expression-level collations &lt;br/&gt;
Expression-level collations are set when a statement is run, and they affect the way a result set is returned. This enables ORDER BY sort results to be locale-specific. Use a COLLATE clause such as the following to implement expression-level collations: &lt;br/&gt;&lt;br/&gt;

SELECT name FROM customer ORDER BY name COLLATE Latin1_General_CS_AI;  &lt;br/&gt;&lt;br/&gt;

For more information on changing collation, please visit &lt;a href="http://msdn.microsoft.com/en-us/library/ms179254.aspx"&gt;http://msdn.microsoft.com/en-us/library/ms179254.aspx&lt;/a&gt;. &lt;br/&gt;&lt;br/&gt;&lt;img src="http://feeds.feedburner.com/~r/blogspot/MUMi/~4/58vjnX-FOjE" height="1" width="1"/&gt;</description><link>http://feedproxy.google.com/~r/blogspot/MUMi/~3/58vjnX-FOjE/sql-server-collation.html</link><author>noreply@blogger.com (ClevelandDotNet)</author><media:thumbnail xmlns:media="http://search.yahoo.com/mrss/" url="http://4.bp.blogspot.com/-TfelmvNwXJ4/UXq7TUt5fAI/AAAAAAAAAF0/9znuOFso_Hs/s72-c/SSCollation.jpg" height="72" width="72" /><thr:total>2</thr:total><feedburner:origLink>http://clevelanddotnet.blogspot.com/2013/04/sql-server-collation.html</feedburner:origLink></item><item><guid isPermaLink="false">tag:blogger.com,1999:blog-10611556.post-1297853186725987921</guid><pubDate>Fri, 21 Dec 2012 20:47:00 +0000</pubDate><atom:updated>2012-12-21T15:53:30.947-05:00</atom:updated><title>Using the "Shrink Volume" Utility</title><description>&amp;nbsp;One of the best kept secrets of Windows 7 is the "Shrink Volume" utility. TechNet Documentation explains it best at &lt;a href="http://technet.microsoft.com/en-us/magazine/gg309169.aspx"&gt;http://technet.microsoft.com/en-us/magazine/gg309169.aspx&lt;/a&gt;. Although, this link explains how to use it, it does not list all the advantages of using it.&amp;nbsp; That will be my goal for this article.&lt;br /&gt;
&lt;br /&gt;
The utility will shrink the current volume, leaving all files intact, without a problem.&amp;nbsp; Although I used this utility many times in the past without issue, I still highly recommend performing a full back-up before using it.&amp;nbsp; After all, a good backup is always the best insurance against any unforeseen issue.&lt;br /&gt;
&lt;br /&gt;
This free utility allows you to shrink a large volume on your hard drive that is not fully utilized.&amp;nbsp; For example, most developers have large hard drives.&amp;nbsp; In most cases, they probably have more than 100GB of unused space.&amp;nbsp; In addition, they most likely have a need to install additional OS for trial or multi-use purposes.&amp;nbsp; By using the Shrink Volume utility, you can now leverage unused space on your hard drive and install different OS’s.&lt;br /&gt;
&lt;br /&gt;
For example, I have a machine with a 500GB Hard drive and only 1 partition (C :\).&amp;nbsp; This partition has Windows 7 installed on it.&amp;nbsp; With all my other storage on it, I was using about 300GB with the remaining 200GB unused.&amp;nbsp; I needed to install SharePoint and SQL Server for a new client but wanted to keep it separate from work I was doing for other clients.&amp;nbsp; SharePoint 2010 requires 64-Bit hardware so I could not run it in a Virtual PC machine.&amp;nbsp; I tried using Hyper-V but ran into several problems.&lt;br /&gt;
&lt;br /&gt;
I used the Shrink Volume utility (as outlined in the TechNet documentation) to reduce my C: drive by 50GB, thus creating a new 50GB partition.&amp;nbsp; I used the new partition to install Windows 2008, SharePoint 2010, and SQL Server. A few months later, I needed to install Windows 8 so I did the same thing and extracted another 41 GB from C: by shrinking it.&amp;nbsp; Now I have three operating systems installed on my hard drive, each fully utilizing the 64-bit capability of my PC and all of its hardware components without any virtualization.&lt;br /&gt;
&lt;br /&gt;
&lt;strong&gt;Boot Manager&lt;/strong&gt;&lt;br /&gt;
After following the directions listed on the TechNet link above, I simply rebooted my PC with a DVD of the new OS inserted in the DVD player.&amp;nbsp; When prompted by the installer, I chose the new empty partition I recently created.&amp;nbsp; The installer then formatted it, installed the new OS, and setup the Boot Manager with all the existing OS’s.&lt;br /&gt;
After installation was completed, the PC rebooted once more.&amp;nbsp; After the system check, I was prompted to select an OS from the Boot Manager Menu within a specified number of seconds.&amp;nbsp; &lt;br /&gt;
 &lt;br /&gt;
&lt;br /&gt;
&lt;strong&gt;Boot Manager Settings&lt;/strong&gt;&lt;br /&gt;
The settings for the Boot Manager can be changed from two places. First, it can be accessed from the Control Panel &amp;gt; System &amp;gt; Change settings &amp;gt; “Advanced” tab &amp;gt; “Settings” in Startup and Recovery section.&lt;br /&gt;
The second method allows for more advanced options of the Boot Manager.&amp;nbsp; It can be accessed from Control Panel &amp;gt; Administrative Tools &amp;gt; System Configuration &amp;gt; “Boot” tab.&lt;br /&gt;
&lt;strong&gt;&lt;/strong&gt;&lt;br /&gt;
&lt;strong&gt;Partition Access&lt;/strong&gt;&lt;br /&gt;
Once you select the operating system of choice, the PC will boot normally.&amp;nbsp; The partition with the chosen operating system will become “C:\” and the other partitions will be assigned other drive letters.&amp;nbsp; This happens automatically without user intervention.&amp;nbsp; The other partitions will be exposed and the files on them will be accessible. This allows access to the file system on each partition without having to boot into that specific partition.&amp;nbsp; &lt;br /&gt;
&lt;br /&gt;
&lt;strong&gt;Summary&lt;/strong&gt;&lt;br /&gt;
In closing, listed below are all key advantages of using the Shrink Volume utility.&lt;br /&gt;
•&amp;nbsp;Free built in utility: The Shrink Volume utility is standard on all Windows 7 machines, as part of the OS.&lt;br /&gt;
•&amp;nbsp;Reliable: All files are left in place without corruption.&amp;nbsp; However, a full backup is highly recommended before using this utility.&lt;br /&gt;
•&amp;nbsp;Automatically configures Boot Manager menu&lt;br /&gt;
•&amp;nbsp;All partitions are always visible and accessible&lt;br /&gt;
•&amp;nbsp;Leverages your current investment in hardware by using free disk space&lt;br /&gt;
•&amp;nbsp;New OS’s are installed natively on the machine, accessing all hardware without virtualization.&lt;img src="http://feeds.feedburner.com/~r/blogspot/MUMi/~4/REvt0XQM-7U" height="1" width="1"/&gt;</description><link>http://feedproxy.google.com/~r/blogspot/MUMi/~3/REvt0XQM-7U/using-shrink-volume-utility.html</link><author>noreply@blogger.com (ClevelandDotNet)</author><thr:total>0</thr:total><feedburner:origLink>http://clevelanddotnet.blogspot.com/2012/12/using-shrink-volume-utility.html</feedburner:origLink></item><item><guid isPermaLink="false">tag:blogger.com,1999:blog-10611556.post-5213191447488237173</guid><pubDate>Tue, 04 Dec 2012 20:05:00 +0000</pubDate><atom:updated>2012-12-04T15:06:23.625-05:00</atom:updated><title>December Events</title><description>&lt;strong&gt;&lt;u&gt;Local Events&lt;/u&gt;&lt;/strong&gt;&lt;br /&gt;
12/04: ON SQL User Group (&lt;a href="http://www.ohionorthsqlserverug.org/"&gt;www.ohionorthsqlserverug.org&lt;/a&gt;) &lt;br /&gt;
12/11: Cleveland .Net User Group (&lt;a href="http://www.bennettadelson.com/"&gt;www.bennettadelson.com&lt;/a&gt;) &lt;br /&gt;
12/18: Cleveland WPF User Group (&lt;a href="http://www.clevelandwpf.info/"&gt;www.ClevelandWPF.info&lt;/a&gt;)&lt;br /&gt;
12/19: Hudson Software Craftsmanship (&lt;a href="http://www.hudsonsc.com/"&gt;www.hudsonsc.com&lt;/a&gt;) &amp;nbsp; &lt;br /&gt;
&lt;br /&gt;
&lt;strong&gt;&lt;u&gt;Regional/Online Events&lt;/u&gt;&lt;/strong&gt;&lt;br /&gt;
12/04: Training on the T’s SQL Webinars (&lt;a href="http://www.pragmaticworks.com/"&gt;www.pragmaticworks.com&lt;/a&gt;)&lt;br /&gt;
12/08: CODODN-Columbus (cododn.wordpress.com) &amp;nbsp;&amp;nbsp;&amp;nbsp;&lt;img src="http://feeds.feedburner.com/~r/blogspot/MUMi/~4/Cssda0QdeDg" height="1" width="1"/&gt;</description><link>http://feedproxy.google.com/~r/blogspot/MUMi/~3/Cssda0QdeDg/december-events.html</link><author>noreply@blogger.com (ClevelandDotNet)</author><thr:total>0</thr:total><feedburner:origLink>http://clevelanddotnet.blogspot.com/2012/12/december-events.html</feedburner:origLink></item><item><guid isPermaLink="false">tag:blogger.com,1999:blog-10611556.post-3059296163558145291</guid><pubDate>Tue, 02 Oct 2012 17:23:00 +0000</pubDate><atom:updated>2012-10-20T06:03:14.977-04:00</atom:updated><title>Area Events</title><description>&lt;strong&gt;&lt;u&gt;Local Events&lt;/u&gt;&lt;/strong&gt;&lt;br /&gt;
&amp;nbsp;10/02: ON SQL User Group (&lt;a href="http://www.ohionorthsqlserverug.org/"&gt;www.ohionorthsqlserverug.org&lt;/a&gt;) &lt;br /&gt;
10/09: Cleveland .Net User Group (&lt;a href="http://www.bennettadelson.com/"&gt;www.bennettadelson.com&lt;/a&gt;) &lt;br /&gt;
10/16: Cleveland WPF User Group (&lt;a href="http://www.clevelandwpf.info/"&gt;www.ClevelandWPF.info&lt;/a&gt;) &lt;br /&gt;
10/16: Office 365 Great Lakes User Group (&lt;a href="http://www.havilahtech.com/"&gt;http://www.havilahtech.com/&lt;/a&gt;)&lt;br /&gt;
10/23: Cleveland C#/VB.Net User Group (&lt;a href="http://www.clevelanddotnet.info/"&gt;www.ClevelandDotNet.info&lt;/a&gt;) &lt;br /&gt;
&lt;br /&gt;
&lt;strong&gt;&lt;u&gt;Regional Events&lt;/u&gt;&lt;/strong&gt;&lt;br /&gt;
10/05: SharePoint UG Golf outing at Quail Hollow (&lt;a href="http://www.sharepointcleveland.com/"&gt;www.SharepointCleveland.com/&lt;/a&gt;)&lt;br /&gt;
10/06: SQLSaturday 171-Pittsburgh (&lt;a href="http://www.sqlsaturday.com/"&gt;www.sqlsaturday.com&lt;/a&gt;) &lt;br /&gt;
10/25-26: m3 conference (&lt;a href="http://www.m3conf.com/"&gt;www.m3conf.com&lt;/a&gt;) &lt;br /&gt;10/27: SQL Saturday 174-Charlotte (&lt;a href="http://www.sqlsaturday.com/"&gt;www.sqlsaturday.com&lt;/a&gt;) &lt;br /&gt;
11/8-9: Dogfood Conference (&lt;a href="http://www.dogfoodcon.com/"&gt;www.dogfoodcon.com&lt;/a&gt;) &lt;br /&gt;11/17: 1DevDay-Detroit (&lt;a href="http://1devdaydetroit.com/"&gt;1devdaydetroit.com&lt;/a&gt;)&amp;nbsp; &lt;br /&gt;
12/08: CODODN-Columbus (&lt;a href="http://cododn.wordpress.com/"&gt;cododn.wordpress.com&lt;/a&gt;)&amp;nbsp; &lt;br /&gt;
12/08: SQL Saturday 173-DC (&lt;a href="http://www.sqlsaturday.com/"&gt;www.sqlsaturday.com&lt;/a&gt;) &lt;br /&gt;&lt;img src="http://feeds.feedburner.com/~r/blogspot/MUMi/~4/RlvVFpouy1E" height="1" width="1"/&gt;</description><link>http://feedproxy.google.com/~r/blogspot/MUMi/~3/RlvVFpouy1E/area-events.html</link><author>noreply@blogger.com (ClevelandDotNet)</author><thr:total>0</thr:total><feedburner:origLink>http://clevelanddotnet.blogspot.com/2012/10/area-events.html</feedburner:origLink></item><item><guid isPermaLink="false">tag:blogger.com,1999:blog-10611556.post-7979456445877760397</guid><pubDate>Fri, 27 May 2011 21:53:00 +0000</pubDate><atom:updated>2011-05-27T17:54:09.870-04:00</atom:updated><title>Intellisense not working</title><description>&lt;strong&gt;Q:&lt;/strong&gt; While editing Script.PostDeployment.sql in a database project, intellisense stopped working.  How can I fix this?&lt;br /&gt;&lt;br /&gt;&lt;strong&gt;A:&lt;/strong&gt;  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."&lt;img src="http://feeds.feedburner.com/~r/blogspot/MUMi/~4/1OKCsKwnKc8" height="1" width="1"/&gt;</description><link>http://feedproxy.google.com/~r/blogspot/MUMi/~3/1OKCsKwnKc8/intellisense-not-working.html</link><author>noreply@blogger.com (ClevelandDotNet)</author><thr:total>2</thr:total><feedburner:origLink>http://clevelanddotnet.blogspot.com/2011/05/intellisense-not-working.html</feedburner:origLink></item><item><guid isPermaLink="false">tag:blogger.com,1999:blog-10611556.post-5444345242477460340</guid><pubDate>Wed, 28 Jul 2010 12:26:00 +0000</pubDate><atom:updated>2010-07-28T08:39:10.740-04:00</atom:updated><title>Array of Tuples</title><description>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#)?&lt;br /&gt;&lt;br /&gt;A: Listed below is a sample code snippet to implement an array of tuples.&lt;br /&gt;&lt;br /&gt;            //Array of Tuples (i.e. EmpName, EmpIDNum)&lt;br /&gt;            Tuple&lt;string, int&gt;[] EmpRecs =&lt;br /&gt;             { &lt;br /&gt;                 Tuple.Create("Sam Nasr", 891),&lt;br /&gt;                 Tuple.Create("Jim Smith", 358),&lt;br /&gt;                 Tuple.Create("Lisa Jones", 962) &lt;br /&gt;             };&lt;br /&gt;&lt;br /&gt;            string FirstEmpName = EmpRecs[0].Item1;&lt;br /&gt;            &lt;br /&gt;            string SecondEmpName = EmpRecs[1].Item1;&lt;br /&gt;            int SecondEmpIDNum = EmpRecs[1].Item2;&lt;br /&gt;&lt;br /&gt;&lt;br /&gt;More information can be found at http://msdn.microsoft.com/en-us/library/dd413854(VS.95).aspx&lt;img src="http://feeds.feedburner.com/~r/blogspot/MUMi/~4/TzcQ0N4jBNg" height="1" width="1"/&gt;</description><link>http://feedproxy.google.com/~r/blogspot/MUMi/~3/TzcQ0N4jBNg/array-of-tuples.html</link><author>noreply@blogger.com (ClevelandDotNet)</author><thr:total>3</thr:total><feedburner:origLink>http://clevelanddotnet.blogspot.com/2010/07/array-of-tuples.html</feedburner:origLink></item><item><guid isPermaLink="false">tag:blogger.com,1999:blog-10611556.post-2107839688483517589</guid><pubDate>Tue, 20 Jul 2010 20:17:00 +0000</pubDate><atom:updated>2010-07-20T16:24:45.522-04:00</atom:updated><title>MVVM Resources</title><description>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:&lt;br /&gt;• MVVM Overview (June’s Presentation): &lt;a href="http://www.clevelandwpf.info/presentations/MVVMOverview.ppt"&gt;http://www.clevelandwpf.info/presentations/MVVMOverview.ppt&lt;/a&gt;&lt;br /&gt;• MVVM, a WPF UI Design Pattern(17min video): &lt;a href="http://channel9.msdn.com/shows/Continuum/MVVM/"&gt;http://channel9.msdn.com/shows/Continuum/MVVM/&lt;/a&gt;&lt;br /&gt;• Problems and Solutions with Model-View-ViewModel: &lt;a href="http://msdn.microsoft.com/en-us/magazine/ff798279.aspx"&gt;http://msdn.microsoft.com/en-us/magazine/ff798279.aspx&lt;/a&gt;&lt;br /&gt;• WPF x FileExplorer x MVVM: &lt;a href="http://www.codeproject.com/KB/WPF/WPFFileExplorer.aspx"&gt;http://www.codeproject.com/KB/WPF/WPFFileExplorer.aspx&lt;/a&gt;&lt;br /&gt;&lt;br /&gt;For directions to the Cleveland WPF User Group, please visit  &lt;a href="http://www.clevelandwpf.info/"&gt;www.ClevelandWPF.info&lt;/a&gt;&lt;img src="http://feeds.feedburner.com/~r/blogspot/MUMi/~4/PXvz_l-BLkg" height="1" width="1"/&gt;</description><link>http://feedproxy.google.com/~r/blogspot/MUMi/~3/PXvz_l-BLkg/mvvm-resources.html</link><author>noreply@blogger.com (ClevelandDotNet)</author><thr:total>0</thr:total><feedburner:origLink>http://clevelanddotnet.blogspot.com/2010/07/mvvm-resources.html</feedburner:origLink></item><item><guid isPermaLink="false">tag:blogger.com,1999:blog-10611556.post-455707364994677135</guid><pubDate>Mon, 21 Jun 2010 18:24:00 +0000</pubDate><atom:updated>2010-06-21T14:54:52.629-04:00</atom:updated><title>Local &amp; Regional Events</title><description>&lt;strong&gt;&lt;u&gt;Local Events&lt;br /&gt;&lt;/u&gt;&lt;/strong&gt;June 22: Cleveland C#/VB.Net User Group Meeting (&lt;a href="http://www.clevelanddotnet.info/"&gt;http://www.clevelanddotnet.info/&lt;/a&gt;)&lt;br /&gt;June 23: Cleveland SharePoint User Group Meeting (&lt;a href="http://www.sharepointcleveland.org/"&gt;http://www.sharepointcleveland.org/&lt;/a&gt;)&lt;br /&gt;June 24: Cleveland IT Martini (&lt;a href="http://www.itmartini.com/"&gt;http://www.itmartini.com/&lt;/a&gt;)&lt;br /&gt;July 16: Cleveland Give Camp (&lt;a href="http://www.clevelandgivecamp.org/"&gt;http://www.clevelandgivecamp.org/&lt;/a&gt;)&lt;br /&gt;July 24: TechNic 2010 (Heidi Hooper - &lt;a href="mailto:Heidi@BoundlessFlight.com"&gt;Heidi@BoundlessFlight.com&lt;/a&gt;)&lt;br /&gt;&lt;br /&gt;&lt;strong&gt;&lt;u&gt;Regional Events&lt;/u&gt;&lt;/strong&gt;&lt;br /&gt;June 26: SQL Saturday-Columbus (&lt;a href="http://www.sqlsaturday.com/42/schedule.aspx"&gt;www.sqlsaturday.com/42/schedule.aspx&lt;/a&gt;)&lt;br /&gt;June 25-26: CodeStock (&lt;a href="http://www.codestock.org/"&gt;http://www.codestock.org/&lt;/a&gt;)&lt;br /&gt;August 5-7: DevLink (&lt;a href="http://www.devlink.net/"&gt;http://www.devlink.net/&lt;/a&gt;)&lt;img src="http://feeds.feedburner.com/~r/blogspot/MUMi/~4/xNJGsCzILos" height="1" width="1"/&gt;</description><link>http://feedproxy.google.com/~r/blogspot/MUMi/~3/xNJGsCzILos/local-regional-events.html</link><author>noreply@blogger.com (ClevelandDotNet)</author><thr:total>0</thr:total><feedburner:origLink>http://clevelanddotnet.blogspot.com/2010/06/local-regional-events.html</feedburner:origLink></item><item><guid isPermaLink="false">tag:blogger.com,1999:blog-10611556.post-263888132837302511</guid><pubDate>Sat, 29 May 2010 13:22:00 +0000</pubDate><atom:updated>2010-05-29T09:34:42.461-04:00</atom:updated><title>Toughest Developer Puzzle Ever</title><description>So you think you're a hot shot developer able to resolve every problem that comes your way. Put your skills to the test by visiting &lt;a href="http://www.toughestdeveloperpuzzleever.com/"&gt;www.toughestdeveloperpuzzleever.com&lt;/a&gt;.  The site offers 100 levels of varying difficutly.  To maneuver through the levels, you have to examine the page for cllues that will allow you to go to the next levels.  Some pages have a hidden link, others require you change the URL manually, etc.&lt;br /&gt;&lt;br /&gt;The site is scheduled to launch on May 31 and offers great prizes for the first 100 people to complete it, with excpetionally great prizes for the first 5!  Put your thinking caps and visit &lt;a href="http://www.toughestdeveloperpuzzleever.com/"&gt;www.toughestdeveloperpuzzleever.com&lt;/a&gt;!&lt;img src="http://feeds.feedburner.com/~r/blogspot/MUMi/~4/tjv9NhAcEkw" height="1" width="1"/&gt;</description><link>http://feedproxy.google.com/~r/blogspot/MUMi/~3/tjv9NhAcEkw/toughest-developer-puzzle-ever.html</link><author>noreply@blogger.com (ClevelandDotNet)</author><thr:total>2</thr:total><feedburner:origLink>http://clevelanddotnet.blogspot.com/2010/05/toughest-developer-puzzle-ever.html</feedburner:origLink></item><item><guid isPermaLink="false">tag:blogger.com,1999:blog-10611556.post-477004321418107342</guid><pubDate>Tue, 04 May 2010 17:21:00 +0000</pubDate><atom:updated>2010-05-04T13:33:13.086-04:00</atom:updated><title>T3CHn!c 2010 - Bringing the Northeast Ohio Technical Community Together</title><description>The 2nd annual TechNic will build on the camaraderie of the boundless IT community of Northeast Ohio with the support of companies and organizations by providing a free event for attendees to simply enjoy a summer day of classic picnic fun and activities.&lt;br /&gt;&lt;br /&gt;Last year’s event brought together over 200 attendees and 20 supporting companies from around the globe! Pictures of last year's event can be seen &lt;a href="http://s724.photobucket.com/albums/ww244/adelheid_photos/TECHnic%206-20-09/?albumview=slideshow"&gt;here&lt;/a&gt;.&lt;br /&gt;&lt;br /&gt;We hope that your organization becomes a part of T3CHn!c TM 2010. Feel free to include your friends, family, employees, customers, clients, partners, prospects, and their friends and families, too!&lt;br /&gt;&lt;br /&gt;Logos of supporting organizations will be displayed on all announcements. Consistent mention and messaging on behalf of supporters will be made through social media and other public relations, with a higher level of promotion for top sponsors. Banners and other means of visibility will be displayed at the event.&lt;br /&gt;&lt;br /&gt;&lt;strong&gt;Suggested donation guidelines:&lt;/strong&gt;&lt;br /&gt;$200 +.....................................T3CHn!c TM 2010 Sponsorship&lt;br /&gt;$75....................................... Table Rental for Service / Product Demo&lt;br /&gt;$100...................................... Keg&lt;br /&gt;$50....................................... Food &amp;amp; Beverages&lt;br /&gt;$Peerless................................. Prizes, Entertainment&lt;br /&gt;$Priceless................................ Swag, Volunteers&lt;br /&gt;&lt;br /&gt;July 24th, 2010, 11am – 8pm  (Rain or shine!)&lt;br /&gt;St. Sava’s Picnic Grove&lt;br /&gt;2300 W Ridgewood&lt;br /&gt;Parma OH 44134&lt;br /&gt;&lt;br /&gt;For more information, contact:&lt;br /&gt;Heidi Hooper&lt;br /&gt;216-469-1163&lt;br /&gt;Heidi@BoundlessFlight.com&lt;br /&gt;Twitter: @Heidi1163&lt;img src="http://feeds.feedburner.com/~r/blogspot/MUMi/~4/aAvZa2rSW7o" height="1" width="1"/&gt;</description><link>http://feedproxy.google.com/~r/blogspot/MUMi/~3/aAvZa2rSW7o/technic-2010.html</link><author>noreply@blogger.com (ClevelandDotNet)</author><thr:total>2</thr:total><feedburner:origLink>http://clevelanddotnet.blogspot.com/2010/05/technic-2010.html</feedburner:origLink></item><item><guid isPermaLink="false">tag:blogger.com,1999:blog-10611556.post-467978910553493354</guid><pubDate>Mon, 29 Mar 2010 21:03:00 +0000</pubDate><atom:updated>2010-03-29T17:12:40.602-04:00</atom:updated><title>Regional .Net Events</title><description>&lt;span style="font-size:85%;"&gt;Listed below are upcoming regional events relating to .Net
&lt;br /&gt;
&lt;br /&gt;April 17: Pittsburgh Code Camp (&lt;/span&gt;&lt;a href="http://codecamppgh.com/default.aspx"&gt;&lt;span style="font-size:85%;"&gt;http://codecamppgh.com/default.aspx&lt;/span&gt;&lt;/a&gt;&lt;span style="font-size:85%;"&gt;) &lt;/span&gt;
&lt;br /&gt;&lt;span style="font-size:85%;"&gt;
&lt;br /&gt;April 20: Cleveland WPF User Group –RIA Services by Chris Woodruff (&lt;/span&gt;&lt;a href="http://www.clevelandwpf.info/"&gt;&lt;span style="font-size:85%;"&gt;http://www.clevelandwpf.info/&lt;/span&gt;&lt;/a&gt;&lt;span style="font-size:85%;"&gt;)
&lt;br /&gt;&lt;/span&gt;
&lt;br /&gt;&lt;span style="font-size:85%;"&gt;April 27: Cleveland C#/VB.Net User Group - Architecture tools in Visual Studio 2010 by Cameron Skinner (Microsoft) (&lt;/span&gt;&lt;a href="http://www.clevelanddotnet.info/"&gt;&lt;span style="font-size:85%;"&gt;http://www.clevelanddotnet.info/&lt;/span&gt;&lt;/a&gt;&lt;span style="font-size:85%;"&gt;)
&lt;br /&gt;&lt;/span&gt;
&lt;br /&gt;&lt;span style="font-size:85%;"&gt;April 28: Cleveland SharePoint User Group (&lt;/span&gt;&lt;a href="http://www.sharepointcleveland.com/default.aspx"&gt;&lt;span style="font-size:85%;"&gt;http://www.sharepointcleveland.com/default.aspx&lt;/span&gt;&lt;/a&gt;&lt;span style="font-size:85%;"&gt;)
&lt;br /&gt;&lt;/span&gt;
&lt;br /&gt;&lt;span style="font-size:85%;"&gt;May 1: Ann Arbor Day of .Net (&lt;/span&gt;&lt;a href="http://www.dayofdotnet.org/AnnArbor/Spring2010/default.aspx"&gt;&lt;span style="font-size:85%;"&gt;http://www.dayofdotnet.org/AnnArbor/Spring2010/default.aspx&lt;/span&gt;&lt;/a&gt;&lt;span style="font-size:85%;"&gt;)
&lt;br /&gt;&lt;/span&gt;
&lt;br /&gt;&lt;span style="font-size:85%;"&gt;May 1: Chicago Code Camp (&lt;/span&gt;&lt;a href="http://chicagocodecamp.com/"&gt;&lt;span style="font-size:85%;"&gt;http://chicagocodecamp.com/&lt;/span&gt;&lt;/a&gt;&lt;span style="font-size:85%;"&gt;)
&lt;br /&gt;&lt;/span&gt;
&lt;br /&gt;&lt;span style="font-size:85%;"&gt;May 7: Stir Trek (&lt;/span&gt;&lt;a href="http://www.stirtrek.com/"&gt;&lt;span style="font-size:85%;"&gt;http://www.stirtrek.com/&lt;/span&gt;&lt;/a&gt;&lt;span style="font-size:85%;"&gt;)
&lt;br /&gt;&lt;/span&gt;
&lt;br /&gt;&lt;span style="font-size:85%;"&gt;June 25-26: Code Stock (&lt;/span&gt;&lt;a href="http://www.codestock.org/"&gt;&lt;span style="font-size:85%;"&gt;http://www.codestock.org/&lt;/span&gt;&lt;/a&gt;&lt;span style="font-size:85%;"&gt;)
&lt;br /&gt;&lt;/span&gt;
&lt;br /&gt;&lt;span style="font-size:85%;"&gt;June 26: Columbus SQL Saturday (&lt;/span&gt;&lt;a href="http://www.sqlsaturday.com/42/eventhome.aspx"&gt;&lt;span style="font-size:85%;"&gt;http://www.sqlsaturday.com/42/eventhome.aspx&lt;/span&gt;&lt;/a&gt;&lt;span style="font-size:85%;"&gt;)
&lt;br /&gt;&lt;/span&gt;
&lt;br /&gt;&lt;span style="font-size:85%;"&gt;August 5-7: DevLink (&lt;/span&gt;&lt;a href="http://devlink.net/"&gt;&lt;span style="font-size:85%;"&gt;http://devlink.net/&lt;/span&gt;&lt;/a&gt;&lt;span style="font-size:85%;"&gt;)&lt;/span&gt;
&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;&lt;img src="http://feeds.feedburner.com/~r/blogspot/MUMi/~4/PjKe5xG9muU" height="1" width="1"/&gt;</description><link>http://feedproxy.google.com/~r/blogspot/MUMi/~3/PjKe5xG9muU/regional-net-events.html</link><author>noreply@blogger.com (ClevelandDotNet)</author><thr:total>0</thr:total><feedburner:origLink>http://clevelanddotnet.blogspot.com/2010/03/regional-net-events.html</feedburner:origLink></item><item><guid isPermaLink="false">tag:blogger.com,1999:blog-10611556.post-967628592343005079</guid><pubDate>Sat, 03 Oct 2009 18:08:00 +0000</pubDate><atom:updated>2009-10-03T14:17:09.845-04:00</atom:updated><category domain="http://www.blogger.com/atom/ns#">Stephen Toub</category><title>Special October Meeting</title><description>Stephen Toub from the Parallel Computing Platform team at Microsoft will be presenting at the Cleveland C#/VB.Net User Group on Thursday, October 29, 2009.  Please note this meeting date is in addition to, not replacing, our regularly scheduled meeting every 4th Tuesday (October 27, 2009).&lt;br /&gt;&lt;br /&gt;He will be travelling through our district the last week of October.  He will be speaking at corporations during the day, and user groups in the evening.  Stephen's goal is to get direct feedback from developers on the products he works on.  Your questions and feedback help make .NET better!&lt;br /&gt;&lt;br /&gt;Stephen will discuss concurrency and how .NET 4.0 simplifies parallel programming.  This is one of the exciting things about .NET 4.0.  With Moore’s Law breaking down, software developers need to be able to master multithreading and know how to develop concurrent applications.  Historically, this has been very difficult.  It’s hard to understand concurrency issues, hard to write good code, and hard to debug when race conditions and such do happen.  With .NET 4.0, there are APIs and tools to make parallel programming much simpler.   &lt;br /&gt;&lt;br /&gt;If you would like to attend this special meeting, please send an e-mail to &lt;a href="mailto:sam@clevelanddotnet.info"&gt;sam@clevelanddotnet.info&lt;/a&gt; with "RSVP" in the subject line.&lt;img src="http://feeds.feedburner.com/~r/blogspot/MUMi/~4/PhRftiZv65Y" height="1" width="1"/&gt;</description><link>http://feedproxy.google.com/~r/blogspot/MUMi/~3/PhRftiZv65Y/special-october-meeting.html</link><author>noreply@blogger.com (ClevelandDotNet)</author><thr:total>0</thr:total><feedburner:origLink>http://clevelanddotnet.blogspot.com/2009/10/special-october-meeting.html</feedburner:origLink></item><item><guid isPermaLink="false">tag:blogger.com,1999:blog-10611556.post-1781059466662200749</guid><pubDate>Fri, 18 Sep 2009 03:21:00 +0000</pubDate><atom:updated>2009-09-17T23:25:27.941-04:00</atom:updated><category domain="http://www.blogger.com/atom/ns#">Typemock</category><title>Typemock Webinar</title><description>Typemock is holding a free live webinar (web-seminar) on how to unit test successfully.  The webinar will include the following:&lt;br /&gt;&lt;br /&gt;· Creating Supporting environment&lt;br /&gt;· Unit testing tools of the trade&lt;br /&gt;· Practices and Pitfalls&lt;br /&gt;· Writing the first test&lt;br /&gt;· Live Q &amp;amp; A&lt;br /&gt;&lt;br /&gt;You can get more details on - &lt;a href="http://blog.typemock.com/2009/09/unit-testing-net-successfully-live-free.html"&gt;http://blog.typemock.com/2009/09/unit-testing-net-successfully-live-free.html&lt;/a&gt;&lt;img src="http://feeds.feedburner.com/~r/blogspot/MUMi/~4/VuPCwQpN4V4" height="1" width="1"/&gt;</description><link>http://feedproxy.google.com/~r/blogspot/MUMi/~3/VuPCwQpN4V4/typemock-webinar.html</link><author>noreply@blogger.com (ClevelandDotNet)</author><thr:total>0</thr:total><feedburner:origLink>http://clevelanddotnet.blogspot.com/2009/09/typemock-webinar.html</feedburner:origLink></item><item><guid isPermaLink="false">tag:blogger.com,1999:blog-10611556.post-3358532184736421776</guid><pubDate>Fri, 03 Jul 2009 02:35:00 +0000</pubDate><atom:updated>2009-07-02T22:49:26.932-04:00</atom:updated><category domain="http://www.blogger.com/atom/ns#">Windows 7</category><category domain="http://www.blogger.com/atom/ns#">Vista</category><title>Windows Client Feature Comparison</title><description>Microsoft released a chart highlighting the features of Windows 7, Vista SP1, and Windows Xp SP3.  It lists features in 5 categories:&lt;br /&gt;&lt;br /&gt;File organization and Search&lt;br /&gt;Remote Access&lt;br /&gt;Security and Compliance&lt;br /&gt;Management&lt;br /&gt;Deployment&lt;br /&gt;&lt;br /&gt;To download the comparison chart, go to &lt;a href="http://www.microsoft.com/downloads/details.aspx?familyid=FA0177CC-7E82-4993-B0D6-FEC84216DD9C&amp;amp;displaylang=en"&gt;http://www.microsoft.com/downloads/details.aspx?familyid=FA0177CC-7E82-4993-B0D6-FEC84216DD9C&amp;amp;displaylang=en&lt;/a&gt; \&lt;img src="http://feeds.feedburner.com/~r/blogspot/MUMi/~4/aXAErb4kCPQ" height="1" width="1"/&gt;</description><link>http://feedproxy.google.com/~r/blogspot/MUMi/~3/aXAErb4kCPQ/windows-client-feature-comparison.html</link><author>noreply@blogger.com (ClevelandDotNet)</author><thr:total>0</thr:total><feedburner:origLink>http://clevelanddotnet.blogspot.com/2009/07/windows-client-feature-comparison.html</feedburner:origLink></item><item><guid isPermaLink="false">tag:blogger.com,1999:blog-10611556.post-5152203225000704810</guid><pubDate>Mon, 25 May 2009 16:11:00 +0000</pubDate><atom:updated>2009-05-26T12:34:00.987-04:00</atom:updated><category domain="http://www.blogger.com/atom/ns#">TECHnic</category><title>Cleveland TECHnic</title><description>On Saturday, June 20, 2009, several local technology vendors and user groups will collaborate on hosting a summer picnic, called "TECHnic". The event is scheduled from 10AM-8PM at St. Sava's Picnic Grove in Parma, OH. For more information, please visit &lt;a href="http://www.tinyurl.com/TECHnicPicnic"&gt;www.tinyurl.com/TECHnicPicnic&lt;/a&gt;.&lt;img src="http://feeds.feedburner.com/~r/blogspot/MUMi/~4/pZ5vJEc3qH8" height="1" width="1"/&gt;</description><link>http://feedproxy.google.com/~r/blogspot/MUMi/~3/pZ5vJEc3qH8/cleveland-technic.html</link><author>noreply@blogger.com (ClevelandDotNet)</author><thr:total>1</thr:total><feedburner:origLink>http://clevelanddotnet.blogspot.com/2009/05/cleveland-technic.html</feedburner:origLink></item><item><guid isPermaLink="false">tag:blogger.com,1999:blog-10611556.post-5975669548352830769</guid><pubDate>Mon, 18 May 2009 18:10:00 +0000</pubDate><atom:updated>2009-05-18T14:35:59.644-04:00</atom:updated><category domain="http://www.blogger.com/atom/ns#">CodeStock</category><title>CodeStock 2009</title><description>&lt;a href="http://codestock.org/Default.aspx"&gt;CodeStock 2009&lt;/a&gt; is a conference for software developers held in Knoxville, TN.  The event is aimed at providing the latest and greatest topics in software development across various platforms.  In addition, the event also has "open spaces" where fellow developers can gather and discuss any topic on their mind at the moment.  This could range from advantages of C# vs. VB.Net to  the pros/cons of Agile development to surviving a tough economic period. &lt;br /&gt;&lt;br /&gt;This year's event will be held June 26 - June 27, providing a variety of topics for 2 full days.  The full list of sessions is available at &lt;a href="http://codestock.org/Sessions.aspx"&gt;http://codestock.org/Sessions.aspx&lt;/a&gt; with the exact scheduling due out soon.  Tickets for the event are $25 if purchased before June 1st, and $45 afterwards.&lt;br /&gt;&lt;br /&gt;For members of the Cleveland C#/VB.Net User Group, 2 tickets have been provided free of charge to the first 2 people to respond to this blog.  To claim your ticket, simply send an e-mail to &lt;a href="mailto:sam@clevelanddotnet.info"&gt;sam@clevelanddotnet.info&lt;/a&gt;.  If you're interested in car-pooling to the event from Cleveland, OH, please send an e-mail to the same address.&lt;br /&gt;&lt;br /&gt;For more information on CodeStock, please visit &lt;a href="http://codestock.org/"&gt;http://codestock.org&lt;/a&gt;&lt;img src="http://feeds.feedburner.com/~r/blogspot/MUMi/~4/YLReSnFWuFM" height="1" width="1"/&gt;</description><link>http://feedproxy.google.com/~r/blogspot/MUMi/~3/YLReSnFWuFM/codestock-2009.html</link><author>noreply@blogger.com (ClevelandDotNet)</author><thr:total>0</thr:total><feedburner:origLink>http://clevelanddotnet.blogspot.com/2009/05/codestock-2009.html</feedburner:origLink></item><item><guid isPermaLink="false">tag:blogger.com,1999:blog-10611556.post-6344152903391213382</guid><pubDate>Wed, 08 Apr 2009 18:01:00 +0000</pubDate><atom:updated>2009-04-08T14:04:10.850-04:00</atom:updated><title>Set the identity specification on a primary key</title><description>Q: I always used databases provided by Microsoft to practice on. Today I tried to create my own and ran into trouble. Problem is that I cannot set the identity specification on a primary key. The column properties show up as no and I cannot change it to yes. I’m using SQL Server Express 2005 on a Vista machine. Any thoughts?&lt;br /&gt;&lt;br /&gt;A: .  To change column properties, you must modify the table (right click table and select “Modify”).  Select and highlight the column you want to change, then expand the “Identity Specification” in the “Column Properties” pane.  Change the “Is Identity” property to “Yes”.  Please note the change must be made to the “Is Identity” property, not the “Identity Specification”.&lt;img src="http://feeds.feedburner.com/~r/blogspot/MUMi/~4/k2SHhfPrdsA" height="1" width="1"/&gt;</description><link>http://feedproxy.google.com/~r/blogspot/MUMi/~3/k2SHhfPrdsA/set-identity-specification-on-primary.html</link><author>noreply@blogger.com (ClevelandDotNet)</author><thr:total>0</thr:total><feedburner:origLink>http://clevelanddotnet.blogspot.com/2009/04/set-identity-specification-on-primary.html</feedburner:origLink></item><item><guid isPermaLink="false">tag:blogger.com,1999:blog-10611556.post-1667298517495531814</guid><pubDate>Wed, 08 Apr 2009 17:43:00 +0000</pubDate><atom:updated>2009-04-08T13:53:14.454-04:00</atom:updated><title>IT Events Sponsored by Sogeti</title><description>The Cleveland office of Sogeti USA will be hosting the following IT events in April.&lt;br /&gt;&lt;br /&gt;April 21: Taking the cost out if IT&lt;br /&gt;Time: 2:30 p.m. – 4:30 p.m.&lt;br /&gt;Location: Microsoft Office 6050 Oak Tree Blvd. Independence, OH 44131&lt;br /&gt;Agenda:&lt;br /&gt;&gt; Introductions Microsoft and Sogeti&lt;br /&gt;&gt; Taking the Cost out of IT&lt;br /&gt;&gt; Break&lt;br /&gt;&gt; Optimizing Microsoft Solution Delivery&lt;br /&gt;&gt; Testimonials&lt;br /&gt;&gt; Open Forum&lt;br /&gt;To register, go to &lt;a href="http://www.clicktoattend.com/"&gt;http://www.clicktoattend.com/&lt;/a&gt; then enter Event Code: 137141&lt;br /&gt;&lt;br /&gt;&lt;br /&gt;April 30: "Me the Media - Rise of the Conversation Society"&lt;br /&gt;Date: Thursday, April 30, 2009&lt;br /&gt;Time: 6:00 p.m. – 8:30 p.m.&lt;br /&gt;Location: Beacon Place (lower level conference room), 6055 Rockside Woods Blvd. Independence, OH 44131&lt;br /&gt;The speaker at this event will be Erik van Ommeren,who is managing the US branch of the Sogeti InternationalResearch Institute for New Technology. He is an author andpublic speaker on topics such as innovation, collaboration,service oriented architecture, crowdsourcing and new media. You’re invited!&lt;br /&gt;RSVP by 4/27/09 to &lt;a href="mailto:sue.fellner@us.sogeti.com"&gt;sue.fellner@us.sogeti.com&lt;/a&gt;&lt;img src="http://feeds.feedburner.com/~r/blogspot/MUMi/~4/rZ0Wr6tjYmM" height="1" width="1"/&gt;</description><link>http://feedproxy.google.com/~r/blogspot/MUMi/~3/rZ0Wr6tjYmM/it-events-sponsored-by-sogeti.html</link><author>noreply@blogger.com (ClevelandDotNet)</author><thr:total>0</thr:total><feedburner:origLink>http://clevelanddotnet.blogspot.com/2009/04/it-events-sponsored-by-sogeti.html</feedburner:origLink></item><item><guid isPermaLink="false">tag:blogger.com,1999:blog-10611556.post-5750708275502937695</guid><pubDate>Wed, 08 Apr 2009 17:07:00 +0000</pubDate><atom:updated>2009-04-08T13:59:30.418-04:00</atom:updated><title>April 2009 .Net Events</title><description>Listed below are .Net related events for April 2009:&lt;br /&gt;&lt;br /&gt;April 9: Ann Arbor Cloud Camp (&lt;a href="http://bit.ly/a2cc"&gt;http://bit.ly/a2cc&lt;/a&gt;)&lt;br /&gt;April 9: Ohio North SQL Server User Group - Executive Dashboards using SharePoint 2007 (&lt;a href="http://www.bennettadelson.com/seat.aspx?sig=sql&amp;amp;ID=141"&gt;http://www.bennettadelson.com/seat.aspx?sig=sql&amp;amp;ID=141&lt;/a&gt;)&lt;br /&gt;&lt;br /&gt;April 14: .Net User Group - Silverlight 3.0 Beta (&lt;a href="http://www.bennettadelson.com/seat.aspx?sig=net&amp;amp;ID=145"&gt;http://www.bennettadelson.com/seat.aspx?sig=net&amp;amp;ID=145&lt;/a&gt;)&lt;br /&gt;&lt;br /&gt;April 28: Cleveland C#/VB.Net User Group - IronRuby (&lt;a href="http://www.clevelanddotnet.info/"&gt;http://www.clevelanddotnet.info/&lt;/a&gt;)&lt;br /&gt;&lt;br /&gt;April 30:  ArcReady (&lt;a href="http://www.arcready.com/"&gt;www.arcready.com&lt;/a&gt;)&lt;br /&gt;April 30: MSDN Unleashed (&lt;a href="http://www.msdnevents.com/unleashed"&gt;http://www.msdnevents.com/unleashed&lt;/a&gt;)&lt;br /&gt;April 30: TechNet Unleashed (&lt;a href="http://msevents.microsoft.com/CUI/EventDetail.aspx?EventID=1032410537&amp;amp;Culture=en-US"&gt;http://msevents.microsoft.com/CUI/EventDetail.aspx?EventID=1032410537&amp;amp;Culture=en-US&lt;/a&gt;)&lt;br /&gt;April 30: &lt;a href="http://clevearc.groups.live.com/"&gt;Cleveland Architecture SIG&lt;/a&gt;.&lt;img src="http://feeds.feedburner.com/~r/blogspot/MUMi/~4/rfbtkX1vmcw" height="1" width="1"/&gt;</description><link>http://feedproxy.google.com/~r/blogspot/MUMi/~3/rfbtkX1vmcw/net-events.html</link><author>noreply@blogger.com (ClevelandDotNet)</author><thr:total>0</thr:total><feedburner:origLink>http://clevelanddotnet.blogspot.com/2009/04/net-events.html</feedburner:origLink></item><item><guid isPermaLink="false">tag:blogger.com,1999:blog-10611556.post-5443050697155204149</guid><pubDate>Sat, 28 Mar 2009 21:15:00 +0000</pubDate><atom:updated>2009-03-28T18:35:06.713-04:00</atom:updated><category domain="http://www.blogger.com/atom/ns#">VBS Script</category><title>Scripting Q&amp;A</title><description>&lt;strong&gt;Q:&lt;/strong&gt; How can I automate the FTP process so it runs on scheduler without user intervention?&lt;br /&gt;&lt;strong&gt;A:&lt;/strong&gt; The &lt;strong&gt;FTP.EXE&lt;/strong&gt; (File Transfer Protocol) command line utility comes standard with the Windows Operating system.  Because it's a command line utility, it allows for many options to be entered at run time (simply enter &lt;strong&gt;FTP /?&lt;/strong&gt; at the command prompt for a complete list).  When using the -s:&lt;em&gt;filename&lt;/em&gt; switch allows for the commands to be read from the &lt;em&gt;filename&lt;/em&gt; specified.  For example, first create a text file called &lt;em&gt;myFTP.prm&lt;/em&gt; with the following commands:&lt;br /&gt;&lt;br /&gt;   open &lt;a href="http://www.myftpsite.com/"&gt;&lt;em&gt;www.myftpsite.com&lt;/em&gt;&lt;/a&gt;&lt;br /&gt;&lt;em&gt;   myUserID&lt;/em&gt;&lt;br /&gt;&lt;em&gt;   myPassword&lt;/em&gt;&lt;br /&gt;   prompt off&lt;br /&gt;   binary&lt;br /&gt;   mput &lt;em&gt;myfile&lt;/em&gt;*.txt&lt;br /&gt;&lt;br /&gt;From a command line, execute FTP -s:&lt;em&gt;myFTP.prm&lt;/em&gt;.  Please note there's no specific extension for  file containing the FTP commands.  For more info on this, please visit &lt;a href="http://support.microsoft.com/kb/96269"&gt;http://support.microsoft.com/kb/96269&lt;/a&gt;&lt;br /&gt;&lt;br /&gt;&lt;br /&gt;&lt;strong&gt;Q:&lt;/strong&gt; How can I execute a command line utility from with a VB Script?&lt;br /&gt;&lt;strong&gt;A:&lt;/strong&gt; The &lt;strong&gt;CMD.EXE&lt;/strong&gt; is a command line utility used for running other command line applications.  Typing &lt;strong&gt;cmd /?&lt;/strong&gt; will reveal a variety of command line options for executing the command shell.  Listed below is a sample VB script for doing this:&lt;br /&gt;&lt;br /&gt;   Option Explicit&lt;br /&gt;   Dim return, objShell&lt;br /&gt;   Set objShell = WScript.CreateObject("WScript.Shell")&lt;br /&gt;   return = objShell.Run("cmd /C DIR &gt; DirLog.txt", , True)&lt;br /&gt;&lt;br /&gt;After saving these commands into a .vbs file, they can be executed by running "&lt;strong&gt;cscript &lt;em&gt;myFile.vbs&lt;/em&gt;&lt;/strong&gt;".  Please note the file extension must be .vbs.&lt;br /&gt;&lt;br /&gt;&lt;br /&gt;&lt;strong&gt;Q:&lt;/strong&gt; Using a VBS script, how can I access registry keys?&lt;br /&gt;&lt;strong&gt;A:&lt;/strong&gt; Listed below is a sample script for accessing registry keys.&lt;br /&gt;&lt;br /&gt;   Set SysVarReg = WScript.CreateObject("WScript.Shell")&lt;br /&gt;   value = SysVarReg.RegRead  ("HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\.NETFramework\Windows Presentation Foundation\Hosting\Hosts\v3.0")&lt;br /&gt;   WScript.Echo value&lt;br /&gt;&lt;br /&gt;After saving these commands into a .vbs file, they can be executed by running "&lt;strong&gt;cscript &lt;em&gt;myFile.vbs&lt;/em&gt;&lt;/strong&gt;".  Please note the file extension must be .vbs.&lt;br /&gt;&lt;br /&gt;Another useful example of scripting is to query all the processes running on the current machine and output them to the console.&lt;br /&gt;&lt;br /&gt;   strComputer = "."&lt;br /&gt;   Set objServices = GetObject("winmgmts:\\" &amp;amp; strComputer &amp;amp; "\root\CIMV2")&lt;br /&gt;   Set objProcessSet = objServices.ExecQuery("SELECT Name FROM Win32_Process",,48)&lt;br /&gt;&lt;br /&gt;   For Each Process in objProcessSet&lt;br /&gt;       WScript.Echo Process.Name&lt;br /&gt;   Next&lt;br /&gt;&lt;br /&gt;For more information on scripting, visit Microsoft's Scripting Center at &lt;a href="http://www.microsoft.com/technet/scriptcenter/default.mspx"&gt;http://www.microsoft.com/technet/scriptcenter/default.mspx&lt;/a&gt;&lt;img src="http://feeds.feedburner.com/~r/blogspot/MUMi/~4/PD3NalIV_cw" height="1" width="1"/&gt;</description><link>http://feedproxy.google.com/~r/blogspot/MUMi/~3/PD3NalIV_cw/scripting-q.html</link><author>noreply@blogger.com (ClevelandDotNet)</author><thr:total>0</thr:total><feedburner:origLink>http://clevelanddotnet.blogspot.com/2009/03/scripting-q.html</feedburner:origLink></item><item><guid isPermaLink="false">tag:blogger.com,1999:blog-10611556.post-7498207313262581111</guid><pubDate>Thu, 12 Mar 2009 17:05:00 +0000</pubDate><atom:updated>2009-03-12T13:31:25.302-04:00</atom:updated><title>What is a Tablix?</title><description>The term "Tablix" can mean different things to different people. However, in the Microsoft realm it refers to the ability of SQL Server Reporting Services (SSRS) to combine a table and a matrix together.&lt;br /&gt;&lt;div&gt;&lt;/div&gt;&lt;br /&gt;&lt;p&gt;&lt;img id="BLOGGER_PHOTO_ID_5312350953568892210" style="DISPLAY: block; MARGIN: 0px auto 10px; WIDTH: 400px; CURSOR: hand; HEIGHT: 190px; TEXT-ALIGN: center" alt="" src="http://1.bp.blogspot.com/_b6N4dNMRCHQ/SblDC9WudTI/AAAAAAAAAD4/tAuYWWC2ubE/s400/t1.jpg" border="0" /&gt;&lt;br /&gt;&lt;img id="BLOGGER_PHOTO_ID_5312352342854807602" style="DISPLAY: block; MARGIN: 0px auto 10px; WIDTH: 400px; CURSOR: hand; HEIGHT: 237px; TEXT-ALIGN: center" alt="" src="http://2.bp.blogspot.com/_b6N4dNMRCHQ/SblET02TMDI/AAAAAAAAAEA/3vXVXv_tG24/s400/T2.jpg" border="0" /&gt;&lt;/p&gt;&lt;div&gt;&lt;/div&gt;&lt;img src="http://feeds.feedburner.com/~r/blogspot/MUMi/~4/G3Dn1xbnJIQ" height="1" width="1"/&gt;</description><link>http://feedproxy.google.com/~r/blogspot/MUMi/~3/G3Dn1xbnJIQ/what-is-tablix.html</link><author>noreply@blogger.com (ClevelandDotNet)</author><media:thumbnail xmlns:media="http://search.yahoo.com/mrss/" url="http://1.bp.blogspot.com/_b6N4dNMRCHQ/SblDC9WudTI/AAAAAAAAAD4/tAuYWWC2ubE/s72-c/t1.jpg" height="72" width="72" /><thr:total>0</thr:total><feedburner:origLink>http://clevelanddotnet.blogspot.com/2009/03/what-is-tablix.html</feedburner:origLink></item><item><guid isPermaLink="false">tag:blogger.com,1999:blog-10611556.post-7995190079194826535</guid><pubDate>Wed, 11 Mar 2009 23:20:00 +0000</pubDate><atom:updated>2009-03-11T19:45:10.361-04:00</atom:updated><category domain="http://www.blogger.com/atom/ns#">promotion</category><category domain="http://www.blogger.com/atom/ns#">Book</category><title>Book Promotion from Packt Publishing</title><description>&lt;a href="http://www.packtpub.com/"&gt;&lt;img id="BLOGGER_PHOTO_ID_5312079720326575906" style="FLOAT: left; MARGIN: 0px 10px 10px 0px; WIDTH: 152px; CURSOR: hand; HEIGHT: 87px" alt="" src="http://2.bp.blogspot.com/_b6N4dNMRCHQ/SbhMXGyfNyI/AAAAAAAAADw/XjSNZA__UnE/s400/PacktLogo.png" border="0" /&gt;&lt;/a&gt;&lt;br /&gt;&lt;br /&gt;&lt;br /&gt;&lt;br /&gt;&lt;br /&gt;&lt;br /&gt;Packt Publishing has recently released a new book titled "&lt;a href="http://www.packtpub.com/beginners-guide-for-C-sharp-2008-and-2005-threaded-programming/book"&gt;C# 2008 and 2005 Threaded Programming&lt;/a&gt;". To help promote the new book, they have extended a 15% discount to members of the C#/VB.Net User Group. To take advantage of this offer, simply follow the 3 steps below:&lt;br /&gt;&lt;ol&gt;&lt;li&gt;Visit &lt;a href="http://www.packtpub.com/books"&gt;http://www.packtpub.com/books&lt;/a&gt; and select any Packt title.&lt;/li&gt;&lt;li&gt;Click the "ADD TO CART" button to add the book to your shopping cart.&lt;/li&gt;&lt;li&gt;Now enter "CD15ug" (without quotes) in the 'Promotional Code' field and click the "Update" button. The discounted price should now be reflected in your order.&lt;/li&gt;&lt;/ol&gt;Although Packt is based in the UK, they do offer free shipping to the US, with books arriving in only a few days. Packt Publishing has also sent a free copy to be given at an upcoming user group meeting. For more information, please visit &lt;a href="http://www.packtpub.com/"&gt;http://www.packtpub.com/&lt;/a&gt;&lt;img src="http://feeds.feedburner.com/~r/blogspot/MUMi/~4/1dID-EAR_8Q" height="1" width="1"/&gt;</description><link>http://feedproxy.google.com/~r/blogspot/MUMi/~3/1dID-EAR_8Q/book-promotion-from-packt-publishing.html</link><author>noreply@blogger.com (ClevelandDotNet)</author><media:thumbnail xmlns:media="http://search.yahoo.com/mrss/" url="http://2.bp.blogspot.com/_b6N4dNMRCHQ/SbhMXGyfNyI/AAAAAAAAADw/XjSNZA__UnE/s72-c/PacktLogo.png" height="72" width="72" /><thr:total>0</thr:total><feedburner:origLink>http://clevelanddotnet.blogspot.com/2009/03/book-promotion-from-packt-publishing.html</feedburner:origLink></item><item><guid isPermaLink="false">tag:blogger.com,1999:blog-10611556.post-5778778824573616216</guid><pubDate>Wed, 04 Mar 2009 18:25:00 +0000</pubDate><atom:updated>2009-03-04T13:41:56.307-05:00</atom:updated><title>March .Net Events</title><description>Mar 10th: .Net User Group (Using TFS). To register, go to &lt;a href="http://www.bennettadelson.com/seat.aspx?sig=net&amp;amp;ID=141"&gt;http://www.bennettadelson.com/seat.aspx?sig=net&amp;amp;ID=141&lt;/a&gt;&lt;br /&gt;&lt;br /&gt;Mar 12th: ONSQL User Group. To register, go to &lt;a href="http://www.bennettadelson.com/seat.aspx?sig=sql&amp;amp;ID=141"&gt;http://www.bennettadelson.com/seat.aspx?sig=sql&amp;amp;ID=141&lt;/a&gt;&lt;br /&gt;&lt;br /&gt;Mar 14th: GCPCUG General Meeting (Switching to a Mac &amp;amp; Windows on a Mac). To register, go to &lt;a href="http://www.gcpcug.org/"&gt;http://www.gcpcug.org/&lt;/a&gt;&lt;br /&gt;&lt;br /&gt;Mar 24th: Cleveland C#/VB.Net User Group (Writing Secure Code). To register, go to &lt;a href="http://www.clevelanddotnet.info/"&gt;http://www.clevelanddotnet.info/&lt;/a&gt;&lt;br /&gt;&lt;br /&gt;Mar 25th: Cleveland SharePoint User Group (TBA). To register, go to &lt;a href="http://www.sharepointcleveland.com/default.aspx"&gt;http://www.sharepointcleveland.com/default.aspx&lt;/a&gt;&lt;br /&gt;&lt;br /&gt;Mar 28th: Cincinnati Silverlight Firestarter.  To register, go to &lt;a href="http://cinnug.org/default.aspx"&gt;http://cinnug.org/default.aspx&lt;/a&gt;.&lt;img src="http://feeds.feedburner.com/~r/blogspot/MUMi/~4/40bmK2eG9GQ" height="1" width="1"/&gt;</description><link>http://feedproxy.google.com/~r/blogspot/MUMi/~3/40bmK2eG9GQ/march-net-events.html</link><author>noreply@blogger.com (ClevelandDotNet)</author><thr:total>0</thr:total><feedburner:origLink>http://clevelanddotnet.blogspot.com/2009/03/march-net-events.html</feedburner:origLink></item><item><guid isPermaLink="false">tag:blogger.com,1999:blog-10611556.post-1031476741987262401</guid><pubDate>Sat, 28 Feb 2009 20:08:00 +0000</pubDate><atom:updated>2009-02-28T15:29:51.401-05:00</atom:updated><category domain="http://www.blogger.com/atom/ns#">SQL Server 2008 Webinars</category><title>Straight 2 SQL Server 2008 Webinars</title><description>JC Armand is putting on a series of SQL Server 2008 educational webinars.  These Live Meeting sessions cover a variety of topics on SQL Server 2008, from both a DBA and a developer's perspective.  The sessions occur every Tuesday and Thursday, ending on Thursday, April 2, 2009.  Each session is scheduled to start at 11AM EST and last for approximately 1 hour.&lt;br /&gt;&lt;br /&gt;2/24/2009: Why SQL Server 2008&lt;br /&gt;2/26/2009: How Windows Server 2008 benefits SQL Server 2008&lt;br /&gt;3/3/2009: Upgrade/Migration strategy &amp;amp; Overcoming upgrade challenges&lt;br /&gt;3/5/2009: SQL Server 2008 based Business Intelligence&lt;br /&gt;3/10/2009: SQL Server 2008 for Developers&lt;br /&gt;3/12/2009: What’s new in Reporting Services 2008&lt;br /&gt;3/17/2009: SQL Server Consolidation Strategies&lt;br /&gt;3/19/2009: Resource Governor&lt;br /&gt;3/24/2009: Upgrade SQL Server clusters to Windows Server 2008&lt;br /&gt;3/26/2009: Database compression &amp;amp; Back-up compression&lt;br /&gt;3/31/2009: Database auditing &amp;amp; Transparent data encryption&lt;br /&gt;4/2/2009: Optimizing SQL Server licensing for your business needs&lt;br /&gt;&lt;br /&gt;For more information, or to register, go to &lt;a href="http://www.pragmaticworks.com/StraightTo8Webinars.aspx" target="_blank"&gt;http://www.pragmaticworks.com/StraightTo8Webinars.aspx&lt;/a&gt;.  After registering, links will be emailed for joining each upcoming session, as well as viewing past sessions.&lt;img src="http://feeds.feedburner.com/~r/blogspot/MUMi/~4/RxAPZVqByE0" height="1" width="1"/&gt;</description><link>http://feedproxy.google.com/~r/blogspot/MUMi/~3/RxAPZVqByE0/straight-2-sql-server-2008-webinars.html</link><author>noreply@blogger.com (ClevelandDotNet)</author><thr:total>0</thr:total><feedburner:origLink>http://clevelanddotnet.blogspot.com/2009/02/straight-2-sql-server-2008-webinars.html</feedburner:origLink></item></channel></rss>
