Microsoft

In a previous post, I introduced PowerQuery and demonstrated how to perform various SQL-like operations. This article gives a tour of PowerQuery’s M language that underlies each query. let and in If you select a query and click on the “Advanced Editor” button in the Home tab, you’ll see something like this: This is the […]

Microsoft’s PowerQuery is a neat tool that allows one to perform SQL-like operations on Excel tables. When investigating a database, I actually prefer using PowerQuery over raw SQL for a couple reasons: PowerQuery displays result sets that are much easier to look at than the a typical SQL plaintext result set. It’s easy to immediately […]

Intro Many times a client wants some sort of customized view of the data they have in PowerBI. The truth is, as powerful as it is PowerBI, like all BI tools, offer limited customizability. However, PowerBI comes with a powerful RESTful interface that we can use to show the underlying data however we wish. This […]

Microsoft’s Power BI is a data and analytics reporting tool that lets you connect to multiple data sources. Once connected to a data source, raw data sets can be converted to dashboards and presented to the team, customer, anyone at any time. In this blog, we will get introduced to the custom function feature available […]

I’ve decided to write a tutorial on how to accomplish dependency injection in C# .NET, because the Microsoft documentation of dependency injection libraries is unfortunately way too sparse, and the Microsoft dependency injection tutorial is a little convoluted and complicated. Fortunately, C# .NET’s implementation of dependency injection is pretty straightforward. In my opinion, it’s way […]

As of 15th June 2022, Microsoft’s venerable web browser, Internet Explorer, will finally be officially retired and desupported on Windows platforms; it’s earned its rest! This quick post will discuss what that means for the Oracle Clinical/RDC/TMS suite of applications. As any users of the OC suite will know, Internet Explorer was, for most of […]

This blog is the third and final in a three-part series tackling how to set up and use Microsoft Teams for a project. Chats, Meeting Chats, and Channel Posts are all excellent methods of communication within Microsoft Teams. However, there is often confusion amongst project teams of when it is appropriate to use each feature. […]

This blog is the first in a three-part series tackling how to set up and use Microsoft Teams for a project. Maintaining good communication is crucial to project success. One of the best tools to facilitate regular communication amongst your project team is Microsoft Teams. In this post, we’ll cover a useful way to set […]

This blog is the second in a three-part series tackling how to set up and use Microsoft Teams for a project. So you’ve posted a message in Teams and you’re asking yourself, why hasn’t anyone responded? It might be that your messaging isn’t clear, or the right people don’t even know that you’re addressing them. […]

Monitoring your website performance is a key factor to ensure your application performs as expected. There are a lot of application performance monitoring (APM) tools available in the market that can be used to monitor the performance of the application, such as NewRelic, Azure Monitor, AppDynamics, and others. In this post, I’ll talk more about […]

Application modernization continues to be critical for digital transformation. Perficient is committed to meeting the demands of our customers’ cloud needs with highly skilled and specialized partnerships. We are proud to announce that Perficient has achieved Advanced Specialization in the Modernization of Web Applications to Azure. This formally recognizes Perficient as a leading partner in […]

I’ve decided to write some of my own documentation for common use cases of the Excel functions LOOKUP, VLOOKUP, HLOOKUP and XLOOKUP because the official documentation is pretty confusing. It uses “lookup value” as a synonym for “key”, when one would conventionally expect a “lookup value” to be a synonym for “value”! (After all, in […]