Vidhya Sagar – Blog

In this article we going to look into creating a heterogeneous linked server. i.e. We are going to create a linked server to SYBASE database server from SQL Server environment and then going to query data’s from Sybase. First step in heterogeneous linked server is to create a ODBC connection to that RDBMS platform. For creating ODBC connection we need the ODBC drivers for that RDBMS platform. In this case we need Sybase driver in client machine, this is not included in windows so you need to download it from Sybase Website. Lets discuss on this step by step

Read more…

Vidhya Sagar General Administration, Linked Server

I have seen some questions in forums asking for the answer “is it possible to block connections to SQL Server based on IP address”. As far as now there is no official way in SQL Server to block the connections in SQL Server based on IP address. However this can be done from the OS end, we have the following three options available, refer HERE for more.

Read more…

Vidhya Sagar Security Administration, ip blocking

I got a question from one of our UG member. He asked whether we can use SQL Server 2005 performance dashboard with SQL Server 2008. When we tried at the session we failed to implement it in SQL2K8. I was just thinking this today and planned to try this. I found out the reason why we failed to implement and what has changed in the query.

Read more…

Vidhya Sagar Performance Administration, Performance

Getting information from multi servers for a query is a big process for DBAs and we don’t have a direct option available till SQL 2008 Client tools. We need to write our own manual batch file to execute the query against all the server to fetch the information. In SQL Server 2008 management studio MS team has introduced this in SQL Server management studio 2008.

Read more…

Vidhya Sagar General, SSMS Administration, SSMS

I’ve written a script to find the job activity details, this script will give the output similar to job activity monitor in SQL2K5 or SQL2K8. In my working place we had a request to collect the job details from all the servers which includes all version of SQL Server. I’ve tried sp_help_jobactivity for SQL2K5 \ SQL2k8, however it doesn’t provide the columns needed. So I’ve written a script to get customized output, this script will also work with SQL2K. The script will fetch the following details Read more…

Vidhya Sagar Scripts Administration, Scripts