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: September 2010

Lessons from a Great Mentor

On Sunday I learned of the passing of one of my greatest mentors, Major Herbert L. Day, USMC, Retired. He was Director of Bands at The Citadel, the Military College of South Carolina, from 1984-2004. My tenure there started in August 1991 and ended with graduation in May… Read more

3 comments, 226 reads

Posted in K. Brian Kelley - Databases, Infrastructure, and Security on 28 September 2010

Why You Should Come to SQL Saturday #48 - Columbia, SC

SQL Saturday #48 is on October 2. We're offering free SQL Server and PowerShell training from some great names in the business. We're offering free lunch. And we've got some awesome prizes, courtesy of our sponsors. I say we've got great names, so here are some of them:

Microsoft… Read more

2 comments, 369 reads

Posted in K. Brian Kelley - Databases, Infrastructure, and Security on 22 September 2010

Putting Priorities into Practice

 Yesterday I posted a review on the book Choosing to Cheat. I had begun putting some of the principles into practice long before I read the book, about 2 years ago, in fact.

Architect - A Popular Title Nowadays

In December 2001, I switched from being a senior SQL… Read more

4 comments, 238 reads

Posted in K. Brian Kelley - Databases, Infrastructure, and Security on 21 September 2010

Review: Choosing to Cheat

 Cross-posted from The Goal Keeping DBA blog.

I first heard about this book at SQL Saturday #51 when I was talking with Joe Webb and Thomas LaRock. Joe was describing the basic premise of the book, which is that everyone has more to do than can possibly be… Read more

1 comments, 218 reads

Posted in K. Brian Kelley - Databases, Infrastructure, and Security on 20 September 2010

I Don't Want to Share!

I know we were taught to share in kindergarten, but there are some things that should not be shared. In this case, I don't want to share a stomach bug that I caught from my wife that she has been suffering with the last couple of days. My morning began… Read more

2 comments, 205 reads

Posted in K. Brian Kelley - Databases, Infrastructure, and Security on 17 September 2010

See You at SQL Saturday #46 - Raleigh

EDIT: Updated to include a picture of me.

I'm headed up this weekend to speak at SQL Saturday #46 - Raleigh. This time I'll be giving two presentations, both on SQL Server security:

Fortress SQL Server

This is my standard OS to database security presentation, but I'll be… Read more

1 comments, 267 reads

Posted in K. Brian Kelley - Databases, Infrastructure, and Security on 16 September 2010

Slides and Files: A PowerShell Primer

Here are the slides and scripts from last night's presentation at Midlands PASS Chapter. The presentation was intended to introduce folks to PowerShell and get them started with some of the basics.

A PowerShell Primer

Enjoy the ferret, and the reminder. Read more

0 comments, 268 reads

Posted in K. Brian Kelley - Databases, Infrastructure, and Security on 15 September 2010

Task Manager - Don't Believe the System Idle Process Percentage

This morning my laptop went to a crawl. I looked, and sure enough, there was an AntiVirus scan running. Argh! But it looked like the processor wasn't being hit that hard because the System Idle Process was still relatively high. Time to put into practice some knowledge I picked up… Read more

1 comments, 896 reads

Posted in K. Brian Kelley - Databases, Infrastructure, and Security on 14 September 2010

SQL Saturday #48 - Columbia, SC - Recommended Hotels

If you're thinking about attending SQL Saturday #48 - Columbia, SC and need a hotel room, our crew has done the research. Our criteria were:

  1. Clean and safe
  2. Close to the event
  3. Free Internet

We're happy to announce that we have picked out 2 hotels that meet these criteria and… Read more

SQL Saturday #48 - Columbia, SC Schedule Posted

The sessions have been selected and we have posted the schedule for SQL Saturday #48 - Columbia, SC. A huge thank you to everyone who submitted to present. We appreciate your desire to help and grow the SQL Server community. Also, a big thanks to Allan Cothran (twitter Read more

Thoughts about the PASS BoD Nomination Process

I know I was one of the more vocal ones these past two years when the set of nominees were revealed. To the point where I jokingly recruited a bodyguard for SQL Saturday #48 - Columbia, SC since Stuart Ainsworth is going to be there and he and I have… Read more

Re-learning how to think

Cross-posted from The Goal Keeping DBA:

Re-learning how to think is always a difficult process. My oldest son is starting the the 7th grade and he’s having to go through it. We homeschool, so we pick the curriculum. Since he’s consistently been above the 95% range with respect to… Read more

For SQL Server 2005/2008, Consider SecurityAdmin = SysAdmin

Note: Republishing because the article covering the issue and a workaround has been published here on SSC.

In a recent thread here on SQL Server Central, it was pointed out that a member of the securityadmin fixed server role could do the following:

  1. Create a new login.
  2. GRANT…

Read more

8 comments, 1,722 reads

Posted in K. Brian Kelley - Databases, Infrastructure, and Security on 1 September 2010