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

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

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

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

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

http://www.mysql.com/news-and-events/news/article_959.html

Read more

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

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

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

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

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

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

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

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

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

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

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

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

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