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

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, 693 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, 659 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, 252 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, 240 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, 209 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, 211 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,111 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,006 reads

Posted in The Voice of the DBA on 2 March 2018

SQL in the City is Live

You can watch on YouTube now: https://www.youtube.com/watch?v=0qyMutBkZsg

If you want slides and notifications, register on the Redgate hub.

We’re recording the sessions and they’ll be available whenever you have time to watch, but join us today. We’re live.

The keynote is done, with more sessions to come today.

Read more

0 comments, 598 reads

Posted in The Voice of the DBA on 28 February 2018

Typing Alternative Characters

I tend to work in the US English world. I’m somewhat embarrassed to note that I really only know one language and most of my work has been with US centric industries. I’ve rarely had the need to deal with Unicode and most of my databases have used varchar() everywhere.… Read more

1 comments, 218 reads

Posted in The Voice of the DBA on 27 February 2018

Off to SQL in the City 2018

I’m off today on a plane, flying to the UK for this Wednesday’s SQL in the City broadcast. This is our first event of 2018, and I’m excited. We’ll be talking GDPR and security, not the most exciting of topics, but we also have some cool new products to… Read more

0 comments, 196 reads

Posted in The Voice of the DBA on 26 February 2018

Classifying Data with SSMS 17.5

I upgraded SSMS to 17.5 recently and found an interesting addition. This version has incorporated the ability to classify data. With the GDPR coming for many of us, this is a welcome addition.

This is a quick look at this feature.

Classify a Database

If I select a database and… Read more

4 comments, 353 reads

Posted in The Voice of the DBA on 20 February 2018

dbatools and Orphaned Users

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.

One of the common issues that I would… Read more

1 comments, 343 reads

Posted in The Voice of the DBA on 16 February 2018

Enabling Guest in a Database–#SQLNewBlogger

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

The guest account exists in all your databases. This is installed by default, and guest is used to map a login that doesn’t otherwise have access to a… Read more

0 comments, 1,243 reads

Posted in The Voice of the DBA on 15 February 2018

Join me for Masking, Privacy, Protection, and Clones at SQL in the City Feb 28

Registration is open for SQL in the City 2018. Our first event is Feb 28 and I’ll be heading back to the UK for the event. This time Grant and Kathi will be there and we’ll be joined by the amazing Ike Ellis. This is an event… Read more

0 comments, 242 reads

Posted in The Voice of the DBA on 14 February 2018

Migrating MySQL Databases

A little out of my area, but I need to move the tsqltuesday.com database to a new service. The company running the db decided that they don’t want to keep a lower level consumer type tier. Since their minimum plan is now $20/month, I decided to look elsewhere. My first… Read more

0 comments, 699 reads

Posted in The Voice of the DBA on 12 February 2018

Moving Lookup Data with ReadyRoll

I’ve been using ReadyRoll for a small project and wanted to move some lookup data. There are some tables where I want to keep data in sync across environments, so if my build and release pipeline can do this, great. ReadyRoll makes this easy, and this is a short post… Read more

0 comments, 1,728 reads

Posted in The Voice of the DBA on 8 February 2018

Getting Your SET Options

Have you ever used @@options? I haven’t typically needed this, but there are times that you might wonder what options are set for a session. You can check in SSMS, look for defaults, etc., but there’s an easy way.

SELECT @@OPTIONS

This uses the @@options function, which contains a… Read more

3 comments, 1,957 reads

Posted in The Voice of the DBA on 6 February 2018

Learning Goals–January Review

In December I participated in T-SQL Tuesday #97 and wrote a post about 2018 goals. I promptly spent two weeks out of the country and then a relaxing holiday season. Actually, holidays extended slightly with a ski trip and a wedding in January.

This is a look back at… Read more

0 comments, 266 reads

Posted in The Voice of the DBA on 5 February 2018

Summit 2018 Program Survey

PASS has a survey out asking for your thoughts on the  2018 content. Take a few minutes and fill it out, and maybe you’ll win a registration.

Read more

0 comments, 312 reads

Posted in The Voice of the DBA on 1 February 2018

Newer posts

Older posts