Author: Kevin
-
Welcome Back (to me!)
I know it has been quite some time since I last posted, but, well, life happens. Sadly, there is only one of me, and so many things that are expected of me. Whether it be something at work, something personal, or a combination of both, it just had to be done by yours truly. But…
-
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…
-
Concatenation of Strings!
Now, I know for most of you, this seems like a rather simple idea. The definition of concatenation is, according to Dictionary.com is : verb (used with object) 1. to link together; unite in a series or chain. Simply put, you combine two or more strings together to form a new string. So, the first…
-
Merging Data Sources – Part 3
Now, when I last posted, I’m sure you thought I was done talking about the MERGE statement. You are so wrong, compadre! One more post is absolutely needed! There are a few issues with the MERGE statement. Well, as of this writing, there are 361 possible issues according to Microsoft Connect – the actual website…
-
Merging Data Sources Part II
The last time we were together, we learned how to use the MERGE statement when we wanted to insert rows that didn’t exist and update rows that didn’t. This time we’re going to add onto that. We’re adding the seldom used, but delightfully potent – delete rows that no longer exist in the original table.…
-
Getting rid of data
In previous posts, we’ve talked about SELECTing data, INSERTing data, and UPDATEing data. Now, what do we do if we want to just get rid of the data? Now, in most scenarios, you really don’t want to get rid of data. As a data professional, it is definitely not a good idea to get rid…