The Voice of the DBA
Archives: April 2010
Should I Go? SQL Saturday plans for the year.
There have been quite a few more SQL Saturday announcements this week for new cities. I enjoy attending these events, and look forward to going when I can. I have plans to go to Baton Rouge (#28) in August and Pensacola (#22) in June, after having wonderful times in those… Read more
4 comments, 72 reads
Posted in The Voice of the DBA on 14 April 2010
A Quick Queue Process
As SQLServerCentral grew, we evolved through a few email sending solutions to meet the demand. We started with a manual process, then went to a homegrown automated one, then moved through 2 purchased software solutions before coming back to a (new) homegrown one.
When we used to try and send… Read more
0 comments, 114 reads
Posted in The Voice of the DBA on 14 April 2010
T-SQL Tuesday – The Reporting Table
My T-SQL Tuesday post for April is based on Aaron Nelson’s subject of reporting. If you’re unsure of what T-SQL Tuesday is, you can read about it’s origins here.
The Reporting Table
Years ago, actually well over a decade in my past, I was working for a small… Read more
3 comments, 284 reads
Posted in The Voice of the DBA on 13 April 2010
New SSDs
I ordered a few recently from NewEgg. One for a desktop, one for a laptop. We’ll see how they do, but I was excited enough to snag this picture when they arrived.
$200 for 80GB.
1 comments, 79 reads
Posted in The Voice of the DBA on 12 April 2010
What to do about certification
After my editorial “The Missing Certification” I was amazed at the debate that took place. As of the time I’m writing this, this thread has over 7,000 views and 600 replies!
It’s incredible to see people debating certification, but what’s evolved is kind of a working thread that… Read more
7 comments, 183 reads
Posted in The Voice of the DBA on 12 April 2010
Prius Update – Three Years In
I’ve had the Prius for 3 years as of Mar 31, 2010, and it’s been a great car for us. As the 3 year mark turned over, I was at just over 60,000 miles, which is a pretty heavy load. That level of driving really contributed to my positive experience… Read more
0 comments, 60 reads
Posted in The Voice of the DBA on 9 April 2010
The Tweetup
An interesting experiment from Microsoft tonight. They brought 8 or 9 bloggers/press people from around the country to Redmond for a 3 hours briefing/wine tasting. We were picked up from the airport, taken to a hotel in Bellevue and then shuttled to the Commons building on the Microsoft campus. It’s… Read more
6 comments, 188 reads
Posted in The Voice of the DBA on 9 April 2010
A 96 hour meeting
2 comments, 52 reads
Posted in The Voice of the DBA on 8 April 2010
Use a Clustered Index
I stumbled across this clustered index test from Hugo Kornelis recently from a post in the forums. I think I’d read it before, but it was surprising to me again this week as I read through it.
The test seems to show that if you are changing data over time… Read more
5 comments, 100 reads
Posted in The Voice of the DBA on 7 April 2010
Swing and a Miss
I missed my first newsletter today. It wasn’t until I went to schedule tomorrow’s that I realized I hadn’t sent last nights. I had prepped it, done the work, gotten the editorial written, podcast done, articles scheduled. Things were ready to go, but I didn’t get the newsletter out. I… Read more
4 comments, 61 reads
Posted in The Voice of the DBA on 6 April 2010
Finding the Client IP
It’s not often that I’ve had the need to trace back a client to their host computer, but there are time it’s handy. I had thought that the easy way to do this in the past was with sp_who.
However that’s not correct. I checked back in the SQL Server… Read more
6 comments, 142 reads
Posted in The Voice of the DBA on 6 April 2010
HTC Pro Trade-In
I saw a note that T-Mobile is accepting trade-ins of an iPhone for credit towards a new HTC HD2. That’s interesting, and almost tempting. Not that I don’t like my iPhone, but I’ve been tempted to look on eBay for a 16GB one as I’m running low on space. Plus… Read more
2 comments, 98 reads
Posted in The Voice of the DBA on 5 April 2010
Express Yourself Clearly
Recently my son had a short paper to write for school. He’s a sixth grader, and this year is a turning point for him where he’s expected to think a little more about his writing as well as tackle longer assignments. In this case it was a 2 page paper… Read more
0 comments, 244 reads
Posted in The Voice of the DBA on 5 April 2010
Goals for 2010 – Q1 Review
Here were the goals I posted for 2010 on the last day of December:
6 comments, 100 reads
Posted in The Voice of the DBA on 2 April 2010
Outtakes
Sometimes I think I’m quite the goober. Alternately I’ll laugh or put my head in my hands as I try and clean up the video for an editorial.
I typically save some blooper reels for holidays and try and get a break from all the writing, but I always have… Read more
0 comments, 66 reads
Posted in The Voice of the DBA on 1 April 2010
April Fools is Fun
Some good jokes going around, and the few I wrote for SQLServerCentral went over well. There was a good one at work as well, with my boss “delaying” April Fools until next week so we could get work done, and perhaps another one on the free food. Not sure if… Read more
2 comments, 65 reads
Posted in The Voice of the DBA on 1 April 2010
Career Advice - Moving to Oracle
I’ve always said that it didn’t matter what the database was. If it could do the job then it’s worth using. I have never worried about whether I had an Oracle database, SQL Server database, or any other platform. If someone wanted to pay me to work on it, then… Read more
5 comments, 70 reads
Posted in The Voice of the DBA on 1 April 2010



Subscribe to this blog