Using PowerShell to tidy up CSV files

December 28, 2018 Andy 0

I was recently fussing with a CSV file that had an inconsistent number of columns. UGH. There was a bunch of historical data that had 4 columns, and then more recent data had a new attribute added with 5 columns. I spent a few minutes … [Read More]

Generating artificial CPU load 🔥

June 14, 2018 Andy 0

I was recently asked: For testing, I need to generate artificial CPU load on the server, outside of SQL Server. Do you have any ideas? Maybe something with PowerShell? I quickly replied: Heck yea, PowerShell can do that. I mean, I knew PowerShell could do … [Read More]

Is that share using SMBv1?

June 13, 2018 Andy 4

In case you’ve missed it (though, if you’re a data professional or other IT pro, you must live under a rock if you’ve missed it), SMBv1 should never ever be used. Alas, some shares out there still exist & use it. Recent Windows updates have … [Read More]

Building a Twitter-bot RSS Aggregator

January 11, 2017 Andy 1

I hate RSS readers For some reason, about once a year, I go hunting for a new RSS reader so I can keep track of blogs that I like to read.  It’s always the same process: Dig through reviews to find an app that I think … [Read More]

TSQL Tuesday #85: Backup + Recovery + ☁️

December 13, 2016 Andy 0

It’s T-SQL Tuesday,  the blog party that SQL Server expert Adam Machanic (blog|twitter) started. This month’s episode is hosted by Kenneth Fisher (blog| twitter). The topic: Backup & Recovery Your backups are my bread & butter Backup & recovery are a DBA’s bread & butter. I always tell people that … [Read More]

Moving SSRS Reports between servers

June 29, 2016 Andy 2

Today, my friend Derik Hammer (blog|twitter) asked about moving SSRS reports between (versions and) instances of SSRS: What is the best way to move 2008 R2 SSRS reports into an existing 2012 SSRS instance? Catalog move is insufficient here. #sqlhelp — Derik Hammer (@SQLHammer) June … [Read More]