I know what you’re thinking at this point. You’re like “How many more ways can there be to insert data into SQL Server?” The answer is actually as many ways as you can think of. Uh-huh… I tend to stay mostly within SQL Server, but I do branch out to PowerShell and the computer language…… Continue reading More Fun Inserting Data with R
More Fun Inserting Data with PowerShell
Up until now, we’ve talked about various ways to insert data into SQL Server using SSMS. If somehow you missed out on the excitement, you can revisit those posts at: More Fun Inserting Data Using WizardsMore Fun Inserting Data using ValuesQuick and Simple Inserts Those ways work great if you’re inserting one tab of an…… Continue reading More Fun Inserting Data with PowerShell
More Fun Inserting Data Using Wizards
We have now talked about inserting data into SQL Server with functionality from Excel in both Quick and Simple Inserts and More Fun Inserting Data Using Values. Some of you are probably sitting back and saying “That’s just too much work. Give me something that will walk me through it and not have to remember…… Continue reading More Fun Inserting Data Using Wizards
More Fun Inserting Data using Values
Last time, we went over one of my favorite ways to push data into a database table. If you’ve forgotten – or somehow missed it – please sit back and enjoy the fun of Inserting the data. This time, we’ll do it in a slightly different way that can be useful as well. First, we’ll…… Continue reading More Fun Inserting Data using Values
Quick and Simple Inserts
In my last post (found at Pushing Great Data Into SQL Server), we quickly skimmed over the myriads of ways that I use to push data into SQL Server, or for that matter, almost any relational database. This time, I want to go a bit more in-depth into why it works and why it’s so…… Continue reading Quick and Simple Inserts
Pushing Great Data Into SQL Server
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?