MarlonRibunal

SQL Server Database Administrator at a supply chain and retail software company.

Twitter: @MarlonRibunal
Website: https://marlonribunal.com

All authors

Finding gaps or missing dates in a date range using TSQL

by MarlonRibunal

Marlon Ribunal - SQL, Code, Coffee, etc.

Here’s a quick how-to on returning temporal data set that includes missing dates. Suppose you are tasked to query an...

2015-05-29

16,355 reads

How to resequence column based on numeric prefix using TSQL

by MarlonRibunal

Marlon Ribunal - SQL, Code, Coffee, etc.

Beginning in version 2005, SQL Server is making manipulation of partitioned set of rows easier by using Window Functions (ROW_NUMBER(), aggregate functions...

2015-03-26 (first published: 2015-03-19)

6,315 reads

Getting back to basics

by MarlonRibunal

Marlon Ribunal - SQL, Code, Coffee, etc.

I committed to studying for MCSA SQL Server 2012 and taking the certification exams by the end of the year…last...

2014-10-28

614 reads

Executing scripts on multiple servers the easy way

by MarlonRibunal

Marlon Ribunal - SQL, Code, Coffee, etc.

Central Management Server and server groups provide a convenient way to manage multiple servers and databases in one place and at...

2014-07-03

2,392 reads

Failed To Lock Virtual Machine’s Configuration

by MarlonRibunal

Marlon Ribunal - SQL, Code, Coffee, etc.

[Updated]
I rebuilt my Hyper-V virtual machines / virtual network by deleting the old ones and building new machines on a portable...

2014-05-23

14,769 reads

Virtual SQL Playground Adventure: Building The Virtual Environment

by MarlonRibunal

Marlon Ribunal - SQL, Code, Coffee, etc.

Few blog posts ago, I decided to build a virtual environment for a personal SQL Server sandbox. So, the Virtual...

2014-03-14 (first published: 2014-03-03)

3,677 reads

Laying The Ground For A Successful Reporting Project

by MarlonRibunal

Marlon Ribunal - SQL, Code, Coffee, etc.

Building a reporting system from the ground up is a daunting task. Such a big project usually involves intricate resource...

2014-01-14 (first published: 2014-01-09)

3,152 reads

My First Book: SQL Server 2012 Reporting Services Blueprints

by MarlonRibunal

Marlon Ribunal - SQL, Code, Coffee, etc.

Packt Publishing has published SQL Server 2012 Reporting Services Blueprints – the book that Mickey Stuewe (b | t) and I have...

2013-10-29

1,306 reads

Virtual SQL Playground Adventure: Introduction

by MarlonRibunal

Marlon Ribunal - SQL, Code, Coffee, etc.

Welcome to the Virtual SQL Playground Adventure! Why Adventure? What’s an Adventure?
An adventure is an exciting or unusual experience; it may...

2013-06-13

1,486 reads

Connecting Windows Server 2003 VM To External Network In Hyper-V

by MarlonRibunal

Marlon Ribunal - SQL, Code, Coffee, etc.

The Windows 8 and Windows Server 2012 SP1 Virtual Machines on my laptop are connecting just fine to my physical...

2013-05-31 (first published: 2013-05-24)

4,796 reads

Discuss

All authors

MarlonRibunal

Finding gaps or missing dates in a date range using TSQL

How to resequence column based on numeric prefix using TSQL

Getting back to basics

Executing scripts on multiple servers the easy way

Failed To Lock Virtual Machine’s Configuration

Virtual SQL Playground Adventure: Building The Virtual Environment

Laying The Ground For A Successful Reporting Project

My First Book: SQL Server 2012 Reporting Services Blueprints

Virtual SQL Playground Adventure: Introduction

Connecting Windows Server 2003 VM To External Network In Hyper-V

Blogs

Automated SQL Server Benchmarking with HammerDB and Docker: A Complete Testing Framework

T-SQL Snapshot Backups on Availability Group Secondary Replicas

The Book of Redgate: Hours

Forums

Alamat BCA KCP Iskandar Muda Telp/Wa:0821-8200-233

BCA KCP Panglima Polim Raya Tlp:0821-8200-203

Alamat BCA KCP Kota Kasablanka Tlp/Wa:0821-8200-174

Question of the Day

Squared Values