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

Certification on Orchestrating Big Data with Azure Data Factory

I took a break from blogging this week to finish the course for and get certified with Orchestrating Big Data with Azure Data Factory on edX. This is a verified certificate of achievement.

The topics covered include but not limited to:

  • Creating data workflows with Azure Data Factory
  • Scheduling data…

Read more

0 comments, 255 reads

Posted in Marlon Ribunal - SQL, Code, Coffee, etc. on 16 March 2019

SQL Server 2017 Reporting Services: The Basics Part 5

We’re now on Part 5 of our SQL Server Reporting Services Basics Series. In this installment, we’ll learn how to use a range parameter. If you want to review the series: Part 1, Part 2, Part 3, Part 4.

You may remember in Part 4… Read more

0 comments, 1,371 reads

Posted in Marlon Ribunal - SQL, Code, Coffee, etc. on 9 March 2019

Transforming Data With Azure Data Factory Data Flow

Azure Data Factory (ADF) offers a convenient cloud-based platform for orchestrating data from and to on-premise, on-cloud, and hybrid sources and destinations. But it is not a full Extract, Transform, and Load (ETL) tool. For those who are well-versed with SQL Server Integration Services (SSIS), ADF would be the Control… Read more

0 comments, 308 reads

Posted in Marlon Ribunal - SQL, Code, Coffee, etc. on 1 March 2019

Copy Data From On-Premise SQL Server To Azure Database Using Azure Data Factory

Let’s take a break from our SQL Server 2017 Reporting Services Basics Series and jump to Azure Data Factory (v2). The latest installment on our SSRS Series is about adding a simple parameter to the report, which you can find here.

Azure Data Factory (ADF) is a data integration… Read more

0 comments, 878 reads

Posted in Marlon Ribunal - SQL, Code, Coffee, etc. on 21 February 2019

SQL Server 2017 Reporting Services: The Basics Part 4

Note: I’ve been meaning to start a series on the basics of SQL Server Reporting Services (SSRS). The last time I did this was on a book on SQL Server 2012 Reporting Services published by Packt. SSRS has since evolved into a better reporting platform with the addition of… Read more

0 comments, 268 reads

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

SQL Server 2017 Reporting Services: The Basics Part 3

Note: I’ve been meaning to start a series on the basics of SQL Server Reporting Services (SSRS). The last time I did this was on a book on SQL Server 2012 Reporting Services published by Packt. SSRS has since evolved into a better reporting platform with the addition of… Read more

2 comments, 407 reads

Posted in Marlon Ribunal - SQL, Code, Coffee, etc. on 8 February 2019

SQL Server 2017 Reporting Services: The Basics Part 2

Note: I’ve been meaning to start a series on the basics of SQL Server Reporting Services (SSRS). The last time I did this was on a book on SQL Server 2012 Reporting Services published by Packt. SSRS has since evolved into a better reporting platform with the addition of… Read more

3 comments, 2,801 reads

Posted in Marlon Ribunal - SQL, Code, Coffee, etc. on 1 February 2019

SQL Server 2017 Reporting Services: The Basics Part 1

I’ve been meaning to start a series on the basics of SQL Server Reporting Services (SSRS). The last time I did this was on a book on SQL Server 2012 Reporting Services published by Packt. SSRS has since evolved into a better reporting platform with the addition of KPI’s,… Read more

3 comments, 2,643 reads

Posted in Marlon Ribunal - SQL, Code, Coffee, etc. on 25 January 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 mainframes. Most of the business processes have been migrated to modern servers at… Read more

0 comments, 2,035 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, 426 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, 233 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,427 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, 272 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, 861 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,469 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,920 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, 404 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,245 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,671 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, 444 reads

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

Older posts