What time is it in Oz?

October 5, 2021 Andy 1

There was a recent post on Database Administrators, where there was some confusion over Daylight Saving Time(DST) in Australian timezones. Let’s be honest though–timezones are confusing, especially when DST comes into play. Arizona Time doesn’t observe Daylight Saving Time, so sometimes it’s the same as … [Read More]

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]