ClevelandDotNet

Listed below are announcements of developer events local and regional to the Cleveland area.  In addtion there are links to job openings and videos of past presentations. Local Events: Oct 1: ONSQL-Cleveland ( https://www.meetup.com/Ohio-North-SQL-Server-User-Group-Cleveland/ ) Oct 16: Hudson Software Craftsmanship Group ( https://www.meetup.com/Hudson-Software-Craftsmanship-Meetup/ ) Oct 24: Cleveland C#/VB.Net User Group ( https://www.meetup.com/Cleveland-C-VB-Net-User-Group/ ) Regional Events: Oct 1: ONSQL-Cleveland ( https://www.meetup.com/Ohio-North-SQL-Server-User-Group-Cleveland/ ) Oct 16: Hudson Software Craftsmanship Group ( https://www.meetup.com/Hudson-Software-Craftsmanship-Meetup/ ) Oct 24: Cleveland C#/VB.Net User Group ( https://www.meetup.com/Cleveland-C-VB-Net-User-Group/ ) Job Openings: TekSystems:  https://www.teksystems.com/it-jobs Inedo:  https://inedo.com/company/career-culture Video: Please subscribe to  https://www.youtube.com/channel/UCU4ffaI...

This year I had the privilege of being invited to FoxCon for the 5th time.  FoxCon is a private invite-only conference.  It was started decades ago when FoxPro was one of the products from Microsoft.  Although the product is no longer supported, it is still widely used and loved at many organizations of various sizes.  The FoxCon conference targets FoxPro related topics but the organizers are always open to hear new topics. This year I presented 2 sessions: "SQL Server Security"  and "New Features in SSRS 2017".  Presenting to a technical audience is something I have always enjoyed.  However, it seems much more enjoyable presenting to this group of tech experts. I look forward to attending and possibly presenting again next year.

I would like to thank Guy Royse (DataRobot) for presenting "Machine Learning for Gamers" at the last meeting of the Cleveland C#/VB.Net User Group Listed below are the links for the presentation recording and events in area/region. Presentation Recording :  https://www.youtube.com/channel/UCU4ffaIzhsvMr_cCt9kjQMw Local Events Nov 6: ONSQL-Cleveland( https://www.meetup.com/Ohio-North-SQL-Server-User-Group-Cleveland/ ) Nov 21: Hudson SC ( https://www.meetup.com/Hudson-Software-Craftsmanship-Meetup/ )  Nov 29: Cleveland C#/VB.Net User Group( https://www.meetup.com/Cleveland-C-VB-Net-User-Group/ )  Regional Events Oct 19-21: SpaceApps Cleveland Hackathon ( https://2018.spaceappschallenge.org/locations/cleveland-oh/ ) Oct 20: Cleveland Medical Hackathon ( http://clevelandmedicalhackathon.com )  Oct 27: Columbus Code Camp ( https://columbuscodecamp.com/ )  Nov 3: NuGet Essentials ( https://www.eventbrite.com/e/nuget-essentials-tickets-48803794463 )

Listed below are the various .Net events happening in the Cleveland area and surrounding region: May Events May 24: Cleveland C#/VB.Net User Group: Building Hololens Apps ( https://www.meetup.com/Cleveland-C-VB-Net-User-Group/ ) May 30: Cleveland User Experience: Exploring the New CSS with Eric Meyer: ( https://www.meetup.com/make-the-internet/ ) June Events Jun 2: PGH Tech Fest ( http://pghtechfest.com/ )  Jun 5: ONSQL-Cleveland ( https://www.meetup.com/Ohio-North-SQL-Server-User-Group-Cleveland/ ) Jun 19: ONSQL-Akron ( https://www.meetup.com/Akron-SQL-Database-Professionals-Meetup/ ) Jun 20: Hudson Software Craftsmanship ( https://www.meetup.com/Hudson-Software-Craftsmanship-Meetup /) Jun 20: Cleveland Web Design and Development: Building apps with Blazor ( https://www.meetup.com/CLE-WDD ) Jun 23: BSides Software Security Conference: ( https://www.bsidescleveland.com/ ) Jun 23: Cleveland User Experience: Hands-on UX (https://www.meetup.com/Cleveland-User-Experience...

Cleveland User Group Events — Feb 13: “Advance Automation Strategies”  https :// www.eventbrite.com/e/neo-advance-software-testing-conference-tickets-42512510062   — Feb 21: Hudson Software Craftsmanship Group ( https://www.meetup.com/Hudson-Software-Craftsmanship-Meetup/ )    — Feb 21: NEOISF ( http ://www.neoisf.org / ) — Feb 22: CLE C#/VB.Net: ( www.meetup.com/Cleveland-C-VB-Net-User-Group ) Ohio Regional Events — Feb 3: SQL Saturday CLE( www.sqlsaturday.com/708/EventHome.aspx )  — May 4: StirTrek ( https://www.stirtrek.com / ) 

Listed below are .Net events happening in the Cleveland area and surrounding region for October 2017 Local Events  Oct 3: ON SQL User Group ( ohionorth.pass.org ) Oct 10: Cleveland .NET User Group ( www.bennettadelson.com/ComingEvents.aspx ) Oct 19: Akron AITP ( http://akron-aitp.org/ )  Oct 25: Cleveland WDD ( https://www.meetup.com/CLE-WDD/events/239855298/ ) Oct 26: Cleveland C#/VB.Net User Group ( https://www.meetup.com/Cleveland-C-VB-Net-User-Group/?_cookie-check=FWQcEWsRV8pW0oJU ) Regional Events  Oct 5-6: DogFood Conference ( http://dogfoodcon.com/ ) Oct 14: Columbus Code Camp ( http://columbuscodecamp.com/ )

If you're considering taking Exam 70-533 "Implementing Microsoft Azure Infrastructure Solutions", here are some resources you might find valuable: https://crpietschmann.github.io/Azure-70-533-Practice-Test/ https://courses.edx.org/courses/course-v1:Microsoft+DEV205Bx+3T2016/course/ https://buildazure.com/2015/06/12/preparing-for-70-533-implementing-microsoft-azure-infrastructure-solutions-exam/ https://buildazure.com/2016/11/06/azure-infrastructure-exam-70-533-gets-arm-refresh/ http://www.azureman.com/certification/azure-infrastructure-exam-70-533-study-guide/ As always, if you have any questions about the exam, please leave a comment.

With the launch of Windows 10 and Visual Studio 2015, developers around the world are becoming very excited about writing apps on the Windows Universal Platform.  To help with this growing need, Microsoft has provided a variety of free online resources: Developer Tools Download: https://www.visualstudio.com/?Wt.mc_id=DX_MVP5000378 What’s New for Developers in Windows 10: https://dev.windows.com/en-us/getstarted/whats-new-windows-10/?Wt.mc_ic=DX_MVP5000378 Get Started: https://dev.windows.com/en-us/getstarted/?Wt.mc_ic=DX_MVP5000378 Design: https://dev.windows.com/en-us/design/?Wt.mc_ic=DX_MVP5000378 Develop: https://dev.windows.com/en-us/develop/?Wt.mc_ic=DX_MVP5000378 Publish: https://dev.windows.com/en-us/publish/?Wt.mc_ic=DX_MVP5000378 Windows 10 courses on MVA: https://www.microsoftvirtualacademy.com/en-US/training-courses/getting-started-with-windows-10-for-it-professionals-10629/?Wt.mc_ic=DX_MVP5000378 Channel 9: https://channel9.msdn.com/windows/?Wt.mc_ic=DX_MVP5000378

Listed below are .Net-related events happening in the Cleveland area and Midwest region for June... and beyond: .Net-related User Groups: June 4: ON SQL User Group ( www.ohionorthsqlserverug.org ) June 10: Cleveland .NET User Group ( www.bennettadelson.com/ComingEvents.aspx )   June 17: Cleveland WPF User Group ( www.ClevelandWPF.info )  June 18: Hudson Software Craftsmanship ( http://hudsonsc.com ) June 24: Cleveland C#/VB.Net User Group ( www.clevelanddotnet.info )  June 25: SharePoint User’s Group ( www.sharepointCleveland.com )    Regional Events: June 4: Security Summit ( https://www.informationsecuritysummit.org/ ) June 13: Cleveland SharePoint Golf Outing ( http://www.sharepointcleveland.com/default.aspx ) June 13-15: Circle City Con ( http://www.circlecitycon.com/ ) June 14: SQL Saturday #299 ( http://www.sqlsaturday.com/299/eventhome.aspx ) July 11-12: CodeStock ( http://www.codestock.org/ ) July 18: Cleveland GiveCamp: ( http...

On June 3, 2014, Microsoft released Visual Studio “14” CTP (Community Technology Preview).  Listed below are some useful links relating to this release:   Downloads: Download the Visual Studio “14” CTP (also available on MSDN subscriber downloads ). Alternatively, save some time and use the provided VM in Azure . Blogs & Release Notes: Read announcements by Soma & Brian . Check out the team blogs, including Visual Studio , Web Dev (web tooling) , Web Dev (ASP.NET vNext) , Entity Framework , C# , VB , and C++ . See the Visual Studio “14” CTP release notes for a list of new features. Discuss on Facebook & Twitter . Known Issues: This release should be installed in a test environment, such as a VM or a clean machine. Do not install on a machine with another version of Visual Studio installed. For other known issues, please see the Visual Studio “14” CTP KB . Feedback: Submit bugs through Connect , suggestions on UserVoice and quick thoughts th...

Local Events 10/1: ON SQL User Group ( www.ohionorthsqlserverug.org ) 10/8: Cleveland .NET User Group ( www.bennettadelson.com/ComingEvents.aspx )  10/10: Cleveland Riak ( http://www.meetup.com/Cleveland-Riak ) 10/12: Techie Family Meet & Play ( http://www.meetup.com/UX-Akron/events/141530432/ ) 10/15: Cleveland WPF User Group ( www.ClevelandWPF.info )  10/16: Software Engineering 101 ( https://swe101october2013.eventbrite.com/ ) 10/16: Hudson Software Craftsmanship ( http://hudsonsc.com )  10/22: Cleveland C#/VB.Net User Group ( www.clevelanddotnet.info )  11/22: Build Highlights ( https://msevents.microsoft.com ) 12/4: Monetization of Real-World Windows Apps ( https://msevents.microsoft.com ) Regional Events 10/23: Azure Dev Camp – Columbus, OH ( https://msevents.microsoft.com/ ) 11/2: CODODN – ( http://cododn.azurewebsites.net ) 11/2: SQL Saturday: Kalamazoo, MI ( http://www.sqlsaturday.com/256/eventhome.aspx ) 11/9: Raleigh Code Camp ( http://codecamp.org/ )...

Question : While working on an AJAX-enabled application, I got "Object reference not set to an instance of an object when using HTMLEditorExtender". How do I fix this? Answer : Add a register page directive referencing the AjaxControlToolKit. This is in addition to the steps mentioned at http://www.asp.net/ajaxLibrary/AjaxControlToolkitSampleSite/HTMLEditorExtender/HTMLEditorExtender.aspx

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

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

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