Azure Based COVID19 PPE Hospital Forecasting Using Azure Server-less Architecture

Introduction This project was born from Rush’s Medical Center development of the same project which was implemented using Jupyter Notebook & hosting it on a virtual machine using Voila. Rush’s Medical Center calculates forecasting based on 3 models: Exponential Regression Logistic Regression Polynomial Regression Deploy to Azure To deploy this solution to Azure click here to access … More Azure Based COVID19 PPE Hospital Forecasting Using Azure Server-less Architecture

Implementing Azure DevOps for Power Bi

DevOps is applicable to multiple IT processes: cloud automation, code releases, machine learning. Building and publishing Power BI reports is no different, every report writer needs to manage multiple versions and environment: development, test and deployment. Manually managing this process can be cumbersome. Integrating to Power BI to Azure DevOps simplifies and automates this process … More Implementing Azure DevOps for Power Bi

Full Circle?

I am currently working on training required for Azure Cloud Solution Architect – App Dev. These are pretty cool tools, all in one platform at your reach, easy to install and to use. My father was a banker, during a brief time in his life, he had a short stint in the late 1960’s working for … More Full Circle?

Writing Data From .Net to Excel Interrupted by User Opening Excel Window

Problem I have an application that generates financial reports in excel. After installing Office 2013, if a user opens excel while the application is running, the application returns a error: System.Runtime.InteropServices.COMException with HRESULT: 0x800AC472 which interrupts the data from being written to the spreadsheet. After some research according to Microsoft this was done by design, the … More Writing Data From .Net to Excel Interrupted by User Opening Excel Window

OAuth2 – Get an Access Token – C#

What is OAuth2? OAuth 2.0 is the industry-standard protocol for authorization. OAuth 2.0 supersedes the work done on the original OAuth protocol created in 2006. OAuth 2.0 focuses on client developer simplicity while providing specific authorization flows for web applications, desktop applications, mobile phones, and living room devices. reference: https://oauth.net/2/ Who uses OAuth2? Among them … More OAuth2 – Get an Access Token – C#

Error The “GenerateResource” task failed unexpectedly.

Problem I was enhancing an application that I have been working with for years, without any trouble. This application was developed with Visual Studio and the solution has multiple projects. While I was working on the enhancements I did some refactoring and renamed some of the classes and files on the application. All of the “sudden” … More Error The “GenerateResource” task failed unexpectedly.

Focus – Pocus

Last week, as the first North East blizzard of 2016 approached, my inner hermit rejoiced at the prospect of being stuck at home, and having the opportunity of tackling those chores that are frequently put on the back burner when outside shinny things are dangled in from of me. Jonas was the perfect opportunity to finish … More Focus – Pocus

Refactoring I -Convert Linq Anonymous Types to List

Refactoring is an important process to crafting readable and maintainable code. Functions should follow  the single responsibility principle – a function should do one thing and one thing only and should have few lines of code. Like with everything, you should apply this with measure and wisdom. I was asked to write a function that … More Refactoring I -Convert Linq Anonymous Types to List

Transact-SQL Server – Transposing a table

The Problem A client sent me an excel sheet with financial information classified in columns where each column header was a date and the values associated with that date were listed below I needed to insert the information to a normalized table with the following columns: Client Account EntryDate Value The Solution Step 1 Loaded … More Transact-SQL Server – Transposing a table