For the last few posts, I’ve been going on about various ways in which you can import data from spreadsheets into SQL Server. But, why should it only work one way? Why can’t we export data as well? Good question, my friend! One of the ways that you can export data is by using our…… Continue reading How to Export data to Excel
Tag: SQL
More Fun Inserting Data with R
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
PASS Summit 2017
For those of you that don’t know, PASS Summit 2017 is literally just around the corner and I just happen to be going! For those who have never been before, it’s possibly one of the greatest networking events for those of us into data imaginable! You can literally go into multiple presentations, where you will…… Continue reading PASS Summit 2017
Reading from a data source
Last time we listed out several things that can be done with or to a data source. Now all of the examples we’ll be using in this series will use a database as a data source. It will allow us to discuss another of my favorite topics — SQL — while we talk about what…… Continue reading Reading from a data source