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: April 2007

Keeping Skills Up-to-Date and Discoverability

One thing is always certain about information technology: there is always change. This past week I was pitching in on a Citrix upgrade for my organization and I went to tweak the web interface. Though I'm not primarily a "server guy" and directory services administrator, I do have a web…

Read more

Midlands PASS - April 5, 2007 Presentation posted

The presentation How to Be a Consultant has been posted to the Midlands PASS Chapter website. The presentation was given by Midlands PASS Vice President and Treasurer, Ben DeBow, of CounterLogic.com. There's a lot of great information on succeeding as an independent consultant from one who has been…

Read more

The Final Word on SQL Server 2005 SP2?

Bob Ward posted on the PSS SQL Server Engineers blog a fairly long post on SP2 and the hotfixes thereafter:

  SQL Server 2005 Service Pack 2 (SP2) Re-release and post fixes explained

So with all the confusion, what version should you be at? Bob posts that in his summary:

Read more

New Tool: ApexSQL Audit Viewer

ApexSQL has announced a new viewer tool for ApexSQL Audit. ApexSQL Audit does a lot of the dirty work of building audit structures for you as a huge time saver. In addition, it provides the trigger scripts for review prior to execution (they are built from templates which you…

Read more

Thoughts from Never Eat Alone

Watching a Chefograpy on Giada De Laurentiis, I learned that she was considered very much an introvert and had a hard time in front of the camera. However, over time she has overcome all of this and has become more comfortable around people and being on film. I've always…

Read more

More information about SQL Server 2005 and SP2

SQL Server MVP Aaron Bertrand has posted an update (April 6, 2007) on the version numbers of post SP2 hotfixes. Also, Mr. Bertrand has tried to keep up with the various builds and their version numbers. Normally I refer to the SQL Server Version Database on SQLSecurity.com but it…

Read more

Help Johnny, Help Kids

I had heard of Johnny Long before I attended his briefing at Black Hat 2004. Well known for his research on finding information of value to hackers through Google, it was a talk I looked forward to seeing and left well-satisfied. Everything I've read about Johnny Long's character has…

Read more

Microsoft CRM Security Internals

On the Microsoft Dynamics CRM Team Blog, Jay Grewal has posted information about the CRM Security Model Internals.

CRM is an interesting application for DBAs because it does use row-level security. It's a bit more complex than most row-level security models in that there are access checks and…

Read more

How to pick a combination lock in 30 seconds

This is just frightening. A piece of a beer can, a pair of pliers, and the combo lock pops open.

  Network Security Blog: Pick a combination lock in 30 seconds

If it looks easy to make such a shim, it is:

  Beer Can Padlock Shim

This goes right…

Read more

SQL Server Samples on CodePlex

Like many other SQL Server focus area, SQL Server Samples has its own blog. A recent post there indicates that they are moving to release their code samples at CodePlex. I first heard of CodePlex by listening to the podcast Plumbers @ Work, which is a podcast…

Read more

Thoughts from The Cuckoo's Egg

The Cuckoo's Egg
by Clifford Stoll has been around for a while, having been published in 1989. It details how a system administrator (a trained astronomer who had to find something else to do) tracked a malicious hacker through his system and numerous others including defense contractors and unclassified DoD…

Read more