Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
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: May 2013

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

The Windows 8 and Windows Server 2012 SP1 Virtual Machines on my laptop are connecting just fine to my physical network adapter (wifi) via the External Virtual Switch that I setup in Hyper-V (Windows 8 Pro host). I can connect to the internet to do Windows updates on those VM’s. Read more

0 comments, 1,542 reads

Posted in Marlon Ribunal - SQL, Code, Coffee, etc. on 24 May 2013

Rated R (A Teaser)

How many lines of TSQL codes and Window Functions you need to come up with this?

With R, it takes about 2 commands:

> order <- as.matrix(sqlFetch(ch,"SalesDetails")
> summary(order)

To give you an idea, I prepared the dataset into a view like this:

CREATE VIEW SalesDetails
AS
SELECT
 soh.OrderDate…

Read more

1 comments, 279 reads

Posted in Marlon Ribunal - SQL, Code, Coffee, etc. on 16 May 2013

Non-Tech Books On My Desk

This post is inspired by Andy Warren’s ( b | t ) “Books On The Desk” post.

I’ve got plenty of SQL Server books at home (physical and Kindle versions). But if I’m not in the mood of reading a tech book but itching to read anyway, I’d… Read more

0 comments, 404 reads

Posted in Marlon Ribunal - SQL, Code, Coffee, etc. on 10 May 2013

Visionary: Seeing Through Defects

Joe Lacob bought the struggling Golden State Warriors NBA franchise in 2010. He has been the most hated man by the Warriors fan base since then.

Lacob promised the fans he would turn the franchise around and get it back to the winning edge.

To set the wheels in motion,… Read more

0 comments, 273 reads

Posted in Marlon Ribunal - SQL, Code, Coffee, etc. on 3 May 2013