-->
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: March 2018

Learning is Hard–March Goals Update

This is the third update for my goals for 2018. This is about 3 weeks after the last update, and it’s too soon. Not in time, but because I haven’t done a great job.

This was a busy month. March and April are prime volleyball season, so I’ve had… Read more

0 comments, 913 reads

Posted in The Voice of the DBA on 29 March 2018

Moving to AWS EC2

SQLServerCentral has been stuck in the past for some time, but we’ve finally decided to move. I’ve been asking for this, and it’s usually a resource issue. However, earlier this year we started to debate and examine the costs, and decided to pursue a move to EC2. We have other… Read more

1 comments, 1,395 reads

Posted in The Voice of the DBA on 28 March 2018

The 700 Milestone for SQL Saturday

This past weekend was SQL Saturday #700. Another milestone in the franchise of events, and I was glad to attend. This is my fifth or sixth Colorado Springs event, and everything ran great. The leadership has changed over the years, as has the structure and format, but attendance continues to… Read more

0 comments, 695 reads

Posted in The Voice of the DBA on 26 March 2018

Scripting Tables with dbatools

I really like the dbatools project. This is a series of PowerShell cmdlets that are built by the community and incredibly useful for migrations between SQL Servers, but also for various administrative actions. I have a short series on these items.

I’ve been experimenting with scripting some tables, and… Read more

0 comments, 1,383 reads

Posted in The Voice of the DBA on 23 March 2018

I learned about the order of logical operations #SQLNewBlogger

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

I had logic in a CS curriculum many years ago and I’ve worked with AND and OR statements for years. I’ve sometimes confused myself, but I usually ensure… Read more

6 comments, 2,572 reads

Posted in The Voice of the DBA on 22 March 2018

The 700 Milestone

I’ve watched various SQL Saturday milestones go by. I missed 100 in Brazil, but did manage to get to 200 in Philadelphia and 300 in Kansas City. 400 was in Torino, and I am sad about not making the effort to get there. 500 was Boston, but I had a… Read more

2 comments, 216 reads

Posted in The Voice of the DBA on 15 March 2018

The SQL Privacy Summit

This May 18th, Redgate is putting on a SQL Privacy Summit for people that are looking for solutions to help them comply with the GDPR regulations.  I’ll be heading over to participate, and I’m looking forward to hearing from customers and attendees about the challenges they’re facing.

The Details

Friday… Read more

0 comments, 1,192 reads

Posted in The Voice of the DBA on 14 March 2018

Powershell and Data Masking with SQL Provision

Just a quick post here after the PASS Marathon Webinar during which I talked about the GDPR effects around the world. In the talk, I demo’d SQL Provision, which is SQL Clone + Data Masker for SQL Server. Someone asked for the PoSh, so here it is.

# Connect…

Read more

0 comments, 830 reads

Posted in The Voice of the DBA on 13 March 2018

Looking Forward for T-SQL Tuesday #100

It’s T-SQL Tuesday #100. Amazing. I can’t believe this has been going for so many years. I’m proud that I had the chance to host the main archive site at tsqltuesday.com and host a few topics.

This month we return to the original founder, Adam Machanic, with the topic of… Read more

1 comments, 744 reads

Posted in The Voice of the DBA on 13 March 2018

Catch up on SQL in the City 2018–GDPR Edition

The videos for our SQL in the City 2018 broadcast from last month are up on the Redgate channel in a playlist. If you missed anything or would like to rewatch something, you can do it.

If you’ve got questions or comments, we’d love to hear from you.

Read more

0 comments, 348 reads

Posted in The Voice of the DBA on 8 March 2018

Learning Goals 2018–February Review

Better than month 1. Only XE this month.

My first week I got a reminder to spend some time on XE, so I watched a couple modules of Jonathan Kehayias’s Pluralsight course.  A lot of review, but I thought I’d start with the basics and Jon knows more about… Read more

0 comments, 327 reads

Posted in The Voice of the DBA on 7 March 2018

Packt $10 Sale

One sale today, my Getting Started with SQL Server 2016 Administration video. You can get this for $10 today, and it’s an introduction to an overview of what’s in SQL Server 2016, most of which applies to 2017 as well.

Covers basics of administration from install and configuration to security… Read more

2 comments, 291 reads

Posted in The Voice of the DBA on 6 March 2018

Table Internal Sync Rule–Substituting the Sync Column

I’ve been playing with Data Masker for SQL Server v6 and it’s an interesting product. I like the way it works, but I do find it a little challenging sometimes to figure out how to mask values. I’ve written a set of posts for different scenarios.

In a previous post Read more

0 comments, 325 reads

Posted in The Voice of the DBA on 6 March 2018

SSMS 17.4 Vulnerability Assessment

SSMS 17.5 is out as of February 2018, but the the Vulnerability Assessment (VA) was released in SSMS 7.4

It seems that the Microsoft tools team is trying to build us better tools that come with the platform. There are good third parties that build tools, such as my employer,… Read more

0 comments, 2,356 reads

Posted in The Voice of the DBA on 5 March 2018

Data Masker for SQL Server–Syncing Values Across Rows

I’ve been playing with Data Masker for SQL Server v6 and it’s an interesting product. I like the way it works, but I do find it a little challenging sometimes to figure out how to mask values. I’ve written a set of posts for different scenarios.

We had a customer… Read more

1 comments, 2,219 reads

Posted in The Voice of the DBA on 2 March 2018