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

Archives: May 2011

MCITP: 2 Down 2 to go

It’s time for the weekly update.  Much like last week, we had more issues with taking this exam today.  I scheduled exam 70-433 for first thing in the morning at a “private” test center.  The registration was easy enough.  The process is a bit different since this test center… Read more

0 comments, 571 reads

Posted in SQL RNNR on 26 May 2011

CTE, Recursion and Math

Earlier this month we had a TSQL Tuesday on the topic of CTEs.  I bailed on my submission because I already posted some CTE examples and was bone dry on what I could write about.

Later I saw a request for some help on creating combinations and permutations from TSQL.… Read more

0 comments, 1,368 reads

Posted in SQL RNNR on 23 May 2011

MCITP 1 Down 3 To Go

Yesterday I posted a quick blurb about my certification plans this year.  Well, ok not full blown plans , but you get the gist.  I announced that I would be taking an exam this morning.  Well, this is to report on that experience.

I scheduled the exam for near first… Read more

8 comments, 697 reads

Posted in SQL RNNR on 20 May 2011


Last year (and this year too) I had set the goal to renew my certification.  I failed miserably at it last year with the exception that I at least bought the vouchers and did a little bit of studying.  I never really set some time aside to achieve that goal.… Read more

3 comments, 503 reads

Posted in SQL RNNR on 19 May 2011

DBA VC Presentation May 11

Come one, come all!!  Oh wait, it’s too late now.  I just finished giving my presentation to the DBA VC (virtual chapter).  There was good attendance and there were good questions asked.  My presentation was the very same presentation that I gave for SQLSat83 (sheepishly: I even used the same… Read more

0 comments, 647 reads

Posted in SQL RNNR on 11 May 2011

May 2011 S3OLV Meeting Reminder

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… Read more

0 comments, 514 reads

Posted in SQL RNNR on 10 May 2011

My Public Events RoundUp

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… Read more

0 comments, 671 reads

Posted in SQL RNNR on 10 May 2011

T-SQL Tuesday #18 – CTEs

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… Read more

2 comments, 679 reads

Posted in SQL RNNR on 10 May 2011

May 2011 S3OLV Meeting

After a whirlwind of last minute changes last month, we expect stability this month with the monthly meeting.

Meeting Time is 6:30PM PST

Erika Bakse (blog | twitter) has been gracious to us by allowing us to pre-empt her last month and then to come back and speak… Read more

0 comments, 565 reads

Posted in SQL RNNR on 3 May 2011

Meme Monday – “I got 99 problems but a disk ain’t one”

Today is Meme Monday and is a little thing that Thomas LaRock (Blog | Twitter)  has started.  Today he has started things off with a list of things that could cause a Database to go “wrong” that are not always disk related.

He has tagged a few people… Read more

2 comments, 898 reads

Posted in SQL RNNR on 2 May 2011