-->
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: February 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, 766 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, 386 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, 292 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, 708 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, 521 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,361 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, 321 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, 815 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,855 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, 2,087 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, 352 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, 399 reads

Posted in The Voice of the DBA on 1 February 2018