Monthly Archives: June 2017

Loading All CSV Files with PowerShell

Posted on June 23, 2017 by way0utwest

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

The Traveling Data Professional

Posted on June 23, 2017 by way0utwest

It’s summertime in the Northern hemispheres, and a time when much of the world takes their holiday time away from work. Most kids are out of school for at least part of the June/July/August time period. With many of us … Continue reading →

Posted in Editorial | Tagged | 2 Comments

Move a Stored Procedure to a New Schema–SQLNewBlogger

Posted on June 22, 2017 by way0utwest

Another post for me that is simple and hopefully serves as an example for people trying to get blogging as #SQLNewBloggers. One of the things I needed to do recently was move an object. I was testing the WideWorldImporters database … Continue reading →

Posted in Blog | Tagged , , , | Comments Off on Move a Stored Procedure to a New Schema–SQLNewBlogger

Backup Plans for Data Loss

Posted on June 22, 2017 by way0utwest

The British Airways computer failure has been on my mind for a few weeks. It seems like such an epic failure in 2017 from a high public company that many, many people depend on. I still struggle to believe the … Continue reading →

Posted in Editorial | Tagged , | Comments Off on Backup Plans for Data Loss