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

Archives: March 2009

How to Deal with the Difficult Forum User

It has happened to us all at one time or another.  We are trying to help someone on an online forum and they won't cooperate when asked for more details regarding the problem they are experiencing.  You may have written some code and they come back and say it doesn't… Read more

6 comments, 1,477 reads

Posted in SQL Musings from the Desert on 25 March 2009

Launch Replication Monitor Without SSMS

I manage a lot of replication publications\subscriptions and when I get a latency or agent failure alert it always bugs me that I have to go through 5 steps to launch Replication Monitor: launch SSMS, go to my server in object explorer, expand the treeview, right click on the Replication… Read more

0 comments, 611 reads

Posted in Kendal Van Dyke on 25 March 2009

What a fortnight I had

This has been one of the most stressful fortnight in this company. I did not feel this stressed when our SAN went down couple of years ago. First someone messed with the Back storage server while Warm standby restore was going on. This Made the Warm StandBy Cold.

Then yesterday… Read more

1 comments, 448 reads

Posted in RumblingDBA on 25 March 2009

Touch Your Resume

One of the pieces of advice that I give in my talk "The Modern Resume" is that you should review, and likely touch, your resume once a quarter. It was a habit I got into when I worked in the corporate world after having a startup company that I worked… Read more

4 comments, 1,497 reads

Posted in The Voice of the DBA on 25 March 2009

Overload & Stress - Part 2

Yesterday I was commenting on how a big part of stress for me is getting that sudden burst of work that leaves me so far behind it seems the only answer is to just work harder - but that doesn't often work.

I think we should all manage our own… Read more

2 comments, 770 reads

Posted in SQLAndy on 24 March 2009

PASS 2009 Summit Site Open

Registration has been open since the last Summit, but this year Bill Graziano and team have released the Summit 2009 site up two months earlier than last year, timed to coincide with the call for speakers. Some highlights from Bill:

  • We’ve increased the number of technical sessions to 168
  • Summit…

Read more

0 comments, 550 reads

Posted in SQLAndy on 24 March 2009

Ada Lovelace Day – Celebrating Women In Technology

Today is Ada Lovelace Day, an international day of blogging to draw attention to women excelling in technology. I don't normally post off-topic things, but this particular subject hits home for me. No, not because the first computer language I learned in college was Ada 95. It's because I… Read more

0 comments, 702 reads

Posted in Kendal Van Dyke on 24 March 2009

Tips for Submitting Speaking Abstracts to the 2009 PASS Community Summit

As most of you know now, the Call for Speakers for the 2009 PASS Community Summit is open from March 20, 2009 through April 10, 2009. Each year, the PASS Program Committee, which is responsible for selecting the sessions offered at the Summit, receives many more speaking abstracts than they… Read more

0 comments, 896 reads

Posted in SQL Aloha on 24 March 2009

Great IT Teambuilding – Star Trek

When I worked at JD Edwards years ago, we were looking for monthly teambuilding exercises that would help our group of 20 stay focused, and ensure we bonded together. We tried a variety of things, we’d plan and discuss ideas at a weekly meeting, and we would rotate the odd-man-out,… Read more

4 comments, 1,470 reads

Posted in The Voice of the DBA on 24 March 2009

Involuntary Mindcasting and some reasons behind Twitter Protected Updates

Can you imagine involuntary mindcasting? Most likely all accounts would be protected; probably Twitter wouldn’t exist at all…

Recently I sent a mail to over 200 twitters inside Microsoft asking why we were using an e-mail alias instead of a protected account for sharing experiences. The first answer was Why… Read more

0 comments, 454 reads

Posted in The Future Computing Appliances and SQL Server on 24 March 2009

Overload & Stress - Part 1

As I gain more experience I've found that stress comes in three forms; stress that is there that you don't see, stress that you recognize but still don't seem to manage, and on rare occasion when you see the stress and manage to change your behavior to fix it. For… Read more

1 comments, 539 reads

Posted in SQLAndy on 23 March 2009

Data Mining With Google Insights For Search

I recently read a NYT article that highlighted how Google search data is being used to predict flu outbreaks at a regional level and in some cases a week to 10 days before they're reported by the CDC. It turns out that a good portion, if not all, of Google's… Read more

0 comments, 800 reads

Posted in Kendal Van Dyke on 23 March 2009

Policy Based Management - On Change Prevent, Doesn't

SQL Server 2008 introduces "Policy Based Management" (PBM) as a way to better manage your servers. This was a feature that I really thought had, and still has a lot of potential for making the life of a DBA easier.

The tagline for PBM is "manage by policy"… Read more

4 comments, 2,405 reads

Posted in The Voice of the DBA on 23 March 2009

PASS 2009 Summit - Call for Speakers is Open

The call for speakers is open through midnight on April 10, 2009, so get busy submitting those abstracts! Work hard on the title and description, make it something that seems interesting and compelling for attendees. Expect the competition to be fierce and if you don't get selected, come to the… Read more

0 comments, 709 reads

Posted in SQLAndy on 22 March 2009

Heads I win, Tails You Lose

Imagine going to a casino with $100 dollars to gamble. As you enter, you notice a vending machine that sells gambling insurance policies. For a small price, the insurance policy will guarantee to replace any losses that you may incur while gambling. So being a prudent person, you buy one.… Read more

0 comments, 586 reads

Posted in SQLSequel on 22 March 2009


I've been amazed at the amount of content that I am getting at SQLServerCentral. So far, in 2009, I've received over 70 articles, usually at the rate of 10-12 a week. Granted some of these are resubmits based on comments I've made, but that's a lot of content.

I used… Read more

6 comments, 565 reads

Posted in The Voice of the DBA on 20 March 2009

Kindle – DCMA Invocation

I’m not sure how I feel about Amazon invoking the DCMA clause to prevent other e-books from being read on the Kindle. On one hand I think that if encryption on other books is being cracked to put them on the Kindle, that’s an issue for other e-book vendors,… Read more

2 comments, 914 reads

Posted in The Voice of the DBA on 20 March 2009


I've been slowly looking at and experimenting with LinkedIn to see if it has value and if so, how to unlock it in a way that works for me. I mentioned it during my series on networking and since I've evolved a strategy that I think is interesting for now,… Read more

33 comments, 850 reads

Posted in SQLAndy on 19 March 2009

Audi A4 Production

I found a cool video on the 37 Signals blog that showed the Audi A4 production process. It’s relatively low budget, not background noise or narration, just clips of the car being assembled.

A nice marketing move. For owners or potential customers, to feel a little closer to the car. Read more

2 comments, 712 reads

Posted in The Voice of the DBA on 19 March 2009

Combining SQL Server & Flash Technologies - Floor Plan example

Starting the summer 2002, for about a year or so, the team and I embarked on a project to develop business for local utilities giant Hydro Quebec, by developing a web site for the twenty-first International Commission on Large Dams' congress in Montreal, where it was hosted in 2003. … Read more

0 comments, 924 reads

Posted in The Database Hive for SQL Server DBAs on 19 March 2009

Newer posts

Older posts