-->
Click here to monitor SSC
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: September 2015

SQL Data Generator–Masking Production Data

I learned a new trick with SQL Data Generator that I wasn’t aware of previously. I think this is a good idea for masking some of that production data that you might not want developers to have.

Let’s start with a production table. In my case, I’ve created a Sandbox_Prod… Read more

2 comments, 3,072 reads

Posted in The Voice of the DBA on 30 September 2015

SQL Data Generator–Masking Production Data

I learned a new trick with SQL Data Generator that I wasn’t aware of previously. I think this is a good idea for masking some of that production data that you might not want developers to have.

Let’s start with a production table. In my case, I’ve created a Sandbox_Prod… Read more

2 comments, 369 reads

Posted in The Voice of the DBA on 30 September 2015

Congrats to Jen, Tim, Ryan, and Argenis

Last week we received the results of the PASS Board of Directors elections for 2015. Jen Stirrup and Tim Ford were re-elected to new terms. They’ve served for the past few years as members of the BOD. Ryan Adams was elected for the first time, and I supported his… Read more

0 comments, 306 reads

Posted in The Voice of the DBA on 29 September 2015

Congrats to Jen, Tim, Ryan, and Argenis

Last week we received the results of the PASS Board of Directors elections for 2015. Jen Stirrup and Tim Ford were re-elected to new terms. They’ve served for the past few years as members of the BOD. Ryan Adams was elected for the first time, and I supported his… Read more

0 comments, 496 reads

Posted in The Voice of the DBA on 29 September 2015

Exercism

I’ve been looking to work on my programming skills a bit and try some new languages. I’d like to grow my career in a few different ways, as well as investigate where some of the new languages and platforms might be useful for data analysis. As I’ve talked to some… Read more

0 comments, 497 reads

Posted in The Voice of the DBA on 28 September 2015

Exercism

I’ve been looking to work on my programming skills a bit and try some new languages. I’d like to grow my career in a few different ways, as well as investigate where some of the new languages and platforms might be useful for data analysis. As I’ve talked to some… Read more

0 comments, 221 reads

Posted in The Voice of the DBA on 28 September 2015

SQL Saturday as an Attendee

Last week I did something that many people have already done. However this was my first experience, and I really enjoyed it. We’ll see if I get to do it again.

I went to SQL Saturday #441 – Denver as an attendee. I hadn’t submitted to speak, but I spent… Read more

0 comments, 484 reads

Posted in The Voice of the DBA on 25 September 2015

Use SCOPE_IDENTITY()–SQLNewBlogger

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

I ran across a question on Facebook, of all places, the other day. Someone had asked a friend how to return a value from a procedure and assign… Read more

3 comments, 2,284 reads

Posted in The Voice of the DBA on 24 September 2015

Costumes at the PASS Summit

tl,dr; We’re raising money for Doctors without Borders. Donate and a few of us will dress up at the Summit. You don’t have to attend the Summit to have some fun here.

Last year a bunch of us agreed to get silly to raise money. We ended up getting over… Read more

0 comments, 421 reads

Posted in The Voice of the DBA on 22 September 2015

Simple Merges KDiff3 at SQL in the City

One of the hassles of working in a development team is that you will have conflicts between your code and another developer’s. That’s fine, and it’s a natural effect of allowing each person to work on parts of a database independently.

However resolving conflicts can be a pain. Fortunately there… Read more

0 comments, 675 reads

Posted in The Voice of the DBA on 21 September 2015

Custom Placeholders in SQL Prompt 7

I love my snippets in SQL Prompt. Adding some snippets can make work go so much quicker.  I add new ones all the time, based on the tasks I’m doing and I find that code can almost write itself.

SQL Prompt 7 was just released, and it added a… Read more

0 comments, 654 reads

Posted in The Voice of the DBA on 15 September 2015

Remember the N

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

I saw a post recently from someone that was having trouble with Chinese characters being inserted into a SQL Server table. I’m not sure if they were using… Read more

1 comments, 464 reads

Posted in The Voice of the DBA on 14 September 2015

Argenis and Ryan

It’s the time of the year when PASS holds its annual elections for the board of directors. This year we have four candidates for 3 slots: Jennifer Stirrup, Tim Ford, Argenis Fernandez and Ryan Adams. Jennifer and Tim have been serving on the board the last few years, with newcomers,… Read more

0 comments, 634 reads

Posted in The Voice of the DBA on 11 September 2015

Share Your Passion at Summit ‘15

Every Monday night on the week of the PASS Summit. Andy Warren and I host a networking dinner. This year we’re at the Yard House, and we’d love for you to come by if you don’t have plans Monday night. The event is from 6-9, but come early, come… Read more

0 comments, 453 reads

Posted in The Voice of the DBA on 10 September 2015

Custom Column in SQL Data Generator

One of the interesting things with Redgate’s SQL Data Generator (SDG) is that it allows the user of custom data patterns for your columns. The user of regular expressions (RegEx) is used, which is something I find many SQL Server DBAs don’t really work with often.

While there are plenty… Read more

0 comments, 1,402 reads

Posted in The Voice of the DBA on 9 September 2015

T-SQL Tuesday #70 – The Enterprise

It’s hard to believe this is the 70th edition of T-SQL Tuesday. I haven’t missed many, and I’ve enjoyed them all. I hope more of you are participating in this monthly blog party started by Adam Machanic (b / t). Whether you write today, or you write at… Read more

0 comments, 1,102 reads

Posted in The Voice of the DBA on 8 September 2015

How Many Times Will You Change a Password?

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

If you create a login and the user can’t log in, how many times will you change the password?

It turns out I’ll do it 5 times.

I… Read more

0 comments, 452 reads

Posted in The Voice of the DBA on 7 September 2015

Growing Pains for the Networking Dinner

A few years ago Andy Warren had this idea for a networking dinner. We had been chatting about all the parties and events at PASS, with many of them limited to select individuals. We talked about trying to get more people involved in the community and giving them something to… Read more

7 comments, 555 reads

Posted in The Voice of the DBA on 3 September 2015

Better Test Data Domains with SQL Data Generator

I’ve been working more with SQL Data Generator (SDG) because it solves some problems that many software developers have with test data. Often each developer needs to create their own set of test data, with these being the common actions:

  • Use a backup of production, perhaps old.
  • Randomly insert a…

Read more

0 comments, 661 reads

Posted in The Voice of the DBA on 1 September 2015