March 2006 - Blogs - SQLServerCentral

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, 405 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, 458 reads

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

RegCreateKeyEX() error

I just began migrating SQL Servers (2000) to Windows 2003 from Windows 2000 a few months ago. In the past, I never had to add the start up account to the local administrators group. Now that we are moving to Windows 2003, I had to start adding the start up account… Read more

0 comments, 781 reads

Posted in Advice from Aunt Kathi on 27 March 2006

Is Documentation Dying?

The BOL for SQL Server 2005 has been interesting to read. On one hand there is a more comprehensive approach to documentation, but on the other, many entries lack substance. I've been in there a lot with book writing and after my editorial today, it hit me with Jamie Thomson's…

0 comments, 423 reads

Posted in The Voice of the DBA on 24 March 2006

Blue Hat

Microsoft had their Blue Hat security conference recently, inviting hackers to take their shots at the Microsoft products. Mostly security researchers letting actual developers and engineers know what they think about the products.

There's a new blog that has some info on the conference. Interesting as one of the…

0 comments, 413 reads

Posted in The Voice of the DBA on 16 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, 474 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, 398 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, 447 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, 437 reads

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

Get Your Own Blog

All Blogs

Feeds

Archives

Archives: March 2006

12-inch grass stem?

Internet Explorer Vulnerability

RegCreateKeyEX() error

Is Documentation Dying?

Blue Hat

Rights within the database

What are the actual rights?

Tool Updates

First Impressions of Professional SQL Server 2005 Integration Services