:::: MENU ::::

Posts Categorized / SSMS tips and tricks

  • 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.

  • Mar 30 / 2012
  • 0
DBA best practices, dbDigger, Performance Tunning and Optimization, SSMS tips and tricks, T-SQL Tips and Tricks

Move the columns to required position in SSMS result pane

It is always good to have a clear idea of filtered data and order of columns for any required result. However, consider the scenario that you have executed a resource intensive query and got the data in SSMS result pane. And after having a look at the result set you perceive that moving a column prior to a specific one may improve the report.
A option may be to change the order of columns in query and re-generating the result set to required order. But this would again consume resources for that resource intensive query. Best solution for changing column order in result set would be by dragging the column to required position.
Here is an example, i have retrieved result from AdventureWorks database and later moved the column [Phone] from last to second last position.

Swaping the columns in SSMS results pane

This simple tip may prevent the re-execution of query for column re-ordering purpose.

  • Feb 20 / 2012
  • 0
dbDigger, SSMS tips and tricks, T-SQL Tips and Tricks

Copy and paste among multiple lines in SSMS

SQL Server Management Studio (SSMS) is my favorite tool and m fan of it right from its start with SQL Server 2005. With every new release SSMS got more coll features for DBAs. Recently i came across a very useful feature in SSMS query pane. It allows to select specific content from multiple lines in query pane. This feature is extremely helpful when we are required to select table names, column names or even values from the script. The selected values may be deleted or copied as required. And may be paste in same alignment any where among the text.

Basically the technique is to hold the ALT key and drag the mouse on required text in SSMS query pane. Following is an example of its usage and you may use it for many tasks in more creative manner.
Suppose i am required to select just table names given in three seperate T-SQL statements. I would press ALT key and start dragging the mouse on required data. The selection would be as shown in following snap
select data from multiple lines in SSMS

Now we may copy data for onward use. It is notable that during the paste process data would preserve its alignment that was during the copy process. Spend some time to play with this cool feature and make use of it.

  • Dec 06 / 2010
  • 0
dbDigger, Publications of Atif Shehzad on MSSQLTips.com, SSMS tips and tricks

Scripting every task performed through SSMS GUI

Recently i explored a wonderful option provided in SQL Server Management Studio. SSMS allows to generate script for any operation performed through its GUI. It is awesome and provides you a comprehensive and authentic T-SQL code reference. You may save the GUI tasks performed in form of .sql files. Such code may be reused in daily tasks or scheduled jobs.

Click here to read my article for details of using this feature of SSMS.

Consult us to explore the Databases. Contact us