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

Getting Started With Power BI Desktop: Simple Visualization

This is the third installment of our Getting Started With Power BI Desktop series. The first post is about installation and the second is about getting data. In this post, let’s see how easy it is to create visualization on Power BI Desktop. If you’re quite familiar with creating… Read more

0 comments, 131 reads

Posted in Marlon Ribunal - SQL, Code, Coffee, etc. on 27 August 2015

Getting Started With Power BI Desktop: Getting Data

Now that the Power BI Desktop is installed, let’s get some data. As of this writing, Power BI can get data from 37 different data sources and data connections – File (Excel, CSV, XML, Text), Database (SQL Server, Oracle, IBM DB2, MySQL, PostgreSQL, Terada, etc.), Azure (SQL Database, Azure… Read more

2 comments, 1,397 reads

Posted in Marlon Ribunal - SQL, Code, Coffee, etc. on 19 August 2015

Getting Started With Power BI Desktop: Installation

Power BI is becoming popular for a lot of reasons. Simply put, Power BI is “BI on your fingertips.” Companies looking to adopt BI technology need not look further. Power BI is easy to learn with its intuitive tools. Gone are the days when building BI solutions always involve massive… Read more

1 comments, 185 reads

Posted in Marlon Ribunal - SQL, Code, Coffee, etc. on 13 August 2015

Finding gaps or missing dates in a date range using TSQL

Here’s a quick how-to on returning temporal data set that includes missing dates. Suppose you are tasked to query an employee’s “time sheet”. You’d want to return not only the days he’s reported to work but also all the days that he missed.

The expected result would look something like… Read more

4 comments, 424 reads

Posted in Marlon Ribunal - SQL, Code, Coffee, etc. on 29 May 2015

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 that require recursion were simplified by using combination… Read more

3 comments, 5,661 reads

Posted in Marlon Ribunal - SQL, Code, Coffee, etc. on 19 March 2015

Getting back to basics

I committed to studying for MCSA SQL Server 2012 and taking the certification exams by the end of the year…last year. That didn’t happen. At the start of this year, I made that same commitment again. Neither did that happen. At that time, I told myself there’s still a lot… Read more

4 comments, 192 reads

Posted in Marlon Ribunal - SQL, Code, Coffee, etc. on 28 October 2014

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 be designated as Central Management Server. You can execute… Read more

0 comments, 636 reads

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

Failed To Lock Virtual Machine’s Configuration

[Updated]

I rebuilt my Hyper-V virtual machines / virtual network by deleting the old ones and building new machines on a portable external hard drive. So after a while of not starting up the host laptop, I could not start any of the machines. First, I noticed that the state… Read more

0 comments, 2,235 reads

Posted in Marlon Ribunal - SQL, Code, Coffee, etc. on 23 May 2014

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

2 comments, 2,458 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,575 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

5 comments, 701 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

2 comments, 753 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

2 comments, 2,308 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, 471 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, 630 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, 456 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, 295 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, 482 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, 483 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, 500 reads

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

Older posts