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

Archives: January 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,254 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,094 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, 294 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, 432 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,657 reads

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