Hi, as you are covering connecting to azure SQL you might also want to discuss the other authentication methods I.e. those related to azure

A good script that I have used a few times. Just found out today that because it is based on profiles (inner join ...) it does not script accounts that...

Hi Shawn, I am trying to implement the same solution and having the same issue. Can you confirm that this will work if you failover to SQL2 and then take...

Hi masud4u2006,

Regarding your question about reading data from the mirrored database. You can by implementing a DBSnapshot

Please read http://technet.microsoft.com/en-us/library/ms175511.aspx

There are a few gotchas re performance and renewing the...

No you do not need to block transactions. However, do not waste too much time between the backup and restore of the transaction log. When you set up the mirror...

I presume you use a where clause somewhere along the way. I tend to see this type of issue when the statistics get out of date and I would assume...

The issue is that you have a GO statement partway down your code. This effectively ends the batch and all variables are then forgotton. I would have to ask why...

I agree with Vasc that both types (int and smalldatetime) use 4 bytes.

Unfortunately, the code from Remi Gregoire is all done on the...

A previous post says that dates make good indexes. I tend to disagree. At the end of the day a date is stored as a number. Because types of smalldatetime and datetime allow...

Or ...

If you have an identity column in teh table do the insert and then use

SET guid = @@IDENTITY

Once again this only work when inserting oe record at a time.