Tag Archives: ETL

Importing Flat Files in SSMS 17.x Works

One of the more annoying things I’ve found in SSIS/SSMS is trying to import CSV files for some quick analysis. For some reason I constantly seem to get files that the import wizard keeps having issues. On top of that, … Continue reading

Posted in Blog | Tagged , , | 2 Comments

ETL or ELT

I was reading a piece on ETL patterns and found it interesting that the author noted that one way to reduce the challenge of ETL processes keeping up with changing schemas is to move to an ELT process. That’s an interesting perspective, and … Continue reading

Posted in Editorial | Tagged

Brush Up on Your ETL Skills

Many of us that work with data will find requests and demands to import or export data at some point. Plenty of us have regular processes that perform these actions, and we may regularly troubleshoot or enhance these activities. In … Continue reading

Posted in Editorial | Tagged ,

Bulk Inserting Build Data–#SQLNewBlogger

Another post for me that is simple and hopefully serves as an example for people trying to get blogging as #SQLNewBloggers. One of the common tasks that many DBAs need to do is insert data into a database. Often this … Continue reading

Posted in Blog | Tagged , , , | 2 Comments

Loading All CSV Files with PowerShell

I ran across Denis Gobo’s post about working with names from Social Security cards and wanted to play with the dataset. However, rather than use xp_cmdshell, which I might have, I decided to use PowerShell. I need to repeat this … Continue reading

Posted in Blog | Tagged , , | 2 Comments

DevOps – Downloading a File from the Internet with PoSh

One of the things we need to do as data professionals is move data files around. Often we’ll get a local path, but in looking for public data sets, I wanted to get a file from the Internet. In this … Continue reading

Posted in Blog | Tagged , , | 2 Comments

Loading a Text File with a Line Feed

Loading text files is a skill that probably every DBA needs. I know that the import wizard is available, but there are times that you might want to automate this without using SSIS. In those cases, it’s nice to know … Continue reading

Posted in Blog | Tagged , , | 2 Comments

When Should We Be Cleaning Data?

I was reading Grant Fritchey’s update from the Business Analyst Conference  and noticed this quote: ” There were lots of sessions on the need to clean data, which implies that we need to do a better job at data collection in order … Continue reading

Posted in Editorial | Tagged , ,

Opening Up Data

Tim O’Reilly has been an advocate of open data access and standards for some time, especially from governments. He’s pushed for more interoperability and certainly more accessability from all sorts of groups. He gave an interview earlier this year to LinuxVoice where … Continue reading

Posted in Editorial | Tagged , ,

ETL

Today we have an editorial that was originally published on Aug 31, 2006 as Steve is traveling at DevConnections. I’ve followed the development, release, and subsequent news on SQL Server 2005 for over two years now. It’s been an interesting … Continue reading

Posted in Editorial | Tagged ,