Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

Marlon Ribunal - SQL, Code, Coffee, etc.

I'm passionate about SQL Server. But I feel like I haven't reached my full potential yet. So, this is my mission: My purpose is to help people in their pursuit of growth and development; and, thereby, help myself realize my full potential as a professional, husband, father, christian, and human being.
My online presences include: Tech Blog: Marlon Ribunal - SQL, Code, Coffee, etc. Productivity & GTD Hack Blog: Productivity Bits Twitter: @MarlonRibunal

Virtual SQL Playground Adventure: Building The Virtual Environment

Few blog posts ago, I decided to build a virtual environment for a personal SQL Server sandbox. So, the Virtual SQL Playground Adventure blog series came to life.

In the introduction I promised to document everything but did not do a follow up blog post after that. That doesn’t mean… Read more

0 comments, 1,685 reads

Posted in Marlon Ribunal - SQL, Code, Coffee, etc. on 3 March 2014

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 considered. Data analysis and integration become pointless if they lack… Read more

3 comments, 2,159 reads

Posted in Marlon Ribunal - SQL, Code, Coffee, etc. on 9 January 2014

My First Book: SQL Server 2012 Reporting Services Blueprints

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 Packt Blueprints Book?

“Blueprints are basically in… Read more

6 comments, 446 reads

Posted in Marlon Ribunal - SQL, Code, Coffee, etc. on 29 October 2013

Virtual SQL Playground Adventure: Introduction

Welcome to the Virtual SQL Playground Adventure! Why Adventure? What’s an Adventure?

An adventure is an exciting or unusual experience; it may also be a bold, usually risky undertaking, with an uncertain outcome.

That is exactly what this series is all about. I can’t tell you how… Read more

1 comments, 472 reads

Posted in Marlon Ribunal - SQL, Code, Coffee, etc. on 13 June 2013

Connecting Windows Server 2003 VM To External Network In Hyper-V

The Windows 8 and Windows Server 2012 SP1 Virtual Machines on my laptop are connecting just fine to my physical network adapter (wifi) via the External Virtual Switch that I setup in Hyper-V (Windows 8 Pro host). I can connect to the internet to do Windows updates on those VM’s. Read more

0 comments, 1,551 reads

Posted in Marlon Ribunal - SQL, Code, Coffee, etc. on 24 May 2013

Rated R (A Teaser)

How many lines of TSQL codes and Window Functions you need to come up with this?

With R, it takes about 2 commands:

