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

SQLskills joining Pluralsight is a good news for all

Many can boast that they were trained by Paul and Kimberly Randal at SQLskills. That company is so highly regarded in SQL Server circle that having undergone training with them is considered a great privilege.

Not all of us will have the same privilege of sitting in an Immersion Event Read more

2 comments, 542 reads

Posted in Marlon Ribunal - SQL, Code, Coffee, etc. on 6 September 2012

Demonstration of a simple dashboard created with the Tableau Software

Like I said on Twitter, here’s the post about the dashboard I created using Tableau, a BI visualization software. I’ve been hearing good things about Tableau from different people and from the social networks. A couple of friends from Twitter encouraged me to try it and see if I… Read more

0 comments, 964 reads

Posted in Marlon Ribunal - SQL, Code, Coffee, etc. on 1 September 2012

Digging deeper into SQL Server

I’m nowhere near where I needed to be. I am not digging enough. I’m not learning enough. Learning opportunities are not landing on my lap.

I have to go out on my own and learn SQL Server on my own time and resources.

This blog was never meant to become… Read more

5 comments, 617 reads

Posted in Marlon Ribunal - SQL, Code, Coffee, etc. on 25 August 2012

Lenovo’s Cancellation Policy is not consumer-friendly

I recently placed an order for a ThinkPad W530 from Lenovo. One day before the estimated shipping date, I noticed that I inadvertently picked the integrated wireless card that I didn’t want (ThinkPad B/G/N 1×1). I wanted the Intel Centrino Ultimate-N 6300 (or at least Intel Centrino Advanced-N 6205) instead. Read more

5 comments, 834 reads

Posted in Marlon Ribunal - SQL, Code, Coffee, etc. on 9 August 2012

Getting to the next level in your SQL Server career

Jen McCown (Blog | Twitter) wrote about an interesting topic on the different levels of database professionals. In her article, Jen identified the three levels as Junior, Mid-Level, and High-Level.

