-->
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

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, 699 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,256 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,772 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, 256 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, 2,911 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

0 comments, 2,476 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, 258 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,188 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, 2,918 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, 1,927 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,229 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,072 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, 292 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, 427 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,650 reads

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

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… Read more

1 comments, 608 reads

Posted in Marlon Ribunal - SQL, Code, Coffee, etc. on 26 December 2017

Book Review: High Performance SQL Server

As SQL Server professionals, we sometimes encounter some issues that we haven’t seen before or have seen already but forgot how we fixed them. There are few things that we usually do in these situations: Diagnose using sp_whoisactive or sp_Blitz, or any other tools that we have at our… Read more

1 comments, 278 reads

Posted in Marlon Ribunal - SQL, Code, Coffee, etc. on 3 October 2017

Power BI KPI Report: Hospital Charge Data

Update: Just getting started with Power BI? You can download the Power BI Report File for this KPI Report. Please find the link at the end of this post.

The Power BI KPI report is probably on top 10 of the most in-demand use-case for Power BI.  In my previous… Read more

4 comments, 1,803 reads

Posted in Marlon Ribunal - SQL, Code, Coffee, etc. on 16 February 2016

How Much Hospitals Charge For The Same Type Of Cases?

Update: For the KPI version of this report, please check Power BI KPI Report: Hospital Charge Data

How much hospitals charge for the same type of cases compared with the average across the US and other cities around the world (limited data)?

The data used in this analysis may be… Read more

4 comments, 2,119 reads

Posted in Marlon Ribunal - SQL, Code, Coffee, etc. on 9 February 2016

How to Install Microsoft R Server for Windows

Microsoft R Server, or Revolution R Enterprise (RRE) as it is formally known, for now, is basically a platform for advanced analytics designed to tackle big data statistics, predictive modeling, and machine-learning capabilities.

The open source R is limited in capacity as it is “single threaded and memory bound.” Microsoft… Read more

2 comments, 2,774 reads

Posted in Marlon Ribunal - SQL, Code, Coffee, etc. on 2 February 2016

Older posts