Identifying resources that can be deleted or underutilized in Azure … More Microsoft Azure: find unattached disks that can be deleted and other recommendations
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
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
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?
You have a class and you need to save values to of the class to an xml file to be consumed later on Save your class values to This is the template content To read the content of the xml back to your class
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
Now that you have your Access Token – in case you missed it, here is the link to how to get it OAuth2: Get an Access Token – C#, you can now pass your authorization token to interact with your API. Make sure to add a header to your request with your authorization token The … More OAuth2 – Pass 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#
Date time – how to initialize a date Concatenate string list into comma separated string Initialize a string list Save text to a file What was the last thing I created in that database? Open the database using Microsoft SQL Server Management Studio, create a query for the database and a You can filter by … More Handy C#, VB.Net & SQL Code Snippets
Problem I have a Microsoft Access database application. When updating a record from the screen, users kept getting the error: This recordset is not updateable The form datasource is a query with two tables Solution This query was not updatable, here is a list of reasons why a query would not be updatable By Allen … More This Recordset is not Updateable
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.
I am the proud owner of a Night Hawk Black Pearl – Honda Accord EX Coupe – V6 – Manual Transmission. This is the best car I ever had, a piece of excellent machinery, smooth to ride, great pick up and handling of the road, fun to ride the highway with the windows down and the … More My old car – your MS SQL 2005 Server
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
On the previous post, we moved validation functionality to the Scraping object. The resulting function was this: There is still too much going on. The next step is to extract a method to process the items on the list, I called this method ScrapeStockData The resulting function would be, you can get an idea of … More Refactoring IV – Finally There
On the previous post I moved URL parsing code by extending the StockData class and creating a property called Url, now we are left with this code, but if you look at the highlighted code, there are way too many things happening here!. First you see negotiations between StockData and TickerData, validations. This functionality needs to be moved … More Refactoring III -Why is this here?
On my previous post, I started refactoring a function that reads stock and dates, checks the data against Yahoo Finance and returns some data. In this function, I take the Stock Ticker and the data and parse the URL to be evaluated by our web scrapper object. Now, this code can be taken out of … More Refactoring II- Encapsulating
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
The Problem My client wants to backup all the databases in their MS SQL Server Server – 1,000 large databases – to a shared network drive. I want to run a script, get coffee and come back to check when the backup is completed. Solution Created a script to backup all the databases on the … More SQL-Transact Backup all Databases In a MS SQL Server
Last weekend we went with friends on a skiing trip to the Poconos, Pennsylvania. Our trip was a simple one and half hour drive from North New Jersey to just over the Delaware Gap – the border between Pennsylvania and New Jersey. On our way down, our driver and co-pilot took out their respective iPhones and … More Three GPS systems – One destination
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