Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
Log in  ::  Register  ::  Not logged in

The Voice of the DBA

Steve Jones is the editor of 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

Execute the Current Statement–SQL Prompt

This is a great little feature in SQL Prompt that I wrote about at SQLServerCentral. It’s Current statement Execution, which comes about from pressing Shift+F5. Whatever statement the cursor is on, whether it’s a single line or multi-line, the statement will execute.

It can be on the first line: Read more

0 comments, 284 reads

Posted in The Voice of the DBA on 14 January 2015

T-SQL Tuesday #62 – Healthy SQL

The invitation for T-SQL Tuesday this month comes from Robert Pearl. It’s called HealthySQL and it’s a topic I like. I’ve spent a lot of time in my career being proactive with SQL Server databases, and keeping them healthy is important.

If you’d like to participate in the party, just… Read more

1 comments, 219 reads

Posted in The Voice of the DBA on 13 January 2015

It’s a Problem When a SysAdmin Can’t Log In

I showcased a demo recently that looked at a potential issue with an application where a user used a simple update statement to gain privileged access to a system. That’s scary, and it’s a potential issue for many applications that handle their own authentication.

The problem with this type of… Read more

0 comments, 5,933 reads

Posted in The Voice of the DBA on 12 January 2015

Building Connection Strings

I ran across a great article on Connection Strings from my good friend, Allen White (b, t, c), recently. Quite a few of the items he mentioned in there, I knew, but it was a good review to stop and think about how to actually connect… Read more

0 comments, 452 reads

Posted in The Voice of the DBA on 8 January 2015

Building Rollback Scripts with SQL Compare

There’s a neat switch in SQL Compare that lets you build rollback scripts. It looks like this:

I’ve used this before to help with deployments, as many of you have. The idea is that when you finish with your code in your dev environment, you run a comparison with production,… Read more

0 comments, 5,644 reads

Posted in The Voice of the DBA on 7 January 2015

Beware of Login Issues for Privileged Accounts

In a recent post, I described an attack against a privileged account using a simple SQL Injection technique of updating data in a table. One of the things showed was an administrator using their user and password credentials, but being unable to log on.

In this case, the administrator… Read more

0 comments, 248 reads

Posted in The Voice of the DBA on 5 January 2015

My 2015 Plan

I started this on Jan 1, but with family commitments, I ended up delaying it until today. I wrote about having a 2015 plan, and thought I should build one as well. I’ve tried a few things in the last couple years, and while I haven’t stuck to the… Read more

0 comments, 289 reads

Posted in The Voice of the DBA on 2 January 2015

Speaking Stats

I was updating my speaking schedule and CV, trying to get an idea of what might be planned for 2015. As I was doing so, I decided to do a quick count of events and talks to see where I was last year. Last year was tough, and I… Read more

0 comments, 226 reads

Posted in The Voice of the DBA on 30 December 2014

Powershell – Copy the Latest Backup

I got an email recently where someone asked me how they can refresh a dev environment with Powershell. I guess I’d written something about this in 2009, though that would have been for testing as Red Gate had already banned me from development on SQLServerCentral by that time.

I dug… Read more

5 comments, 5,483 reads

Posted in The Voice of the DBA on 29 December 2014

Quick Audio Switching

I’ve got a semi complicated desktop setup, with multiple monitors, lots of USB stuff, and a few ways to record and listen to sound. I hadn’t thought of things as complex, especially with regards to audio, but between recording podcasts, having regular video conferences, and the speakers I added to… Read more

0 comments, 250 reads

Posted in The Voice of the DBA on 19 December 2014

SQL Konferenz

I’ve spoken at lots of events, but all in the US and the UK. Next year I get my first talk outside of those locations, going to the SQL Server Konferenz near Frankfurt, Germany.

The agenda is up, and I’ll be talking testing and tSQLt there, and it’s cool to… Read more

1 comments, 255 reads

Posted in The Voice of the DBA on 17 December 2014

Load Balanced IIS Machines

I noticed a contest this week while working on the Database Weekly newsletter. It’s the Cloud Hero contest, with the chance to win a Surface Pro 3. I could always use another device, or at least a device I could give away, so I decided to enter.

There are… Read more

2 comments, 234 reads

Posted in The Voice of the DBA on 16 December 2014

RegEx Those Dates

Recently I was working on transforming some dates, and wanted to generate a large n number of dates for testing. I decided to use SQL Data Generator, and a little RegEx to meet my needs.

The format I needed was CYYMMDD, which is the century as a 0 or 1… Read more

0 comments, 711 reads

Posted in The Voice of the DBA on 15 December 2014

T-SQL Tricks – Trigger Your Memory

I was scanning Twitter the other day and saw a note from someone that they had written a query using an obscure T-SQL command and were glad it had worked. I exchanged a note with the person and they mentioned that they had to look up the command and syntax… Read more

1 comments, 7,133 reads

Posted in The Voice of the DBA on 11 December 2014

Converting Dates

I ran across a post recently where someone had dates stored as characters (never good), but also in this format: CYYMMDD. I’d never seen that, and thought it was strange. The person was asking for a way to convert this to YYYY-MM-DD, which I think it fairly easy.

Let’s set… Read more

0 comments, 272 reads

Posted in The Voice of the DBA on 10 December 2014

T-SQL Tuesday #61 – Giving Back

It’s that time of month again, the time when we have a day where everyone writes on the same topic.

This month Wayne Sheffield is the host and has chosen Giving Back as his theme. It’s a good one with the holidays and it’s one that really inspired SQLServerCentral. We… Read more

0 comments, 223 reads

Posted in The Voice of the DBA on 9 December 2014

SQL Server Disk Space Emergencies

One of the things I’ll see happen often with SQL Server instances is that the system will run out of space on a drive. This could be for a variety of reasons, some of which can be prevented, and some cannot. You might have:

  • Don’t delete old backup files
  • Data…

Read more

0 comments, 6,779 reads

Posted in The Voice of the DBA on 8 December 2014

SQL in the City 2014 – Washington DC

I’m off today, traveling to SQL in the City 2014 – Washington DC to meet Grant and deliver another database delivery seminar. We’ll be talking about Version Control, testing, continuous integration, and database delivery, and showing off some of the Red Gate tools that can make the process easier.

I… Read more

0 comments, 224 reads

Posted in The Voice of the DBA on 4 December 2014

SQL Injection Issues–Password Hashing

I’ve got a demo for one of my talks that really highlights some issues we have with SQL Injection. It’s part of my encryption talk, and it goes like this.

NOTE: I am showing a simple example here, not one that I would deploy into production. The concepts are similar,… Read more

5 comments, 549 reads

Posted in The Voice of the DBA on 4 December 2014

T-SQL Tricks – Customizing SSMS Templates with Parameters

I wrote briefly about templates in Management Studio (SSMS), and showed the default templates that come with SQL Server. I now want to customize some of the templates in a way that makes sense for me.

If I grab a script I use often, like this one, I can make… Read more

5 comments, 6,169 reads

Posted in The Voice of the DBA on 3 December 2014

Newer posts

Older posts