-->
SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 

Marlon Ribunal - SQL, Code, Coffee, etc.

I'm passionate about SQL Server. But I feel like I haven't reached my full potential yet. So, this is my mission: My purpose is to help people in their pursuit of growth and development; and, thereby, help myself realize my full potential as a professional, husband, father, christian, and human being.
My online presences include: Tech Blog: Marlon Ribunal - SQL, Code, Coffee, etc. Productivity & GTD Hack Blog: Productivity Bits Twitter: @MarlonRibunal

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 mainframes. Most of the business processes have been migrated to modern servers at… Read more

0 comments, 183 reads

Posted in Marlon Ribunal - SQL, Code, Coffee, etc. on 18 January 2019

Book Review: SQL Server 2017 on Linux

I don’t have any statistics but I think most IT Professionals in the SQL Server field are managing or developing solutions on their SQL Server Databases deployed on Windows Servers. If you’re planning to try SQL Server on Linux, this is a good book to get you started. Or, if… Read more

0 comments, 359 reads

Posted in Marlon Ribunal - SQL, Code, Coffee, etc. on 11 January 2019

Looking Forward

2018 has come and gone. And we’re on a new year once again. This is another opportunity for a new beginning and new goals to aspire for. For most of us, the new year brings the promise of a restart or reboot. We can start with a clean slate. The… Read more

0 comments, 187 reads

Posted in Marlon Ribunal - SQL, Code, Coffee, etc. on 4 January 2019

Forecasting Kyle Kuzma’s Field Goal Percentage (FG%)

More and more tools are becoming available for data analysts and data scientists. These tools provide convenience and lower the bar of entry for aspiring data professional.

I’ve been looking for an easy way to get to learning predictive analysis and forecasting. Prophet provides that path. Prophet is released by… Read more

0 comments, 2,352 reads

Posted in Marlon Ribunal - SQL, Code, Coffee, etc. on 22 December 2018

How I Work: Data Professionals at Work

It has been a busy year so far. Last March, I did a review, as a Technical Reviewer, for a SQL 2017 Machine Learning book. In the summer, the whole family went to the Philippines for a 3-week vacation. Between the Machine Learning book and the vacation, I was… Read more

0 comments, 224 reads

Posted in Marlon Ribunal - SQL, Code, Coffee, etc. on 2 November 2018

Creating Facets in SQL Server 2017 Using R

SQL Server 2017 In-Database Machine learning has brought the analytics closer to the data. It is now convenient to do data analytics either by using the programming language R or Python with the database engine.

In my previous post, I have demonstrated how easy it is to create a bar… Read more

0 comments, 807 reads

Posted in Marlon Ribunal - SQL, Code, Coffee, etc. on 11 April 2018

Creating Bar Graph In SQL Server 2017 Using R

Creating a bar graph with R in SQL Server 2017 is relatively easy. It’s just a matter of finding the correct functions, components, and properties of the package of your choice. For our example here, I am using ggplot2 which is probably the most popular plotting system for R.

Let’s… Read more

0 comments, 2,397 reads

Posted in Marlon Ribunal - SQL, Code, Coffee, etc. on 3 April 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 currently using the latest version as of this writing, which is v17.6.

I set it up in different configurations according to my taste at any given time. After… Read more

0 comments, 2,873 reads

Posted in Marlon Ribunal - SQL, Code, Coffee, etc. on 27 March 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 separately.

Here’s an easy way to… Read more

0 comments, 349 reads

Posted in Marlon Ribunal - SQL, Code, Coffee, etc. on 20 March 2018

Getting Started With R In SQL Server 2017

Prior to SQL Server 2016, running R on Microsoft platform required an installation of the R Language and its environment and an external IDE to write R codes. Then came the Microsoft R Server and its own flavor of R, the Microsoft R Open. With SQL Server 2016, and now… Read more

2 comments, 3,138 reads

Posted in Marlon Ribunal - SQL, Code, Coffee, etc. on 13 March 2018

Book Review: SQL Server 2017 Machine Learning Services With R

Disclaimer: I’m one of the Technical Reviewers for this book.

With the rising demand for cloud computing and wide adaptation of cloud-based analytics platforms such as Data Lake Analytics and the likes, the chasm between the traditional Data Professionals and their need for analytics literacy is becoming wider and wider.… Read more

1 comments, 2,601 reads

Posted in Marlon Ribunal - SQL, Code, Coffee, etc. on 6 March 2018

Productivity For The Data Pro

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. One moment you’re looking at something… Read more

0 comments, 389 reads

Posted in Marlon Ribunal - SQL, Code, Coffee, etc. on 27 February 2018

Killing A Service Broker SPID

Killing a SPID shouldn’t be complicated. Execute the command KILL [SPID] and that should kill the session. But there are situations where a SPID that is spawned by the Service Broker stays alive even after the queue is stuck in limbo.

No matter how many times you kill the SPID,… Read more

0 comments, 2,519 reads

Posted in Marlon Ribunal - SQL, Code, Coffee, etc. on 20 February 2018

Database Maintenance Without Breaking The Bank

Database maintenance does not have to be expensive. There are free tools out there that will make your life easier. Of course, commercial DBA tools are worth their price – they are paid for a reason. Software like SolarWinds Database Performance Analyzer and Redgate SQL Monitor are two examples of… Read more

0 comments, 3,055 reads

Posted in Marlon Ribunal - SQL, Code, Coffee, etc. on 13 February 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 that I didn’t have to go beyond identifying the waiting tasks to quickly troubleshoot a production performance issue.

I have encountered a case where an application filter got stuck in loading… Read more

0 comments, 2,006 reads

Posted in Marlon Ribunal - SQL, Code, Coffee, etc. on 6 February 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 established methodology of how to approach the problem.

Consider this scenario.

The application users are complaining about their app being so slow and explaining further that they didn’t do anything out… Read more

2 comments, 3,414 reads

Posted in Marlon Ribunal - SQL, Code, Coffee, etc. on 30 January 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 an exaggeration but I use it daily in my job. Whether I’m writing stored procedures or crunching TSQL codes to troubleshoot data issues in SQL Server, I depend on it to show… Read more

1 comments, 2,228 reads

Posted in Marlon Ribunal - SQL, Code, Coffee, etc. on 23 January 2018

How To Split Table Partitions Automatically

Table partitions can bring a lot of benefits to the manageability and performance of your SQL Server – that is if the partitions are configured and designed correctly. If you’ve got a large table with hundreds of millions of records, and you need to maintain a portion of that table… Read more

1 comments, 374 reads

Posted in Marlon Ribunal - SQL, Code, Coffee, etc. on 16 January 2018

SQL Operations Studio As Monitoring Dashboard

Microsoft as a company has entered a new phase of innovation under the leadership of their CEO Satya Nadella. In the database world, few of the things that came out of this innovation are SQL Server for Linux, Azure SQL Database, Azure SQL Datawarehouse, etc. As the technology stack,… Read more

2 comments, 511 reads

Posted in Marlon Ribunal - SQL, Code, Coffee, etc. on 9 January 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 that you want to… Read more

0 comments, 1,743 reads

Posted in Marlon Ribunal - SQL, Code, Coffee, etc. on 2 January 2018

Older posts