Leveraging the Power Platform and Microsoft Azure to connect housing agencies and intermediaries with the Department of Housing and Urban Development (HUD) Intro The US Department of Housing and Urban Development runs a program known as the Housing Counseling Program that aids housing agencies around the nation through things like grants and training. These agencies provide tremendous benefit to Americans in many forms including credit counseling, foreclosure prevention, predatory lending awareness, homelessness, and more. One of the requirements for approval […]

Agility and Discipline are Both Required as Organizations Adopt the Cloud At the beginning of cloud adoption, experimentation is common and exploration of applicable technologies is welcomed. Development teams are excited to try the newest service offerings and proof of concept efforts are completed with great interest. However, the thrill of discovery often turns to frustration as configuration complexity increases, and cost control challenges mount. The initial exploration proof of concepts often does not consider where costs are coming from […]

Executive Summary This blog post is for Power Apps developers with basic experience with Microsoft Excel and .NET development. It begins by defining a real-world example for data migration. Next, it describes the steps necessary to use Excel to generate repetitious code within a provided Visual Studio Console Application. Finally, it demonstrates the solution being used and the result data in a Power App. The Scenario In part one of this two-part series, we covered the basics techniques of how […]

Applied Information Sciences (AIS) has been recognized as the Microsoft Partner of the Year (2020) for Power Apps and Power Automate! This is an exciting award for our company and one which we are honored to receive. AIS has a long history helping customers in large, global, and often regulated industries work through their cloud transformation. We know that this success is due in large part to the Power Platform community and the hard work of our business applications leaders […]

A Framework to Meet Your Needs PowerApps comes with a wide variety of controls out of the box. However, these controls may not be on-brand or have the desired look and feel, functionality, or style for your app. The PowerApps Component Framework command-line interface tools let you create a custom PowerApps control specific to your individual needs. PCF works this magic by integrating JavaScript libraries into the PowerApps control. As a primarily JavaScript frontend developer, my normal workflow is project […]

Finding the perfect “fit” when it comes to a career choice can often feel like finding a needle in a haystack. An employer who values the experience of their employees, encourages the growth of individuals alongside the enterprise, and provides access to mentors and resources to advance your career is what you’ll find at AIS. We are proud to have a quickly growing team with many employee tenures in the decades, some upwards of 35 years! That’s a long time […]

This is the second of two blog posts that will share solutions to common Azure DevOps Services concerns: In “Azure DevOps Services for Government: Access Control”, I covered common access control concerns. In “Azure DevOps Services for Government: Information Storage” (this post), I will address common concerns with storing information in the commercial data centers that host Azure DevOps Services. Storing Service Connection Credentials To deploy Azure infrastructure from an Azure DevOps pipeline, your pipeline agent needs permission to create […]

Relational database source control, versioning, and deployments have notoriously been challenging. Each instance of the database (Dev, Test, Production) can contain different data, may be upgraded at different times, and are generally not in a consistent state. This is known as database drift. Traditional Approach and Challenges Traditionally, to move changes between each instance, a one-off “state-based” comparison is done either directly between the database or against a common state like a SQL Server Data Tools project. This yields a […]

In my previous post, I discussed lessons learned about migrating SQL Server databases from on-premise to Azure SQL Databases. This post will share several of my issues and solutions around automating Azure resource provisioning and application code deployment. Before this project, I had never used Azure DevOps or Team Foundation Server for anything except a code repository or task tracking. Most of these applications would use Build and Release pipelines to configure the Azure subscription and deploy the applications. Besides, […]

One of our clients has been pushing big to migrate all the application infrastructure to Azure. Some of the applications have been using on-prem file servers and we have been looking at different options available to migrate these file shares to Azure. We looked at Azure Blob storage, Azure Files and Azure Disks to find out the most fitting solution for us that would offer high performance, permissions at the folder level, and long-term backup retention. Although Azure Blob storage […]