Tag Archives: sql server

Getting Close to the 2017 RTM

Posted on July 18, 2017 by

I still can’t believe that we’ll have a new version of SQL Server this year. After speaking at so many events last year, talking about the new features of SQL Server 2016, it seems crazy that there’s a new version … Continue reading →

Posted in Editorial | Tagged | Leave a comment

SQL Server 2017 RC1 is Here

Posted on July 18, 2017 by

And I’ve got it. Glenn Berry posted a a link to the MSDN blog and almost immediately a note that the link was still the CTP. I decided to fire up my Ubuntu install and check. No updates there, though … Continue reading →

Posted in Blog | Tagged , , | 2 Comments

Database Mirroring Needs FQDNs

Posted on July 3, 2017 by

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 , , , | Leave a comment

SQL Server is Lagging a Bit

Posted on June 28, 2017 by

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 | Leave a comment

Adding Performance Counters back for SQL Server

Posted on June 26, 2017 by

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 , , | Leave a comment

Using OPENROWSET in SQL Server on Linux

Posted on June 21, 2017 by

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

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 , , , | Leave a comment

Why Does My Log Grow–SQLNewBlogger

Posted on June 8, 2017 by

Another post for me that is simple and hopefully serves as an example for people trying to get blogging as #SQLNewBloggers. This is a great topic, and really, every DBA or admin should blog this and be sure they understand … Continue reading →

Posted in Blog | Tagged , , | Leave a comment

SQL Server is Getting Smarter

Posted on June 8, 2017 by

There’s been a lot of press and media about Microsoft on the AI and machine learning work they’re heavily investing in. From Cognitive Services to Cortana to Bots, Microsoft is really investing in developers and applications that will perform detailed … Continue reading →

Posted in Editorial | Tagged , | Leave a comment

Restore a BACPAC–#SQLNewBlogger

Posted on June 1, 2017 by

Another post for me that is simple and hopefully serves as an example for people trying to get blogging as #SQLNewBloggers. I needed to get the WideWorldImporters sample database for a project and noticed that there was a BACPAC available. … Continue reading →

Posted in Blog | Tagged , , , | 2 Comments