Once you start becoming a "lazy dba" and writing code that generates code - you begin the ascension into being efficient.

One absolutely stupid thing that I "picked up" was the...

I think the reality is, some of us are still better after several beers than many of our coworkers are sober - so as long as you can safely get...

I agree with Gail. I think the overuse of identities is a problem. Too often I come across data integrity issues caused by the theory of "identity on every...

sorry - had the message 1/2 typed out and got pulled away. you need to select the columns you want persisted into the XML- as you said

I need to...

Thanks - that would be an interesting use of QA. Our current structure really does not have QA in the loop when going to production or the build process,...

This might help, its not particularly difficult to setup - varbinary storage..

http://msdn.microsoft.com/en-us/library/cc278098.aspx

also, open SSMS, F1, search for this :encryption [SQL Server], functions

Good luck on your project.

Buenos Nochas! (my weak Espanol for good night)

Another fun fact : NULL never equals NULL

SELECT * FROM ORDENES WHERE TRABAJO = NULL

The correct way:

SELECT * FROM ORDENES WHERE TRABAJO IS NULL

UPDATE <schema>.ORDENES

SET trabajo = 'wasoncenull'

WHERE trabajo...

If you have it installed, your all set.

Connect up and edit the table - whats the issue?

Obviously going from a nullable field to non nullable will require you...

Have you installed SSMS and connected to your server?

For a newbie, navigate to the table, right click modify, then check the allow nulls where applicable.

You can download SSMS express and...

By in large, most companies I have worked for were very fair with their overtime requirements. You put in the hours when you need to, if you are putting...

Kudos on your choice of libations.

Personally, I typically reduce stress with a 6 pack of really good beer and some good old Chicago Blues.

Thanks for the input. At this point, its "enforced in the application", but being in the data business I always have that preference to make the model truly express...

I would keep your order structure and probably create a SCHEDULED_ORDER table and have a job add the order to the table or the application pull in the defaults and...