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: March 2006

12-inch grass stem?

Those of us in technology are very, very used to automated systems, batch jobs, etc., all which run without human interaction (or at least, very little). We can fall into the trap of thinking of this environment as "real life," and I have found myself drifting there from time to…

Read more

Internet Explorer Vulnerability

If you're using Internet Explorer, be advised Microsoft has released a security advisory for Internet Explorer. This would allow an attacker to run code under the context of the logged on user. The only workaround is to disable active scripting, which isn't such a great workaround because it breaks so…

Read more

Rights within the database

This is a follow-on to my post What are the actual rights?

First and foremost, I want to include membership in the fixed database roles. That's fairly easy to pull based on individual users. The db_datareader and db_datawriter roles are naturally of great interest because they grant explicit access to…

Read more

What are the actual rights?

One of the things I've started to work on are some scripts to quickly be able to pull what a user's actual rights are within SQL Server. This is a question often asked by auditors and it would be great to give them a comprehensive answer. Just keying off the…

Read more

Tool Updates

Catching up on recent updates for tools I've looked at and/or recommended.

SQL Server Tools:

PromptSQL is now up to version 1.4. The latest release was February 24, 2006.

ApexSQL Log is now up to version 1.9. The latest release was February 22, 2006. This version includes SQL…

Read more

First Impressions of Professional SQL Server 2005 Integration Services

I received a copy of Professional SQL Server 2005 Integration Services a few weeks back from Kathi. Because of illness and a few things going on around home, I've not gotten around to writing a full review of the book yet, though I'm dilligently working towards that goal. However,…

Read more