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.
Tag Archives: Administration - Page 2
IP Address Blocking or Restriction in SQL Server
Posted by Vidhya Sagar
on December 3, 2009
19 comments
Utilizing SQL 2005 Performance Dashboard in SQL Server 2008
Posted by Vidhya Sagar
on September 26, 2009
2 comments
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.
Running Adhoc queries against multiple servers using SSMS 2008
Posted by Vidhya Sagar
on September 23, 2009
1 comment
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.
Script to find SQL Job activity details
Posted by Vidhya Sagar
on September 17, 2009
15 comments
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 »
How to do Table Partitioning to an existing source table
Posted by Vidhya Sagar
on August 19, 2009
8 comments
In this article we are going to see how to partition a existing table in a database. In my working place I got a request from client to partition an existing table, I have searched in BOL but couldn’t find the exact detail how to do it. I’ve figured out that and Implemented successfully, I’m Just sharing the steps with you so that this might be helpful to you.
To show this with an example I would like to do the steps below
- Create a table and populate the data first
- Create the partition Function
- Creation the partition Scheme
- Create Clustered index on the table using the partition scheme to move the data’s to the partitions
Applies to
- SQL Server 2005
- SQL Server 2008