Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

Guest Columnist: Santveer Singh

SQLServerCentral.com profile

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.

   Items 1 to 3 of 3   
 

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.   Read more...
By Santveer Singh 2004/12/15 | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 5,575 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.   Read more...
By Santveer Singh 2004/11/02 | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 22,028 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.   Read more...
By Santveer Singh 2004/06/09 | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 9,330 reads
   Items 1 to 3 of 3