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

Archives: September 2011

Data Head

Well, it’s official.  I am a Data Head.  It doesn’t change too much my level of geekiness.  But I may have to rethink one of the answers given during that interview.

The Data Head profiles are being done by a training company called Data Education.  The company is another… Read more

2 comments, 761 reads

Posted in SQL RNNR on 27 September 2011

In The SQL News

There is a lot of stuff going on out there these days.  I am looking forward to a few things.  And since I am looking forward to them, I thought there are others out there that are probably interested too!


SQL Server MVP Deep Dives 2:  The first… Read more

2 comments, 544 reads

Posted in SQL RNNR on 23 September 2011

September Performance Contest

This month SafePeak is sponsoring a contest centered around improving performance in SQL Server.

The host of the contest is my friend Robert Pearl.  You can read the announcement from him about the contest here.  In that link you can also read his submission.  After reading that link by… Read more

0 comments, 1,072 reads

Posted in SQL RNNR on 21 September 2011

Stored Procedures – Common Security Practice

In SQL Server a good practice is to access the data via calls through stored procedure.  Have a look at the document available in that link.

To further this practice, one may create a database role, then add users to that role.  Permissions to execute the stored procedures would… Read more

0 comments, 886 reads

Posted in SQL RNNR on 20 September 2011

Performance Tuning – Over the Top Biz Logic

This month, Robert Pearl is helping to host a Performance Story contest.  The contest is being sponsored by Safe Peak, and you can see more about it – here.

The timing on this contest actually fits well with something I have already been working on.  The only delay has… Read more

2 comments, 1,763 reads

Posted in SQL RNNR on 19 September 2011

Column Level Permissions

Did you know that you can grant permissions down to the column level in SQL Server?   Well, if you didn’t know that – you do now.

It is actually rather simple to grant permissions at the column level.  This can be demonstrated by the following script.

Read more

0 comments, 1,644 reads

Posted in SQL RNNR on 19 September 2011


It has been a looooong time since I wrote a little book review.  It’s nice to take time out with a little fantasy to ease and please the brain.

Just because I haven’t written a review in a long time doesn’t mean that I stopped reading books.  I actually have… Read more

0 comments, 542 reads

Posted in SQL RNNR on 16 September 2011

What Happens in Vegas…

…Need not Stay in Vegas

Coming to Las Vegas in 2012 is an event many have been waiting for.  Those that have been waiting for this event are the SQL professional type.  And believe me, it will be good.

A few friends and I have begun work on putting together… Read more

3 comments, 740 reads

Posted in SQL RNNR on 14 September 2011

T-SQL Tuesday #22 – Data Presentation

Tuesday is upon us.  It also happens to be the second Tuesday of the month and you know what that means.  It is time for TSQL Tuesday.  This month, Robert Pearl, a friend, is hosting.  Read his invitation here.

As the invitation suggests, this topic is wide open.  There… Read more

0 comments, 667 reads

Posted in SQL RNNR on 13 September 2011

Hustle and Bustle to Kick off September

September is kicking off with a boom for me.  In one week, it seems I will be here, there and everywhere.  Between SQL, PASS, Family, and User Group – this is shaping up to be quite the week.

Here’s a quick run down of this weeks agenda.

Cross Country

My… Read more

0 comments, 802 reads

Posted in SQL RNNR on 7 September 2011

S3OLV September 2011

I really meant to get this post out last week.  My apologies, but here is the post finally.  Along with the post, I also had meant to get the invites for Livemeeting and from Evite for the meeting out – but failed there too.

Now that I have finally got… Read more

0 comments, 773 reads

Posted in SQL RNNR on 6 September 2011

Windows 7

The other day I logged on to my backup laptop (Win 7 N 64 Bit) and had this nice little warning and error message to greet me.  My activation had failed and had been nagging me from the systray.  Too bad I ignored it for a month or so.

Now… Read more

0 comments, 576 reads

Posted in SQL RNNR on 1 September 2011