MarlonRibunal

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

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

Book Review: High Performance SQL Server

by MarlonRibunal

Marlon Ribunal - SQL, Code, Coffee, etc.

As SQL Server professionals, we sometimes encounter some issues that we haven’t seen before or have seen already but forgot...

2017-10-03

388 reads

How Much Hospitals Charge For The Same Type Of Cases?

by MarlonRibunal

Marlon Ribunal - SQL, Code, Coffee, etc.

Update: For the KPI version of this report, please check Power BI KPI Report: Hospital Charge Data
How much hospitals charge...

2016-02-16 (first published: 2016-02-09)

2,210 reads

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,163 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,970 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,625 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

809 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,219 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

16,153 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,301 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

602 reads

All authors

MarlonRibunal

Book Review: High Performance SQL Server

How Much Hospitals Charge For The Same Type Of Cases?

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

Blogs

SQL Server is Slow, part 3 of 4

AI Model Size, Parameters and Download

Expanding Your DBA Horizons: Installing PostgreSQL in a Home Lab

Forums

caught off guard by some greek lettering in a warehouse feed

Unlocking High-Concurrency Inserts in SQL Server with OPTIMIZE_FOR_SEQUENTIAL_KEY

Vector Datatype

Question of the Day

Vector Datatype