> order <- as.matrix(sqlFetch(ch,"SalesDetails")
> summary(order)

To give you an idea, I prepared the dataset into a view like this:

CREATE VIEW SalesDetails
AS
SELECT
 soh.OrderDate…

Read more

1 comments, 283 reads

Posted in Marlon Ribunal - SQL, Code, Coffee, etc. on 16 May 2013

Non-Tech Books On My Desk

This post is inspired by Andy Warren’s ( b | t ) “Books On The Desk” post.

I’ve got plenty of SQL Server books at home (physical and Kindle versions). But if I’m not in the mood of reading a tech book but itching to read anyway, I’d… Read more

0 comments, 407 reads

Posted in Marlon Ribunal - SQL, Code, Coffee, etc. on 10 May 2013

Visionary: Seeing Through Defects

Joe Lacob bought the struggling Golden State Warriors NBA franchise in 2010. He has been the most hated man by the Warriors fan base since then.

Lacob promised the fans he would turn the franchise around and get it back to the winning edge.

To set the wheels in motion,… Read more

0 comments, 273 reads

Posted in Marlon Ribunal - SQL, Code, Coffee, etc. on 3 May 2013

SQLMentor: Do you have a mentor?

I’ve been looking for better ways of learning and improving my SQL Server skills. Blogs, BOL, webcasts, and training videos are great learning aids. Having the right tools and method makes a lot of difference. Building a SQL Server VM Playground to put the lessons in practice is a vital… Read more

2 comments, 136 reads

Posted in Marlon Ribunal - SQL, Code, Coffee, etc. on 13 April 2013

SQL Saturday #177 – Silicon Valley

There is something about the Silicon Valley that attracts the innovative and creative individuals. The “misfits, rebels, troublemakers, and the round pegs in square holes” come here as dreamers and leave the valley as billionaires world changers. The Silicon Valley provides the opportunity and platform to make a difference for… Read more

0 comments, 318 reads

Posted in Marlon Ribunal - SQL, Code, Coffee, etc. on 20 February 2013

I’m dropping the book project

Update:

This book project got its second life. I am now collaborating with another author to bring this book to completion.

*****

I was super excited when I received an invitation to write a book on SSRS 2012. Writing a book has been in my bucket list for as… Read more

5 comments, 335 reads

Posted in Marlon Ribunal - SQL, Code, Coffee, etc. on 16 February 2013

My Writing Toolkit for the book project

I’m in the middle of writing the first chapter of my book. I’m not just ready to announce the working title yet. I’ll probably wait until I finish the 5th chapter (total of 10 chapters).

I thought it would be fun if I open up my writing process so… Read more

1 comments, 352 reads

Posted in Marlon Ribunal - SQL, Code, Coffee, etc. on 5 December 2012

Choose specific folders to sync with SkyDrive

Every time you run the SkyDrive Client on your device, a laptop in my case, all your files from the cloud are downloaded to your device locally. That is cool because you can still work on your files even when you’re offline.

The thing is I don’t need all the… Read more

0 comments, 500 reads

Posted in Marlon Ribunal - SQL, Code, Coffee, etc. on 26 November 2012

I’m Thankful for 978-1-84968-508-5

There are things that I’m thankful for this year. Yes, I also got a lot of setbacks but that wouldn’t make me less thankful.

I’m thankful for my family as always. No words can ever describe how thankful I am for the gift of family.

I’m also thankful for my… Read more

4 comments, 353 reads

Posted in Marlon Ribunal - SQL, Code, Coffee, etc. on 22 November 2012

Tools of the Trade

I needed to upgrade my tools. It was not a matter of “want” but of “need”. It’s no longer enough to have just the bare minimum, specially when you need to test or study about certain features of SQL Server that require multiple servers in a network environment.

My current… Read more

1 comments, 425 reads

Posted in Marlon Ribunal - SQL, Code, Coffee, etc. on 19 November 2012

SQL Server Express with complete SSMS

Developers will love this latest improvement, specially those that have SQL Server Express installed on their laptops or workstations but still work with full versions of SQL Server on their network.

In the past you have to have at least the Developer Version of SQL Server if you also wanted… Read more

0 comments, 595 reads

Posted in Marlon Ribunal - SQL, Code, Coffee, etc. on 15 November 2012

Agile way of acquiring SQL Server skills

You probably heard about 7 Days To OLAP by Simon Doubt. It’s Simon’s experiment on learning OLAP during his stay on the PASS Summit. This is a very interesting concept and you should try it. The experiment has four key elements:

  • Focus on one goal
  • Isolation from regular work/life responsibilities

Read more

2 comments, 1,105 reads

Posted in Marlon Ribunal - SQL, Code, Coffee, etc. on 10 November 2012

Attendant’s checklist to a SQL Saturday event

Weeks Before The Event

  1. Check for conflict in Schedule
    • Family Activities (Y/N)
    • Business Appointment (Y/N)
    • Other Commitments (Y/N)
  2. Plan the Trip
    • Distance (calculate travel time)
    • Budget $ (Gasoline, food, etc.)
    • Airline/Hotel Booking (if applicable)
  3. Want to Volunteer for the Event (Y/N)

Few Days Before The Event

  1. Check If Schedule is…

Read more

0 comments, 386 reads

Posted in Marlon Ribunal - SQL, Code, Coffee, etc. on 15 September 2012

SQLskills joining Pluralsight is a good news for all

Many can boast that they were trained by Paul and Kimberly Randal at SQLskills. That company is so highly regarded in SQL Server circle that having undergone training with them is considered a great privilege.

Not all of us will have the same privilege of sitting in an Immersion Event Read more

2 comments, 476 reads

Posted in Marlon Ribunal - SQL, Code, Coffee, etc. on 6 September 2012

Demonstration of a simple dashboard created with the Tableau Software

Like I said on Twitter, here’s the post about the dashboard I created using Tableau, a BI visualization software. I’ve been hearing good things about Tableau from different people and from the social networks. A couple of friends from Twitter encouraged me to try it and see if I… Read more

0 comments, 902 reads

Posted in Marlon Ribunal - SQL, Code, Coffee, etc. on 1 September 2012

Older posts