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

Quick MCM Prep Help

Before I went on vacation, I mentioned I was downloading some of the MCM videos from Technet.I had grabbed 4 or 5 before I left, dropping the MP3s on my iPhone, and I listened to a few of them on the drive to Steamboat Springs.

That worked out so…

Read more

1 comments, 640 reads

Posted in The Voice of the DBA on 31 December 2010

MCM Prep - VLF Allocations

I had heard that you could have too many VLFs in your transaction log, and it could cause performance issues. Kimberly Tripp has a great blog on how to get better performance from your log, but until I was studying for the MCM, I didn’t realize you could have… Read more

3 comments, 727 reads

Posted in The Voice of the DBA on 30 December 2010

Looking Back at 2010–Goal Review

I had 8 goals for 2010, which I posted at the end of last year. That reminds me, I need to work on goals for 2011

These were a variety of work, community, and professional goals that I set with, thinking that I would be able to achieve these… Read more

1 comments, 585 reads

Posted in The Voice of the DBA on 29 December 2010

Getting a Dedicated Admin Connection

Did you know you can easily get a Dedicated Admin Connection (DAC) in SSMS? I didn’t assuming that I’d need to use a command line and SQLCMD. However while studying for the MCM, I learned that there’s an easy way.

I tested this on a SQL Server 2008 instance, having… Read more

9 comments, 475 reads

Posted in The Voice of the DBA on 28 December 2010

Rebuilding my laptop

I finally got around to adding the new memory (16GB), removing the old 4GB and then replacing the DVD drive with an SSD. Now he hard part: rebuilding the machine.

In order to use the 16GB, and get VMs to run more smoothly, I need 64 bit Windows 7. I…

Read more

2 comments, 238 reads

Posted in The Voice of the DBA on 27 December 2010

The Twelve Days of (SQL) Christmas

Once upon a time a group of twelve bloggers agreed to each pick a post (or posts)  they found interesting from the previous year, blog about them, comment, and call attention to them. I was tapped to summarize things, and here we go.

On the twelfth day of Christmas Stuart… Read more

2 comments, 820 reads

Posted in The Voice of the DBA on 27 December 2010

The MCM Journey

I’m not really planning on getting the MCM. Perhaps I’ll change my mind, but it’s not the time for me to do it. I’m not consulting, and not planning on doing it anytime soon. If I studied enough to pass the lab, likely my skills would atrophy without some… Read more

7 comments, 272 reads

Posted in The Voice of the DBA on 27 December 2010

And the winners are….. (iPads for Christmas contest)

Congratulations to the following winners of our iPads for Christmas contest. It was a hard choice, but I ended up with these winners:

  • CC-597066
  • DataChomp
  • Scott Murray-240410
  • richardn-1128243
  • Michael Lysons
  • chris.cantley
  • Nick Van Dyk
  • barb.wendling
  • hghumphrey
  • MdApache

I had over a 100 entries to go through, and it  took some… Read more

7 comments, 442 reads

Posted in The Voice of the DBA on 20 December 2010

How not to ask for help

you can help me for the visule studio 2005 programe I have assigment
I do not how to use for these program
you can help me plase

That’s literally the text of an email that came to me at SQLServerCentral. Apart from the language barriers and issues, it is the… Read more

2 comments, 219 reads

Posted in The Voice of the DBA on 17 December 2010

T-SQL Tuesday #13 Roundup

After my call for “What the Business Says Is Not What the Business Wants”, there were quite a few people that responded. Including my blog post, I found 43 comments posted on with links back to the thoughts.

Here’s a quick summary, along with a short comment… Read more

2 comments, 350 reads

Posted in The Voice of the DBA on 17 December 2010

Denver SQL Server User Group Holiday Party

Tonight was the 2010 Denver SQL Server User group party. I typically haven’t done in the past to the holiday meetings since they aren’t usually well attended, and time is vey valuable. However this year the meeting was being held at a local bowling alley, and I decided to go. Read more

2 comments, 376 reads

Posted in The Voice of the DBA on 16 December 2010

Insert_Identity Permissions

Despite my joking with Aaron Bertrand on Twitter that his suggestion on Connect got voted down because he’s Canadian, I think he has a great point with a hole in Books Online. He wrote a nice blog on the item, and it’s one you ought to consider voting up… Read more

0 comments, 322 reads

Posted in The Voice of the DBA on 16 December 2010

Thanksgiving Bloopers

I'm slow to get this out, but I finally rendered the raw bloopers from November. Enjoy.


Part 1



Part 2


Part 3

Read more

0 comments, 429 reads

Posted in The Voice of the DBA on 15 December 2010

Busy Week

It’s going to be a busy week for me. At last count, I had over 40 comments for my T-SQL Tuesday party. Most of them are of a decent length, and I need to get through them all to write a summary.

I’m hoping to get it done for… Read more

3 comments, 251 reads

Posted in The Voice of the DBA on 14 December 2010

T-SQL Tuesday #13– The Business and Disaster Recovery

I’m hosting this month’s T-SQL Tuesday blog party, but that doesn’t mean I can’t participate. I posted the invitation last week, and hopefully we’ll have a large number of people participating today.

The Cost of HADR

I’ve dealt with a lot of business people over the years, and for… Read more

0 comments, 483 reads

Posted in The Voice of the DBA on 14 December 2010

iPads for Christmas

There's a contest going on, today through Friday, and you can win a copy of SQL Monitor from my employer Red Gate Software.

Oh yeah, in order to use your new software like we do at SQLServerCentral, we'll send you an iPad as well. A 16GB, 3G, iPad.

You…

Read more

1 comments, 250 reads

Posted in The Voice of the DBA on 13 December 2010

SQL Server 2005 SP4

Last year I submitted a Connect item for SQL Server 2005 SP4. Quite a few people supported this item and voted for it, and Microsoft decided to build this last, final Service Pack for SQL Server 2005.

No timeline was given, but last week someone noticed that my Connect… Read more

3 comments, 479 reads

Posted in The Voice of the DBA on 13 December 2010

SQL Saturday #45 Cancelled

I hate not living up to commitments. It really, really bothers me and I have tried hard in my career to under-promise and over-deliver. However I’m going to get a big fat #FAIL for SQL Saturday #45.

I found out last night that my son has his black belt test… Read more

0 comments, 233 reads

Posted in The Voice of the DBA on 10 December 2010

The 2011 SQL Saturday Schedule is Filling Up

I have been trying to figure out where to go in 2011 for SQL Saturdays, especially as Red Gate is looking to have me do a few more demos and sessions at events. It seemed that there were relatively few events, and I’d already decided on these two:

Read more

0 comments, 232 reads

Posted in The Voice of the DBA on 10 December 2010

Put Your Thinking Caps On

A repost from SQLServerCentral.
What would you like for Christmas?





Hint, hint, a little visual imagery of the kind of prize that you just might win from Red Gate software next week. And just in time for Christmas!


To celebrate the release of SQL Monitor, Red Gate is…

Read more

1 comments, 269 reads

Posted in The Voice of the DBA on 8 December 2010

Older posts