K. Brian Kelley - Databases, Infrastructure, and Security - March 2006 - Blogs

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…

0 comments, 397 reads

Posted in K. Brian Kelley - Databases, Infrastructure, and Security on 29 March 2006

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…

0 comments, 451 reads

Posted in K. Brian Kelley - Databases, Infrastructure, and Security on 28 March 2006

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…

0 comments, 464 reads

Posted in K. Brian Kelley - Databases, Infrastructure, and Security on 14 March 2006

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…

1 comments, 389 reads

Posted in K. Brian Kelley - Databases, Infrastructure, and Security on 14 March 2006

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…

0 comments, 437 reads

Posted in K. Brian Kelley - Databases, Infrastructure, and Security on 13 March 2006

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,…

3 comments, 426 reads

Posted in K. Brian Kelley - Databases, Infrastructure, and Security on 13 March 2006

Get Your Own Blog

Contact the author

All Blogs

Feeds

Archives for this blog