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

Archives: October 2009

SQL Server Standard, Volume 6, Issue #1

It’s alive! It’s alive!

That’s enough from Colin Clive.

It’ll be out for the Summit. SQL Server Standard lives again! Although, not quite in the same shape as it used to be. But hey, stitching stuff together out of dead tissue is messy work.

I want to thank our…

Read more

2 comments, 633 reads

Posted in The Scary DBA on 27 October 2009

SQL University: Diving into Authorization

It's good to see all your bright and chipper faces here at SQL University. Hopefully you've digest Monday's lesson on Authentication. Today we're going to discuss Authorization. Now Authorization can only take place after Authentication has been accomplished. If SQL Server doesn't know who you are, it can't… Read more

2 comments, 5,955 reads

Posted in K. Brian Kelley - Databases, Infrastructure, and Security on 27 October 2009

Four New Zealand Cities are Final Stops on 30 Day Speaking Tour

After making seven presentations in Australia, I headed to New Zealand where I made four presentations in four cities, on four successive days. Because my schedule was so packed, I only got a couple of days in Auckland (New Zealand’s most populace city) to visit the sites.

The photo is… Read more

1 comments, 440 reads

Posted in SQL Aloha on 27 October 2009

Deterministic Functions

Do you know what determinism is? It's something that comes up periodically in Books Online as various SQL objects require deterministic functions. Things like indexes views.

I ran across a question on this for our ASK site, and thought it was interesting. I started to reply, then had to double… Read more

1 comments, 1,714 reads

Posted in The Voice of the DBA on 27 October 2009

Where Will We PASS Each Other?

In my a post on Monday, I talked about who I want to meet while at the PASS Summit.  Today I’m going to post where I plan to be while at the Summit.


I’m scheduled to fly into Seattle at 6pm, which means I hope to be at… Read more

5 comments, 791 reads

Posted in Wise Man or Wise Guy on 27 October 2009

Book Review: Murach’s JavaScript and DOM Scripting by Ray Harris

In early September I received a complimentary copy of Murach’s JavaScript and DOM Scripting by Ray Harris (Amazon) to review.  I got the book because my friend, Andy Warren, passed my name along to the publisher when they asked him to review the book.  He knew I was… Read more

1 comments, 450 reads

Posted in Wise Man or Wise Guy on 26 October 2009

Annoyed with LinkedIn

Funny how tools can surprise you. I’ve had in mind to set up a sub-group and invite all the SQLSaturday #21 attendees, encourage post event networking. I’ve imported contacts before and it worked well, so went to do it today for a subgroup and as far as I can tell,… Read more

0 comments, 541 reads

Posted in SQLAndy on 26 October 2009

Notes on a Migration from Oracle to SQL Server


I have to admit, when asked to perform a migration from Oracle to SQL Server over the past couple of months, I was a bit apprehensive.  After having passed an all-nighter to finish the project off recently, starting at 3pm, and finally heading home around 6:30am, there was…

Read more

0 comments, 545 reads

Posted in The Database Hive for SQL Server DBAs on 26 October 2009

Special Events at PASS Summit

Besides giving two Community Session presentations (here and here), next week, I will be involved in the Birds of a Feather (BOF) Lunch on Tuesday, November 3 at 11:30AM and the SQL Server MVP Deep Dives Book Launch and Signing on Wednesday, November 4 at 11:30AM. These are… Read more

0 comments, 553 reads

Posted in Glenn Berry's SQL Server Performance on 26 October 2009

Beginning T-SQL 2008

My book "Beginning T-SQL 2008" came out about two weeks ago. http://www.amazon.com/Beginning-T-SQL-2008-Kathi-Kellenberger/dp/1430224614/ref=sr_1_1?ie=UTF8&s=books&qid=1256604424&sr=8-1 It's a beginning book because I assume that the readers know nothing about T-SQL. I wanted to make sure that beginners get off to the right start, so I talk a lot about performance and cover some of the… Read more

