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

Reblogged from Marlon Ribunal's Note On SQL Server:

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.

Read more… 99 more words

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

SQL Server 2005 Backup

Reblogged from 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):

Read more… 195 more words

SQL Server 2005 Back TSQL Basics (Reblog)

The "ALL" Parameter In SQL Server Reporting Services 2005

Reblogged from 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…

Read more… 99 more words

Adding "ALL" Parameter in SSRS (Reblog)

Steve Jobs, Thank You

No words can ever express how thankful this world is to you, Steve. You led the way. You left a mark. You left us a better world.

Photo Courtesy of Apple.com

FREE SQL Training In Los Angeles!

Red Gate’s “SQL in the City” will be in Los Angeles on October 28, 2011! That’s a Friday so make sure to check your schedule.

Verbatim from Red Gate’s Flyer:

Here are some facts about SQL in the City which may help convince your boss to let you attend this free SQL Server training event:

1. It’s a full day of SQL Server training for free.

2. You’ll meet SQL Server MVPs with years of SQL Server experience, who’ll provide you with training which you can put into practice back in the office.

3. You’ll learn new skills specific to SQL Server to help improve your daily tasks from top SQL Server experts.

4. You’ll meet the people who’ve developed the tools you use to help solve your problems.

5. This is your chance to ask Red Gate developers, product managers and other users questions, and get answers face-to-face.

6. You’ll be able to make suggestions and give your feedback about products that could influence the future development of Red Gate tools.

7. You’ll get to network with professionals who are as passionate about SQL Server as you are. 

8. Refreshments and lunch are included for free, so you won’t go hungry whilst you’re out of the office.

9. The event is in a great location with excellent transport links, so it’ll be no hassle to get there.

10. The event aims to be an awesome training experience unlike any you’ve experienced before.