:::: MENU ::::

Posts Categorized / SQL Server tools

  • 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 / 2009
  • 0
DBA Interview questions, dbDigger, Monitoring and Analysis, SQL Server tools

Purpose and use of profiler

Profiler is very useful tool for repeatable and insight analysis/monitoring of SQL Server database engine, SSAS and SSIS. Profiler is a GUI used to utilize SQL Trace. SQL tarce is a used to capture client-server communication. Profiler may server following major purposes for a SQL Server DBA

  • Query analysis of execution plans
  • Analyze errors and warnings of SQL Server
  • Analyze the user activities
  • Create traces to reuse later also
  • Save trace results for later analysis
  • Jan 28 / 2009
  • 0
DBA Interview questions, dbDigger, SQL Server tools

SQL Server 2005 optional features kept off by default

Keeping in view the fact that more accessible features causes more security threats, Microsoft SQL Server 2005 came with optional features kept off by default. These features include

  • CLR Integration
  • OLE Automation sys procedures
  • Database Mail sys procedures
  • SQL Mail sys procedures
  • Ad Hoc remote queries
  • SQL Server web assistant
  • XP_cmdShell availability
  • Remote use of dedicated admin connection

It will be best that you keep off these features as long as you do not need. When you require any of these features, you may turn it on through Surface Area configuration tool or Surface Area configuration command line interface.

  • Dec 11 / 2008
  • 0
dbDigger, Monitoring and Analysis, SQL Server tools

Duration value in SQL Server 2005 trace

Question: You make a SQL Trace in SQL Server 2005 and after you have loaded everything into a table you do a select and see the following results:

Duration Reads Writes CPU
1061610 400 0 66

When you look at the duration, what is the value here?

Answer: 1.06161 seconds

Explanation: The answer is 1.06161 seconds.

In SQL Server 2005, the server reports the duration of an event in microseconds (one millionth, or 10-6, of a second) and the amount of CPU time used by the event in milliseconds (one thousandth, or 10-3, of a second). In SQL Server 2000, the server reported both duration and CPU time in milliseconds. In SQL Server 2005, the SQL Server Profiler graphical user interface displays the Duration column in milliseconds by default, but when a trace is saved to either a file or a database table, the Duration column value is written in microseconds.

  • Nov 12 / 2008
  • 0
DBA Interview questions, dbDigger, Logins and Users, SQL Server tools

Change password with -Z parameter through SQLSMD

Question: You are trying to run some scripts using SQLCMD but keep getting errors that your password has expired. SSMS is not installed on this machine. What should you do?

Answer: Use the -Z parameter to change your password.

Explanation: While many of us might feel like going home, that’s not a great solution. Either calling a DBA or finding another workstation will work, but that’s inefficient. With the -Z parameter, you can change your own password with SQLCMD.

Ref: SQLCMD – http://msdn.microsoft.com/en-us/library/ms162773(SQL.90).aspx

Note: The Question is taken from SQLServercentral.com.

Consult us to explore the Databases. Contact us