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,687 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,713 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

Everyone Run a SQL Saturday in 2021

By

With SQL Saturdays being rebooted, and the SQLSaturday.com website live, it’s time for events....

Modern Data Warehouse & Reverse ETL

By

An extension to the Modern Data Warehouse (MDW) that I have heard a bit...

Daily Coping 12 Apr 2021

By

I started to add a daily coping tip to the SQLServerCentral newsletter and to...

Read the latest Blogs

Forums

How to check latency for user database.

By sizal0234

Hi, One of the user databases was in Not synchronizing / In recovery mode....

How to map out multi-level Supervisor/Employee relationship

By YSLGuru

No doubt this has already been answered and probably detailed many ways so I...

T logs increasing

By atulyan.aries

Hi In one of our servers the t-logs of one of the database which...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers