Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
Log in  ::  Register  ::  Not logged in

K. Brian Kelley - Databases, Infrastructure, and Security

IT Security, MySQL, Perl, SQL Server, and Windows technologies.

Archives: February 2011

Selecting Speakers for SQL Saturday #70

The Call for Speakers for SQL Saturday #70 - Columbia, SC, ended on February 17, 2011. We wanted to put the schedule up two days later, on February 19, 2011. Last year we had a good number of submissions, but it wasn't a number that was overwhelming. So we… Read more

PASS in Five Years: It's about the Members

Andy Warren (blog | twitter) recently blogged about wanting input on What Should PASS Be? and I think it's a reasonable question to ask. What he is basically saying is, "Okay, member of PASS (or potential member), what do you want PASS to be in the future? After… Read more

Configuring Antivirus for SQL Servers

I've been on both sides of the debate with respect to whether or not to install antivirus software on a server running Microsoft SQL Server. If you decide to go down that route (or you are required to go down that road), here's the guidance you need to read:

Microsoft… Read more

2 comments, 1,952 reads

Posted in K. Brian Kelley - Databases, Infrastructure, and Security on 24 February 2011

PASS Election Review Committee: NomCom Process

 Over on the ERC forums, Bill Graziano (blog | twitter) has posted the proposed NomCom selection process. We would really like your feedback on it. Some highlights:

  • PASS membership (outside of the BoD) make up the majority of voting members.
  • You cannot be on the NomCom if…

Read more

Shameless Self-Promotion - Introduction to SQL Server [Book]

My introductory text to SQL Server, appropriately titled Introduction to SQL Server, is now in print and available for sale. The book is intended to be useful for someone new to SQL Server, typically an end user who is faced with getting data out of Microsoft SQL Server. In this text… Read more

Use Patterns and Prior Code and Don't Reinvent the Wheel

In recent days I've seen folks try to recreate functionality when they had access to code that already did effectively the same thing they needed done. In some cases other folks were able to convince them to look at the code they had in their hip pocket and in other cases… Read more

SQL Saturday #70 - Columbia, SC 2011 Session Schedule Is Up!

As announced, we have posted our session schedule for SQL Saturday #70 - Columbia, SC.  The event will be March 19, 2011 and we've got an even better cast than last year for speakers. It's not too late to register to attend! We had 48 session slots available and 91… Read more

I'm in at SQL Connections!

At the end of March I'll be journeying down with the family to Orlando, Florida. We plan on stopping in to see the Mouse, but while it's not all Disney, it is all pleasure! That's because I'll be speaking at SQL Connections as part of the track. I'm… Read more

SQL University: Home-Grown, with Real Options!

There's the light, as this is the last class for Security week at SQL University. From the scenarios we specified in the introduction class on Monday, this is the last and easiest case we'll ever have with respect to imposing our security mindedness on, but it also can… Read more

SQL University: SQL Server Security Architecture - Home-grown, No Options!?!

Thanks for hanging in there for Day 4 of Security Week here at SQL University. Today we're going to look at the most frustrating scenario that we often come across, and that's where a development team has built an application, but there are few if any options for us on the… Read more

0 comments, 1,086 reads

Posted in K. Brian Kelley - Databases, Infrastructure, and Security on 10 February 2011

Why You Should Attend SQL Saturday #70 - Columbia, SC

Free training. Excellent speakers. Outstanding location. Great networking opportunities. Experienced and efficient event staff. These are the primary things you look for when you're going to give up your Saturday for a SQL Server conference. I'm glad to say that as SQL Saturday #70, scheduled for March 19th in Columbia,… Read more

SQL University: SQL Server Security Architecture - 3rd Party, Some Options

Day 3 of Security Week at SQL University is now in session. You're implementing a third party solution and you have some options on the table for the security model which you deploy. You've gotten there either because the vendor supports some flexibility or because you've negotiated and fought for… Read more

0 comments, 2,208 reads

Posted in K. Brian Kelley - Databases, Infrastructure, and Security on 9 February 2011

SQL University: SQL Server Security Architecture - 3rd Party, No Options

Welcome back to day 2 of Security Week for this semester of SQL University. If you missed yesterday's introduction, you'll probably want to review it first.

The first scenario we'll look at is probably the easiest to consider, because our options tend to be rather limited. This is… Read more

1 comments, 1,322 reads

Posted in K. Brian Kelley - Databases, Infrastructure, and Security on 8 February 2011

SQL University: Architecting SQL Server Security, the Big Picture

Welcome to this semester's security week at SQL University. In previous semesters we've covered the technical aspects of SQL Server security but at some point you've got to put it all together. So this week we're going to talk about putting together an architecture that meets the needs of… Read more

6 comments, 1,715 reads

Posted in K. Brian Kelley - Databases, Infrastructure, and Security on 7 February 2011

Setting the Standard with Personal Appearance

Cross-posted from the Goal Keeping DBA blog:

Personal appearance matters. We all know this. Yet a lot of times we don’t give it the attention that we should. As I’ve struggled with severe migraines over the last year or so, personal appearance was one of those things I did… Read more