All Things Microsoft AI

Virtual User Group Meetings Jan 29: OWASP Cleveland Chapter ( https://www.meetup.com/owasp-cleveland-group/events/275751911/ ) Feb 2: ONDT ( https://www.meetup.com/ohio-north-database-training/events/275862156/ ) Feb 17: Hudson Software Craftsmanship ( https://www.meetup.com/Hudson-Software-Craftsmanship-Meetup/ ) Feb 18: GLUG.Net: ( https://www.meetup.com/GLUGnet/events/lnbmpryccdbxb/ ) Feb 25: Cleveland C#/VB.Net User Group ( https://www.meetup.com/GLUGnet/events/ )   Virtual Conferences Feb 17: Developer Week 2021 ( https://www.developerweek.com/ ) Feb 25: .Net Conf ( focus.dotnetconf.net ) Feb 27: Data Saturday ( https://datasaturdays.com/events/datasaturday0001.html )  

The Global AI Bootcamp is a free one-day event organized across the world by local communities that are passionate about artificial intelligence on Microsoft Azure. It takes place on January 15-16th, 2021 with venues on every continent. The event is a perfect balance of quality content, awesome talks, and hands-on learning with like-minded peers in your community.  Currently, there are 4 events happening in the US in different time zones.    Las Vegas, NV: https://globalai.community/global-ai-bootcamp-2020/united-states-las-vegas Plano, TX: https://globalai.community/global-ai-bootcamp-2020/usa-plano-tx-1 Des Moines, IA: https://globalai.community/global-ai-bootcamp-2020/usa-des-moines Raleigh, NC: https://globalai.community/global-ai-bootcamp-2020/united-states-raleigh   Find the one that best suits you or choose another event elsewhere in the world.  To see a full list of all events, please visit https://globalai.community/gl...

Virtual User Group Meetings Dec 15: The JavaScript Club ( https://www.meetup.com/thejavascriptclub/events/274882089/ ) Dec 16: We Can Code IT ( https://www.meetup.com/WeCanCodeIT/events/274968946/ ) Dec 17: GLUG.Net: ( https://www.meetup.com/GLUGnet/events/ ) Jan 20: Hudson Software Craftsmanship ( https://www.meetup.com/Hudson-Software-Craftsmanship-Meetup/ ) Jan 28: Cleveland C#/VB.Net User Group ( https://www.meetup.com/GLUGnet/events/ )   Virtual Conferences Dec 19: SQL Saturday- Lagos ( https://www.sqlsaturday.com/1008/ )    

A situation came up where a Windows Forms application required 2 combo boxes filled with customer IDs.  A caption of that form is shown below, where a user must select “From Customer ID” and “To Customer ID”.  Since both combo boxes were populated from the same data column, the natural thing to do was to use the same code for filling both with the same data.  However, this caused an undesirable effect.  When the user selected the “From Customer ID”, the “To Customer ID” was automatically populated with the same value.    To resolve this problem, 2 separate DataTable objects must be used, dtFrom and dtTo.  Although both objects are populated using the same method (dm.GetCustomerIDNames()), keeping the objects separate will prevent one control selection from effecting the other control.  See sample code shown below.               p...

Virtual User Group Meetings Sep 29: .Net Virtual User Group - “VS/Code Hidden Gems” https://www.meetup.com/dotnet-virtual-user-group/events/ Oct 15: Akron AITP User Group – “Enterprise Architecture in the Cloud” https://www.meetup.com/AkronAITP/events/ Oct 21: Hudson Software Craftsmanship - “Crafting Better Software” https://www.meetup.com/Hudson-Software-Craftsmanship-Meetup/ Oct 22: Cleveland C#/VB.Net User Group - “Multi-Model Databases in Azure SQL” https://www.meetup.com/Cleveland-C-VB-Net-User-Group/   Virtual Conferences Sep 26: Northern Virginia Code Camp https://novacodecamp.org/index.html Oct 3: SQL Saturday-Memphis https://www.sqlsaturday.com/1003/ Oct 24: SQL Saturday-Oregon https://www.sqlsaturday.com/1000/  

Listed below is an example of using Sorting and Filtering on ADO objects.  This examples utilizes an Oracle DB, but ADO objects can be used with various databases.  In this situation, the entire data table is retrieved in memory.  When needed, that data table can be sorted using a specific column or filtered using the SELECT method with the specified predicate.           public void ProcesssData()         { //Retrieve entire data table into memory gPOLines = RGNdm.GetLineNumsByPO(PO);  //Create a VIEW from the in-memory data table var newView = gPOLines.DefaultView.ToTable(false, "PART_ID", "PO_NUMBER", "CREATE_DATE", "VENDOR_NAME", "INITIATED_BY"); //SORT by desired field gPOLines.DefaultView.Sort = " PART_ID ASC ";   //SELECT (filter) for specific criteria                 DataRow[] filte...

Handling exceptions is a critical task in any application.  When an exception is logged, it needs to have sufficient detail so it can be researched at a later time.  In addition, as a developer, you want to extract and log as much detail about it as possible.  Some of those details include the file name and line number where the exception occurred.  Listed below is a method that handles exceptions, extracts the message, file name, and line number for logging.             private void ProcessEx(Exception ex, string details = "")         {             int lineNumber = 0;             const string lineNumberMarker = ":line ";             string traceText = ex.StackTrace + "";  /...

While working with Oracle SQL Developer , you may encounter the following message when the password is near expiration.   5   A database warning was encountered performing the requested operation:   ORA-28002: the password will expire within 5 days 28002. 00000 -  "the password will expire within %s days" *Cause:    The user's account is about to expire and the password            needs to be changed *Action:   change the password or contact the DBA Vendor code 28002     To change the password: Open the Connections tab (View > Connections) Right click the database where the password needs to be changed Select “Reset Password…”     A pop-up form (see below) will appear prompting for the old and new passwords.     That’s it.  Seems simple but if you’re not familiar ...

Overview : I have a Windows Form application, built in .Net 4.7.2 using Visual Studio 2019.  The form has 3 PartID combo boxes, allowing the user to select 3 distinct part IDs from a finite list of parts in the drop down.     Problem : When the combo box was being filled with values in the drop down list, the following exception was thrown.   Exception : System.AccessViolationException   HResult=0x80004003   Message=Attempted to read or write protected memory. This is often an indication that other memory is corrupt.   Source=<Cannot evaluate the exception source>   StackTrace: <Cannot evaluate the exception stack trace>   Code :         private void cbPO_LostFocus(object sender, EventArgs e)         {             FillPartID1(poLines);      ...

Overview : I have a Windows Form application, built in .Net 4.7.2 using Visual Studio 2019.  The form has 3 PartID combo boxes, allowing the user to select 3 distinct part IDs from a finite list of parts in the drop down.     Problem : Once the user selects a PartID in any combo box, the other 2 combo boxes are automatically set to that value.             private void Start()         {             DataTable POLines = GetLineNumsByPO(PO);               FillPartID1(POLines);             FillPartID2(POLines);             FillPartID3(POLines);                  ...

Virtual User Group Meetings Sep 1: ONSQL-Cleveland “SQL Azure Deployment Options” https://ohionorth.pass.org/   Sep 10: .Net Virtual User Group “Adding a little DAPR to .NET Microservices” https://www.meetup.com/dotnet-virtual-user-group/events/272490405/   Sep 16: Hudson Software Craftsmanship “Crafting Better Software” https ://www.meetup.com/Hudson-Software-Craftsmanship-Meetup /   Sep 24: Cleveland C#/VB.Net User Group https ://www.meetup.com/Cleveland-C-VB-Net-User-Group /     Virtual Conferences Aug 28: .NET Dev Summit 2020 (Bengaluru): https://bdotnet.in/dotnet-dev-summit-2020/   Aug 29: SQL Saturday (Salt Lake City, UT): https://www.sqlsaturday.com/997/  

Like Technical Events?  Me too!  Here’s a list of .Net related events online and free of charge. Aug 11: “Come meet the new .NET Standard MVVM” - https://www.meetup.com/dotnet-virtual-user-group/events/272490308 Aug 12-14: Pittsburgh Tech Fest - http://www.pghtechfest.com/ Aug 13: “Migrate Your Apps and SQL Server Databases to Azure” - https://info.microsoft.com/ww-landing-azure-webinar-series-migrate-your-apps-and-sql-server-databases-to-azure.html?lcid=en-us&ocid=mkto_eml_EM666897A1LA1&ocid=eml_pg189324_gdc_comm_az Aug 13: “Breaking Bad Habits: Solutions for Common Query Antipatterns” - https://www.meetup.com/Louisville-Data-Technology-Group/events/270966985/ Aug 13-14: JavaScript & Friends Conference - https://www.javascriptandfriends.com/   Aug 19: Hudson Software Craftsmanship - https://www.meetup.com/Hudson-Software-Craftsmanship-Meetup/ Aug 27: “Dialogue with your Data...

The Global 2020 Summer AI/ML Fest is a virtual event with 8 tracks (3 Developer, 3 Business, 2 ML).  The event took place on Friday, July 31, 2020.  If you missed this free event or want to revisit some of the sessions, the links below provide access to all content:   Full listing of all sessions: https://aka.ms/summer2020-globalaimlfest.com   Presentation Slides: https://aka.ms/downloads-global2020summeraimlfest   Recorded Sessions:  https://aka.ms/azurecloudevents