-->
SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 

The Voice of the DBA

Steve Jones is the editor of SQLServerCentral.com and visits a wide variety of data related topics in his daily editorial. Steve has spent years working as a DBA and general purpose Windows administrator, primarily working with SQL Server since it was ported from Sybase in 1990. You can follow Steve on Twitter at twitter.com/way0utwest

Archives: May 2017

Quitting VIM

I saw this post from Joel Spolsky lately, noting that Stack Overflow has been helping 1 million developers exit VIM. It’s a funny post, but one that has some truth in it. I’ve gotten into VIM, almost always from git, but sometimes in Linux, and I often Google the… Read more

2 comments, 312 reads

Posted in The Voice of the DBA on 29 May 2017

Save on IT/DevConnections this fall

For the first time in many years, I won’t be at IT/DevConnections this fall.  I’m disappointed to miss the event, but I had other commitments around this time when I heard about being chosen as a speaker and this would be the fourth event in four weeks. That’s a bit… Read more

0 comments, 312 reads

Posted in The Voice of the DBA on 25 May 2017

Restore to a point in time–#SQLNewBlogger

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 things I had to show recently was a restore… Read more

2 comments, 375 reads

Posted in The Voice of the DBA on 25 May 2017

Looking Back at Build–CosmosDB

Part of a series looking back at Build 2017, going over the 20+ pages of notes I took.

One of the big announcements at Build 2017 was the release of CosmosDB. This is a rebranding of DocumentDB, the document store in Azure, with some additional capabilities. You can also… Read more

0 comments, 1,239 reads

Posted in The Voice of the DBA on 24 May 2017

A Busy Few Years

Last week on Twitter, a friend mentioned they were submitting to the PASS Summit and went through their previous speaking engagements. This person noted they had done over 40 talks in the last few years, which is a lot. I do more, but it’s part of my job. Ten talks… Read more

2 comments, 252 reads

Posted in The Voice of the DBA on 22 May 2017

La La Land Speaking at SQL Saturday #640

I love LA. In many ways, it’s a fun city to visit, and I love taking a few minutes, even just a 10-20 minute walk along the boardwalk on some beach. I’ve looked forward to quite a few trips to LA in my life, and I often take advantage of… Read more

2 comments, 495 reads

Posted in The Voice of the DBA on 19 May 2017

DevOps Basics – Connecting to a Git Remote

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.

As I work more and more with Git, I find myself learning… Read more

0 comments, 340 reads

Posted in The Voice of the DBA on 18 May 2017

A (mostly) Unwired Week at #MSBuild

Part of a series looking back at Build 2017, going over the 20+ pages of notes I took.

Last week I had the opportunity to attend Microsoft’s Build conference, and as I wrote, I planned to use a notebook and not my PC. For the most part, that… Read more

0 comments, 415 reads

Posted in The Voice of the DBA on 15 May 2017

Trying GO with SQL Server

Not the batch separator, but the GO language.

I’m always interested in learning new things, and GO has been one of those items that I’ve wanted to look at and see how it works. This is a big language at Google and

I saw a new blog from Mat Hayward-Hill… Read more

0 comments, 773 reads

Posted in The Voice of the DBA on 15 May 2017

Quick Graph Database

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 INTEGER PRIMARY KEY, name VARCHAR(100)) AS NODE;
CREATE TABLE friends…

Read more

4 comments, 702 reads

Posted in The Voice of the DBA on 12 May 2017

DevOps Basics–Creating a local repo and committing files

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.

A local repo is a repository, and is the version control… Read more

0 comments, 325 reads

Posted in The Voice of the DBA on 11 May 2017

Using DBCC Clonedatabase

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 VM that we use to show various Redgate… Read more

1 comments, 473 reads

Posted in The Voice of the DBA on 10 May 2017

Shipping Database Changes–T-SQL Tuesday #90

This is a good T-SQL Tuesday topic from James Anderson: shipping database changes. It’s especially poignant for me since I talk and present often on this topic. Much of my work at Redgate involves helping people implement DevOps for Databases, deploying changes smoothly and efficiently to databases.

I’ve got… Read more

0 comments, 911 reads

Posted in The Voice of the DBA on 9 May 2017

Copy-SqlJob, a handy dbatools cmdlet

One of the things I’ve often needed to do is move jobs around between instances of SQL Server. I’ll often test a job on one instance, maybe run it for awhile to see if it’s a useful addition to my instance, and then deploy the same job to other instances.… Read more

0 comments, 1,370 reads

Posted in The Voice of the DBA on 8 May 2017

I’m on dbatools!

I made the front page of dbatools, as a part of the community that is supporting this project. Along with quite a few others, I’m happy to be there and doing my part to make SQL Server administration and scripting easier.

 

Maybe I’ll even write a cmdlet some… Read more

0 comments, 325 reads

Posted in The Voice of the DBA on 5 May 2017

Finding the Service Name–#SQLNewBlogger

Another post for me that is simple and hopefully serves as an example for people trying to get blogging as #SQLNewBloggers.

A quick one today, and this one I remembered without looking anything up.

I recently needed the service name to kill it for a test. I was… Read more

0 comments, 485 reads

Posted in The Voice of the DBA on 4 May 2017

How Can I Get Accepted to Speak at the PASS Summit?

There has been some discussion and concern over the changes to the speaker selection process for the PASS Summit. I’ve written some thoughts, as have others (Joey, Andy), but I was struck a bit by Eugene Meidiner’s post. In it, he asks, how can I… Read more

2 comments, 747 reads

Posted in The Voice of the DBA on 1 May 2017