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

Music City Data

I’ve never spoken in Tennessee. I’ve wanted to visit, but the I’ve only managed to drive through a part of the state or transfer in the airport. That changes at the end of this month.

Music City Tech, a three day conference consisting of Coding, Agile, and Data tracks,… Read more

0 comments, 182 reads

Posted in The Voice of the DBA on 17 May 2018

Reaching the Refactoring Redoubt with #SQLPrompt

I enjoy themes, and when I ran across the SQL Prompt Treasure Island, I had to take a few minutes and go through it. I wrote about Code Snippet Cove first, and this post finishes my movement around the map. The other items I’ve read about are:

Read more

0 comments, 133 reads

Posted in The Voice of the DBA on 14 May 2018

Finding Tabs in SSMS–#SQLNewBlogger

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

Someone posted this as a question and I thought it was worth noting. I use SQL Prompt for formatting, and never worry if there are tabs in code,… Read more

0 comments, 165 reads

Posted in The Voice of the DBA on 10 May 2018

First Wave of Sessions for PASSSummit Now Available

The first wave of sessions for the #PASSSummit have been released. You can see the list at: http://www.pass.org/summit/2018/Learn/ConferenceSessions.aspx

I am honored to have a session on the list. This year, I’ll be doing a session called Minimizing the Impact of Data Breaches in Dev and Test Databases. This is… Read more

0 comments, 754 reads

Posted in The Voice of the DBA on 9 May 2018

Relaxing on the Tab Management Terraces with #SQLPrompt

I enjoy themes, and when I ran across the SQL Prompt Treasure Island, I had to take a few minutes and go through it. I’ve written about a few of the other items on the map:

Read more

0 comments, 743 reads

Posted in The Voice of the DBA on 9 May 2018

T-SQL Tuesday #102–Getting Started

It’s time for another blog party, on the second Tuesday of the month. For this month’s T-SQL Tuesday, Riley Major has a couple of invites. One is on giving back, which is good, but doesn’t fit me. 

The second option is to explain how and why we got started, so… Read more

0 comments, 397 reads

Posted in The Voice of the DBA on 8 May 2018

Randomizing Names with Data Masker

Data Masker for SQL Server is pretty cool. It can reduce your attack surface area and exposure under the GDPR or any other regulation. There are plenty or rules and templates to help you anonymize data, in ways you might not have expected. Data Masker is a part of SQL… Read more

0 comments, 2,191 reads

Posted in The Voice of the DBA on 7 May 2018

Moving Birthdays with Data Masker

Data Masker for SQL Server is a fantastic product, and one that can reduce your attack surface area and exposure under the GDPR or any other regulation. There are plenty or rules and templates to help you anonymize data, in ways you might not have expected. It’s a part of… Read more

0 comments, 566 reads

Posted in The Voice of the DBA on 4 May 2018

Defining FKs in CREATE TABLE–#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 important things that a database developer can do is to define Foreign Keys (FK) at table creation. This is a good time to do this… Read more

2 comments, 2,536 reads

Posted in The Voice of the DBA on 3 May 2018