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

Advice from Aunt Kathi

Kathi Kellenberger is a Sr. Consultant with Pragmatic Works. She is an author, speaker and trainer.

PASS Report

Somehow between the sessions, networking and socializing I never found time to post anything last week. So, I'm going to post two summaries, one for what I learned, one about the social stuff.


I attended Itzik Ben-Gan's all day pre-con session. He covered a lot of material and it…

Read more

0 comments, 1,162 reads

Posted in Advice from Aunt Kathi on 23 September 2007

CTEs and where have I been?

I haven't posted much lately, but it has been a busy few months with many family activities.  At work, I am happy to say that we are in the middle of upgrading our financial system, which includes an upgrade from SQL Server 2000 to SQL Server 2005 64 bit.  Basically,… Read more

0 comments, 388 reads

Posted in Advice from Aunt Kathi on 9 July 2007

Stored procs vs user defined functions

I was at DevTeach/SQLTeach in Montreal last week. The conference was very well run and the organizers did a great job. I gave two presentations, one of which was "T-SQL for Beginners".

During the presentation, a member of the audience asked me a question that I never really thought about… Read more

0 comments, 1,105 reads

Posted in Advice from Aunt Kathi on 19 May 2007

Conditional formatting in Reporting Services

Yesterday's post reminded me of another interesting technique I have used to change the color of the values on a report based on a range. Let's say I wanted the color of a field to be black if the value was between 0 and 10, blue if between 11 and…

Read more

0 comments, 1,147 reads

Posted in Advice from Aunt Kathi on 11 March 2007

Using IIF in Reporting Services

I found an interesting use for the IIF function in a Reporting Services report this week. I needed to provide a report of users and the schedule date for migrating them to our new workstation image or the date that they were migrated. The people viewing the report are mostly…

Read more

0 comments, 1,512 reads

Posted in Advice from Aunt Kathi on 10 March 2007

SQL Server Learning Opportunities!

There are two big SQL Server learning opportunities I want to remind you about.  First, DevTeach/SQLTeach will be held in Montreal May 14 - 18.  I will be speaking there this year on beginning T-SQL and new T-SQL features of SQL Server 2005.  The second talk will cover error trapping,… Read more

1 comments, 1,600 reads

Posted in Advice from Aunt Kathi on 9 March 2007

Phone books and Indexes

On Wednesday I gave a presentation to the St. Louis Visual Basic.Net user group.  I really enjoy speaking to this group, they never look like they are falling asleep and we always have a lively discussion.  I spoke about indexes, using estimated query plans to troubleshoot queries and the procedure… Read more

0 comments, 1,153 reads

Posted in Advice from Aunt Kathi on 22 December 2006


We recently received a script for a modified stored proc from a vendor.  My colleague ran the script on the test database, but the application owner wasn't ready to test the new functionality.  My colleague knew she had to revert back to the old proc and scripted out the proc… Read more

0 comments, 1,964 reads

Posted in Advice from Aunt Kathi on 15 December 2006

The Moto Q and Being Proactive

I am a big fan of automating whatever I can and being proactive.  The more proactive you can be, the less fires to put out and the less stress you have.  I was reading the 7 Habits book at one time which suggests that you can carry around a little… Read more

0 comments, 1,309 reads

Posted in Advice from Aunt Kathi on 14 December 2006

Inserting missing rows

I can think of three ways to insert just the missing rows from one table or query into another table. 

The first way is so ugly that I hate to even bring it up, yet I know that there are developers and (gasp) DBAs using this very technique.  Basically, you create… Read more

0 comments, 1,325 reads

Posted in Advice from Aunt Kathi on 6 December 2006

Bad weather and Power Outage

After years of mild weather in the St. Louis area, this is the second time we have been hit hard in a year.  In July, two storms in one week left hundreds of thousands of homes without power in 95 degree plus temperatures (F) .  On Thursday afternoon this week, an… Read more

0 comments, 1,152 reads

Posted in Advice from Aunt Kathi on 2 December 2006

Data Dude

I went to an abbreviated version of the Visual Studio 2005 Team Edition for Database Professionals launch this morning. The reason for the shorter than usual launch is because freezing rain began falling mid-morning making roads treacherous. They thought we would appreciate getting out of there early. St. Louis has… Read more

2 comments, 1,363 reads

Posted in Advice from Aunt Kathi on 30 November 2006

SSMS and scripting

I've heard a lot of complaints about SQL Server Management Studio concerning slowness and some of the things, like scripting out objects into individual files, that are missing.  I have been using it to manage my SQL Server 2000 and 2005 servers for several months and have gotten used to… Read more

0 comments, 1,185 reads

Posted in Advice from Aunt Kathi on 28 November 2006

Default schema

Sadly, I haven't had much experience yet with SQL Server 2005 except for Reporting Services and SSIS. The majority of my databases are for third-party
applications that are not yet certified for SQL Server 2005 or require an upgrade so I'll be running 2000 for quite awhile at work.

This… Read more

0 comments, 1,208 reads

Posted in Advice from Aunt Kathi on 27 November 2006

Back from PASS

While at PASS, I created a thread in the forums: http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=61&messageid=322277 .  It was an incredible week.  I look forward to implementing many of the things I learned about.

Attending the Summit as a volunteer is a totally different experience.  You meet someone like Bill Graziano from working on a… Read more

0 comments, 1,130 reads

Posted in Advice from Aunt Kathi on 20 November 2006


My daughter-in-law just reminded me on Sunday that her birthday was in 21 days.  Yikes! That's the day I fly to Seattle for PASS.  I can't believe it is almost here.  Anyway, I'll be at PASS from Sunday through Saturday morning and am looking forward to meeting lots of new…

Read more

0 comments, 1,129 reads

Posted in Advice from Aunt Kathi on 26 October 2006

Jumpstart TV Video

If you are new to SQL Server, you might be interested in viewing a video that covers the terms you use when working with T-SQL: http://www.jumpstarttv.com/Media.aspx?vid=35 .  I plan to record many more videos on T-SQL and am working on the second one now.


  Read more

0 comments, 1,378 reads

Posted in Advice from Aunt Kathi on 11 September 2006

RegCreateKeyEX() error

I just began migrating SQL Servers (2000) to Windows 2003 from Windows 2000 a few months ago.  In the past, I never had to add the start up account to the local administrators group.  Now that we are moving to Windows 2003, I had to start adding the start up account… Read more

0 comments, 2,698 reads

Posted in Advice from Aunt Kathi on 27 March 2006

PASS 2006 Call for Presentations

For those of you who are interested in speaking at PASS in November, the submission site is open: http://passew.prod.web.sba.com/callpapers/CallPapers.cfm?conference_id=15 .

I encourage you to submit your abstract!  Read more

0 comments, 1,123 reads

Posted in Advice from Aunt Kathi on 9 February 2006

Upgrading your databases link

I got the link from Kirk about the couse: http://www.maxtrain.com/classes/classInfo.aspx?id=SQLADV .

Read more

0 comments, 1,147 reads

Posted in Advice from Aunt Kathi on 2 February 2006

Newer posts

Older posts