Database Recovery

How to Import Stock Data into Your SQL Server database

As a trader, you would want to analyze the performance of stocks to invest on the right stock. In this article we will learn how to use Microsoft SQL Server database to store historical stock data which we can later analyze using TSQL scripts or Excel macros to assist investment plans. Prepare the data: There are several online finance portals that provide historical data to public. For example, in Google finance, you can get historical data for a ticker in a tabular format. Though there is...

Read more »

How to Diagnose and Collect Health Information for Multiple Remote SQL Servers from a Central SQL Server

Collecting and analyzing health and event related information from SQL Servers is very important. This can be automated with this SQL script.  SQL server diagnosis: When it comes to SQL Server diagnosis, database administrator always uses dynamic management views to collect key information from SQL Server instances. The diagnosing task can be made easier with the less commonly used stored procedure called sys.sp_serverdiagnostics. The only drawback is, this stored procedure is available only...

Read more »