03/19/2015
by Marlon Ribunal
1 Comment

How to resequence column based on numeric prefix using TSQL

Beginning in version 2005, SQL Server is making manipulation of  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 queries … Continue reading

07/03/2014
by Marlon Ribunal
0 comments

Executing scripts on multiple servers the easy way

Central Management Server and server groups provide a convenient way to manage multiple servers and databases in one place and at the same time.You can register and manage any servers but only those in SQL Server versions 2008 and higher can … Continue reading

01/09/2014
by Marlon Ribunal
3 Comments

Laying The Ground For A Successful Reporting Project

Building a reporting system from the ground up is a daunting task. Such a big project usually involves intricate resource movement. Reporting is an important component of Business Intelligence (BI). Therefore, perceptive implementation options of the reporting portion should be … Continue reading

Google Circle
Join my Circle on Google+

Plugin by Social Author Bio