SQL Clone
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in

Archives: July 2009

Things You Need To Know If You Use DFS Replication

In addition to being a SQL DBA I'm also a network administrator, or at least I pretend to be. This is a bit off-topic from my usual SQL Server fare, but I figured my pain is your gain. Today, July 31, is System Administrator Appreciation Day. If you use… Read more

0 comments, 2,237 reads

Posted in Kendal Van Dyke on 31 July 2009

PASS & SQL Bloggers

PASS is trying to find better ways to reach out to SQL Bloggers. They’re going to experiment with taking advantage of the new subgroup features offered by LinkedIn. Membership to the subgroup will come fromthose currently listed in the PASS blog directory. If you’re looking to get into a…

Read more

0 comments, 1,304 reads

Posted in The Scary DBA on 31 July 2009

No really. When did this statement start?

I thought I had an interesting answer to the question. Unfortunately Adam Machanic, who has been working in this specific area quite a bit longer than I have, and, let’s face it, is a bit smarter, pointed out (in the comments) the possibility that I didn’t have this quite right.

Read more

0 comments, 1,298 reads

Posted in The Scary DBA on 31 July 2009

Article re-featured on SQLServerCentral

The second article I had published on SQLServerCentral, ANSI PADDING, Trailing Whitespace, and Variable Length Character Columns, was re-featured in the newsletter and on the home page today. 

My favorite part of being published is the discussion that hopefully follows.  Even if there are some negative comments, I… Read more

0 comments, 1,404 reads

Posted in Wise Man or Wise Guy on 31 July 2009

Heading to N'Awlins

I'm leaving today for SQLSaturday #17, actually in Baton Rouge. I'll be at the speaker party tonight and hope to see many of you at the event tomorrow. I'm not sure when I'm speaking as there was some schedule shuffling, but I'll deliver "The Modern Resume: Building Your Brand"… Read more

3 comments, 1,547 reads

Posted in The Voice of the DBA on 31 July 2009

Book Review: The Connect Effect: Building Strong Personal, Professional, and Virtual Networks

I read The Connect Effect: Building Strong Personal, Professional, and Virtual Networks by Michael Dulworth ($16 @ Amazon) months ago, forgot to write up the review and finally getting back to it. The emphasis of this book – to me – is on the value of networks, and that was… Read more

0 comments, 1,879 reads

Posted in SQLAndy on 30 July 2009

24 Hours of PASS - Building a Better Blog

I got asked to do an hour during the 24 hours of PASS that is happening on Sept 2. It's a 24 hour marathon, spanning the globe, where you'll have (I think), 24 speakers who will be broadcasting across LiveMeeting to anyone that wants to drop in for an hour.… Read more

0 comments, 1,367 reads

Posted in The Voice of the DBA on 30 July 2009

Embedding Bing Maps in a Web Page

I was doing some maintenance on the SQLSaturday web site recently and one request kinda low on the list was to try using Bing Maps. We’ve been using Google Maps (see SQLSaturday #17 for an example) because it’s easy to use. Just enter the address and make sure… Read more

2 comments, 3,470 reads

Posted in SQLAndy on 29 July 2009

70-433 Or Bust: Working toward MCTS Microsoft SQL Server 2008 Database Development

The 70-433 will be my first Microsoft certification test. There are two main reasons why I've decided to take on this quest.

The first reason is to "fill in the cracks." Even on fundamental topics I've found myself saying "oh - I didn't know that" while taking a training class… Read more

18 comments, 4,216 reads

Posted in Bill Nicolich on 29 July 2009

Scared to Reboot

I have my weekly conference call today, and in trying to get the webcam to work, it appears to be locked up with the manufacturer's software. Usually this happens and I reboot, and it will free up. Sometimes two reboots.

However the laptop has been acting up. Even with the… Read more

0 comments, 1,407 reads

Posted in The Voice of the DBA on 29 July 2009

Netbook Experiences

I’ve had an HP Mini netbook for about a month now and have been using it on and off. Actually for the most part my wife has taken control of it, using it for blogging most nights after our kids are in bed. It’s handy, small, and works well for… Read more

0 comments, 1,402 reads

Posted in The Voice of the DBA on 29 July 2009

PASS Interview With Don Gabor

Just in case you don’t read the Connector today, here’s a link to an interview that PASS HQ did with Don Gabor that focuses on his upcoming seminar at the Summit. If you’re on the fence (or definitely not going), I’d be interested to hear what you think about his… Read more

0 comments, 1,529 reads

Posted in SQLAndy on 28 July 2009

Connector Editorial for July 29,2009

I currently write the editorial for the PASS Connector which is published every two weeks as part of my role on the Board of Directors. I'm cross posting those editorials here as well as to the main PASS blog.

How good are you at meeting new people at a… Read more

0 comments, 1,435 reads

Posted in SQLAndy on 28 July 2009

Time Management – Not So Easy

Steve Jones sent me this link on time management that discusses two things – getting ‘ambushed’ at the start of the day with unexpected tasks and the power of ritual. It was timely (as it were) because I’d just had a miserable day where I had some goals to hit… Read more

3 comments, 1,608 reads

Posted in SQLAndy on 28 July 2009

LinkedIn & Open Networking

I ran across this a while back and it’s been on my ‘to blog about’ list for too long. Open networkers (LION’s) are those that actively seek and accept networking connections on LinkedIn. It’s a controversial strategy, both to LinkedIn itself and to those of us building networks, but it’s… Read more

1 comments, 1,454 reads

Posted in SQLAndy on 28 July 2009

SQLSaturday 21 – Orlando Announced!

Andy Warren and crew at OPASS have announced that SQLSaturday 21 – Orlando will be held at Seminole Community College, 100 Weldon Boulevard, Sanford, FL 32773, on October 17th.  The call for speakers just opened this afternoon and we have our first session submitted, and it wasn’t by me or… Read more

0 comments, 1,294 reads

Posted in Wise Man or Wise Guy on 28 July 2009

ActiveAugust –> Getting More Fit

ActiveAugust started as a discussion on Twitter and Mike Walsh (@mike_walsh) has set the bar with his blog post about it.  The general idea is to commit to lifestyle changes by becoming more active and/or eating healthier.  The key thing is to setup a plan, blog your plan,… Read more

0 comments, 1,191 reads

Posted in Wise Man or Wise Guy on 28 July 2009

When did this statement start?

UPDATE: This post is incorrect. Adam nailed it in the comments. I explain my mistake here.

A question came up over at SQL Server Central where someone was wondering if it was possible to know when a given statement within a batch started. Immediately I thought, oh yeah,…

Read more

0 comments, 1,870 reads

Posted in The Scary DBA on 28 July 2009

Kids at Work

My daughter has gotten into a few podcasts andhas fun with it. Occassionally she interrupts me, and that happened yesterday. She was really cute, and so I sliced out this section and uploaded it. Enjoy.

Podcast Interuption Read more

0 comments, 1,711 reads

Posted in The Voice of the DBA on 28 July 2009

SQLSaturday #21 in Orlando on October 17, 2009

I had hoped to announce this much sooner, sometimes the wheels turn slowly. But turn they do! We’re back at Seminole Community College this time and looking forward to a great event. We’re going to try to feature some longer sessions in Part 1/Part 2 format, a block of 15… Read more

0 comments, 1,448 reads

Posted in SQLAndy on 28 July 2009

Older posts