04/11/2012
by Marlon Ribunal
Comments Off on How To Limit 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. … Continue reading
04/04/2012
by Marlon Ribunal
Comments Off on 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 … Continue reading
03/29/2012
by Marlon Ribunal
1 Comment
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 … Continue reading