Dear Readers.. It was your encouragement and help that make it possible for us to success in our work, so i wish you to have more intelligence, healthy, wealthy, and wish you to have a good year. Hope to see more good articles and technical stuffs in our website to enrich our knowledge.
Monthly Archives: December 2009
Happy New Year 2010
Posted by Vidhya Sagar
on December 31, 2009
No comments
SlipStream in SQL Server 2008 Setup
Posted by Vidhya Sagar
on December 30, 2009
No comments
Slipstream is a feature expected in earlier version of SQL server itself however from SQL Server 2008 SP1 it’s included. This is one of the most expected thing in SQL Server by DBA’s since windows operating system has the feature already and the system admin’s can easily update their setup packages. Now we have the capability to merge service pack with the base setup of SQL Server 2008. There are two methods of slipstream creation available and they are below
Change \ Transfer Schema for all Objects
Posted by Vidhya Sagar
on December 21, 2009
No comments
In my working environment we will be using different schema for production and development environments. Our development apps are configured to Dev schema and Production apps are configured to Prod schema, so when we restore the db from production to development environment, all our dev apps stopped working since the objects \ securable will be using prod schema. Here I need to change the schema to dev from prod, so the syntax will be like below
Creating Linked server to SYBASE from SQL Server
Posted by Vidhya Sagar
on December 5, 2009
No comments
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
IP Address Blocking or Restriction in SQL Server
Posted by Vidhya Sagar
on December 3, 2009
19 comments
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.