windows

Top 7 Things You Want To Do In Windows Azure SQL Database, But Can’t

Top 7 Things You Want To Do In Windows Azure SQL Database, But Can’t

I’m a huge fan of Windows Azure SQL Database (WASD), I really am. I know there are other fans out there as well. With each passing day we help transport more of the old-school DBAs into the 21st century by showing them what Azure has to offer. Unfortunately there are always a few folks that(…)

How To: Migrate Encrypted Procedures To Windows Azure SQL Database (WASD)

How To: Migrate Encrypted Procedures To Windows Azure SQL Database (WASD)

Here’s the easy answer: you don’t. WASD does not support the WITH ENCRYPTION option for objects such as stored procedures, user defined functions, triggers, or views. So the idea of migrating an object that was compiled with that option is simply not feasible. If you have a system with encrypted objects and you try migrating(…)