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: February 2013

Attaching an MDF with no Log (AdventureWorks)

Attaching an MDF file without an LDF file can be a little tricky. I had to go through this recently when I downloaded the AdventureWorks2008R2 database, which was just an MDF file. I know I’ve done this before, but I had to stop and look things up, which means… Read more

1 comments, 1,964 reads

Posted in The Voice of the DBA on 27 February 2013

A Learning Experiment at SQL Saturday #187– Richmond

In a little over a week, SQL Saturday #187 takes place in Richmond, VA. I’m looking forward to going back as I attended school not too far from there (Charlottesville), and even worked on the West side of Richmond for a time. My brother lives in MD and my mother… Read more

2 comments, 1,141 reads

Posted in The Voice of the DBA on 25 February 2013

Speaking – Slide Design

I’m not sure I love this advice on slide design, but some of it makes sense. Much too often I see people putting lots of information on slide decks, as though readers will be studying the slides. I am working to reduce the amount of letters or “data” on… Read more

0 comments, 799 reads

Posted in The Voice of the DBA on 22 February 2013

Off to Redmond

Actually I’m off to Bellevue this week for the annual MVP Summit that Microsoft puts on each year. This is a conference, with over 1000 MVPs attending where we get the chance to hear presentations and interact with the developers in our particular areas. I’ll be in downtown Bellevue for… Read more

1 comments, 774 reads

Posted in The Voice of the DBA on 18 February 2013

Inserting Binary Data

There are a number of articles on dealing with the insertion of binary data into SQL Server using BULK INSERT, OPENROWSET, and even Java. However I saw someone asking recently how to insert data dynamically and thought that was an interesting question.

If you are working… Read more

1 comments, 8,467 reads

Posted in The Voice of the DBA on 17 February 2013

Home Power – Generators

A slightly off topic post, but since I was asked recently, I thought I’d take my reply, make a post and have it handy for people to refer to.

As technology people, electricity is important to us. Without it, we can’t get a lot done. I’ve lost power at work,… Read more

7 comments, 2,668 reads

Posted in The Voice of the DBA on 14 February 2013

T-SQL Tuesday #39 – PowerShell

This month the invitation is from Wayne Sheffield, asking if you have a PowerShell story for everyone. That’s fitting since Wayne is currently writing a month of PowerShell blogs, and they are worth reading.

The second Tuesday of each month is T-SQL Tuesday, with a new theme each month.… Read more

0 comments, 1,001 reads

Posted in The Voice of the DBA on 12 February 2013

SQL Saturday #183 Albuquerque – Wrap Up

This past weekend was the first SQL Saturday in New Mexico. I had written about our trip down last week, with a few fellow Coloradan’s that were speaking at the event. We drove to Taos on Thursday and stayed the night. Friday we skiied, and had a great time.… Read more

1 comments, 1,065 reads

Posted in The Voice of the DBA on 11 February 2013

I’m Speaking at ….

Last week I noted that I was speaking at the new SQL Intersection event. Hopefully I’ll see some of you there and get the chance to shake some hands.

As I was writing that post, I included a “I’ll be there” graphic, which I’ve included here as well. It… Read more

0 comments, 883 reads

Posted in The Voice of the DBA on 5 February 2013

SQL Intersection 2013 – Las Vegas in April

It’s not too hot, it can be fun, and after a full day of SQL Server learning, there are lots of things to do. I’m heading back to Las Vegas in April to speak at the new SQL Intersection event. It’s in conjunction with DevIntersection, and it’s at the… Read more

1 comments, 1,228 reads

Posted in The Voice of the DBA on 1 February 2013

Activating Windows 8 from MSDN

I installed Windows 8 recently and needed to activate it. I didn’t do this on the install since I didn’t have an Internet connection when I first set things up. This is a hardwired desktop, and I had to move it to my office to plug it in. However I… Read more

0 comments, 1,120 reads

Posted in The Voice of the DBA on 1 February 2013