Probably two things - started learning/utilizing powershell for automation.

And I read, read, read some more. Lots of great blogs out. In addition, try to read/reread a...

Logon trigger, of course! Danke.

I concur on the pwd management. In other place, a network admin created and encrypted the service account passwords and the devs never knew...

Lucene is basically indexing for .NET apps. It basically allows web apps to search the Lucene index versus heading off to the DB to do the search. In...

This has the syntax:

http://technet.microsoft.com/en-us/library/bb522469.aspx

As reflecting in many comments already, they enable those of us who managed a series of databases that cross many applications to manage security extremely easily. No longer does...

Thanks - I am in good with our secretary ( vegetables from the garden for bribery) and she runs the show on bookings - the hotel at the Summit would...

I get to go to my first Summit this year - had to negotiate it as part of a counter offer. Its good for both parties. I am...

We are even going through the debate currently of productivity vs performance. It will be interesting to see if the developers can pull off a quality ORM deployment. ...

When a developer runs the package from their machine, it will (in our case) connect as dbo to the Configuration View - the reason being the SSIS developers our part...

"do you have one configuration table for all the environments or has each environment its own config table?"

We maintain one configuration table per ETL server (because each physical machine can...

I only tested it in 2008 -> I can't say that it doesn't work since I jumped over the 2005 versions.

Jack Corbett's article (mine is a derivative of his) talks about SQL/VS 2005 implementation. This article refers to a 2008 version - sorry.

I would like to see greater admin ability at the database level - and the ability to lock that down to the server level. Many app teams want lots...

Source is key - that is for sure.

I think the difficult part is in the QA/firm hand area. You mentioned the organizational pressures and they are very true here,...

Thanks - we are looking at a label like implementation to snap builds at certain points. We have lists of objects and their path in source and use the...