Assume that there are thousands of rows in a table and the rows need to be split and saved in different CSV files based on
Category: SQL Server
SQL Server Administration, Development and Maintenance
SQL Server – Parsing, Casting and Conversion
Sometimes the data stores in the table in a different format in comparison to the real data type it belongs to. The date might be
SQL Server Error Log – Search
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
Big Data & SQL 