-->
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: April 2017

GroupBy–Bringing DevOps to the Database

Today was my presentation in the April GroupBy conference lineup. I presented on DevOps and changing your database development to include more agile, DevOps, flexible development practices.

If you want to get the deck, the slides are here: BringingDevOpstotheDatabase.pptx.

The video is also up on the GroupBy Youtube channel Read more

2 comments, 978 reads

Posted in The Voice of the DBA on 28 April 2017

A Couple Weeks until VS Live–Austin

VS Live takes place in Austin on May 15-18, 2017. This is a great conference in a fun city. It’s a full stack event, with the change to learn about cloud computing, ALM/DevOps, SQL, and Visual Studio, all at the same event. You can move from room to room and… Read more

0 comments, 305 reads

Posted in The Voice of the DBA on 28 April 2017

Limiting the Max–#SQLNewBlogger

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

I was chatting with someone the other day about MAX() and how it can work within a set of rows, rather than across an entire result set. That’s… Read more

0 comments, 310 reads

Posted in The Voice of the DBA on 27 April 2017

Still time to enter the SQL Clone contest

You could win an Amazon Echo from Redgate. Our contest is still open for a few days, so post a comment on my blog and take your chances. I’ll be picking from the comments next week.


Filed under: Blog Tagged: Redgate, SQL Clone, syndicated

Read more

0 comments, 283 reads

Posted in The Voice of the DBA on 26 April 2017

DevOps Basics– git Cloning Repos

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

This continues my series on git, because I think it’s good to know what the command line is and how to use it.

Once you have git… Read more

1 comments, 344 reads

Posted in The Voice of the DBA on 21 April 2017

SQL Server on Linux (Ubuntu)–Updating from Early CTP

I’ve been testing the SQL Server on Linux for a long time. After the recent Microsoft Data Amp event, I saw the announcement for CTP-2. So I did what I’ve been doing for some time on my Ubuntu machine:

sudo apt-get update

sudo apt-get install mssql-server

However, I got… Read more

0 comments, 383 reads

Posted in The Voice of the DBA on 19 April 2017

Agent Phases in VSTS Deployment

VSTS (Visual Studio Team Services) continues to grow and change over time. It seems every few months I see some new features and changes, which are good and bad. Good in that usually things improve. Bad in that I get confused and lost at times, and sometimes have to re-acquaint… Read more

0 comments, 333 reads

Posted in The Voice of the DBA on 17 April 2017

Making VSTS Deployment Changes to Databases without Breaking Your Application

One of the things that I do a lot is demo changes to databases with CI/CD in a DevOps fashion. However, I also want to make some application changes to my sample app without breaking things. As a result, I’ve built a few ideas that work well for both situations.… Read more

0 comments, 329 reads

Posted in The Voice of the DBA on 17 April 2017

Upgrading VSTS Redgate Build Tasks

I’ve been putting it off, but in prepping for SQL Bits demos, I decided this was a good time to just upgrade my original build and release tasks on VSTS from v1 to v2 for the Redgate tasks.

The first step was to go into the marketplace and find the… Read more

0 comments, 243 reads

Posted in The Voice of the DBA on 11 April 2017

Margaritas and TexMex at VS Live

takes place in a few weeks and I’m excited. Austin is one of those cities I enjoy visiting, with a few friends, now a Redgate office, and some great good and drink. I’m hoping my wife will come along and we can enjoy a few days there.

However, I’ll… Read more

0 comments, 542 reads

Posted in The Voice of the DBA on 10 April 2017

Speaking at SQL Saturday #621–Silicon Valley

Once again I’m heading back to the Valley. I was accepted to speak at SQL Saturday #621 – Silicon Valley on April 22, 2017. This is one of the larger SQL Saturday events in the US and I enjoy visiting California, so I’m looking forward to the event.

I’ll be… Read more

1 comments, 366 reads

Posted in The Voice of the DBA on 7 April 2017

Laptop Cattle

I traveled to Cambridge recently for some meetings at Redgate Software and to attend SQL Bits. I arrived on Tuesday, worked a bit, and then came back to the office Wednesday for the SQL Clone launch (a success, by the way. Watch it. Now. Well, not now, but after this… Read more

3 comments, 373 reads

Posted in The Voice of the DBA on 6 April 2017

What’s Next for SQL Clone?

I think SQL Clone is a useful, handy product. It’s what I’ve needed in a number of organizations, or it’s what would have saved us (literally), $100,000s of dollars by avoiding larger SANs with snapshot technology. At one company, we actually bought a second six-figure SAN when our customer… Read more

0 comments, 369 reads

Posted in The Voice of the DBA on 5 April 2017

DevOps at VSLive–Austin

You can see me in May at VS Live in Austin, where I and many others will be talking DevOps. There are lots of sessions to choose from, including some all day pre-cons. If you work in multiple areas (data, development, ops), or want to get ideas about how… Read more

0 comments, 305 reads

Posted in The Voice of the DBA on 4 April 2017

The Foundry–Data Masking Research

For most of the time I’ve been working for Redgate, we’ve had some sort of R&D group that tries out new ideas. Over the years we’ve done this in a few ways, evolving things over time. I had the chance recently to meet with The Foundry, which is formally… Read more

0 comments, 241 reads

Posted in The Voice of the DBA on 4 April 2017

Good DevOps Books to Read

I was interviewed recently at DevOps.com talking about the database as a part of DevOps. As part of the interview, Alan Shimel asked me for a book recommendation. After that, I decided I should recommend a few books that I’ve read and think have helped me to understand DevOps.

Tl;Dr:… Read more

0 comments, 458 reads

Posted in The Voice of the DBA on 3 April 2017