We had the same  problem today.

I wrote a script that does the following:

• Starts a transaction
• retrieves the last id number of the table
• uses sp_rename to rename the PK,...

The scariest data type may be sql_variant, but any data type can made to be scary if it is nullable.

We used a popular commercial telephony library to implement an IVR system. This library comes with extensive example code. One of the common complaints in the reviews of the software...

You can wrap it all in a transaction, but everyone who uses the table (and more) will be locked for the duration of your change.

Best to do it during off-peak...

This is an especially important when you store personal information, as the laws of the local area apply to the data and the transmission of such data. Thus a country...

I doubt that they will build any more giant dishes. Most giant radio telescopes now are long baseline arrays which coordinate their signals using atomic clocks in order to increase...

Yes

Working from home in healthcare IT support. As this crisis goes on it becomes more and more stressful. Now with re-opening, there will be a spike in the stress levels,...

I begin the block with [font="Courier New"]/*Dbg [/font]for debug code and [font="Courier New"]/*Rls[/font] for release code. That way I can search and replace [font="Courier New"]--/*Dbg [/font]with [font="Courier New"]/*Dbg [/font]to disable...