Archive of stories published by SQL, Code, Coffee, etc.

Homepage

Open in app

SQL, Code, Coffee, etc.

All

Marlon Ribunal in SQL, Code, Coffee, etc.

Jan 16, 2018

How To Split Table Partitions Automatically

Table partitions can bring a lot of benefits to the manageability and performance of…

1 response

Marlon Ribunal in SQL, Code, Coffee, etc.

Jun 3, 2013

On Eating People

Or How to Find the Next Big Thing

Marlon Ribunal in SQL, Code, Coffee, etc.

Feb 15, 2016

Power BI KPI Report: Hospital Charge Data

The Power BI KPI report is probably on top 10 of the most in-demand use-case for Power…

Marlon Ribunal in SQL, Code, Coffee, etc.

Mar 27, 2018

Getting Things Done With SSMS

As a SQL Server pro, I spend most of my productive time in the SQL Server Management Studio (SSMS). I am…

Marlon Ribunal in SQL, Code, Coffee, etc.

Jan 8, 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…

Marlon Ribunal in SQL, Code, Coffee, etc.

Jan 30, 2018

Layman’s Guide to Performance Tuning

Performance tuning is one of those things that is hard to get right when you do not have an…

Marlon Ribunal in SQL, Code, Coffee, etc.

Apr 3, 2018

Creating Bar Graph In SQL Server 2017 Using R

l:Creating a bar graph with R in SQL Server 2017 is relatively easy. It’s just a…

Marlon Ribunal in SQL, Code, Coffee, etc.

Jan 18, 2019

Miscellaneous Notes On System Architecture and Design

When I first joined the programming team at my previous job in an aerospace company, the first observation I made was that their Data Integration System was antiquated — architecture-wise. The system architecture was adopted from legacy…

1 response

Marlon Ribunal in SQL, Code, Coffee, etc.

Dec 26, 2017

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 tech bloggers write about any given topic. The topic…

Marlon Ribunal in SQL, Code, Coffee, etc.

Mar 20, 2018

Identify R Package Dependencies Using miniCRAN

Installing R packages in SQL Server 2017 is a breeze with the stored procedure sp_execute_external_script. But so far, it is limited to installing one package at a time. If you have an R Package with dependencies, you have to install those in a…

These were the top 10 stories published by SQL, Code, Coffee, etc.; you can also dive into yearly archives: 2012, 2013, 2014, 2016, 2017, 2018, 2019, and 2021.

About

SQL, Code, Coffee, etc.

Data and stuff by @MarlonRibunal

More information