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

K. Brian Kelley - Databases, Infrastructure, and Security

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

Archives: October 2009

Not Attending/Presenting at SQL Connections

Given everything that has happened in the last couple of weeks, this is not surprising to those who have kept up with my family's most recent struggle. I had one more big decision to make from a professional side of things and that was whether or not to still attend… Read more

1 comments, 1,374 reads

Posted in K. Brian Kelley - Databases, Infrastructure, and Security on 31 October 2009

OFF-TOPIC: God is Still Good, Even as We Mourn

Kimberly and I went to the high risk doctor's office this morning for the ultrasound. Unfortunately, they realized very quickly that both children had passed away. There was no heartbeat. They suspect Twin-to-Twin Transfusion syndrome. We are in mourning and have begun the procedures to ensure Kimberly's health. Support from… Read more

SQL University: Multiple Paths and Ownership Chaining

Welcome back to our last class this term on security in SQL Server here at SQL University. According to the syllabus, you should be picking up history next week with Jorge Segarra. SQL Server has a rich history. I know you'll enjoy the coming week. However, before we move on,… Read more

1 comments, 2,504 reads

Posted in K. Brian Kelley - Databases, Infrastructure, and Security on 29 October 2009

OFF-TOPIC: More about the pregnancy

 Quite a few folks have commented about my previous post about missing the PASS Summit, whether publicly or in private. It's hard to keep track of everybody who has, so this is a blanket blog post that explains what the doctors are concerned about.

The condition that raised the… Read more

SQL University: Diving into Authorization

It's good to see all your bright and chipper faces here at SQL University. Hopefully you've digest Monday's lesson on Authentication. Today we're going to discuss Authorization. Now Authorization can only take place after Authentication has been accomplished. If SQL Server doesn't know who you are, it can't… Read more

2 comments, 6,117 reads

Posted in K. Brian Kelley - Databases, Infrastructure, and Security on 27 October 2009

SQL University: Authentication and Authorization

Welcome back to class, folks, here at SQL University. This week we're going to take a look at the basics of security for SQL Server. Since this is an introductory class, we're going to focus primarily on SQL Server itself, only delving into the operating system when we have… Read more

4 comments, 10,545 reads

Posted in K. Brian Kelley - Databases, Infrastructure, and Security on 25 October 2009

Another Year, Another Missed PASS Summit

This year I was really looking forward to going to the PASS Summit. It's worth every penny in the knowledge you'll gain and the networking opportunities you'll encounter. You know, a lot hasn't been said on the later, but let me throw my two cents worth in here (since we're… Read more

Habits and Activities for De-Stressing

I was chatting on FaceBook today with a guy from my church who is learning to be a network engineer. He's a smart guy and his dad is in IT, too. John is his name and he has helped me in the past with IT-related work that we needed to do… Read more

Review: ASUS Eee PC 1005HA Netbook

Our home desktop was several years old and due for replacement. I still have my Dell laptop, and it's still more than powerful enough to do everything I need it to do. Plus, I have a work laptop that's more than sufficient as well. We moved my wife to a MacBook Pro,… Read more

5 comments, 2,231 reads

Posted in K. Brian Kelley - Databases, Infrastructure, and Security on 19 October 2009

Vetting the PASS Board of Directors candidates

I've had a pretty heavy involvement in Brent Ozar's interview of Matt Morollo. The reason for my intense activity is he was an unknown factor to me. I interact with Thomas LaRock and Jeremiah Peschka on almost a daily basis through Twitter. I follow their blogs. I exchange emails with them. There… Read more

3 comments, 1,350 reads

Posted in K. Brian Kelley - Databases, Infrastructure, and Security on 16 October 2009

Are you sticking to your goals? Do you know what they are?

I've engaged a little in the discussion on Matt Morollo's interview on Brent Ozar's blog. It made me go back and re-read the other candidates, and when re-reading Brian Moran's, I was struck with this comment:

"I’ve learned over the years that there are a lot of things… Read more

2 comments, 1,179 reads

Posted in K. Brian Kelley - Databases, Infrastructure, and Security on 15 October 2009

Afraid of Presenting? Try Toastmasters

I should be writing a technical post in the next day or so. I've been focusing more on the community and professional development side because that's what is foremost in my mind right now. And that brings me to public speaking. I will admit that I've had a lot of experience… Read more

1 comments, 1,308 reads

Posted in K. Brian Kelley - Databases, Infrastructure, and Security on 12 October 2009

Carolina Code Camp - The Good and the Bad

This past Saturday I was able to participate in the Carolina Code Camp, help just outside Charlotte, NC. I was there for the morning part, spending time with family in Charlotte for the afternoon. So let me go over both the good and the bad, starting with the bad… Read more

Weak Passwords Discovered in the 10,000 Disclosed Hotmail/Live.com/MSN leaked accounts

By now, hopefully everyone has heard of the security breach where accounts and passwords were found on a public site listed the account usernames and passwords of some 10,000 users. Initially it was just reported to be Hotmail/Live.com/MSN, but it turns out Yahoo!, Earthlink, GMail, and others were also affected. Read more

Rant: Cold Calls Are So Twentieth Century

I hate cold calls from vendors. Nothing gets my blood hotter than some vendor trying to call me when we haven't established a working relationship and when I haven't shown the slightest bit of interest in his or her product and that vendor seems to think that I care to… Read more

Speaking Engagements This Week

I'll be doing three talks this week, starting tomorrow (Tuesday).

If you're able to make… Read more

Red Gate's SQL Data Generator

I'm reading SQL Server MVP John Magnabosco's new e-book, Protecting SQL Server Data, and he includes a database schema to be able to use his examples. The schema doesn't include data and in the instructions he makes reference to Red Gate's SQL Data Generator. To this point I… Read more

Pitching in at SQL University

Jorge Segarra (@SQLChicken) has put together an idea to have on-line basic lessons on SQL Server called SQL University. The idea is to present two to three lessons each week in a somewhat academic manner, one that will hopefully encourage learning. It is targeted at the new… Read more

Security: Development Servers and Workstations

I've written about this before, but probably not as a specific subject or blog post. Trading some comments with a friend brought this topic to mind. Basically, there are some things in security we know not to do in production. Things like putting your spouse's name or your favorite sports… Read more