SQL: A love story

January 21, 2019 Andy 0

I’m a college drop-out. When I was trying to figure out my life, a friend (my brother’s ex) referred me to a software company where she was working–I got the job because I was (a) breathing, (b) eager to do the job, and (c) cheap. … [Read More]

Failure is always an option

January 15, 2019 Andy 1

Bloggers spend a lot of time writing about our successes, but we’re human and we make mistakes, too. This post is a chance to share one of my memorable failures.

Managed Instance Restart

January 5, 2019 Andy 0

Question Does anyone know how to restart a SQL Server Managed Instance? The stop / start / reset are all grayed out, so that’s really. It an option. Any thoughts? Thanks… asked 2019-01-05 by Kevin Wilkie Answer You don’t restart Managed Instance. The beauty of … [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]

Working from home: Home office tour

December 18, 2018 Andy 4

About two years ago, I moved my home office down into the basement at our house. Earlier this year, I started a new job at SentryOne, and work from home full time. This means I spend more (awake) time in my office than any other room in the house. I thought I’d take everyone through a guided tour of my home office.

Installation of SQL Server Express LocalDB 2017

November 4, 2018 Andy 0

Question I want to install Microsoft SQL Server LocalDB 2017 on my system. I downloaded SQL Server Express Setup (about 5.1 MB). Then I opened it and chose ‘Download Media’ option and then chose LocalDB. Then it downloaded SqlLocalDB.msi setup (about 45.9 MB). I ran … [Read More]

how azure sql geo replication works internally?

November 2, 2018 Andy 0

Question My company moved to azure and started to use azure Sql database and geo replication. For our on-premise servers, we heavily rely on Microsoft transactional replication to move data. Now we setup transactional replication between on-premise server (publisher) and azure sql db. Then we … [Read More]