This tutorial shows how to create a connection to a SQL Server database in dbForge Studio for SQL Server. It also covers selecting an environment category, adjusting connection settings, saving connections with the Import and Export Settings wizard, and retrieving data from a table.
00:00 Introduction.
00:20 Get started with dbForge Studio for SQL Server.
00:32 Set up connection parameters: server name, user name and a password, the database you want to connect to.
01:05 Assign the environment category (Development, Production, Sandbox, or Test) and color to SQL Server connections.
01:25 Connect to the selected SQL Server database.
01:34 View connection properties.
01:38 Create a new database connection to the SQL Azure.
01:52 Azure Active Directory – Universal with MFA.
02:13 Open the connections you’ve created.
02:17 Modify the connection properties.
02:46 Save your connections using the Import and Export Settings wizard.
03:16 To view data in any table, select the Retrieve data command.