Archives: April 2012
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