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: April 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, 1,370 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, 3,514 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, 1,426 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, 638 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, 742 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, 2,722 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, 652 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, 3,636 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, 614 reads

Posted in The Voice of the DBA on 16 April 2014

An Open Letter to Brogrammers

It’s not in the language I would write it in and it’s not necessarily safe for work, but it gets the point across.

An Open Letter to Brogrammers

One reason I do support Women in Technology, and other groups opposing discrimination. Apart from it’s poor behavior, it’s often just not… Read more

0 comments, 778 reads

Posted in The Voice of the DBA on 11 April 2014

Vote for me at SQLBits

SQL Bits XII is coming this July to Telford in the UK and voting is underway for sessions. I’ve submitted a few and am hoping to get accepted to go back. You can help.

You can log into the site and vote for the sessions you’d like to see. I’d… Read more

0 comments, 813 reads

Posted in The Voice of the DBA on 9 April 2014

T-SQL Tuesday #53–Why So Serious?

It’s an interesting topic this month for T-SQL Tuesday #53. When I read Matt Velic’s invitation, I became intrigued. I like jokes. I like messing with people, and I was thinking about the recent April Fool’s jokes I’d written and those in the past that have been fun. I’m… Read more

0 comments, 809 reads

Posted in The Voice of the DBA on 8 April 2014

One week to SQL Intersection

You still have time to grab the boss and convince him to invest in you. Show what you’ve learned in the last year. Tell him or her how some training you’ve taken, perhaps at a SQL Saturday, helped you at work. Make a good case to attend, and perhaps I’ll… Read more

0 comments, 731 reads

Posted in The Voice of the DBA on 8 April 2014

Don’t Be an Arse

In deference to my British employers, I’ll use their word.

It constantly strikes me how rude, stupid, and unfriendly people can be on the Internet. I’ve been trying to avoid even reading comments on many places, including Facebook because I’m struck by how people behave. I haven’t completely succeeded and… Read more

0 comments, 968 reads

Posted in The Voice of the DBA on 4 April 2014

Great Companies – Spotify

I don’t know anyone at Spotify, nor have I worked there. However when I see descriptions and explanations like this one of how they organize and build their culture, it makes me think they’re doing it right.

Autonomy is important, and it helps motivate people. I need to do more… Read more

0 comments, 686 reads

Posted in The Voice of the DBA on 4 April 2014

Three Days to the first Nevada SQL Saturday

It’s three days to the first SQL Saturday in Nevada, taking place this Saturday in Las Vegas. I’m looking forward to going, meeting new people, and seeing lots of friends. The speaker lineup is amazing and you can see them all for FREE.

Just register and make your way… Read more

0 comments, 651 reads

Posted in The Voice of the DBA on 2 April 2014

Oracle, MySQL, and MongoDB Come to SQLServerCentral

We’re in for a name change. As of May 1, we’ll be welcoming the Oracle and MySQL communities to SQLServerCentral. Our daily content will grow to include articles and questions about these platforms as we look to become more inclusive to the large numbers of data professionals that work on… Read more

0 comments, 977 reads

Posted in The Voice of the DBA on 1 April 2014