MarlonRibunal

SQL Server Database Administrator at a supply chain and retail software company.

Twitter: @MarlonRibunal
Website: https://marlonribunal.com

All authors

Power BI KPI Report: Hospital Charge Data

by MarlonRibunal

Marlon Ribunal - SQL, Code, Coffee, etc.

Update: Just getting started with Power BI? You can download the Power BI Report File for this KPI Report. Please...

2016-02-16

2,158 reads

How to Install Microsoft R Server for Windows

by MarlonRibunal

Marlon Ribunal - SQL, Code, Coffee, etc.

Microsoft R Server, or Revolution R Enterprise (RRE) as it is formally known, for now, is basically a platform for...

2016-02-11 (first published: 2016-02-02)

2,947 reads

Getting Started With Power BI Desktop: Getting Data

by MarlonRibunal

Marlon Ribunal - SQL, Code, Coffee, etc.

Now that the Power BI Desktop is installed, let’s get some data. As of this writing, Power BI can get...

2015-09-01 (first published: 2015-08-19)

2,620 reads

Getting Started With Power BI Desktop: Simple Visualization

by MarlonRibunal

Marlon Ribunal - SQL, Code, Coffee, etc.

This is the third installment of our Getting Started With Power BI Desktop series. The first post is about installation...

2015-08-27

805 reads

Getting Started With Power BI Desktop: Installation

by MarlonRibunal

Marlon Ribunal - SQL, Code, Coffee, etc.

Power BI is becoming popular for a lot of reasons. Simply put, Power BI is “BI on your fingertips.” Companies looking to...

2015-08-13

1,216 reads

Finding gaps or missing dates in a date range using TSQL

by MarlonRibunal

Marlon Ribunal - SQL, Code, Coffee, etc.

Here’s a quick how-to on returning temporal data set that includes missing dates. Suppose you are tasked to query an...

2015-05-29

15,769 reads

How to resequence column based on numeric prefix using TSQL

by MarlonRibunal

Marlon Ribunal - SQL, Code, Coffee, etc.

Beginning in version 2005, SQL Server is making manipulation of partitioned set of rows easier by using Window Functions (ROW_NUMBER(), aggregate functions...

2015-03-26 (first published: 2015-03-19)

6,292 reads

Getting back to basics

by MarlonRibunal

Marlon Ribunal - SQL, Code, Coffee, etc.

I committed to studying for MCSA SQL Server 2012 and taking the certification exams by the end of the year…last...

2014-10-28

601 reads

Executing scripts on multiple servers the easy way

by MarlonRibunal

Marlon Ribunal - SQL, Code, Coffee, etc.

Central Management Server and server groups provide a convenient way to manage multiple servers and databases in one place and at...

2014-07-03

2,356 reads

Failed To Lock Virtual Machine’s Configuration

by MarlonRibunal

Marlon Ribunal - SQL, Code, Coffee, etc.

[Updated]
I rebuilt my Hyper-V virtual machines / virtual network by deleting the old ones and building new machines on a portable...

2014-05-23

14,757 reads

All authors

MarlonRibunal

Power BI KPI Report: Hospital Charge Data

How to Install Microsoft R Server for Windows

Getting Started With Power BI Desktop: Getting Data

Getting Started With Power BI Desktop: Simple Visualization

Getting Started With Power BI Desktop: Installation

Finding gaps or missing dates in a date range using TSQL

How to resequence column based on numeric prefix using TSQL

Getting back to basics

Executing scripts on multiple servers the easy way

Failed To Lock Virtual Machine’s Configuration

Blogs

My 2024 in Data: Music

A New Word: Suente

Side Projects

Forums

Timeout Error while executing a TSQL statement in Sql server Express Edition

Timeout Error while executing a TSQL statement in Sql server Express Edition

Sql script replace and rearrange numbers

Question of the Day

DCL