Find blocking queries in MSSQL
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
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…
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…
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…