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: April 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,488 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,026 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, 859 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, 563 reads

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