SQL Clone
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in

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

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

Read more

0 comments, 1,503 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…

Read more

0 comments, 1,547 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…

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