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,157 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,945 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,215 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,683 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

600 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,756 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

How to find free space in Azure PosgreSQL

T-SQL Tuesday #180: Good enough is perfect Roundup

Using SQL Compare with Read-only Access

Forums

Compare rows within the same table

Microsoft Recommendations for Update Stats?

how can i tell if our db2 driver is ms or ibm or other?

Question of the Day

A Strange Result