MS-SQL Server - M-J-M

M-J-M

- Mirroring
- Joins and Visit our Queries Banq
- Migration Best Practices....

https://learn.microsoft.com/en-us/azure/cloud-adoption-framework/migrate/azure-best-practices/sql-migration

Additionally,

1. Well Known Text

https://learn.microsoft.com/en-us/bingmaps/v8-web-control/map-control-concepts/well-known-text-examples/

2. Using Kerberos integrated Authentication

https://learn.microsoft.com/en-us/sql/connect/jdbc/using-kerberos-integrated-authentication-to-connect-to-sql-server?view=sql-server-ver16

3. Manage databases in Azure SQL Database by using Azure Automation

https://learn.microsoft.com/en-us/azure/azure-sql/database/automation-manage?view=azuresql

ROLLBACK Insert Statement

https://learn.microsoft.com/en-us/sql/t-sql/language-elements/rollback-transaction-transact-sql?view=sql-server-ver16

For ODBC Connection

https://learn.microsoft.com/en-us/sql/integration-services/import-export-data/connect-to-an-odbc-data-source-sql-server-import-and-export-wizard?view=sql-server-ver16

HEADERONLY returns information for all backup sets on a particular backup device

https://learn.microsoft.com/en-us/sql/t-sql/statements/restore-statements-headeronly-transact-sql?view=sql-server-ver16

Select @@version to get current version info.

Catch Error Message

https://learn.microsoft.com/en-us/sql/t-sql/language-elements/try-catch-transact-sql?view=sql-server-ver16

Note:- A Force bring illness, However an Urge bring brightness. Two things to earn before planning to become a DBA. Logic And Attention...

Best Regards

T. Amit Vaid S.