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

Six Months

“Show up for work on time for six months and then we’ll talk. Until then, I have four words for you: shut the fuck up.” – Kitchen Confidential

I wish people showed up and heard this on their first day of work. Too many people I think have a very… Read more

8 comments, 757 reads

Posted in The Voice of the DBA on 30 April 2010

Windows 7 v the iPad

No, I didn’t buy an iPad, but I have to say on a trip to the Apple Store this week (for an iPod issue), I played with one for about 20 minutes and I came to this conclusion.

It. Is. Cool.

It’s not semi-cool. Or neat. It is very, very… Read more

3 comments, 910 reads

Posted in The Voice of the DBA on 30 April 2010

Plagiarism

It seems to rear it’s ugly head more and more these days. Once again I found some content from my site republished on another site, without permission, and without a link.

I can’t speak for others, but if I knew you were plagiarizing content, I wouldn’t hire you. I believe… Read more

2 comments, 609 reads

Posted in The Voice of the DBA on 30 April 2010

A Identity Bug

Someone asked an interesting question recently. If they had this code:

if OBJECT_ID('aa') is not null
   drop table aa
create table aa (id int identity(1,1))
go
set identity_insert aa on
insert aa (id) select -10 union select -11
set identity_insert aa off

insert aa default values

select * from… Read more

1 comments, 971 reads

Posted in The Voice of the DBA on 29 April 2010

Backup Compression in SQL Server 2008 – The Complete Presentation

From the PASS 2010 Summit Survey: 29% of people want a presentation on backup compression. OK, here it is.


Turn it on:

 


Turn it off:

 



That’s it. If you want to script it, go here.

I saw Brent Ozar’s (blog, twitter) interpretation of the… Read more

9 comments, 845 reads

Posted in The Voice of the DBA on 28 April 2010

One Trip Booked – TechEd 2010

Tia thinks I’m crazy to book early, but I like to have a choice of flights, and I like to get things off my plate. I heard back from someone about TechEd today, so I decided to just book the trip. One less thing for me to worry about.

SQL… Read more

3 comments, 180 reads

Posted in The Voice of the DBA on 27 April 2010

The PASS Summit Survey Results 2010

I hope there will be more surveys, so I’ll tag this as 2010. The results were released recently, and there were some write-ups on the results. There was the release by PASS, and then a great interpretation (and debate) by Brent Ozar. There are others as well ( Read more

11 comments, 585 reads

Posted in The Voice of the DBA on 27 April 2010

Beware, events falling from the sky

Are SQL Saturdays falling from the sky? (from Jen McCown, @midnightDBA)
I think so. This past weekend had three events, #39 in NYC, #41 in Atlanta, and #44 in Huntington Beach, CA. That’s unusual, but this weekend we have #36 in Wheeling, WV and #38…

Read more

1 comments, 215 reads

Posted in The Voice of the DBA on 26 April 2010

Upgrading your Beta/CTP Software

This is one of the reasons that I don’t like to put CTP software (or Beta software) onto machines that I can’t take the time to wipe and rebuild. Buck Woody wrote a note about upgrading your CTP, and the short answer in his blog is:

NO

You can’t… Read more

2 comments, 476 reads

Posted in The Voice of the DBA on 26 April 2010

Adding Administrator

I installed a new VM with SQL Server in it, along with Win 7 and Reporting Services. The plan was to mess with this as a detailed journey through to learning more about SSRS this year.

I was excited to get going on this new install since I hadn’t messed… Read more

1 comments, 229 reads

Posted in The Voice of the DBA on 23 April 2010

Book Review - Rework

I have been a fan of 37 Signals for some time, and I read their blog regularly. I think they go a great job of writing about how to run a business and not build an investment.

Rework is a summary of quite a bit of advice from their blog… Read more

3 comments, 227 reads

Posted in The Voice of the DBA on 23 April 2010

e-Ink Improvements

I saw this article on the improvements from E-ink that are coming. There are two videos, one of a better screen that can handle simple animations, likely getting into actual products you can by in about a year (early 2011).

The other was low power, but more durable. The guy… Read more

0 comments, 232 reads

Posted in The Voice of the DBA on 22 April 2010

Rebuilding the Home Server

My Windows Home Server died a month ago, just as I was getting ready to leave the country. I didn’t have time to deal with it, but since I was still in the process of moving data over to it, I felt fairly safe. When I got back to it… Read more

2 comments, 199 reads

Posted in The Voice of the DBA on 22 April 2010

I’m on TV at the Tweet-up

I was listening to the announcement of SQL Server 2008 R2 yesterday on a call from Microsoft. It was released to manufacturing, downloadable on May 3. While listening and making notes, I wandered over to the Microsoft SQL site and was surprised to find a video montage of the Tweet-up Read more

2 comments, 206 reads

Posted in The Voice of the DBA on 22 April 2010

SQL Server 2008 R2 Released to Manufacturing

Microsoft scheduled a conference call this morning, and I jumped on since I was laid up in bed with a pinched nerve in my neck. What else did I have to do?

Actually I had work to do, but I was in pain much of the night and this morning,… Read more

3 comments, 697 reads

Posted in The Voice of the DBA on 21 April 2010

Log Shipping Delays are Good

In the past, when I’ve set up log shipping, it was primarily as a DR device, designed to get copies of logs to another server ASAP. The idea being that if we had an issue on the production server, we could switch to the secondary server quickly and lose minimal… Read more

2 comments, 879 reads

Posted in The Voice of the DBA on 21 April 2010

Sad Sack – Hardware Failures all over

I feel like I have some bad digital karma lately. In the past week I’ve had these downed systems:

  • iPod iTouch
  • Lenovo Laptop
  • Acer laptop
  • Windows Home Server

To be fair the Windows Home Server died just before we went to the UK and I hadn’t had time to mess… Read more

2 comments, 204 reads

Posted in The Voice of the DBA on 20 April 2010

Just one mirror

You can only have one mirror of a SQL Server database in SQL Server 2005/2008. I researched that last year when someone asked the question. It didn’t make sense to me why you couldn’t have more than one, and I struggled to find documentation, but finally Paul Randal pointed me… Read more

3 comments, 202 reads

Posted in The Voice of the DBA on 19 April 2010

SQL Server 2008 R2

The RTM date is out for SQL Server 2008 R2. At the UK Tech Days it was released as May 21 of this year, so my guess it’s pretty much done and there’s a little fit and finish work to be completed.

I’m surprised that they can announce that date… Read more

4 comments, 184 reads

Posted in The Voice of the DBA on 16 April 2010

It’s a Start

One of my 2010 goals is to really increase my SSRS knowledge. I’ve used SSRS in a cursory manner over the years, but never really delved into building complex reports and trying new things. So I decided to fix that and work my way through some articles and books on… Read more

6 comments, 230 reads

Posted in The Voice of the DBA on 15 April 2010

Older posts