:::: MENU ::::

Posts Categorized / SQL Server Utilities

  • Aug 17 / 2017
  • 0
SQL Azure, SQL Server tools, SQL Server Utilities, SSMS tips and tricks

Authentication methods in SSMS 17.2

In previous post about 17.2 we briefly mentioned about its download flavors. There is much more to explore in it. Login box of new SSMS shows additional options along with conventional Windows Authentication and SQL Server Authentication.

Authentication types in SSMS 17.2

These additional options are

  • Active Directory – Universal with MFA support (Introduced in SSMS 17.2)
  • Active Directory – Password (Introduced in SSMS 17.0)
  • Active Directory – Integrated (Introduced in SSMS 17.0)

All three options have one thing common that they relate to Azure active directory. Azure SQL Database and Azure SQL Data Warehouse support connections from SSMS using Active Directory Universal Authentication.

Active Directory РUniversal with MFA support is multi factor authentication and involves two step verification by adding call, SMS, bio metric device, smart cards with pin, or mobile app notification and can result in pop up box for validation.

Remaining two options Password and integrated are not interactive and do not generate any dialogue box. Can be used in different applications like ADO.NET, JDBC, ODBC etc.

  • Aug 11 / 2017
  • 0
SQL Server tools, SQL Server Utilities, SSMS tips and tricks

SSMS 17.2 is available now

SQL Server management studio (SSMS) 17.x is the latest generation of SQL Server Management Studio and provides support for SQL Server 2017. Microsoft has released SSMS 17.2 with number of improvements and additional features. You can download the SSMS 17.2 from here and also have a look at “New in this Release”.

Download is provided with two options.

  1. Download whole setup for SSMS 17.2
  2. Download updates if you have already installed 17.0 or 17.1

In both cases you would have SSMS 17.2 available.

  • Aug 26 / 2009
  • 1
dbDigger, SQL Server Utilities, SSMS tips and tricks

Where are import Data and export Data wizards in SSMS

I noticed my some colleagues that after migration from SQL Server 2000 to SQL Server 2005, they were having problem to find their favorite data import/export wizard in SSMS. Import data and export data wizards can be accessed by right click on specific database folder in SSMS.

Import data and export data wizards in SSMS

Wizard will be invoked and further steps are same as SQL Server 2000. However we can not save it like DTS package for later use. However in SSMS of express edition, these wizards will not be accessible.

Consult us to explore the Databases. Contact us