When it comes down to primary keys, most of us that have been working with databases for a while have come across a few million different ones. Some work fairly well. Some just don’t work at all and should be banned from ever being used as a primary key again. First, let’s delve into what…… Continue reading Primary Keys – Good and Bad
Reverse Engineering an ERD
One of the items you may have seen on the tools that you were using on Set up for an ERD is that you were asked if you wanted to reverse engineer it. Do not let the term “Reverse Engineer” confuse or scare you. Reverse Engineer – in this case – just means that the…… Continue reading Reverse Engineering an ERD
Set up for an ERD
So, last time, we discussed briefly what an ERD is and how it makes life easier for you. This time, let’s go thru setting one up. The first step – and possibly the hardest – is picking out the right tool for you. Over the past several years, I have tended more towards the ones…… Continue reading Set up for an ERD
The Real Value of ERDs
Several years ago, when I first started working with databases, I was lucky enough to work under a manager that believed in the value of Entity-Relationship Diagrams – better known as ERDs. For those of you not familiar with ERDs, they show the relationships of entity sets stored in a database. In other words, they show how each table…… Continue reading The Real Value of ERDs
Just a final bit of Power Platform Goodness
Over the last few blog posts, I hopefully have shown off at least some of the basics of what the Power Platform can do for you: https://www.youtube.com/watch?v=Sxjl3ejBYwA Yeah, don’t expect a lot of Sheryl Crow from this page. In the past few days, Microsoft has come out with new icons for each app in the…… Continue reading Just a final bit of Power Platform Goodness
Working within the Power Platform – Power Virtual Agents
So, now we’ve focused on 3 of the 4 products that make up the Power Platform – Power BI, Power Automate, and Power Apps. Finally, we turn our focus on the newest member of the Power Platform – Power Virtual Agents. Power Virtual Agents are chat bots that are created to answer questions from your…… Continue reading Working within the Power Platform – Power Virtual Agents
Working within the Power Platform – Power Automate
Power Automate is the new-ish name for a product that you may have heard of sometime back – Microsoft Flow. It was given a new name back in November of 2019 so that it was more obvious to users that it was part of the Power Platform, and, therefore, gets all of the integrations and…… Continue reading Working within the Power Platform – Power Automate
Working within the Power Platform – Power Apps
The next product in the Power Platform suite is Power Apps. Power Apps is a “no-code” interface that works well for the non-technical people out there – yes, it works great for the technical people as well. To create a Power App yourself, you have to start at the Power Apps Home Page. Working in…… Continue reading Working within the Power Platform – Power Apps
Working within the Power Platform – Power BI
Power BI – as has been told probably many times before – is a game-changer. Many people will tell you that Power BI is, quite simply, a visualization tool. https://imgur.com/tDmp4oh Power BI is the analytics tool that can help your business move up to the next level. There are two distinctly different ways that you…… Continue reading Working within the Power Platform – Power BI
Introducing the Microsoft Power Platform
So for the past few years, everyone has been talking about the latest “big sexy” from Microsoft – Power BI. But, have you heard about the restof the Power Platform? Somehow I doubt most of us had even thought there was anything beyond Power BI! In actuality, there are 4 unique parts to the Power…… Continue reading Introducing the Microsoft Power Platform