April 2007 - Posts

Richmond Code Camp 3 - Success!

Richmond Code Camp 3 was a success!

The most common complaint throughout the day was "How do I choose between these cool sessions?!"

The speakers did an outstanding job! The volunteers were awesome! And, as usual, the Richmond Code Camp Steering Committee did a great job with all the planning and execution!

The contributors really came through for us this time - browse over to the Richmond Code Camp 3 website for a complete list!

We start planning RCC4 in two weeks! Hope to see you all there!

:{> Andy

Technorati Tags: Developer Community Richmond Code Camp RCC3

Books Online updated

Sorry I missed this one: Books Online was updated in February.

Download the update .

:{> Andy

Technorati Tags:

Richmond Code Camp 3 in 3 days!

Can you believe Richmond Code Camp 3 is only three days away?! Wow, time flies when you're having fun!

It's not too late to (although registration is filling up fast!). Come on out Saturday, have something to eat, learn some cool new tips and tricks from local and regional developers, and - maybe - win an XBox, Zune, or copy of Vista!

:{> Andy

Technorati Tags: Richmond Code Camp 3 Developer Community MSDN

My Goals for the Richmond Developer Community

I want to see the Richmond Microsoft Developer Community grow. That's my goal for Richmond and the surrounding communities.

I want to facilitate free and open access to software professionals and experts for enthusiasts, hobbyists, junior developers, and anyone who just wants to know more about developing software for Microsoft platforms.

Some of the coolest .Net and SQL Server work on the planet is being done right here - although a lot of it is subject to NDAs, security clearances, and/or has patents pending, it is being done here nonetheless.

If you're interested in learning more and growing your skills, an excellent opportunity presents itself just seven days hence: Richmond Code Camp 3. !

:{> Andy

Technorati Tags: Richmond Developer Community Goals Code Camp

Today We Are All Hokies

Today We Are All Hokies

Virginia Tech has a fitting memorial on their website today. At noon, we will pause and pray for the friends, families, and loved ones of 32 fallen - along with individuals and families around the world.

It is a somber day in the Commonwealth.

Stevie Ray and I got up early this morning so we could stop by Walmart on the way to pre-school. We wanted to pick him up a Tech t-shirt, cap, or shorts to wear today. He's four years old and doesn't need to know the details of what happened, but it's a lesson in community. I'm proud of Farmville - there wasn't a single VA Tech item left in the store. There wasn't so much as a maroon or gold t-shirt left on the shelves.

I told him today we were remembering good people who are no longer here, and are praying for their friends who will miss them now that they're gone. I told him we need to appreciate the good people around us every day, and that it's sad that it takes bad things to remind us sometimes.

Again, he doesn't understand - and part of me hopes he never does.

His oldest sister, Manda, is a Virginia Tech alumnus. She's also a pastoral counselor who helps folks when their loved ones are in the hospital, so she sees a lot of pain. She's headed to the memorial today in Richmond along with lots of folks from the area.

So today, I invite you to join me and pause at noon and remember 32 good people - a lot of them heroes - taken from us too soon.

Andy

Technorati Tags: Today We Are All Hokies Virginia Tech Hokies Pause at Noon Heroes

Visual Studio Orcas Beta 1

!

You have to have an MSDN subscription to get the bits at the time of this writing.

But...

...there are VPC images available! I'm grabbing the (which includes Orcas VSTS B1) on the BOOM (Big Old Office Machine) as I type!

:{> Andy

Technorati Tags: Orcas Team System Team Foundation Server Beta 1

Customer Service

A few months back we decided to incorporate Richmond User Groups as a not-for-profit. We changed the structure of the Richmond User Groups to a sponsored model after careful consideration and a bunch of planning. It worked out well for us and most of the community. Now we're more flexible and scalable, and it isn't such a pain to manage leadership changes.

One of the things every corporation needs - whether it's for-profit or not - is a bank account. But I had a problem: I wanted to start the account, then use money from the account to form the corporation - sort of a cart-before-the-horse scenario. Since I'd been doing business with this one particular national bank for five years, I waltzed into the local branch here in Farmville, explained my situation, and asked them what I needed to start an account.

They told me I needed a tax id number, or Federal Employer Identification Number (FEIN). So I went online and found I was able to submit a Form SS-4 online prior to actually incorporating. How cool! Things were moving now.

I went back to the bank branch the next day with paperwork in hand all ready to open that account. I was then told I needed articles of incorporation.

Now, I don't mind providing a bunch of stuff to get things going. I do mind not getting a complete list of what's required up front.

I called customer support - a centralized service of this large institution. I was told by customer service I could open an personal account in my name, incorporate the business, then convert that account to a corporate account. I'm not a banker, I believed them.

Allow me to shorten the story some here by saying that the previous statement was also inaccurate.

So I went with the competition to open the not-for-profit account for the Richmond User Groups Corporation. It took less than an hour with my Tax ID number. I showed up two weeks later with official articles of incoporation and everyone has been happy as clams ever since.

I also opened my new business accounts with the competing bank. They were just as helpful and I even scored two free personal checking accounts and a free safety deposit box - very cool indeed. Thank you Wachovia.

So today I waltz back into my old local branch to close out a savings account and checking account I haven't used in several months. The savings account is actually in the red $14.99 due to monthly service fees. They ask why I'm closing the account and I tell them - politely.

Now at this point there's an opportunity for some customer service. I'm sending all the signals that I'm about to sever my relationship with this institution. The response?

I was asked to pony up the $14.99 before I could close the Bank of America savings account I hadn't touched in several months.

Great job there - lots of good will instilled. It's a good thing I'll never need banking services in the future...


This happens in the software industry too. Real or imagined, bad customer service is the fastest way to end a potential or thriving business relationship. It doesn't have to be anything dramatic - something that places you second on the list is enough to cost you a consulting gig.

If you find yourself on the other side of the desk in such a transaction, stop and think for a minute: "If it were me, what would I want out of this exchange?"

Answering that question appropriately - and then acting on it - can alter the dynamics of the situation dramatically. Since it generally costs so much less to maintain an existing customer than it does to gain a new customer, this is something to consider.

While it remains online and available, you may want to peruse Tax Facts - a weekly newsletter generated throughout the 1990's and into 2005. David B. Robinson is one of those people every business person should listen to. He's a mentor and a heck of a nice guy. He certainly helped shape my career as an entrepreneur.

Doing good customer service is its own reward. The return on good will is difficult to measure - but I guarantee you it's positive!

:{> Andy

Technorati Tags: Software Business Customer Service Richmond User Groups Wachovia David Robinson, CPA

Microsoft Announces Silverlight

Microsoft announces - the new web platform for delivering RIAs (Rich Interactive Applications) via the web.

One interesting twist on the name of this platform: it was named after web guru and Community-Credit founder David Silverlight.

So far as I know this is the first time Microsoft has after an individual. Congratulations David!

:{> Andy

Technorati Tags: Silverlight web platform

Virginia Tech

Our thoughts and prayers are with the families and friends of students, faculty, and administration of Virginia Tech this morning.

:{< Andy

Richmond Code Camp 3 Swag!

Richmond Code Camp 3 is less than 2 weeks away!

We have an awesome speaker / topic line-up - check out this schedule.

We have some awesome swag this time! In addition to the usual free magazines and best-selling technical books, we also have cool prizes!

It's going to be a fun and educational day - from Frank's opening keynote to Darrell's closing keynote! today!

:{> Andy

Technorati Tags: Richmond Code Camp Developer Community RCC3 Frank La Vigne Darrell Norton

posted Sunday, April 15, 2007 5:52 PM by andy with 0 Comments

Tim Tatum's T-SQL Presentation

Tim Tatum did a great job presenting to the Richmond SQL Server Users Group last night! Last night's meeting also set a new attendance record - it was a great night.

Tim thought his topic wouldn't be well-received since most of our presentations focus on SQL Server 2005. Truth be told, there's still quite a market out there for SQL Server 2000. The platform is stable and still meets the database needs of most organizations.

SQL Server 2005 performs better, is more scalable, and has some very interesting and useful features. Not all organizations have a need for SQL Server 2005, and some will not upgrade until .

:{> Andy

Technorati Tags: sql server Tim Tatum Richmond SQL Server Users Group T-SQL

posted Friday, April 13, 2007 10:46 PM by andy with 0 Comments

Some days blogs just write themselves...

...and today is one of those days. :)

First, if you don't already receive Steve Jones' excellent daily editorials (from SQLServerCentral.com), click the link immediately and sign up. It's a free site and there's lots of good stuff there. I enjoy the afore-mentioned editorials a lot - Steve does a great job.

Today's editorial is about making IT better. If you are an IT manager, stop what you are doing and read this editorial and the articles to which it refers. It's that important.

Go ahead - I'll wait.

Ok, back now? Weren't those articles interesting? I thought so too.

Second, an email was waiting in my Inbox this morning from Fernando G. Guerrero - CEO of Solid Quality. It was in everyone's Inbox, addressed to all of us at Solid Quality:

Go to http://maps.google.com
Select "get Directions"
From "Madrid" to "Seattle"
Click on "Get Directions"
Look at step #40
:)
Cheers


I've had my share of experiences with PHBs (as Frank likes to call "Pointy-Haired Bosses") and remember how it feels to identify with comments made in the eWeek article. Having those experiences makes me really appreciate working with Solid Quality because, frankly, that crap doesn't happen here.

From what I've seen it only takes one individual in an organization to spread groupthink. And once it takes root, groupthink spreads like weeds in a garden.

Joel Spolsky's Two Stories illustrates the benefits (including profit) of empowering employees.

Although I can sympathize with people interviewed for the eWeek article, like Joel I'm no longer in that position career-wise.

I think the experience of having-been-there made me a better manager when I managed DBAs at a large company. I remember my first review said something like "Team members will take a bullet for Andy." I appreciated that because it was something I cultivated. I wanted to be a "follow me" leader and not a "go and do that" leader.

The eWeek article contained quotes from folks who lamented being reactive - the "fire-fighting" role their jobs had become. The DBA Team I managed was in that spot when I became manager. The situation was indeed dire. Not only was the team spending an inordinate amount of time fighting fires, we were losing the fight. The amount of time required was increasing.

The stratgey I proposed sounded simple: First we will fight fires better. Second, we will engage in fire prevention.

As a team (I cannot stress this enough) we brainstormed ideas about doing a better job fighting fires. We hit on a couple key concepts - communication and cross-training. Individuals on the team were experts in certain applications. When something "bad" happened with Application "A" the go-to guy was "Joe". When Joe fixed the issue, he started sending an email to the group explaining the fix. The plan was to post the fix on a SharePoint portal, starting a Knowledge Base. The email soultion worked well enough (Outlook is searchable) that we never implemented this fully. Communicating worked - really well. We expanded the knowledge among the group and everyone felt better about being on call, etc.

Doing a better job of fighting fires gave us some breathing room to address fire prevention. We implemented a suite of light-weight tools that allowed front-line support personnel to make changes to data. It wasn't a perfect solution, but it allowed us time to fix underlying bugs in database code, instead of spending all our time correcting the bad data generated by bugs. Yes, we had to admit we made mistakes. Test Engineers had to admit these mistakes weren't caught by testing. But that challenged our Test Engineers to write more robust custom tests - and these tests found their place in the regression suite so it served to strengthen quality overall. And quality improved - but that wasn't all:

The paranoia and threat level disappeared when we all admitted mistakes were being made. The walls dropped and people loosened up. It went from being an ok place to work to being fun.

Most importantly (for the business anyway) was the fresh attitude allowed more freedom, and developers love freedom. Freedom was channeled directly into creativity, which developers (database and application) used to produce applications that literally blew management's mind! All of a sudden we had applications doing things they weren't slated to do for months. Performing, scaling, the sorts of things that applications do to make a company money.

What happened at this company? Where are they now? Apologies for a sad ending...

IT management - the PHBs - were threatened by a technology they did not understand: .Net. Their paranoia expanded and they literally "stopped all development" within three months of the application setting new corporate records for electronic processing. I honestly believe they would have pulled the application out of production had it not performed around 100 times better than the old application. As it was, they clamped the screws on the team that built it and, understandably, that team dissolved within six months.

But hey, the threat was mitigated.


It doesn't have to end this way. There are still cool companies out there. Sadly, they will not all stay cool, but you can enjoy the coolness while it lasts. You can use this time to grow yourself, become better at what you do, more valuable to another cool company. Or you can start your own cool company!

IT managers would do well to pay attention to Solid Quality. Solid Quality attracts MVPs and authors and treats us well. All businesses face challenges and SQL is no exception. What is an exception is how they handle challenges.

Whether you're a CxO or shift supervisor, you can treat people fairly, communicate more / better, and - for goodness' sake - do what you can to see those in your charge are allowed to do their job unencumbered by stupid rules.

:{> Andy

Technorati Tags: business software PHB pointy-haired boss SQLServerCentral Steve Jones Frank La Vigne

posted Tuesday, April 10, 2007 9:32 AM by andy with 1 Comments

Richmond Code Camp 3 (RCC3) in less than 3 weeks!

Richmond Code Camp 3 (RCC3) is less than three weeks away!

is filling up fast.

RCC3 will be April 28th. Code Camps are day-long events for and by developers. This the third Richmond Code Camp and it promises to be the biggest and best to date!

To receive the latest news, join the Richmond .Net Users Group or join the Richmond SQL Server Users Group!

If you're thinking of attending !

:{> Andy

Technorati Tags: Developer Community Richmond Code Camp RCC3

Easter in Farmville, VA

It's Easter Sunday in Farmville, Virginia, USA. It's a bit colder than usual - the weather man said it's 20 degrees (F) colder than normal today.

Yesterday we had a rare April snow.

Christy did a lot of work in the tulip bed near our side door a couple weeks ago and these beautiful tulips blossomed last week while I was in Boston. The snow provided an interesting contrast:

We ran into town yesterday for some garden supplies - it's time to plant gardens around here despite the snow. A neighbor brought his tractor over Thursday and plowed and disced a plot for us on the east side of the house. We're going for morning sun and afternoon shade.

The Easter Bunny showed up while we were at Walmart so we grabbed a picture with Stevie Ray and Emma Grace.

On the way out Emma got to ride the "frain":

We almost bought Stevie Ray this Easter basket:

Earlier today we went to church with Mom and Jimmy Lee:

That's Stevie Ray (4) and Emma Grace (almost 2) down front. Mom's on the left, Christy (and "Wee") are in the middle, and Jimmy Lee is on the right.

Everyone else at casa de Leonard is napping as I type. I'm using the time to catch up on business paperwork, write, work on some SSIS projects, and blog! The Mets/Braves game is on in the background. Life is good.

We'll likely ride into town a little later and get some ice cream. The kids were relatively quiet and good in church this morning... we need to reinforce that behavior at every opportunity.

From Farmville, Happy Easter everybody.

:{> Andy

Technorati Tags: Easter Farmville Nascar Tulips Snow

SQL Provisioning Tool (SQL Server 2005 SP2)

At the end of the SQL Server 2005 SP2 installation you may be prompted to launch the SQL Provisioning Tool. This utility makes members of the local administrators group SQL Server sysadmins - which is cool, especially if your instance security is Windows Authentication only.

If anything "bad" happens during the provisioning process, the utility simply shuts down.

By "bad" I mean things like the tool attempting to access a service you shut down. Note: you may have shut down this service because you were prompted the file was locked during an earlier step in the Service Pack installation.

When you search for the Provisioning Tool in the Start Folders you will note it isn't there.

You can find it with diligent searching (or by reading this blog): It defaults to [Installation Drive]\Microsoft SQL Server\90\Shared\SqlProv.exe. On my machine I installed SQL Server on the C:\ drive so my path to SQLProv is "C:\Program Files\Microsoft SQL Server\90\Shared\SqlProv.exe".

Re-executing the tool doesn't seem to cause any negative impact, but I haven't conducted rigorous testing.

:{> Andy

Congratulations Frank!

Frank La Vigne is published in CoDe Magazine!

Frank's article Exploring Ink Analysis is now available online. Congratulations Frank!

:{> Andy

Technorati Tags:

SSIS Design Patterns Series

On Applied Business Intelligence I've started a new series called SSIS Design Patterns.

The first in this series is now posted: Dynamic SQL.

:{> Andy

Technorati Tags: SSIS Dynamic SQL Design Patterns

Solid Quality MVPs!

A bunch of MVP Solid Quality Mentors were renewed or awarded yesterday!

  • Marino Posadas
  • Dusan Zupancic
  • Eladio Rincón
  • Dino Esposito
  • Karol Papaj
  • Erik Veerman
  • Peter Myers
  • Chris Webb
  • Randy Dyess

These folks are not only really smart, they're also cool to work with!

Congratulations to all!

:{> Andy

Technorati Tags: MVP Solid Quality

It's MVP Day

So far as I know, s are annouced the first day of each quarter.

Congratulations to Frank La Vigne who was re-awarded Tablet PC MVP for another year!

Update! Darrell Norton was renewed as an ASP.Net MVP!

Congrats also to David Silverlight, the brains behind Community Credit, XML PitStop, NonProfitWays, Code Camp Evals, and many other cool websites - at least one of which he's asked me not to talk about yet! David was also re-awarded as an XML MVP.

I was nominated for Q3 / 2006 but not awarded. I was disappointed but understood: the process looks at your community involvement over the past year, and I sort of "came out of nowhere" a few months earlier.

I was fortunate enough to be nominated again earlier this year. And today I received the news I was awarded SQL Server MVP! The email arrived around 4:30 AM EDT. I was up until 3:45 AM EDT polishing off my Testing The Database chapter for the upcoming Wrox book: - so I almost knew about it real-time!

It's a huge honor and I am humbled and overwhelmed all at the same time.

:{> Andy

Technorati Tags: About Andy MVP SQL Server