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

SQL Source Control and Git–Getting Started

It seems as though Git is taking the world by storm as the Version Control System (VCS) of choice. TFS is widely used in the MS world, but Git is growing, Subversion is shrinking, as are most of the other platforms.

As a result, I wanted to do a quick… Read more

10 comments, 79 reads

Posted in The Voice of the DBA on 5 October 2015

SQL Source Control and Git–Getting Started

It seems as though Git is taking the world by storm as the Version Control System (VCS) of choice. TFS is widely used in the MS world, but Git is growing, Subversion is shrinking, as are most of the other platforms.

As a result, I wanted to do a quick… Read more

10 comments, 1,534 reads

Posted in The Voice of the DBA on 5 October 2015

Standing Desk Update

It’s been a long time since I wrote about my workspace, however I made a change recently. This was the "short term test" situation I set up a couple years ago:

After just using boxes for a few days, I decided I liked things and got monitor stands. However… Read more

1 comments, 262 reads

Posted in The Voice of the DBA on 2 October 2015

Standing Desk Update

It’s been a long time since I wrote about my workspace, however I made a change recently. This was the "short term test" situation I set up a couple years ago:

After just using boxes for a few days, I decided I liked things and got monitor stands. However… Read more

1 comments, 60 reads

Posted in The Voice of the DBA on 2 October 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, 102 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, 2,397 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, 258 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, 79 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, 52 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, 281 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, 327 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,029 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, 253 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, 400 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, 340 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, 270 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, 465 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, 285 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,118 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, 902 reads

Posted in The Voice of the DBA on 8 September 2015

Newer posts

Older posts