Tag Archives: sql server

Database Mirroring Needs FQDNs

Posted on July 3, 2017 by way0utwest

A quick basic post, and one that I’ve forgotten. Since blogging is a good way to remind myself of things, here goes. I was testing Database Mirroring (DBM) recently for an upgrade situation. I’ve set up it up in the … Continue reading →

Posted in Uncategorized | Tagged , , , | Comments Off on Database Mirroring Needs FQDNs

SQL Server is Lagging a Bit

Posted on June 28, 2017 by way0utwest

I don’t expect this to last, or I hope it doesn’t, but SQL Server is lagging behind. I ran across a short piece on the SQL:2016 standards, and I know these standards aren’t necessarily an important consideration for most of us when choosing … Continue reading →

Posted in Editorial | Tagged | Comments Off on SQL Server is Lagging a Bit

Adding Performance Counters back for SQL Server

Posted on June 26, 2017 by way0utwest

I had a strange situation the other day, where a number of things went wrong with my instance. First, I lost permissions to detached databases. The SID was listed in the file permissions, but apparently unlinked to an account. Next, … Continue reading →

Posted in Blog | Tagged , , | Comments Off on Adding Performance Counters back for SQL Server

Using OPENROWSET in SQL Server on Linux

Posted on June 21, 2017 by way0utwest

I wanted to import the million song dataset in SQL Server on Linux. There’s a github repo that has the SQL to allow you to use this with the graph database features. However, it’s built for Windows. Linux is a … Continue reading →

Posted in Blog | Tagged , , , | 2 Comments