- Details
- Written by: Stanko Milosev
- Category: SQL
- Hits: 4583
How to check locks in Azure SQL?
SELECT * FROM sys.dm_db_wait_stats ORDER BY wait_time_ms desc
- Details
- Written by: Stanko Milosev
- Category: SQL
- Hits: 4585
Table where we can see logs from Windows Azure.
- Details
- Written by: Stanko Milosev
- Category: SQL
- Hits: 4650
Use "CREATE DATABASE destination_database_name AS COPY OF [source_server_name.] source_database_name" to make a copy of database on the Azure SQL.
There is also possibility to check progress of DB copy, but at this moment I don't have that code.
- Details
- Written by: Stanko Milosev
- Category: SQL
- Hits: 6448
Install SSMS 2012 (not DB engine, only Management Studio) from:
Download BACPAC, it can be done using Visual Studio (View->Server explorer,…)
If you receive the error like:
Error SQL72014: .Net SqlClient Data Provider: Msg 468, Level 16, State 9, Procedure MyProc, Line "some number" Cannot resolve the collation conflict between "SQL_Latin1_General_CP1_CI_AS" and "Latin1_General_CI_AS" in the equal to operation.
(Microsoft.SqlServer.Dac)
Then unzip BacPac (bacpac is actually zip file), find file which has SQL_Latin1_General_CP1_CI_AS, then, best is just to rename bacpac to zip, and search and replace file directly from zip, or install new instance of MS SQL, because I couldn’t find a way to change collation of the server…