This post will detail how to use last modified date when importing data from any data file into SQL server. This can be very useful if you have a lot of files but don’t want to reload...
This post will detail how to use last modified date when importing data from any data file into SQL server. This can be very useful if you have a lot of files but don’t want to reload...
In most cases, creating and maintaining a data dictionary requires significant manual effort. Report users must constantly download a new report to get the latest definitions and...
Ever been tasked with analyzing data from a table, but you have little-to-no understanding of the "origin" and/or "meaning" of its various columns?
Topics: Blog, Data, Excel, Excel and PowerPivot, Functions, Large data set, SQL
In this article I will provide a simple walk through of how to compare two different data sources that (should) contain the same data.
Skill Level: Beginner Target Audience: Business...
1) Know your file location! In this case I have a 10 GB txt file saved to my desktop
C:\Users\Login\Desktop\LargeFile.txt
2) Open up Visual Studio > File > New > Project >...
Topics: Blog, Data, ETL, Large data set, SQL, SSIS, Visual studio
If you’re reading this and you haven’t read Part 1 of the Messy Data trilogy, then please take a few minutes to read Part 1 now. This will make much more sense if you’ve done so.
In...
In a perfect world, every database would be perfectly normalized, and nobody would ever manually enter a value into a table. Unfortunately, this is reality, and not everyone is a...