Find LOB tables with no PRIMARY KEY

What if there is no primary key in table? Read more →

How to find SQL Filtered Indexes

Which type of index is a filtered index that includes a where clause?How to find filtered index in SQL Server? Read more →

How to capture SQL login details with Extended Events

An application owner wanted to record the usage of a specific logon and assess where the connections were coming from Read more →

Find SQL database Orphaned Users SQL script

Question: Do you have a sql script to list database orphaned users. ? I need to run a daily report , checking if orphaned database users exist and then having a process to work with the application owners to clean up. Answer: A standard script used is below. One of the keys is to differentiate between database users which are orphaned versus database users which require to be remapped. An orphaned sql database user should have an value of "INSTANCE" in the column "authentication_type_desc" in the sys.database_principals, while a sql database user without login should have a value "NONE" SELECT... Read more →

How to get SQL port number using xp_readererrorlog

If using a fixed port or dynamic port , get the xp_readererrorlog via scanning Read more →