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
Month: April 2021
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