To find queries that block others in Microsoft SQL databases, execute This returns the list of active sessions and indicates what session blocked it. To get the query of a session, execute
Tag Archives: database
MSSQL database migration to another database server
When a database is migrated to another server by copying the database file or restoring it from a backup file, the original database user account references are also carried with it. Those accounts contain the account IDs specific to the original database server. To provide access to the restored database on the new database server …
Continue reading “MSSQL database migration to another database server”
Microsoft SQL Server clients
To connect to an MSSQL database on Macintosh Install the Azure Data Studio Download it from Download and install Azure Data Studio on Windows Install SSMS (SQL Server Management Studio Download it from Download SQL Server Management Studio (SSMS) Install the Azure Data Studio Download it from Download and install Azure Data Studio
Migrate databases to and from AWS RDS instances
Amazon Web Services do not provide tools to migrate data to, from and between AWS RDS instances. There is a free utility that can do the job. SQL Server Management Studio (SSMS) Install Microsoft SQL Server Management Studio (SSMS), because the utility uses libraries from it. Download the installer for free from https://msdn.microsoft.com/en-us/library/mt238290.aspx SQL Azure Migration …
Continue reading “Migrate databases to and from AWS RDS instances”