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

FileTable– Using GetParent for Inserts

In a previous post, I looked at the ways in which I could insert files into a Filetable folder programmatically. I used a NEWID() generation process, which mimics the constraint that is coded in the Filetable schema. However there was a comment asking if I could, or rather would, use… Read more

0 comments, 184 reads

Posted in The Voice of the DBA on 19 May 2014

Powershell Tips–PSEdit

I got this from watching a session from Jeffrey Snover at TechEd. It was a neat trick, and it’s worked better than what I used to do.

Editing files

Suppose I have the ISE open and I want to edit a file. I could easily do this:

Click File –>… Read more

0 comments, 312 reads

Posted in The Voice of the DBA on 15 May 2014

Quick Tips–SQL Prompt Formatting

I love SQL Prompt, and think it’s a great productivity tool. Even before I worked at Red Gate, I love the tool and had a copy before Red Gate bought the technology from the original developer. Recently I’ve run into a few people that weren’t aware of some of… Read more

7 comments, 1,811 reads

Posted in The Voice of the DBA on 14 May 2014

T-SQL Tuesday #54–Interviews and Hiring

It’s the May T-SQL Tuesday, and this time it’s a great one. This month the host is Boris Hristov (@BorisHristov) and his topic is one that’s near and dear to me. He’s asking about interviews and hiring, and I have a lot to say on this… Read more

5 comments, 266 reads

Posted in The Voice of the DBA on 13 May 2014

Filetable–Nesting folders and files

In previous posts I showed how to create a folder in a Filetable and also how to the create (and move) files into the subfolder. However I didn’t repeat that and wanted to test the ability to actually nest things further. With that in mind, I’m going to take this… Read more

0 comments, 176 reads

Posted in The Voice of the DBA on 12 May 2014

Getting Local Books Online

One of the things that’s annoyed me in the last few versions is that Books Online isn’t smoothly installed for me. I often seem to forget to run through the process, and I’ll find myself on an airplane without being able to check documentation. It’s frustrating and while I’ve muddled… Read more

0 comments, 179 reads

Posted in The Voice of the DBA on 8 May 2014

Secure Coding

I was looking recently for some sort of guideline that would help me ensure that code was securely written. I stumbled upon the CERT standards, of which there are few, but one that seemed interesting was this one on Oracle and Java. I thought this first standard was a… Read more

0 comments, 168 reads

Posted in The Voice of the DBA on 7 May 2014

Filetable–Moving files programmatically

I’ve been playing with Filetable and I was asked an interesting question. Can I move files to a folder programmatically?

It’s trivial to do this in Explorer. Just drag and drop, and I’d expect that most people using Filetable from the client side would do this. I’d even expect that… Read more

0 comments, 188 reads

Posted in The Voice of the DBA on 6 May 2014

Sabbatical Decisions

My employer, Red Gate Software, offers a sabbatical to their employees, and this year I’m taking mine. I’ll be gone from June 2 – July 14, away from work, but I’ll be blogging here about my experience.

I wrote before that I had a sabbatical coming from Red Gate… Read more

1 comments, 330 reads

Posted in The Voice of the DBA on 2 May 2014

Continuous Delivery Visualization

A good one, one of the better diagrams I’ve seen.


Now if we can get tooling and processes to make this work reliably for databases.

Filed under: Blog Tagged: continuous delivery, software development, syndicated

Read more

0 comments, 189 reads

Posted in The Voice of the DBA on 1 May 2014

Speaking at Connections

I just got my acceptance to the DevConnections, SQLConnections in September for two sessions:

  • Continuous Integration for Databases
  • Maintaining High Performance When Using Encryption

I enjoy the Connections events, usually finding time to go check out an ASP.NET or developer session of some sort.

Now’s the time to register and… Read more

0 comments, 142 reads

Posted in The Voice of the DBA on 30 April 2014

The Cardinality Estimator in SQL Server 2014 – Going Forward and Backward

I saw a talk from Joe Sack (b | t) on the cardinality estimator (CE) in SQL Server 2014 and found it very interesting. To be fair, some of the "how it works" isn’t something I care about much, but I did like Joe sharing some places in… Read more

0 comments, 1,559 reads

Posted in The Voice of the DBA on 30 April 2014

Back to Work

After surgery Fri am, I’ve been mostly taking it easy, but now it’s back to work. Got kids to school and at the standing desk. Overall I feel good and can walk fairly normal. Other than this big brace on my leg that slows me down and makes walking funny.… Read more

0 comments, 167 reads

Posted in The Voice of the DBA on 29 April 2014

Out for a day

I’m hoping I’m only out for a day. As I write this, I’ll be recovering from my ACL surgery, though hopefully only slightly limited in work.

We’ll see. I’ve learned to hope for the best, but plan for the worst, and as a result, I decided to take Monday… Read more

0 comments, 167 reads

Posted in The Voice of the DBA on 25 April 2014

The Powershell Challenge Update

I’ve fallen down on my challenge over the last month. It’s been a content time, with me working more towards presentations and writing most of Mar and April to meet deadlines and commitments. I also let my calendar reminder die in Feb and didn’t renew it.

As a result, here… Read more

1 comments, 164 reads

Posted in The Voice of the DBA on 22 April 2014

FileTables–Inserting Directories from T-SQL

Creating a directory in a Filetable share is easy. It looks like this:

It’s hard to see, but this was a right click, New, Folder in the share from Windows Explorer.

However what about creating a directory from T-SQL? That’s almost as easy.

I created that folder above by running… Read more

0 comments, 1,847 reads

Posted in The Voice of the DBA on 21 April 2014

Speaking at SQL Bits XII

I’m heading back to SQL Bits for the third time and I’m excited to be going again. I think that this is my favorite conference, hands down. The large mix of people, the incredibly welcoming hosts and the casual atmosphere make this one of the events I look forward to… Read more

2 comments, 173 reads

Posted in The Voice of the DBA on 18 April 2014

FileTable–Adding a file to a folder

At my Filestream/Filetable talk yesterday at SQL Intersection, someone asked me about programmatically adding a file to a Filetable. Easy enough, I thought, since I’d seen someone do this in .NET and was thinking this has to be simple. Turns out it’s not quite so simple.

I was assuming that… Read more

2 comments, 1,264 reads

Posted in The Voice of the DBA on 16 April 2014

Nothing Scheduled

As of right now, my United account has no flights booked. My Hilton Honors account has no hotel rooms reserved. My National account has no car rentals to pick up.

And I have nothing scheduled for the rest of 2014.

For now. I suspect things will change soon, but… Read more

0 comments, 160 reads

Posted in The Voice of the DBA on 16 April 2014

Newer posts

Older posts