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

Archives: October 2009

My PASS Summit 2009 Schedule

Hooray! The PASS Summit is upon us (finally)! Here's what my plans look like for next week:

My week starts with the cross country flight from Orlando to Seattle-Tacoma International, arriving at 1:30 PM (Want to split the fare for a ride into town? Drop a comment, send me… Read more

1 comments, 611 reads

Posted in Kendal Van Dyke on 29 October 2009

Special Events at the PASS Community Summit

If you’ve ever been to a PASS Community Summit, you know that each day is packed with a ton of great activities. Sure the sessions are top notch, unparalleled for technical education pertaining to SQL Server. But there is much, much, more. There are fun networking activities and games…

Read more

0 comments, 443 reads

Posted in Joe Webb on 29 October 2009

OFF-TOPIC: More about the pregnancy

 Quite a few folks have commented about my previous post about missing the PASS Summit, whether publicly or in private. It's hard to keep track of everybody who has, so this is a blanket blog post that explains what the doctors are concerned about.

The condition that raised the… Read more

More Seattle Food

Was browsing on a break and found this, http://www.seattle.com/dining/. Of them I’ve been to Palomino (good) and Ruths Chris (good), neither is cheap. Food for thought! Read more

2 comments, 721 reads

Posted in SQLAndy on 29 October 2009

Need an Aircard for a Few Days?

Ran across this, http://daypasswireless.com/, lets you rent an aircard plus service. Don’t know if it’s too late for those of you travelling to the PASS Summit, but an interesting idea. Rates are not bad. Read more

0 comments, 600 reads

Posted in SQLAndy on 29 October 2009

What Should PASS Strive To Be?

Steve Jones had a good editorial earlier this week entitled, What Do We Want from PASS?.  It didn’t generate as much discussion as I would have thought, but the discussion is worth reading.  A couple of the posts mention how PASS does not seem to do anything to… Read more

2 comments, 897 reads

Posted in Wise Man or Wise Guy on 29 October 2009

There was a rancher who had a DBA.... (Getting prepped for PASS)

and B-I-N-G-O was his game-o.

Maybe not that funny, but I think that SQL Bingo will be a fun time. If you haven't heard of it, check out the link. Stuart Ainsworth, Blythe Morrow, and Brent Ozar have put together a fun networking game sponsored by Quest and SQLServerPedia. They've… Read more

5 comments, 761 reads

Posted in The Voice of the DBA on 29 October 2009

Featured Blogger: Aaron Bertrand

I’ve been reading Aaron’s blog for a while, he’s prolific and consistently interesting – and definitely a technical focus. He’s been publishing a weekly “Connect Digest” of all the stuff going on at MS Connect (for bugs & suggestions) and lately he’s had a great run on bad habits to… Read more

2 comments, 632 reads

Posted in SQLAndy on 29 October 2009

Don’t Be This Guy

I have a sad story to tell you.  Sit down and grab a tissue.

It was 10pm on a cool night in September 2005.  Somewhere in Grapevine, Texas, a junior SQL Server professional was sitting alone in a hotel room watching TV.  He was tired but not exhausted, having spent… Read more

2 comments, 647 reads

Posted in Tim Mitchell on 29 October 2009

Crazy Egg

I know, I should have put more in the title. Crazy Egg is a web page traffic analysis tool that focuses on visualization. You sign up for an account (starting at $10/month), add a line of code to the page you want to monitor (or your master page), and then… Read more

0 comments, 526 reads

Posted in SQLAndy on 28 October 2009

Amazon.com Author Central Page

If you are a book author, Amazon.com now allows authors to promote their books with a new author’s page. The new feature is called Author Central.

Mine is at:


The page allows you to add a photograph, a short bio, your blog RSS feed, and even a discussion… Read more

1 comments, 560 reads

Posted in SQL Aloha on 28 October 2009

Replication Setup:


I saw too many questions on forum asking step by step process of configuring replication I have these links in my favorites so though consolidating it.

For Sql Server 2000:

Snapshot Replication setup:

By Alexander Chigrik 


Transaction Replication setup:

This is by Alexander Chigrik at database journal you can… Read more

0 comments, 1,018 reads

Posted in Vinay Thakur on 28 October 2009

I Started a Fight

I had no idea, but evidently I started a bit of a donny-brook. Cool!

Read more

1 comments, 539 reads

Posted in The Scary DBA on 28 October 2009

Snags With Profiler GUI

Running the Profiler GUI against a production server is not something you should do. I’ve outlined my research into exactly why in the past. But I hit another little issue with the Profiler GUI as part of work I’m doing on a Microsoft PSS call (more on that in…

Read more

0 comments, 763 reads

Posted in The Scary DBA on 28 October 2009

Electronic Health Records – What’s the Big Deal? (Part 2)

In the first installment of this discussion, I talked about the challenges facing database professionals and others with respect to healthcare data integration.  In this post I’ll talk about the first part of the problem: a lack of adoption of the required technologies and/or methodologies.  I’ll also describe when… Read more

17 comments, 1,714 reads

Posted in Tim Mitchell on 28 October 2009

My Schedule for the PASS Summit 2009

For the most part, I have an easy schedule. I’ll be in the 600 hallway most morning after the keynote on one of the couches. Likely I’ll have a few friends nearby.

While I pop in and out of some sessions, I’m really there to meet people, catch up with… Read more

2 comments, 678 reads

Posted in The Voice of the DBA on 28 October 2009

How Many Rows Have Changed?

One of the things that I've asked DBAs, and I see asked often, is how much does your data change? That affects the transaction log sizes (and backups), the load on your server, possibly the tuning and specs you want to implement, etc. But most DBAs don't have any clue… Read more

1 comments, 2,322 reads

Posted in The Voice of the DBA on 28 October 2009

My Schedule at the Summit/Let’s Connect

I’m flying out Sunday via Alaska Air, taking the direct flight from Orlando to Seattle, arriving at 11:40 am. If you’re there about the same time and want to share a ride in, email me. I’m staying at the Sheraton only because that’s where the Board stays, otherwise I’ve always… Read more

10 comments, 1,142 reads

Posted in SQLAndy on 27 October 2009

2009 PASS Community Summit and SQL Server Connections Conference, Both in November


If you will be attending either the 2009 PASS Community Summit in Seattle, WA, from November 2-5; or the SQL Server Connections Conference in Las Vegas, NV, November 9-12, please stop by and say hello.

I will be making two presentations at both events, and I hope that you can… Read more

0 comments, 403 reads

Posted in SQL Aloha on 27 October 2009

Get Your SQL Server Questions Answered at ASK.SQLServerCentral.com

While the SQLServerCentral.com forums have always been a popular way to get your SQL Server questions answered, and to participate in the greater SQL Server Community, SQLServerCentral.com is now offering a new feature called Ask.SQLServerCentral.com, which is a new way to find answers to your SQL Server questions. You… Read more

1 comments, 773 reads

Posted in SQL Aloha on 27 October 2009

Newer posts

Older posts