Laying The Ground For A Successful SSRS Project

Data analysis and integration become pointless if they lack the proper delivery of meaningful presentation to those who need them.

via Laying The Ground For A Successful SSRS Project.

My Tutorial Book Has Been Published

I have long abandoned this blog and moved to my permanent home-blog at

The Book You Need To Take Your SQL Server Reporting Services Skills From Zero to Hero!

marlonribunal.com.

But I am here again to tell you about my book: SQL Server 2012 Reporting Services Blueprints.

If you want to learn SSRS or deepen your knowledge about it, you may want to grab a copy of this book.

I have more information on my blog: SQL Server 2012 Reporting Services Blueprints

Thanks!

Come visit me on my home-blog: SQL, Code, Coffee, etc.

Marlon

This Blog Has Moved! Please Update Your RSS Feed

To continue to receive updates from me, please update your RSS Feed Address to:

http://feeds.feedburner.com/MarlonRibunal

If you haven’t noticed, the new blog is located at http://marlonribunal.com

Thanks!

 

Marlon

A New Blog, A New Journey

Update: If you want to subscribe to my new blog, please grab the RSS Feed: http://feeds.feedburner.com/MarlonRibunal

I started this blog about four years ago. But in the last couple of years, the activity in this blog has slowed down. Now it has become inactive. I am quitting this blog.

No, I’m not quitting blogging altogether. This is something I love to do. I felt I needed to start anew.

I am on a new journey towards a goal. I am in pursuit of something I really love.

I want to start a new brand – my own brand. That is why I built a new blog.

I am looking forward to learning and sharing about SQL Server and data in general in the new blog. The blog bears my name; so it  reflects my goals, aspirations, and struggles as a person, professional, and data worker.

I want to become a better data professional. The blog chronicles that journey.

Please check out my first post: “I am looking for change“

Find User Tables and Their Columns Info in SQL Server Using Object Catalog Views (Repost)

Marlon Ribunal's Note On SQL Server

[Update 07-09-09: Added MSDN Link at the bottom]

Here’s a quick TSQL solution that you can use to find all the User Tables and their Columns, inluding Data Types, and Column size. This is useful when you need a quick way of finding info on creating your Database’s documentation. Whenever I am asked to document a new system/application or review an existing one, I always want to start from the very core of the system – mostly, this is a Database backend.

SELECT t.name AS [TABLE Name],
c.name AS [COLUMN Name],
p.name AS [DATA Type],
p.max_length AS[SIZE],
CAST(p.PRECISIONASVARCHAR)
+'/'
+ CAST(p.scale ASVARCHAR) AS [PRECISION/Scale]

FROMsys.objectsAS t

JOINsys.columnsAS c
ON t.OBJECT_ID=c.OBJECT_ID
JOINsys.typesAS p
ON c.system_type_id=p.system_type_id

WHERE t.type_desc='USER_TABLE';

UPDATE: MSDN LINK

Querying the SQL Server System Catalog FAQSQL Server 2005 | SQL…

View original post 4 more words

SQL Server 2005 Back TSQL Basics (Reblog)

Marlon Ribunal's Note On SQL Server

Most of the people, if not all, who work around the SQL Server know how to backup their databases by heart. They can even do the task in their sleep. Some may find this article useful, though.

What we’re going to do here is do the 3 backup types: Full, Differential, and Transaction Log Backups.

Here’s how to backup a SQL Server Database (suppose we’re backing up the AdventureWorks Database):

1. Create a directory: C:\myBackUpDir (you may want to create this in a separate physical disk)

2. Open SSMS, and connect to the instance. Open a new query.

3. Execute a Full Backup:

BACKUP DATABASE AdventureWorks TO DISK = ‘ C:\myBackUpDir\ADVWRKS.BAK’

4. Since we also want to create a Differential backup, make any change to one of the tables in the AdventureWorks Database. Next, we want to backup the Transaction Log and capture the change that has been made. Execute:

View original post 115 more words

Adding “ALL” Parameter in SSRS (Reblog)

Marlon Ribunal's Note On SQL Server

One of the most common business requirements for SQL Server Reporting Services is that an SSRS Report should be dynamic. Dynamic in a sense that the report consumer can query the report in a variety of ways. In this post, I will demonstrate how you can add a parameter value “ALL” to return all of the desired result.

I have four parameters in this report; all of them are optional (can be NULL). I will demonstrate the optionality in a different post. For the mean time, let me demonstrate how to add “ALL” in a parameter.

My parameter, which we alias here as “param1”, is optional. Here is how I created my statement in TSQL and wrapped it in a Stored Procedure:

As you can see, a simple “Union ALL” statement can do the job. I can include NULL value in param1 because that parameter is meant to…

View original post 21 more words