This second chance, gives me the opportunity to finally talk about a topic that has been on my to-blog list for quite some time. I hope this post will show some different ways of joining in TSQL.
TSQL Tuesday #26 or #23 – Identity Crisis
Category: SSC
S3OLV update and Reminder
We are now just a few days away from our first meeting of 2012. We have some good content lined up. Check it out here. I am looking forward to the presentation on XML and […]
Meme Monday January 2012
Meme Monday was pushed back this month to the second Monday of the month. That is a good thing or maybe a bad thing or maybe a non-discussion at all. I guess it really depends […]
Daemon
At the recommendation of Jorge Segarra (Blog | Twitter), I got the book Daemon. Well, I actually got that about a year ago as a gift – but it was on my list of books […]
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. […]
Filtering in SSMS
Do you spend seconds, maybe even minutes trying to find things in SSMS? Ever find yourself scrolling up and down thrown the tree trying to find that one specific object you seek? Did you know […]
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.