Prevent Accidental Resource Deletion Using Locks in Azure Data Factory

Learn how to protect production resources from accidental changes in Azure Data Factory.

Locks Taken During Indexed View Modifications

Careful adding tables into your indexed views.

GetDate() in blocked sessions

Trimming whitespace during BCP

Hi, I am working on a project whereby occassionally the client may provide a CSV file where a field has whitespace before the terminating ,.IE: - Example CSV file   Field1,Field2      ,Field3I would like to know how to remove and trim the whitespace using BCP. I have seen this can be done with DTS but how do […]

RE: Does Sql Server 2000 (Standard Edition - English) not respect regional settings?

Probably the "best" answer is to use one of the two generally accepted independent formats. You can read about it, for example, here:http://www.karaszi.com/sqlserver/info_datetime.asp