Subscribe to this blog
Marlon Ribunal - SQL, Code, Coffee, etc.
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, 4,165 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, 794 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, 375 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, 321 reads
Posted in Marlon Ribunal - SQL, Code, Coffee, etc. on 4 April 2012