Thoughts on SSSOLV December Meeting

This is very late – I know.  The meeting was held on December 8, 2011 and I haven’t yet shared my recap/thoughts about the meeting. We hold the SQL Server Society of Las Vegas user […]

January 2012 Las Vegas SQL UG

This month I am attempting to get a jump on things a bit.  I am hoping to get the info out in a more timely fashion throughout this new year for the User Group meetings […]

December Recap

The past few months I have been pretty busy.  December is no exception to that.  Between normal work, moonlighting as a general contractor on my own basement, and trying to keep up with my family […]

My Top 5 for 2011

I have seen a few recap posts bouncing around the net and started thinking about my own blog.  So out of curiosity, I decided to take a look at my top 5 posts for 2011. […]

Public Role and Security

A good rule of thumb with the public role is to leave it be.  Do not add permissions to this role.  Add permissions on a per database  and per group of users basis.  Create roles within the database and grant permissions to that role – in each database.  And remember the rule of least privilege – don’t grant more permissions to a user/role than necessary to perform the job function.  Just the same as in an airport – everybody has their role and it is strictly defined.  If the user need not have access – then don’t grant the permissions.

Why do I Blog?

Last week I heard about a new blog party/meme coming down the pipe for the #SQLFamily.  This new meme is Meme15 and is the pet project of Jason Strate (Blog|Twitter).  Here is the announcement. So, as […]

T-SQL Tuesday #025 – Holiday Gifts

Tis the Season It is the season for TSQL Tuesday.  More importantly it is the season for giving and reflection.  And whether you celebrate Christmas or Chanukkah or Kawanzaa or TSQLTuesday because you believe or […]

MCITP: 4 Down 0 To Go

Yay.  I finally took the plunge and decided to take Exam 70-451.  This is the MCITP exam for the SQL 2008 Dev track. Frankly, I had taken my time with this one because I was a […]

December Event Reminder

We are now only two days away from the biggest event of the week!!   More accurately though, it is the BIGGEST event for the Las Vegas chapter of PASS between 6:30Pm and 8:30PM Pacific. […]