One of the items I get asked a lot to do is to push data – usually in an Excel spreadsheet – into SQL Server. Usually, there are less than 50 rows of data. Heck, there are usually less than 5 columns as well. Today – and in a few succeeding blog posts – we’ll…… Continue reading Pushing Great Data Into SQL Server
Even More Fun with Database Keys
Over the last few posts, we’ve went over Primary Keys, Foreign Keys, Candidate Keys, and Alternate Keys. Most of y’all are probably thinking – that’s too many keys already! Why do we need even more keys? Well, that’s because we sometimes need different ways to describe what we’ve got going on. Of the four different…… Continue reading Even More Fun with Database Keys
More Fun with Database Keys
If you’ve been following along with some of our previous blog posts, you’ll know that we’ve discussed some of the more used keys when dealing with databases. Lest you forget, we talked about keys in these two blog posts: Primary Keys – Good and BadForeign Keys – Are they worth it? Now, we can talk…… Continue reading More Fun with Database Keys
Reverse Engineer an ERD – How to
Over the last few blog posts, I’ve been talking about keys – both primary and foreign. Now, we can use these to get a great ERD for all of our users. First, let’s open up our ERD tool. In this case, we’re going to use the SQL Database Modeler – a tool I talked about…… Continue reading Reverse Engineer an ERD – How to
Foreign Keys – Are they worth it?
Last time, we learned about Primary Keys and some of the goodness that they give you. If you missed that, remember to go back and read that here. This time, though, we want to focus on the close kin of primary keys – the foreign key. Foreign Keys are truly columns that point to the…… Continue reading Foreign Keys – Are they worth it?
Primary Keys – Good and Bad
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