-->
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

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, 68 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, 124 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

0 comments, 225 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, 228 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, 186 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, 191 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, 164 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, 425 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, 259 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, 265 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, 277 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, 237 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, 181 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, 365 reads

Posted in The Voice of the DBA on 3 April 2017

Thoughts on PASS Summit Speaker Selection Changes

Recently the PASS Blog released some changes to the speaker selection process that have generated some commentary and thoughts from various people. I read Joey D’Antoni’s thoughts, Andy Leonard’s thoughts as well as various tweets and comments. I talked with a few people, and wanted to put out a… Read more

10 comments, 223 reads

Posted in The Voice of the DBA on 31 March 2017

Looking Back at the SQL Clone Launch(es)

Yesterday was the SQL Clone launch livestream from the Redgate office in Cambridge, UK. I flew over on Monday, along with Grant Fritchey, to help broadcast a few sessions about the product. I’ve been excited to see SQL Clone for a few years now, ever since I saw a POC… Read more

0 comments, 388 reads

Posted in The Voice of the DBA on 30 March 2017

Watch Your DataTypes in Aggregates–#SQLNewBlogger

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

I’ve got a database of NBA statistics with data like this for players. I downloaded a CSV and loaded it into SQL Server.

I decided to play… Read more

0 comments, 289 reads

Posted in The Voice of the DBA on 29 March 2017

Getting a VHD into Azure with PoSh

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

I thought this would make a nice SQLNewBlogger post, an easy get started one. I used the docs from Microsoft as a guide, so here’s how it… Read more

0 comments, 290 reads

Posted in The Voice of the DBA on 27 March 2017

TSQLTuesday.com – Quick WordPress Setup in Azure

When I agreed to host the T-SQL Tuesday site, I wasn’t sure what to do. I thought about just putting up a static page, one I’d edit, but in some conversations with Adam Machanic, he wanted to have a few people able to manage the site. That makes sense and… Read more

1 comments, 739 reads

Posted in The Voice of the DBA on 24 March 2017

Delete an Azure SQL Database from PowerShell

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

One of the things I’ve been working on is trying to get my DevOps, continuous delivery pipeline working with Azure. Part of that is a test deployment… Read more

0 comments, 1,003 reads

Posted in The Voice of the DBA on 22 March 2017

Older posts