Thanks for the support Andy.

I would support the addition of a setting to a column to mark it as not updatable except by the default.

There are appropriate cases where a column...

I don't know what your problem is, but you might want to get a copy of How to Get Along with Other Humans.

Status itself can be an entity requiring an...

A separate instance would be opened each time, but like the poster above me said, don't try it without stress testing it. The likeliest source of potential problem is if...

Do you also need to set the date back 1 day or is that a typo?

My preferred method is to import all data sources into staging tables, perform any data modifications that need to be made, and then populate the final tables with the data....

I think it was an excellent aricle topic. I think defaults are not only underused but are often misunderstood.

In my opinion, when creating a table, for every column, the table...

The problem with using human readable codes such as a single letter is if one of the codes changes and it used in 10,000 million records, you have to choose...

As the saying goes, "Tru dat!!"

The only non-SQL Server database systems supprted are Oracle and DB2. SQL Server does not support replication to or from MySQL.

Those triggers you deleted are added by replication during the initialization process. They are there to prevent data from being updated while the schemas are being modified. They should only...

I can. First off, your publisher and subscriber can never be a higher level than your distributor. So, the distributor should always be the first one upgraded. So A and...

Well, in my opinion, you've certainly got the right attitude for the job. I got my first dba job the same way. I was the lead database developer at my...

I was speaking in generalities, and not directly to you. I have known people that would simply give admin rights to a whole users group if one person needed something....

As a drastic measure, to shrink a log file for a database in full recovery mode when there is not enough room to backup the log file:

Backup Log DatabaseName With...

Use sp_dbcmptlevel to check and/or change the compatibility level of databases.