SQL Operations Studio Chart

01/09/2018
by Marlon Ribunal
2 Comments

SQL Operations Studio As Monitoring Dashboard

02/08/2019 Update: Late last year, SQL Operations Studio has been rebranded as Azure Data Studio which you can download and install here. Microsoft as a company has entered a new phase of innovation under the leadership of their CEO Satya Nadella. … Continue reading

03/19/2015
by Marlon Ribunal
3 Comments

How to resequence column based on numeric prefix using TSQL

Beginning in version 2005, SQL Server is making manipulation of a partitioned set of rows easier by using Window Functions (ROW_NUMBER(), aggregate functions with OVER(), etc.). You can manipulate partitions of rows on the fly with Window Functions. I’ve seen how complicated … Continue reading