by William Tom | Apr 3, 2017 | How To
In this tutorial, I will show how to handle a NULL value loaded by SSIS from a CSV file. Note that some knowledge of Excel, SQL and programming is necessary. 1. Build a CSV file. Here’s a sample file: 2. Create a table in the SQL server database: create table...
by Craig Rubenstein | Jan 6, 2017 | Uncategorized
Happy New Year! If your resolution is to improve your business intelligence capabilities and get about how you’re leveraging your data, you’ve come to the right place. Whether you’re a developer or end-user, SQL views can be a convenient and powerful...
by Derek Nachimow | May 6, 2013 | Technology
Everyone’s favorite topic of dinnertime conversation! Or maybe that’s just me? With that being said, there are a number of reason for a database to grow quickly in size; however the majority of the time, this can be tied to one specific issue, which...
