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 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: May 2010

Memorial Day

A holiday in the US, commemorating the men and women who have died in the service of our country.

Most years in the US, I’ve spent the day with family, starting summer, and while we remember those in the military, it’s primarily been a time where we spend time… Read more

2 comments, 551 reads

Posted in The Voice of the DBA on 31 May 2010

Auditing Failed Logins – SQL Server 2008

I wrote about setting up a basic server audit recently. That showed about how a server level audit is set up, but that’s a just a shell. The audit itself is just a container in which you can store various audited items. Like a SQL Server Agent job, it doesn’t…

Read more

1 comments, 1,769 reads

Posted in The Voice of the DBA on 28 May 2010

Adding Space to a Home Server

I got new drives for my Windows Home Server the other day and decided to add some space to the box. I don’t need the space so much as I’d like to be sure that I’m protected with some extra drives.

The first step, obviously, is to shut down the… Read more

2 comments, 365 reads

Posted in The Voice of the DBA on 27 May 2010

Reporting Services – Building the first report

One of my goals this year was to spend some time learning Reporting Services. Not necessarily do the 10,000 hours to become an expert, but perhaps the 100 hours or so Andy Warren mentioned in his Professional Development presentation.

I’ve done a little getting SSRS installed and running on… Read more

0 comments, 1,032 reads

Posted in The Voice of the DBA on 26 May 2010

Quick Audits of Schema Changes

I saw someone post a question recently about tracking down who deleted a stored procedure. I suggested the default trace, and linked to a beginner article on it.

However there was another post that had a better way to track things. In SSMS there’s a report that will help you: Read more

4 comments, 377 reads

Posted in The Voice of the DBA on 25 May 2010

Image Testing

One of the things I heard recently from someone was that they clicked some of the links in the newsletter and the front page, expecting to read some information, and got sent to an event instead. That was annoying, and I can understand that. I do try to put in… Read more

2 comments, 236 reads

Posted in The Voice of the DBA on 24 May 2010

Moving On

My oldest son graduates high school today. After a long journey, he’s the first of my wife’s and my three kids that is moving on. It’s a big day, and we have almost all our family in town to watch the first of our next generation becoming an adult.

I’m… Read more

1 comments, 246 reads

Posted in The Voice of the DBA on 21 May 2010

Holiday

A few days off, with family in town, so the blog will be quiet.

Read more

2 comments, 251 reads

Posted in The Voice of the DBA on 20 May 2010

It’s a Data World

I saw this blog about a report from CITA (wireless industry group) that people tend to use their cell phones more for data (text, email, etc.) than for phone calls.

I know that I do a lot more data, primarily through wi-fi, than I do phone calls on my phone.… Read more

0 comments, 281 reads

Posted in The Voice of the DBA on 19 May 2010

Will People Use This?

The cost of making a trip differently in the US, in terms of time, effort, and driving habits, is small. For any individual trip, I’m not sure how many people will change their habits. My wife doesn’t, and the Prius is great because she just drives and gets 40+mpg. I… Read more

3 comments, 337 reads

Posted in The Voice of the DBA on 18 May 2010

One Step Closer to Switching

I liked Android, I really did, and I thought my G1 was the best phone I’d had to date when I got it. I’ve had Motorolas, Nokias, Sidekicks, a Dash and another Windows Mobile, but out of the gate, the  G1 and Android was better. But there were 2 things… Read more

0 comments, 239 reads

Posted in The Voice of the DBA on 18 May 2010

24 Hours of PASS - The Sequel

Tomorrow kicks off the second 24 hours of PASS event. 24 consecutive 1 hour sessions presented around the globe by SQL Server professionals from all around the globe. These are video/audio webcasts that will start on 12GMT on May 19 and continue through 12GMT on May 20.

There’s a great… Read more

0 comments, 254 reads

Posted in The Voice of the DBA on 18 May 2010

Free ebooks

From Barnes and Noble. You can get them on a Nook, Blackberry, iPhone/Ipad, or PC. They are offering a few free titles to you with a coupon. You need to go to a B&N store to get the code, but you can get these titles:

  1. The No. 1 Ladies Detective…

Read more

0 comments, 390 reads

Posted in The Voice of the DBA on 17 May 2010

The Journeyman Certification

There has been quite a debate going on at SQLServerCentral about a DBA journeyman certification. There are a couple good writeups (part 1 and part 2), from Jason Brimhall on the cert, and I’m happy to note that SQLServerCentral, and Red Gate software, are happy to sponsor these… Read more

7 comments, 374 reads

Posted in The Voice of the DBA on 17 May 2010

Interviewed by Professional Development Virtual Chapter

Kathi Kellenburger, fellow MVP and friend, pinged me recently for an interview for the Professional Development Virtual Chapter. This is one of the groups at PASS that tries to focus on a specific area, as opposed to move chapter based user groups that are location based.

She interviewed me… Read more

2 comments, 652 reads

Posted in The Voice of the DBA on 14 May 2010

Live Writer - Paste from Visual Studio

This is a test of the plug in “Paste From Visual Studio”. I had this code sitting in SSMS and I did a CTRL+C to copy it to the clipboard. Then I clicked the “from Visual Studio shortcut that’s in my LiveWriter (image below) and this appeared.
ALTER…

Read more

5 comments, 249 reads

Posted in The Voice of the DBA on 13 May 2010

Formatting Code in LiveWriter

I was getting tired of pre-formatting code in LiveWriter. I love that software, but a couple of the technical things are a PIA. So after messing with this for weeks, hand fixing code blocks, I did the smart thing and Google’d for a plug in.

I found this one, Insert… Read more

3 comments, 265 reads

Posted in The Voice of the DBA on 13 May 2010

24 Hours of PASS - A Week Away

There’s still time to register for the 24 Hours of PASS, a series of 24 one-hour sessions being presented on May 19-20, 2010. There’s an amazing lineup of speakers, including:

  • Brian Knight
  • Kevin Cox of SQL CAT
  • Donald Farmer
  • Jessica Moss
  • Kevin Kline
  • and more!

I participated in… Read more

4 comments, 243 reads

Posted in The Voice of the DBA on 12 May 2010

Twitter is…

I think Twitter is a graffiti wall that emulates a series of hallway conversations near the world's largest food court.

Read more

3 comments, 267 reads

Posted in The Voice of the DBA on 11 May 2010

Put your left LOB in, put your left LOB out…

It’s time again for T-SQL Tuesday and this month the topic is LOB, or BLOB data. You can read more about T-QSL Tuesday in the entry above, and check out tSQL2sDay.com for the redirect.

For you older DBAs, this refers to text, ntext, and image data. For the youngsters,… Read more

4 comments, 730 reads

Posted in The Voice of the DBA on 11 May 2010

Older posts