Tag Archives: sql server

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 , , , | 1 Comment

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

Restore to a point in time–#SQLNewBlogger

Posted on May 25, 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 also a part of a basic series on git and how to use it. One of the … Continue reading →

Posted in Blog | Tagged , , , , | 1 Comment

Listening and Taking Action

Posted on May 22, 2017 by

One way most of us would like to work is to have others listen to our concerns, our requests, our requirements, and then take action to help us. One of the principles of DevOps is just this. We work together … Continue reading →

Posted in Editorial | Tagged , | 1 Comment

Quick Graph Database

Posted on May 12, 2017 by

There’s a sample to work through here: https://docs.microsoft.com/en-us/sql/relational-databases/graphs/sql-graph-sample I decided to try this in CTP2 and just see how it works. I didn’t do much, but I added a node and an edge with this code: CREATE TABLE Person (ID … Continue reading →

Posted in Blog | Tagged , , | 4 Comments

Using DBCC Clonedatabase

Posted on May 10, 2017 by

I haven’t messed with the new DBCC CloneDatabase option in SQL Server 2014/12016 (depending on patches), but recently I saw this: On a quiet Friday afternoon, this seemed like a good time to experiment. We (Redgate Software) have a salesdemo … Continue reading →

Posted in Blog | Tagged , , | 1 Comment

Balloons and Data

Posted on May 9, 2017 by

This editorial was originally published on Aug 8. 2013. It is being re-run as Steve is out of the office. We see a lot of questions at SQLServerCentral repeated over the years as workers new to the platform encounter some … Continue reading →

Posted in Editorial | Tagged , | Leave a comment