SQLServer

SonarQube SQL Error – String or binary data would be truncated

The SonarQube Scanner for MSBuild – Begin Analysis task contacts the SonarQube server to retrieve the quality profile, and dynamically produces rulesets to be applied during the static analysis. If there are issues in the process, I would recommend to go the Administration section in your SonarQube server, and navigate to the background Tasks tab to find the error log.

Identifying Missing Indexes in SQL Server

Having an effective Database Indexing Strategy is a key to your application performance. When we think about optimizing SQL query performance, generally the first thing which comes to our mind are ‘Indexes’.¬†And rightly so, because Indexes tremendously help in fetching your data faster from SQL Server.

Speaking at PASS Summit, Seattle 2017

I am honored and super excited to have been selected to speak at this PASS Summit 2017 – the world’s biggest conference in the Microsoft Data Platform. This will be my first PASS Summit experience. I consider myself very fortunate to have got this opportunity, knowing very well that there are so many experienced and better speakers around.

Use custom colors to differentiate between environments

During my SQL Saturday Birmingham Presentation on SQL Tips and Tricks, one of the productivity feature which got lot of love from most of the attendees was the use of custom colors to differentiate between SQL environments. SSMS provides us with an ability to set different colors for connection to separate environments.