-->
SQL Clone
SQLServerCentral is supported by Redgate
 
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

How To Split Table Partitions Automatically

Table partitions can bring a lot of benefits to the manageability and performance of your SQL Server – that is if the partitions are configured and designed correctly. If you’ve got a large table with hundreds of millions of records, and you need to maintain a portion of that table… Read more

0 comments, 163 reads

Posted in Marlon Ribunal - SQL, Code, Coffee, etc. on 16 January 2018

SQL Operations Studio As Monitoring Dashboard

Microsoft as a company has entered a new phase of innovation under the leadership of their CEO Satya Nadella. In the database world, few of the things that came out of this innovation are SQL Server for Linux, Azure SQL Database, Azure SQL Datawarehouse, etc. As the technology stack,… Read more

2 comments, 261 reads

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

My Tech Reading List to Start the Year

My bold learning goals call for adequate preparation and proportionate action. Before plunging into the challenge, I need to get myself into a focused learning mode quickly. The most effective way for me to do that is by reading. If you are like me, every time that you want to… Read more

0 comments, 1,361 reads

Posted in Marlon Ribunal - SQL, Code, Coffee, etc. on 2 January 2018

My Learning Goals for 2018

A couple of weeks ago, the SQL Server community had their last T-SQL Tuesday of the year – 97th since 2009 – hosted by Mala (b|t). T-SQL Tuesday, a brainchild of Adam Machanic (b|t), is a monthly blog party in which participant… Read more

1 comments, 457 reads

Posted in Marlon Ribunal - SQL, Code, Coffee, etc. on 26 December 2017

Book Review: High Performance SQL Server

As SQL Server professionals, we sometimes encounter some issues that we haven’t seen before or have seen already but forgot how we fixed them. There are few things that we usually do in these situations: Diagnose using sp_whoisactive or sp_Blitz, or any other tools that we have at our… Read more

1 comments, 178 reads

Posted in Marlon Ribunal - SQL, Code, Coffee, etc. on 3 October 2017

Power BI KPI Report: Hospital Charge Data

Update: Just getting started with Power BI? You can download the Power BI Report File for this KPI Report. Please find the link at the end of this post.

The Power BI KPI report is probably on top 10 of the most in-demand use-case for Power BI.  In my previous… Read more

4 comments, 1,550 reads

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

How Much Hospitals Charge For The Same Type Of Cases?

Update: For the KPI version of this report, please check Power BI KPI Report: Hospital Charge Data

How much hospitals charge for the same type of cases compared with the average across the US and other cities around the world (limited data)?

The data used in this analysis may be… Read more

4 comments, 2,050 reads

Posted in Marlon Ribunal - SQL, Code, Coffee, etc. on 9 February 2016

How to Install Microsoft R Server for Windows

Microsoft R Server, or Revolution R Enterprise (RRE) as it is formally known, for now, is basically a platform for advanced analytics designed to tackle big data statistics, predictive modeling, and machine-learning capabilities.

The open source R is limited in capacity as it is “single threaded and memory bound.” Microsoft… Read more

1 comments, 2,651 reads

Posted in Marlon Ribunal - SQL, Code, Coffee, etc. on 2 February 2016

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

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

4 comments, 2,403 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

4 comments, 954 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

5 comments, 3,658 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, 6,145 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, 454 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

1 comments, 1,667 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, 10,172 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, 3,287 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, 3,016 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, 1,103 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, 1,279 reads

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

Older posts