This article is to let you know how to import Excel data into SQL Server. First of all download a set of components i.e OLE
Category: RDBMS
Generate multiple CSV data files from SQL
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
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
Big Data & SQL 