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

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, 418 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, 321 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, 251 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, 510 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, 320 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, 553 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, 458 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, 415 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, 859 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,220 reads

Posted in The Voice of the DBA on 22 March 2017

Building a Database DevOps Process at the Data Platform Summit 2017

I’m heading to India this August for the Data Platform Summit 2017. I am honored to have been selected to deliver a pre-conference seminar called “Building a Database DevOps Process”, where I’ll walk through the way in which you can include your database alongside application code and deploy it… Read more

2 comments, 405 reads

Posted in The Voice of the DBA on 21 March 2017

SQL Bits in less than a month

I’m getting excited, and you should as well. Join me at a fantastic conference in the UK this spring. Register today and come to a training day and learn something. I might just see you there, as I’m thinking to take one or two myself.

I’ll be presenting “Including Your… Read more

0 comments, 286 reads

Posted in The Voice of the DBA on 17 March 2017

Global v Session Trace Flags

I wrote a short article on enabling and disabling trace flags. You can read it, but I didn’t really discuss the implications of session v global trace flags, which is something I’d like to do here.

In the article, I set trace flag 3226 for my session. This showed… Read more

0 comments, 1,517 reads

Posted in The Voice of the DBA on 16 March 2017

Create a BACPAC–#SQLNewBlogger

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 that you might encounter at some point is the need to create a BACPAC. This is essentially a DACPAC with data included. There… Read more

1 comments, 261 reads

Posted in The Voice of the DBA on 15 March 2017

The Livestream Product Launch

SQL in the City Streamed in 2016 was a success, with lots of feedback that people enjoyed the sessions and format. With the release of SQL Clone, we’ve decided to do it again.

The SQL Clone Product Launch Live Stream is coming in a couple weeks, on Mar 29,… Read more

0 comments, 431 reads

Posted in The Voice of the DBA on 15 March 2017

T-SQL Tuesday #88 – WTF

It’s T-SQL Tuesday time again, and this is a good one. The host this month is Kennie Pontoppidan, who I had the pleasure of running with one morning in Copenhagen. His theme is The daily (database-related) WTF.

You can read about T-SQL Tuesday at tsqltuesday.com and see all… Read more

0 comments, 578 reads

Posted in The Voice of the DBA on 14 March 2017

Using tSQLt to Find Min/Max Times

I love tSQLt. It’s a good way to write tests that can determine if your code is actually working. Since I’m a fan of unit testing, I think using tests to verify your logic is great. What’s excellent with tSQLt is that I can verify a number of cases at… Read more

0 comments, 770 reads

Posted in The Voice of the DBA on 13 March 2017

Create a DACPAC to Move Databases–#SQLNewBlogger

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

In my last post, I talked about what a DACPAC was. Now let’s create one. This turns out to be about as simple as it could be.… Read more

1 comments, 498 reads

Posted in The Voice of the DBA on 8 March 2017

The $650 SQL Saturday

SQL Saturday #596 – Denver BI Edition was held on Feb 25, 2017. In keeping with my idea for a slimmer SQL Saturday, we ran this event for a total of $650. It’s not quite the $500 that Andy Warren challenged me to stick to, but it’s close.

We could… Read more

6 comments, 1,952 reads

Posted in The Voice of the DBA on 7 March 2017

Dots, Skills, and SQL Clone: A Contest from Redgate

Redgate just launched SQL Clone, a new product that can provision copies of databases in seconds. By copies, I mean full sized, up to 2TB copies of your database, each separate and isolated, and built in seconds. What’s even more amazing is that each of these copies takes just… Read more

10 comments, 1,077 reads

Posted in The Voice of the DBA on 6 March 2017

Newer posts

Older posts