03/19/2015
by Marlon Ribunal
3 Comments
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
01/09/2014
by Marlon Ribunal
3 Comments
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
10/29/2013
by Marlon Ribunal
15 Comments
Packt Publishing has published SQL Server 2012 Reporting Services Blueprints – the book that Mickey Stuewe (b | t) and I have been collaborating on for months. Packt has published this title under their Blueprints Series. What exactly is a … Continue reading