May 2011 S3OLV Meeting Reminder

Categories: News, Professional, SSC
Comments: No Comments
Published on: May 10, 2011

This is a quick reminder of the upcoming May meeting for the Las Vegas SQL Server Users Group.  We will be meeting on May 12, 2011 at the usual time and at the usual place.

We would really like to get a gaggle of database professionals out to support the group and the speaker this month.  Erika Bakse will be treating us to a slick presentation on MDX.  You can see the original info on this upcoming meeting here.  Time, date, meeting info, abstract, etc is all available in that original post.

My Public Events RoundUp

Categories: News, Professional, SSC
Comments: No Comments
Published on: May 10, 2011

As a part of my careers goals, I am trying to remain involved in the community through various engagements and events.  Recently, I was able to present to the South Africa Johannesburg group as a part of SQL Saturday 83.  I posted an announcement on that opportunity here.

I wanted to briefly cover my experience with that presentation.  I was quite pleased with the presentation and know that I could have done better with it.  That is where practice comes into play with each presentation.  One area of concern was trying to invoke group participation.  The group in JHB participated quite well – considerably better than the last time I presented this particular presentation.  I don’t think the book giveaways had much to do with it since I didn’t even mention that.  Also, they were participating well before we did the first book question.  I might have been a bit punchy during the preso – lack of sleep and sinus meds might have contributed.

I would like to thank everybody in JHB for a great job.  It was nice having a panorama camera available so I could see the group too.  That was very helpful.  I have not heard back yet if the recording is going to be made publicly available.  If so, I will pass it along so more of you can poke fun at me. 😉

This week, I will be giving that very same presentation to the DBA Virtual Chapter.  That presentation will be Wednesday May 11, 2011 at 12PM Mountain Time.  Since this is a virtual chapter, that means the presentation will be done via livemeeting.  If you are interested, you can register and attend the meeting via these links.

Registration: https://www.livemeeting.com/lrs/8000181573/Registration.aspx?pageName=c7pzbgr25qrpqxt5

Attendee: https://www.livemeeting.com/cc/8000181573/join?id=P4583F&role=attend

I hope to see a few people on for this presentation.  It is a low-level kind of presentation and is aimed at creating useful documentation with sql scripts (thus helping reduce cost).

T-SQL Tuesday #18 – CTEs

Comments: 3 Comments
Published on: May 10, 2011

To CTE or not to CTE, that is the Question

So my post really has nothing to do with the title.  This is not a post to help you determine whether a CTE is appropriate or not.  Or is it?

This month, we have the 18th installment in the TSQLTuesday series.  We are being hosted by Bob Pusateri  (Blog|@SQLBob) this month.  The essence of the topic this month is around CTEs (common table expressions).  There are a great many uses for a CTE in SQL server and this was a nice addition to the product.

One thing I like about CTEs is how much cleaner the code looks to me.  Another benefit for me is the recursion that is available through the use of a CTE.  An observation about CTEs is that a common use would be to use them to replace inline derived tables (which lends to cleaner looking code for some).

Think Think Think

I gave this topic a good long thought.  As I thought about the topic, I came to the conclusion that I had nothing new or unique on the subject.  I did however have some scripts that I posted once upon a time that would work very well for this topic.  Though it is a bit of a cop out, it is an appropriate solution for this month.

In the case of the CTE that I have chosen, there are multiple CTEs being used.  I use the CTE to recurse through data, and then to recurse that same data again – in reverse.  This particular script was created to traverse through system catalogs and create a hierarchy of table relationships.  I use this hierarchy to better understand the structure of the database and the interrelationship of the data between objects.  It is a cheap way of mapping out the objects in an effort to better understand it.

I had thought about using this script once upon a time for a different TSQLTuesday, but thought better of it that time.  Since the original post is more than a year old, it is a good time to bring it up and use it again.  Without further adieu, you can read about that script and CTE here.  I hope you enjoy.

page 1 of 1

Calendar
May 2011
M T W T F S S
« Apr   Jun »
 1
2345678
9101112131415
16171819202122
23242526272829
3031  

Welcome , today is Sunday, September 15, 2019