Santveer Singh

B.Sc, MCSE, 10+ years IT experience, been working with SQL Server since 6.5 (1996). Worked at different levels in IT, Manufacturing and Financial industries. Currently working as SQL Server DBA with Algomod.

Finding Objects Owned by non-DBO Users

SQL Server has this concept of an owner of an object. Similar to the concept of schema, but not quite the same. Best practice dictates that all objects in SQL Server be owned by dbo, but that does not always happen. Tracking those objects down might be a pain, but Santveer Singh brings us an easy way of doing this.

2004-12-15

5,673 reads

List of Database Users with Database Roles

SQL Server shows lots of information in Enterprise Manager, but getting a report for someone or manipulating this data is hard from the GUI. Using T-SQL, it's easier, but sometimes not obvious how to get the data. Author Santveer Singh brings us a way to get at some of that information, the users and their database roles.

4.89 (19)

2004-11-02

22,665 reads

Which Databases are Being Backed Up - Another Look

Knowing which databases are being backed up is a critical thing for all DBAs to know. After reading an article on this subject, new author Santveer Singh decided to share his own techniques for checking SQL Server databases and their backup status. He shows us how to look for failed backups as well as find those databases which have not been backed up.

2 (1)

2004-06-09

9,493 reads

Blogs

Azure Platform Series “You have exceeded the maximum amount of scale changes within the past hour”

By

This blog post relates to where you might be doing scale operations of your...

Bash: “command not found” in IF statement

By

This blog post is about a situation where writing an IF THEN ELSE statement...

The First Data Saturday is Tomorrow

By

Data Saturday #2 – Guatemala is tomorrow. This is the first event on the...

Read the latest Blogs

Forums

Data Privacy Grows in California

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Data Privacy Grows in California

Grant user access to view database only

By sql_Reporter

Hi I need to grant a user access to a DB on the server...

Need to strip off the beginning of a field in SELECT statement

By tim8w

I have this table that unfortunately has spaces in the field, which I am...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers

Question of the Day

Amend a Commit

See possible answers