Despite the maturity of TSQL, SQL Server 2017 still introduces several new features which to the T-SQL family which can be very useful in database development.

(Manoj Pandey) So, today I tried to install SSMS 17.3 version, and got following error:

(Dimitri Furman) Over the years, we have been engaged with many customers who were either already using, or were in the process of adopting Azure SQL Database. Most of those engagements involved deep technical work in the areas of performance, resiliency, connectivity, and general database architect

(Edwin Sarmiento) In a previous tip on Implementing Database Mirroring in SQL Server 2005 across domains, we have seen how we can configure Database Mirroring to achieve local high availability for SQL Server databases that are not joined to an Active Directory domain. We need to upgrade our SQL Ser

(Pinal Dave) If you have not understood what I am going to talk in this blog post by just reading the title, I think you are a normal human like me. Just the other day I received an email from a blog reader with subject line as “Select Unique Data From a Column Exist in Two Different Table”.

(Pinal Dave) Recently I received a simple question about AT TIME ZONE feature. This is the new feature which is introduced in SQL Server 2016 and later version of the SQL Server.

(Jack Vamvas) With an existing SQL Server Reporting Services (SSRS) deployment, renaming the ReportServer & ReportServerTempDb databases is not straightforward.

(Kenneth Fisher) If you’ve done much work with the system views (DMVs for example) then you’ve had to translate an object_id into a schemaname and objectname and vise versa.

(Denny Cherry) Building, implementing and executing a proper DR plan successfully is a challenging undertaking. It is a lot more complicated than most experienced IT professionals and/or consultants think it is.

(Chris Webb) One of the new features in Reporting Services 2017 is the new REST API. The announcement is here: