SQL, Code, Coffee, etc.

Productivity is hard to measure when your work has no definite structure like a typical office job. You may operate within the traditional 9–5 office job but the nature of working around databases requires flexibility; and, the focus is shifting constantly minute by minute…

Marlon Ribunal

Feb 6, 2018

Waiting Tasks Reveal Pain Points

Waiting tasks quickly shows you where to look for the bottlenecks. This is only one of the many times…

Marlon Ribunal

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

Jan 23, 2018

My Favorite SQL Prompt Features

SQL Prompt from Redgate Software is one of the tools that I cannot live without. Well, that’s probably…

Marlon Ribunal

Jan 16, 2018

How To Split Table Partitions Automatically

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

SQL Operations Studio As Monitoring Dashboard

Microsoft as a company has entered a new phase of innovation under the…

Marlon Ribunal

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

Marlon Ribunal

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

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…