We can use SSIS now.
We can use SSIS now
Yep, you have to install it once.
Then Run the installer again, this time choosing update. Select another free version, e.g "advanced" or "with tools". Run the installer to the end.
Then run the installer ONE last time, then you will have the option to choose MSSQL Managment studio under components when you install.. redicoulous but it works.
Can we use PIVOT operator in SQL Azure Database, as we used to use it in SQL 2008
The script generated works fine if you are storing small amount data (varbinary(7000)) of session but if session store large then use InstallSQLState. sql from article below
otherwise you will be getting errors like below
Unable to cast object of type 'System.DBNull' to type 'System.Byte'.
Session state can only be used when enableSessionState is set to true, either in a configuration file or in the Page directive
It 's very good and useful code. thank you very mutch.
Any idea how long this should run? I'm copying a 146 GB database to another SQL Azure server and it's only 70% done after 19 hours. It seems to be still running, as the percent_complete is ...slowly... increasing.
Personally, I would not recommend using a datetime column for the clustered key because it does not guarantee uniqueness of the values. A better choice would be to use an int/bigint identity column.
I get the 'table does not have a clustered index' error on tables that do indeed have a clustered... go figure.
Any chance there could be 'next' and 'previous' links at the end of each article to link between them?
When using Invoke-sqlcmd in PowerShell, does certificate validation automatically occur when connecting to a SQL Azure database? Does the -EncryptConnection parameter ensure that certificate validation is occuring such as using sqlcmd -N included in 2012?
Hi Wayne, we have a service that allow you to execute stored procedures on a scheduled basis. I hope you don't mind me posting this on your blog as an alternative solution.
i use the windows Azure to open chat rooms inside it but the problem there are no sound and cams not working too in the chat rooms . my VM is windows server 2008 .... need your help Mr Wayne
While Migrating my sqlserver DB to SQLAzure DB It ended up an error
"Statement 'UPDATE TEXT', 'TEXTPTR' is not supported in this version of SQL Server."
can you pls guide me how to resolve this issue in SQL Azure?
I'm very appreciated. Save a lot of time for my migration