The SQL Server error log contains user-defined events and certain system events you can use for troubleshooting. The errors and the informational data will be
Find a specific column from the database objects
There are many ways to find out a specific column from the database objects like Tables and stored procedures. 1) Red Gate’s SQL Search:This tool
Status of SQL Server Agent
SQL Server Agent is a Microsoft Windows service that executes scheduled jobs and DBAs need to ensure the Agent is running. There are several methods to
Server Principals Login Create and Modification Date
The certificate-based logins that start and end with double hash marks are stated below – ##MS_SQLResourceSigningCertificate## ##MS_SQLReplicationSigningCertificate## ##MS_SQLAuthenticatorCertificate## ##MS_PolicySigningCertificate## ##MS_SmoExtendedSigningCertificate## ##MS_AgentSigningCertificate## By default, they are
Certificate Based Server Logins – SQL Server
The SQL and Windows logins information will be available in sys.server_principals along with the logins that were created from certificates when SQL Server is installed.
Difference between Local File System vs HDFS
In an operating system, file system is the strategy that is used to keep track of files on a disk. It has its own method
Big Data & SQL 