Tag Archives: sql server

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

Renaming MDF/LDF Files–SQLNewBlogger

Posted on June 15, 2017 by way0utwest

Another post for me that is simple and hopefully serves as an example for people trying to get blogging as #SQLNewBloggers. I would guess many people would run into this situation at some point. A developer or DBA creates a … Continue reading →

Posted in Blog | Tagged , , , | Comments Off on Renaming MDF/LDF Files–SQLNewBlogger