I wonder if making use of XACT_STATE(), within the body of the TRY can help. Something like issuing print statements or logging into a table to see the before and...

A old handy tool you could use, if still around, is Microsoft Visio. I think the earlier before 2005 versions are quite nice. Otherwise you can make do with the...

AS mentioned, file "copy" the certificate you created on prod to QA and register it there. Else you are just creating a different one on the QA system regardless of...

"

"

What problems is this causing exactly ?

from...

Old post , but

Using the tmp table suggested by another, you can use bcp with argument -f, -l for first and last rows from this table. Used in a loop...

"The maintenance installation script that creates all of the stored procedures is over 9000 lines. I am not going to spend the hours reviewing that "

I dont review the...

I'm curious on the solution details. If you have a login already for this one windows account, could you not just...

Many times a developer may model a new stored procedure by copying an existing one as a template. This may leave variables that are not used and calls to other...

AS time goes by and the backup table become larger how will this scale ? Should there be a date cutoff on the Exists clause in the inserts ?

How would...

Very insightfull and easy to read. Thank you.

Insightful , thank you for the information. One comment I do have

"If the database is accessible, take the backup. The backup might be used to restore the data which is...

MSSQL has a similar function, but at the DB level, so we have an associated database to the main one, which contains something like logs and performance monitor data....

Simple and to the point, thank you. Another interesting exercise would be where you have a table partitioned across file groups. It would be interesting to see how restoring (for...

Thank you for the good point you make. Indeed indexes do help with isolating transactions and avoiding contention on a common resource.

I do want to note some areas where I...

One would be wise to consider that a HR survey may be a backdoor to find people who are not content in their job, instead of a genuine opportunity for...