All Articles - SQL Authority with Pinal Dave

SQL SERVER – Get Wait Stats Related to Specific Session ID With sys.dm_exec_session_wait_stats

August 28, 2017

SQL DMV, SQL Scripts, SQL Server, SQL Server 2016, SQL Wait Stats

First thing first, this feature of getting wait stats related to Specific Session ID with sys.dm_exec_session_wait_stats will only work with SQL Server 2016 or later version of SQL Server. If you attempt to run this on earlier versions of SQL Server, you will for sure get an error.

What is the Biggest Limitation of ISDATE() Function? – Interview Question of the Week #137

August 27, 2017

Pinal Dave

SQL Interview Questions and Answers

SQL DateTime, SQL Function, SQL Server

Question: What is the Biggest Limitation of ISDATE() Function?

SQL Server Management Studio (SSMS) – Unable to Connect to SSIS – The Specified Service Does Not Exist as an Installed Service

August 26, 2017

Pinal Dave

SQL

SQL Error Messages, SQL Scripts, SQL Server, SQL Server Management Studio, SSIS, SSMS

After installing the latest version of SSMS (17.2), I was not able to connect to SQL Server Integration Services SSIS on my local machine.

SCOM – Alert: SQL Server Cannot Authenticate Using Kerberos Because the Service Principal Name (SPN) is Missing, Misplaced, or Duplicated

August 25, 2017

Pinal Dave

SQL

SQL Error Messages, SQL Server, SQL Server Security

This blog explains what needs to be done when there are tools which can monitor and report issue about SPNs. Once a client informed that SCOM (System Center Operations Manager) is connected to the databases on SQL Server and raising below warning regarding the SQL Server (Service Principal Name) SPNs:

SQL SERVER – Puzzle – Write a Shortest Code to Produce Zero

August 24, 2017

Pinal Dave

SQL Puzzle

SQL Function, SQL Scripts, SQL Server

Puzzle: Write a Shortest Code to Produce Zero.

SQL SERVER – Learning DATEDIFF_BIG Function in SQL Server 2016

August 23, 2017

Pinal Dave

SQL Tips and Tricks

SQL DateTime, SQL Function, SQL Scripts, SQL Server

One of the T-SQL functions introduced in SQL Server 2016 is DATEDIFF_BIG function.

SQL Authority News – Community Hub by Redgate

August 22, 2017

Pinal Dave

SQLAuthority News

Redgate

It is not possible that readers of SQLAuthority.com is not aware of amazing tools built by Redgate. We all know that Redgate builds tool which makes SQL DBA and Developer’s life easier. We can eliminate human errors and improve our efficiency. Redgate software along with helpful tools also produces a very interesting content for DBA and Developers. I am excited to see that Redate has recently announced Community Hub.

SQL Server Management Studio – New Feature – Object Explorer Query Tracking

August 21, 2017

Pinal Dave

SQL Tips and Tricks

SQL Scripts, SQL Server, SQL Server Management Studio, SSMS

A few days ago, I wrote a blog about a new feature in SSMS and I got few emails asking me to share such quick and fresh information. You can read my earlier blog here SQL Download – SQL Server Management Studio (SSMS) – Performance Dashboard. In this blog post we will learn about the brand new feature called Object Explorer Query Tracking.