Category: Databases

Part 2: When Excel Needs to Grow Up — The Hybrid Excel + Python / Power BI Framework

January 22, 2026

In Excel Optimization for Financial Modeling a Modernization Guide – Part 1: Fix Excel, we focused on optimizing Excel: making models faster, smaller, and more stable.But optimization alone doesn’t answer the bigger question many teams face next: When is Excel still enough — and when is it time to modernize? This post explores the hybrid … More Part 2: When Excel Needs to Grow Up — The Hybrid Excel + Python / Power BI Framework

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

May 1, 2020

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

This Recordset is not Updateable

February 28, 2017

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

SQL-Transact Backup all Databases In a MS SQL Server

January 25, 2016

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

Transact-SQL Server – Transposing a table

January 13, 2016

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

Transfer database permissions on all objects from one SQL server to another – MS SQL Server 2008 – 2014

September 10, 2015

The Problem I needed to migrate all databases from a MS SQL server 2008 R2 to MS SQL Server 2014; while I can create and restore my databases, permission in objects live on the system databases, therefore I needed to transfer all my login and data objects from one server to another. This cannot be … More Transfer database permissions on all objects from one SQL server to another – MS SQL Server 2008 – 2014

Install SQL Server 2014 Step by Step

August 26, 2015

I was just recently assigned to a project where we need to migrate large database servers from SQL server 2008 R2 – 32 bit to SQL server 2014 – 64 bit First thing we need to do is install SQL server 2014 on the new servers. Here is a step by step installation guide. Open SQL … More Install SQL Server 2014 Step by Step

Database Normalization

April 7, 2015

Database Normalization This is a brief quick description of database normalization.Database normalization is the process of organizing information in a relational database into tables to minimize redundancy.Normalizing a database allows scalability and it is easier to maintain, query and work with. There are 5 steps to normalize a database, my personal experience is that unless … More Database Normalization