My online presences include: Tech Blog: Marlon Ribunal - SQL, Code, Coffee, etc. Productivity & GTD Hack Blog: Productivity Bits Twitter: @MarlonRibunal
I’m not repeating here her descriptions of the different levels, so go and read her article (link… Read more
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
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.
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
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
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
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
Disclaimer: I wrote this review as a participant to O’Reilly Blogger Review Program.
If you… Read more
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
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…
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
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
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
There are situations where you need to grant
SELECT permission to a particular user and limit that access to a particular
OBJECT, say a
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
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
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
I am looking for a change. Yes, a change. This is the beginning of that quest. This blog will be the silent witness to the battles and struggles I have to go through to get where I want to be.
I have determined the journey but I am yet to… Read more