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

Archives: September 2005

PASS 2005: Day Three

Day Three of PASS had a decidedly better start than did the previous day.  After finally figuring out the effective functionality of a hotel room digital alarm clock, I woke early and arrived at PASS in time for breakfast.  To the detriment of my attempt at healthy eating, the definition… Read more

0 comments, 1,289 reads

Posted in Tim Mitchell on 29 September 2005

PASS 2005: Day Two

Day Two at PASS started out on a sour note. Rewind about 36 hours, to when I was checking in to the hotel. “Mr. Mitchell, would you like a wake-up call for tomorrow morning?” asked the teenage clerk behind the counter. No, I replied, I prefer to use the alarm… Read more

0 comments, 1,533 reads

Posted in Tim Mitchell on 28 September 2005

PASS 2005: Day One

This year, I have the opportunity to attend the SQL PASS event in Grapevine, Texas. This is my first PASS event, and only my second time to attend any SQL Server conference. By the end of the first day, I can say that this trip appears to be well worth… Read more

0 comments, 1,399 reads

Posted in Tim Mitchell on 28 September 2005

PASS Prizes

We get a referral fee from PASS for each person that registers for the Summit with the "SSC" source code. It's their way of showing us that they appreciate our efforts at promoting the conference.

But that fee isn't why we do it. All three of us (Andy, Brian, and…

Read more

0 comments, 1,650 reads

Posted in The Voice of the DBA on 27 September 2005

MySQL 5.0 Release Candidate Released

The release candidate for MySQL 5.0 is out. This little database is really growing up.


Read more

0 comments, 1,361 reads

Posted in K. Brian Kelley - Databases, Infrastructure, and Security on 27 September 2005

September CTP Issues

The September CTP of SQL Server 2005 is not available and I'm sure lots of people have downloaded it. I actually grabbed it the night before it was announced, got some pre-release info :), and got it burned onto a CD. Or I got the downloaded EXE burned at least.

Read more

0 comments, 1,422 reads

Posted in The Voice of the DBA on 23 September 2005

New Server

Surprisingly the DELL server showed up late Friday afternoon last week when I was expecting more of a Wed-Thur delivery this week. It was a pretty small box, only about 2/3 or so of the length I expected. Since I'd grabbed an LCD monitor as well I wasn't actually sure…

Read more

0 comments, 1,421 reads

Posted in The Voice of the DBA on 20 September 2005

Thinking about PASS

With PASS just a little over a week away, I realized that I had better fine-tune my presentation and practice this weekend. The past few months have been crazy for me at work and at home. I've been just moving from deadline to deadline, and the presentation has been on the… Read more

0 comments, 1,297 reads

Posted in Advice from Aunt Kathi on 18 September 2005


I setup an announcement for today (Sept 14) that the Sept CTP for SQL Server 2005 was released and that Database Mirroring is disabled. It's also got more language support and a few other things.

Apparently, however, my coding skills were a bit challenged. I forgot a primary rule in…

Read more

0 comments, 1,420 reads

Posted in The Voice of the DBA on 14 September 2005


Bill Gates keynote is on webcast now, grab it and check it out.

Also a hint. Paul Flessner is speaking tomorrow and he always has the big SQL Server information, so take a look tomorrow for more information.

Read more

0 comments, 1,427 reads

Posted in The Voice of the DBA on 13 September 2005

Let database work for your daily life

I know there are many off-shelf stuff, like MS Money, that can help you organize your personal financial things, but I still prefer to do these by myself, so here is how I do:

Always download my credit card transactions / bank statement to an Excel sheet, and then use… Read more

0 comments, 1,319 reads

Posted in DBA Philosophy on 11 September 2005

about xp_sendmail

I got a very interesting issue, I may guess the reason but not sure why it is this way.

Symptom: Logon to a SQL Server (Server_A) through QA with Windows Authentication (my domain account Domain\JeffYao has sa priviledge), then try to run the following statement

-- the following is SQL_Statement_1
    exec… Read more

0 comments, 1,342 reads

Posted in DBA Philosophy on 9 September 2005

Careful Blogging

I still not sure that this blog service was a great idea, but some of you seem to like it, so we'll keep it going. Who knows, maybe this will be the most popular part of the site one day :)

However I ran across this article on corporate blogging

Read more

0 comments, 1,357 reads

Posted in The Voice of the DBA on 8 September 2005

one issue about SQL 2000 BOL

This is my first post, congrats to myself. :-)

DTS Connection object does not list "UseTrustedConnection" property

I am working on a DTS package where I'd like to reset the connection authentication from Windows to SQL Server with user id and password. I tried to search the properties under Connection object,… Read more

0 comments, 1,332 reads

Posted in DBA Philosophy on 8 September 2005

In praise of three day weekends!

I guess it might be because I have been so busy for the last two months with the book, but this has been a fantastic and relaxing weekend. I was able to visit my parents and spend time with my grown daughter. I also managed to complete a few things on… Read more

0 comments, 1,226 reads

Posted in Advice from Aunt Kathi on 5 September 2005

Head back up above water

I've spent the last few weeks writing SOX documentation, more SOX documentation, and even more SOX documentation. A lot the documentation doesn't directly relate to financial reporting, but what can you do? Any case, I should be active again on the forums and hopefully I'll be contributing more to the…

Read more

0 comments, 1,371 reads

Posted in K. Brian Kelley - Databases, Infrastructure, and Security on 2 September 2005

Of anarchy and thin veneers...

Following the horrifying stories that are unfolding in the aftermath of Katrina, it is difficult for the mind to single out any one of them as more tragic than others. I listened to a woman cry on the radio because her dog was left behind in her apartment and her…

Read more

1 comments, 1,295 reads

Posted in Sushila on 2 September 2005

The Data Center in New Orleans

There's a blog running at LiveJournal from one of the guys at directnic. There's evidently an ISP that is still running down in New Orleans.

It's an amazing account, albeit a little rough in places.

Read more

0 comments, 1,457 reads

Posted in The Voice of the DBA on 2 September 2005