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.

SQLServerCentral Article

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,724 reads

SQLServerCentral Article

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,889 reads

SQLServerCentral Article

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,494 reads

Blogs

Daily Coping 18 Oct 2021

By

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

Azure Cosmos DB – HTAP using Azure Synapse Link

By

I haven’t done much blogging in the last 6 months. My last article was...

Azure Cosmos DB – HTAP using Synapse Analytics

By

I haven’t done much blogging in the last 6 months. My last article was...

Read the latest Blogs

Forums

Event log filling up with Sql error

By IT researcher

Windows event log filling up with ERROR 1 : "The activated proc '[dbo].[SqlQueryNotificationStoredProcedure-]' running...

How to do Join

By patla4u

Hello, I am looking for output where EG_RequestID = 175998968 and Reissue from paymentID...

Connect to PostgreSQL as an External Data Source using PolyBase

By JerodJ

Comments posted to this topic are about the item Connect to PostgreSQL as an...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers