Thoughts, ideas, and rants of a east coast db developer

SSIS – split big file into manageable pieces

We have a process that is taking a long time because the file we receive is pretty big.  What I’m doing is as follows: Create a stripped down file with just this year’s data in it Split that file into 5 much smaller pieces Move everything from the directory except the 5 files We have Read more about SSIS – split big file into manageable pieces[…]

Pulling data from Facebook (so far)

This will be a post that will (hopefully) evolve over time.  I’ve been trying to find an easy way to pull page level comments, replies, likes, reactions, etc from my company page to put into our database.  I know that Facebook has stats that they are currently sharing with admins for pages, but we’re looking Read more about Pulling data from Facebook (so far)[…]

TSQL Tuesday #96: Folks Who Have Made a Difference

I’m really excited to be participating in this month’s T-SQL Tuesday, the monthly blog party that has been running since 2009. This one was started by Ewald Cress. This is my first post for T-SQL Tuesday, and it couldn’t have come at a better time.  I just returned from Pass Summit where I had a Read more about TSQL Tuesday #96: Folks Who Have Made a Difference[…]