Cary G Anderson

Privacy Policy

Seems that every site needs an official Privacy Policy nowadays... So here's this site's Privacy Policy: PRIVACY NOTICE Last updated 5/27/2023 This privacy notice for Software Warrior.NET, Inc. (doing business as Software Warrior.NET) (“Company,” “we,” “us,” or “our“), describes how and why

JSON Decode SQL Server CLR Function

SQL Server has a lot of features, functions, and power. One of the little used but highly useful features is called SQL Server CLR. This allows one to write a C# DLL program that can be called by a SQL Server function to do custom data transformations. This is one

Simple Newtonsoft JSON DLL Validator

Validates that the Newtonsoft JSON DLL is present in the GAC.

Cosmos DB Tool

Enhanced version of the JSON Test Record Reader that allows Cosmos DB browse, finding, and filtering on Dev, Test, and Production environments for testing purposes.

JSON Test Record Reader Tool

Reads the journal history Cosmos DB BSON records posted by microservice.  Can be used to find, browse, and filter the records to confirm records present and for testing purposes.

JSON Test Record Poster

Posts one to thousands of the generated JSON test files from the JSON Test Record Generator to the microservices based web service.

JSON Test Record Generator Tool

Generates JSON based test records to a set of test files. Generates one to millions.

Test Record Generator Tool

Generates thousands of test records from a simple GUI interface.

Smarty Streets Test Tool

Smarty Streets Test Tool - A simple and highly useful GUI tool to test both SmartyStreets web service access and check addresses via SmartyStreets web service. Useful and demonstrates using REST API with a Windows Desktop winforms program.

Documentation as I Go...

Documentation as You Go - Generated complete ETL and cube documentation as I built the MCR cube and ETL systems for: * ETL Design * ETL Implementation * Cube Design * Cube Implementation * Test Plans and Testing Documentation Note: This is a Super Agile Practice/Principle.

I also Help with Testing...

Test Plans – Developed test plan documents for testing MCR cube and ETL. Test Documents – Developed test documents for documenting testing of MCR cube and ETL. Cube Test Tool – Built a cube test tool to validate the design and operational implementation approach. Again, this was for a Federal contract so these

And I Wrote an eBook...

The Tabular Cube Answer Book – Developed and wrote The Cube Answer Book the first book to explain OLAP cubes to users and managers in an easy to understand form and to communicate the advantages and uses of cubes, especially tabular OLAP cubes.

Some SQL Improvements

Improved Data Dimension Generation SQL – Fixed and improved that existing date dimension generation SQL to provide improved and expanded date options and coverage.

Cube Deployment Procedures

I'm an unusual developer in that I actually write procedures and documentation as well!

ASP.NET Cube Status Portal

Cube Portal – I built a cube status web portal in ASP.NET MVC that displays the online and last processed date time of reporting cubes as well as the ETL logging information and status. Using the SQL logging system I developed.

MCR Cube with Journaling Confirmation System

This was first an OLAP cube system that used my ETL programs to retrieve data from a Cosmos DB NoSQL database, convert it from JSON format to a relational format, and then load it into a SQL Server database where it was cubed by SSAS (SQL Server Analysis Services).  Tableau

Cosmos DB NoSQL JSON DB

I worked extensively with Cosmos DB which is an Azure NoSQL JSON based database based upon and derived from MongoDB.

SQL Server Logging System

Logging– Created a SQL logging system using a single simple and adaptable logging stored procedure to easily and thoroughly log ETL and proc execution and run time elapsed time, statistics, performance, and automatic error logging.

Azure CLI Function for ETL - Version 2

Second Generation ETL Program – Command line program in C# to create a Universal ETL Program for NoSQL to relational data transfer and ETL. Main Points: 1.       Auto adapting ETL program. 2.       Uses Definition Programming for operations instead of endless code changes to adapt to various ETL scenarios and operations. 3.

Azure CLI Function for ETL - Version 1

First Generation ETL Program – Command line program in C# to retrieve data from Cosmos DB NoSQL databases, transform the data to a relational form, and insert it into SQL Server for cubing and reporting. Main Points: 1.       Simple and effective ETL via a command line program.

Grant Software Innovations - Summary

This is a simple list of the innovations that I have done in a three year period for a client.  All of them build upon my previous innovations, experience, and work at other companies and also on my own time. [Note to Self- I need to format this better and

Azure Function for Custom ETL for Data Factory

All these planes flying over your head...And when you are in one...All send short text messages down to the ground via ground control links.  The pilots have a little panel in their instrument panel that displays the messages and allows them to send messages regarding the status of

Oracle RDS Log Files Tools for AWS

This I'm just finishing building...So no screen shot yet.  But I'll put one up in the future.  Remind me if I'm remiss in this. So creating and using databases in the Cloud is very easy and convenient.  You just spin up a new

All the Many Things I Build!

As a Software Developer, in many ways and in many jobs I've been a "one man band" for development.  I tend to be given ("thrown at") the tough and challenging problems where I'm often expected by some to fail...And then I

Welcome to SoftwareWarrior.NET!

My name is Grant...C. Grant Anderson. And I've been a Software Warrior in Microsoft C# and .NET for many years. This is a my consulting company website.  Where people can learn a bit more about me, my amazing abilities, and my portfolio of all the things that