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: September 2009

Winding Down

I'm trying to finish up the last few things here at work before taking the weekend off. I scheduled off the next two days and plan on tiling my bathroom. Tia says it's not really time off, but it's a good project, it's mindless (relatively), I've been wanting to do… Read more

0 comments, 555 reads

Posted in The Voice of the DBA on 30 September 2009

Heading Down to the Basement

I'm taking the next two days off, heading down into the basement for a four day weekend. Nothing particular going on, just a little stressed with life. Between work here and a busy life with kids, I realized a few weeks ago that I was feeling stressed. So I decided… Read more

0 comments, 565 reads

Posted in The Voice of the DBA on 30 September 2009

Temp tables and scope

create table MyTable (id int)
go
Create Table #Test (id int)
go
create proc MyProc
@id int
as
insert MyTable select @id
insert #test select @id
return
go
exec MyProc 2
go
select * from #test
go
drop table MyTable
drop procedure MyProc


I saw a question recently about temp… Read more

2 comments, 635 reads

Posted in The Voice of the DBA on 29 September 2009

Storing the Sun's Energy - Solar Power

I stumbled on this article about a spin-off from MIT using solar power to create hydrogen. I think it's a great idea, one that I'd like to have working in my house, but it's not as simple as having a storage tank and a solar panel.

To me this… Read more

2 comments, 397 reads

Posted in The Voice of the DBA on 28 September 2009

Back From Vacation and Making a Big Mistake

I actually got back from camping Sat night, but since I wasn’t scheduled to come back until Sun afternoon, I avoided the computer. I let both the desktop and laptop remain at idle, not even checking personal email until Sun night.

When I checked Sun night, I saw a newsletter… Read more

0 comments, 218 reads

Posted in The Voice of the DBA on 28 September 2009

Out of Space

It seems that often I see posts that say “I’m out of space on my drive, what do I do?” The answer, as with most anything in SQL Server is, it depends.

Backups

The most common issue I see for running out of space is the lack of deleting database… Read more

2 comments, 640 reads

Posted in The Voice of the DBA on 28 September 2009

It's the interaction

This is a great write-up that shows what is important in a phone. It's how you interact with it, not the features, not the specs, it's how you use it.

I tend to agree with that. With both the G1 and the iPhone, the interaction with the device for the… Read more

0 comments, 233 reads

Posted in The Voice of the DBA on 25 September 2009

Chroma Key - Podcasting Tips

I've been wanting to play with the Chroma Key features of my video editing, but I haven't really spent time on it. Today was the day that I tried it, and it worked out pretty good.

With snow coming down outside, I needed to shoot in the basement. I have… Read more

2 comments, 1,081 reads

Posted in The Voice of the DBA on 25 September 2009

The last good date for your database

I was reading the most recent issue of TechNet from Microsoft one morning and flipped through the column on SQL Server. This is one of the few paper magazines I get, and for some reason I see things in there that interest me.

It’s not the topics, but often the… Read more

4 comments, 506 reads

Posted in The Voice of the DBA on 24 September 2009

Fun with Firewalls

We have a couple of boxes at a local Denver co-location facility for the training business, SQL Share. Our firewall died a few weeks ago, and so I called a friend that I've typically used for network stuff. He found us one on eBay for $200 and last night… Read more

0 comments, 360 reads

Posted in The Voice of the DBA on 23 September 2009

Searching for Data in Images

I tried out Bing’s new visual search after seeing a few people note it on Twitter. I was a little excited to try it, thinking that it might help me to find images for the editorials easier.

It didn’t, and I was disappointed. I thought that this short review… Read more

4 comments, 334 reads

Posted in The Voice of the DBA on 22 September 2009

Built In Alerts

The more I think about this, the more I think it should be built into SQL Server as a default. Why not ask for the information to create an operator and email at install and then create a few nice default alerts, like one for which log is full Read more

0 comments, 292 reads

Posted in The Voice of the DBA on 21 September 2009

Prepping for SQL Connections in Las Vegas

I started watching Leverage this season, after it was recommended by Wil Wheaton (blog/twitter). For those of you that don't know Wil, he is an actor and writer, best known by me for playing Wesley Crusher on Star Trek: The Next Generation. I had been working… Read more

3 comments, 360 reads

Posted in The Voice of the DBA on 18 September 2009

Cleaning the Keyboard

I noticed that the keys on my laptop were pretty dirty the other day. The heavily used ones have a nice brown stain in places, mostly from just skin oils, and normally I don't notice them, but it bugged me one afternoon, so I wanted to clean them.

How do… Read more

3 comments, 287 reads

Posted in The Voice of the DBA on 17 September 2009

Nice Quote

Business conventions are important because they demonstrate how many people a company can operate without.

Since I got to so many, perhaps I'm not that valuable? Read more

3 comments, 227 reads

Posted in The Voice of the DBA on 16 September 2009

What's Your Build

This would probably be a good editorial, but I thought I'd drop it out here as a short note.

You ought to be tracking the build (or version) of all your SQL Server instances and Windows. I'd suggest you automate this, maybe even drop it in a table in every… Read more

0 comments, 312 reads

Posted in The Voice of the DBA on 16 September 2009

Car Update – Electric plug in survey and algae hybrids

The Prius is having a few issues. I’ve had a slow leak in a tire that required two trips to the tire guy to get fixed. It wasn’t so bad since I had to get an oil change as well. I combined a few trips and things worked out well. Read more

7 comments, 582 reads

Posted in The Voice of the DBA on 15 September 2009

Denver Area SQL Server User Group Week

All the Denver area groups are having their meetings this week. If you're in the area, try to attend a meeting. You'll meet some great people and learn a few things.

Read more

0 comments, 280 reads

Posted in The Voice of the DBA on 14 September 2009

The Resource Database

I saw a post recently that asked about backing up the Resource database. The person said they just realized that it wasn't included in their backup scheme and was worried.\

Don't worry, you don't need to back it up.

The page at MSDN describes the Resource database as essentially a… Read more

2 comments, 332 reads

Posted in The Voice of the DBA on 14 September 2009

I like this

Not everything that can be counted counts, and not everything that counts can be counted. - Albert Einstein

from 37 signals blog. Read more

0 comments, 322 reads

Posted in The Voice of the DBA on 11 September 2009

Older posts