Bridging the gap between serverless OLTP and Analytics Cosmos DB is unabashedly a document-based Online Transactional Processing (OLTP) system. It was engineered at its core to provide low latency, high throughput transactions with service level agreements (SLAs), consistency models, and guarantees to back it. It does this exceptionally well, but there are trade-offs for these architectural decisions. Other databases can do like complex queries with joins and aggregates or set-based operations. Cosmos DB, by design, doesn’t have a native solution […]

AIS is now one of few partners that can offer your organization cloud licensing across Azure Commercial, Azure Government Cloud, M365, M365 Government Community Cloud (GCC), and M365 GCC High. As a Cloud Solution Partner (CSP) and long-term Microsoft Partner, our Microsoft certified cloud engineers can support purchasing and managing licenses, migrating/deploying cloud infrastructure, modernizing applications, and managing cloud environments – including cost optimizations, security, and compliance. AIS holds 10 Microsoft Gold Competencies, over 25 years of experience in Microsoft […]

How do you know you’re ready to present at a conference? You may have a good understanding of how something works, or you can build and explain how you reached a specific solution. I’m writing this article not because I am a presentation expert, but because I presented once at a large conference (and have seen a fair share of live presentations). If you follow the path that I took, presentations don’t have to be scary, but an opportunity for […]

Building data and formatting features into MS Office applications using Office Add-Ins can be a crucial productivity boost to an organization. Now Microsoft has given us the ability to build Add-Ins faster and easier using the SharePoint Framework (SPFx). What are Office Add-ins? You will find them in the ribbon of Office apps. Below is the Add-ins pane found in the ribbon in Word. The default installation of Word includes the Wikipedia Add-in, a great example of an add-in, that […]

In this blog post, I’d like to share: What I have learned about OCM and its importance The ADKAR® Model for successful OCM How UX and OCM are closely related and connected A case study of implementing UX and OCM together I enjoy being a User Experience (UX) Researcher. I like working with diverse user groups, learning about their needs, understanding their frustrations and challenges, coming up with solutions to address their pain points, and usually making corresponding design recommendations […]

Have you been in a situation where an Azure Resource Manager (ARM) template with Azure Blueprint is the only option available for Infrastructure as Code (IaC) deployment? Have you realized that certain operations during deployment are not possible with an ARM template? Have you been in a situation that PowerShell or Azure CLI can get the job done, but there is no way to inject that script into the ARM template? Maybe you have felt like ARM-disabled at this time. […]

Last week, Microsoft introduced its new Dataflex technology for data services inside of Microsoft Teams, in addition to the rebranding of its former Common Data Service (CDS) to be called Dataflex Pro. I followed this up an hour later with a post on my Runway View blog that outlined four things to know and five things to do following the big Microsoft Dataflex + Teams announcement. Below I have outlined five real-world scenarios where Microsoft Dataflex is a game-changer, particularly […]

The Dockerfile development workflow is fantastic if you are familiar with the documentation and have spent a lot of time troubleshooting. However, if you are writing your first Dockerfile, it may be challenging to identify and debug certain cases. During my first foray into the world of containers, I was containerizing a React Application. As I got comfortable copying the correct files into the image and making sure I was running things correctly, I ran the “docker build .” command […]

This blog is part of a series of hands-on labs on leveraging the Power Platform and Microsoft Azure. To break this series up into more manageable chunks, in this installment, we’ll focus on setting up the On-Premises Gateway that will connect to our local SQL Server and the Azure Logic App that will use the new gateway to connect to our local SQL Server 2017 and return customer data using an HTTP request and response. We’ll wrap it up by […]

We are in awe of our team as they have reached another impressive milestone in support of our nation’s mission to modernize their IT footprint. Within the last week, AIS was able to successfully establish the first Microsoft Azure Impact Level 6 (IL6) instances and achieve a conditional Authority to Operate (ATO) at IL6.  At the end of 2018, AIS was the first to establish a cloud connection at Impact Level 5, meaning our customers could connect and store any unclassified data on their Azure subscription. By achieving an ATO for Microsoft […]