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

Off on Holiday

Another break for me. This might actually be the first year I use all my vacation allowance.

In any case, I’m going to be gone for two weeks from work. Likely I won’t do any email or respond to anything, so if you’re looking for me, wait until then.

Read more

1 comments, 16 reads

Posted in The Voice of the DBA on 23 July 2018

Silly Photos at Work

Someone I stumbled across this picture of @brento on my drive.

This might be the best one:

And this was a good time:

However, I have a collection of silly moments. Enjoy.

Read more

0 comments, 142 reads

Posted in The Voice of the DBA on 20 July 2018

My #SQLCareer Day–July 19

I’ve asked for #SQLCareer posts, and I haven’t done any. My job isn’t a data platform DBA or developer, but it is SQL related, so a glimpse of the nonsense I perform. I’m asking for more posts, so a note at the bottom.

This should have been a cool day,… Read more

1 comments, 260 reads

Posted in The Voice of the DBA on 20 July 2018

Data Masker for SQL Server and Temporal Tables

A customer had a question recently about using Data Masker for SQL Server and temporal (or system versioned) tables. I decided to make a quick demo that will show how this works.

This is a simple demo, using just a few changes, but the concepts are useful for larger systems. Read more

0 comments, 632 reads

Posted in The Voice of the DBA on 18 July 2018

Is this a SQL Provision Cloned Database?

As I work with SQL Provision, I keep finding new questions and concerns from clients and customers. Recently I had someone wonder if we could determine whether or not a database on which they were working was a SQL Clone cloned copy.

You can, and it’s easy to check.… Read more

0 comments, 536 reads

Posted in The Voice of the DBA on 18 July 2018

Working Hard in Baton Rouge

I’m heading back to Baton Rouge for SQL Saturday #749 this August. This is one of the largest SQL Saturdays in the US, and one I really enjoy. I’ve been there 5 or 6 times, and I was honored to be selected again.

But they’re working me. The schedule is… Read more

0 comments, 288 reads

Posted in The Voice of the DBA on 18 July 2018

The Figleaf Data Masking Beta

I’ve been using the Redgate Software Data Masker for SQL Server in a number of situations to help customers. This is a tool we purchased in 2017 and is a part of the SQL Provision bundle to make building safe, secure dev and test databases.

Project Figleaf is the next… Read more

0 comments, 151 reads

Posted in The Voice of the DBA on 17 July 2018

Solving Ken’s FizzBuzz 3D–#SQLNewBlogger

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

I like the FizzBuzz test. It’s cute and fun, and I’ve had my kids solve it, just to think about what it means to structure a simple problem.… Read more

2 comments, 188 reads

Posted in The Voice of the DBA on 16 July 2018

Back to #SQLSat Louisville

Next week is SQL Saturday #729 – Lousiville and I’m making the trip. This will be my third or fourth trip there, and I’m looking forward to the trip. It’s a nice town, I can visit some family, and lots of #sqlfamily friends will be there.

This is the 10th… Read more

0 comments, 245 reads

Posted in The Voice of the DBA on 12 July 2018

Finding Inconsistent Key Values–#SQLNewBlogger

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

I was reading Iris Classon’s blog recently and ran across a post on her day at work. I think it’s a fantastic post that does help younger… Read more

0 comments, 1,586 reads

Posted in The Voice of the DBA on 11 July 2018

Code I Can’t Live Without–T-SQL Tuesday #104

Bert Wagner has a good invitation this month, a T-SQL Tuesday question about code, specifically code you can’t live without. I’ve got my thoughts below.

This is a monthly blog party, and you can participate. Write a post on this topic, and publish it on your blog. Drop a comment… Read more

0 comments, 2,943 reads

Posted in The Voice of the DBA on 10 July 2018

Another MVP Award and a Few Thoughts

I got the news of my MVP award last week. I’m honored that Microsoft feels I do quite a bit for the community. This was my 10th or 11th, though I’m not sure since they changed around the award periods. In any case, it’s been a long time.

As I… Read more

0 comments, 206 reads

Posted in The Voice of the DBA on 9 July 2018

Setting Up Pi-Hole.Net

I saw a tweet a short time ago from Drew Furgiuele about pi-hole.net. He noted this was a near use of a Raspberry Pi, and I wanted to give it a try. I got one awhile ago, and used it for a few things. We started with a media streaming… Read more

4 comments, 216 reads

Posted in The Voice of the DBA on 6 July 2018

Testing BackBlaze Restores

The most important thing for a data guy is having a way to restore data. If security, performance, etc. are broken, those can be fixed is we have the data. If we don’t have data, does security matter? It’s important, but secondary.

When Crashplan stopped providing a multi computer setup,… Read more

8 comments, 2,026 reads

Posted in The Voice of the DBA on 5 July 2018

Updating VSTS to SQL Change Automation

We (Redgate) released SQL Change Automation a few weeks back. This is the first stage to implementing a combined toolset that works with both state/comparison development and migrations based development. The change updated both our migrations toolset (previously ReadyRoll) and our build/release cmdlets (DLM Automation) to SQL Change Automation (SCA). Read more

0 comments, 607 reads

Posted in The Voice of the DBA on 4 July 2018

Building Better Test Data on the Redgate Hub

I have a new piece published over at the Redgate Hub: Building Better Test Data with SQL Provision. Part of my job is helping people learn to use our products better, and provide not only solutions to issues, but also ideas that might help them think about new ways… Read more

0 comments, 594 reads

Posted in The Voice of the DBA on 3 July 2018

Mastering Index Tuning–Day 3

This is a short series of posts on the courses I took with Brent Ozar. I actually completed the courses in the past, but I wrote notes and wanted to revisit the way things went.

This post looks at the Mastering Index Tuning class. Other  posts are:

Read more

6 comments, 620 reads

Posted in The Voice of the DBA on 3 July 2018

Mastering Index Tuning–Day 2

This is a short series of posts on the courses I took with Brent Ozar. I actually completed the courses in the past, but I wrote notes and wanted to revisit the way things went.

This post looks at the Mastering Index Tuning class. Other  posts are:

Read more

3 comments, 781 reads

Posted in The Voice of the DBA on 2 July 2018

Cloud Backup Comparison

I used to use Crashplan. This was about $150 a year, but I could to 5 machines. I used to do 5. I had

  • My desktop
  • My wife’s laptop
  • My daughter’s laptop
  • My laptop
  • My son’s laptop

This changed as my boy decided he didn’t like his data with ours.… Read more

9 comments, 2,516 reads

Posted in The Voice of the DBA on 29 June 2018

Learning Goals –June 2018 Update

The June update for T-SQL Tuesday #97. I made a plan and it’s hard to stick to.

tl;dr – Very little done.

I traveled the first three weeks of June here and there. Two short trips from 1-2 and 8-10, then a long trip from 16-22 and holiday from… Read more

0 comments, 564 reads

Posted in The Voice of the DBA on 29 June 2018

Older posts