3 comments, 714 reads

Posted in Advice from Aunt Kathi on 26 October 2009

SQL Saturday #21 (Orlando) Presentation Downloads

Here are the slide decks and code samples from my sessions at SQL Saturday #21 Orlando on 10\17. I've also cross posted these over on the SQL Saturday #21 event site.

Download: Performance Tuning With DMVs
Download: Configuring SQL Access for the Web Developer & Admin

Read more

0 comments, 379 reads

Posted in Kendal Van Dyke on 26 October 2009

SQL Saturday #21 (Orlando) Recap

Saturday, 10\17, marked the third year for SQL Saturday here in Orlando and each year it gets bigger and better. With 56(!) sessions across 9 tracks and some big name speakers there was plenty of SQL goodness for everyone who came out for the day.

Pre-Event Happenings
Although the main… Read more

0 comments, 731 reads

Posted in Kendal Van Dyke on 26 October 2009

DRP for SQL Server in French - traduction en français du plan de relève – part 5

Here I go again, trying to finish up the translation. Thank you very much to local MVP Eric Moreau for his help fixing my mistakes so far :)Here's a complete final draught en français.

Configuration de l'instance SQL Serveur


Nos serveurs exploitent la version 64-bit de moteur de la base… Read more

0 comments, 777 reads

Posted in The Database Hive for SQL Server DBAs on 26 October 2009

People I Can’t PASS on Meeting

One week from today I will be in Seattle for my first ever PASS Summit.  One of the things I have heard is what a great event this is for networking with other SQL Server people.  I think I’ve been able to experience this in a small way at… Read more

3 comments, 563 reads

Posted in Wise Man or Wise Guy on 26 October 2009

Expert SQL Server 2008 Encryption

Encryption is a tough subject, but it’s one that’s fascinated me for years. I downloaded PGP when it came out nearly two decades ago, and learned about the intricacies of symmetric and asymmetric keys. I thought it was fun, even when I couldn’t convince many people to consider using it. Read more

0 comments, 939 reads

Posted in The Voice of the DBA on 26 October 2009

One Week until PASS 2009

It's one week until the PASS Summit. At this time next week I'll be on a plane, heading to Seattle with a weeks worth of clothes and a bunch of prizes to give away. This will be my 8th or 9th Summit, and the 5th or 6th one I've attended… Read more

0 comments, 593 reads

Posted in The Voice of the DBA on 26 October 2009

Starting the Travel Tips Meme

‘Tis the season for travel!  With the PASS Summit just around the corner and lots of other interesting events waiting in the wings, such as TechEd Europe, lots of IT people will finally be allowed to stretch their wings (and budgets) to get in some first class training.

I’ve been… Read more

0 comments, 538 reads

Posted in Kevin E. Kline on 26 October 2009

SQLSaturday Sensation in NJ

 Well, it's a wrap!  Saturday has come and gone, but memories will go on.  It was great to see so much effort and planning in a relatively short time to come together in one great event.   I had a fantastic time.  If you missed it, no worries, much discussion and…

Read more

1 comments, 679 reads

Posted in Pearl Knows on 26 October 2009

My Eval Results from SQLSaturday #21

I presented Social and Not So Social Networking for the DBA. Of the attendees, 16 submitted an eval. Here are the results:


  • Did Not Meet : 0
  • Met: 6
  • Exceeded: 10


  • Quality 1: 0
  • Quality 2: 0
  • Quality 3: 0
  • Quality 4: 4
  • Quality 5: 12


  • Brilliant

Read more

2 comments, 507 reads

Posted in SQLAndy on 25 October 2009

Business Cards – Again

I posted some thoughts on business cards awhile back, had used up the ones I had and was time to get some more, especially with the PASS Summit coming up and a greater emphasis on networking. I’m breaking with tradition, sorta, this time!

First, I decided to order some cards… Read more

5 comments, 627 reads

Posted in SQLAndy on 25 October 2009

Newer posts

Older posts