I’m not repeating here her descriptions of the different levels, so go and read her article (link… Read more

1 comments, 757 reads

Posted in Marlon Ribunal - SQL, Code, Coffee, etc. on 4 August 2012

Learning solid SQL Server and Business Intelligence skills through online training

I have just signed up for a one year standard subscription of Pluralsight Hardcore Developer Training. I’m focusing on SQL Server and Business Intelligence. My training goal is to improve my technical knowledge and gain new industrial skills to get myself ready for opportunities now and the future.

I… Read more

4 comments, 940 reads

Posted in Marlon Ribunal - SQL, Code, Coffee, etc. on 28 July 2012

This week’s links on monitoring SQL Server performance

From time to time, I will be posting links that I encountered during the week. This is also one way of tracking blog posts that I liked. I hope others will find values in these links.

The Scene Behind NOLOCK – Take another look on the behind the scenes of… Read more

2 comments, 532 reads

Posted in Marlon Ribunal - SQL, Code, Coffee, etc. on 6 July 2012

Why I failed my goals

I have two goals that I have sought to achieve by mid-year of 2012. The deadline I set for myself is up. Goals achieved: Zero, Zip, Nada, Zilch.

Null. Or is that " "?

Earlier this year I set two goals: 1. Learn Ruby on Rails 2. Obtain a… Read more

4 comments, 707 reads

Posted in Marlon Ribunal - SQL, Code, Coffee, etc. on 29 June 2012

I don’t care and why that is good for my blog

I expressed in my About page that this blog is never meant to be a technical blog. But the pressure of relevancy keeps popping up: I need technical content if I want this blog to survive. Readers want to read technical stuff – something they can apply in their job. Read more

4 comments, 536 reads

Posted in Marlon Ribunal - SQL, Code, Coffee, etc. on 22 June 2012

T-SQL Tuesday #31 – Logging

This month’s T-SQL Tuesday is hosted by Aaron Nelson (@SQLvariant | Blog). The topic is about logging. Many will talk about their logging strategies with their SQL Server infrastructure. Many will show us ways they do their day-to-day logging. And many will offer tips and tricks to expert… Read more

2 comments, 604 reads

Posted in Marlon Ribunal - SQL, Code, Coffee, etc. on 12 June 2012

Getting started with SQL Server on private cloud

I have been invited to a private beta of SQLDirector by ScaleGrid. “SQLDirector is a MS SQL as a Service (SaaS) solution for the private cloud.” It is a software solution for your private cloud or virtualization infrastructure.

SQLDirector makes the deployment of SQL Server on virtual infrastructure quick… Read more

1 comments, 650 reads

Posted in Marlon Ribunal - SQL, Code, Coffee, etc. on 6 June 2012

Review of “Start Here! Learn Microsoft Visual C# 2010?

Disclaimer: I wrote this review as a participant to O’Reilly Blogger Review Program.

If you’ve never seen a programming code in your life and want to build a simple program without really trying to learn how to code first, this might just be a good book for you.

If you… Read more

1 comments, 664 reads

Posted in Marlon Ribunal - SQL, Code, Coffee, etc. on 5 June 2012

Are you ready?

I have talked about wanting a change. I thought I am prepared to embrace that change when it finally comes.

I have waited for the right opportunity. And, yes, I finally met the right opportunity.

I wish this is a success story.

If there is one blog post I remember… Read more

1 comments, 596 reads

Posted in Marlon Ribunal - SQL, Code, Coffee, etc. on 1 June 2012

Your SQL Server database just failed, can you restore the backup?

It’s one thing to be able to backup a database, it’s another thing to be able to restore it into an operational database in case of failure. We can run a simple TSQL to check the validity of a backup file. We can do something like this:

 RESTORE VERIFYONLY FROM…

Read more

0 comments, 2,476 reads

Posted in Marlon Ribunal - SQL, Code, Coffee, etc. on 9 May 2012

On the road less traveled: a DBA Roadmap review

The story of why I came up with this blog is no secret to the few readers I have here. In fact, I have written about it in my inaugural post. Although I wrapped it in rather obscure way, you probably get what I meant by the words I’ve… Read more

2 comments, 646 reads

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

Who are the sysadmins in this sql server?

Here’s a quick query that you can run to find out the users with sysadmin fixed server role. Sysadmins have a complete control of your server. So, it is very important to know who these people are.

Just to give you an example on why it is very important to… Read more

5 comments, 7,374 reads

Posted in Marlon Ribunal - SQL, Code, Coffee, etc. on 23 April 2012

10 must follow blogs that might not be in your list

There are few memes going around in the SQL world. Probably the most popular of them is TSQL Tuesday (#tsql2sday). Of course, there’s Meme Monday (#mememonday) and also Un-SQL Friday. Another meme that has been gaining traction is #Meme15 to which this post is contributed.

What’s the significance of a… Read more

5 comments, 1,014 reads

Posted in Marlon Ribunal - SQL, Code, Coffee, etc. on 16 April 2012

Limiting user access to your database

There are situations where you need to grant SELECT permission to a particular user and limit that access to a particular OBJECT, say a TABLE.

Here’s a quick way of accomplishing this. In this example we’re using the AdventureWorks2008R2 database.

I have already created the LOGIN in advance… Read more

0 comments, 839 reads

Posted in Marlon Ribunal - SQL, Code, Coffee, etc. on 11 April 2012

The evolving role of the database professional

The role of the database professional is quickly evolving to conform with the ever changing demands of the business world. The new game of the data pro is adaptation.

The demarcation between the roles of database administrator and database developer has disappeared. You cannot succeed in one path without succeeding… Read more

0 comments, 551 reads

Posted in Marlon Ribunal - SQL, Code, Coffee, etc. on 4 April 2012

Save yourself from despair with full database documentation

Your ability to document thoroughly will determine  your efficiency and productivity when it comes to managing your SQL Server databases. Aside from the question of productivity, there’s always the concern of having to come across with problems relating to the unfamiliarity of vendor databases (this is particularly true with third-party… Read more

0 comments, 823 reads

Posted in Marlon Ribunal - SQL, Code, Coffee, etc. on 29 March 2012

Newer posts

Older posts