SQL-Articles

Category: Articles

  • Basic Slipstream Setup

    In my previous article Ive posted about slipstream and we have discussed about its methods. In this article Im going to write about creating basic slipstream setup in SQL Server 2008. In this method you will be merging the service pack with the base setup at the time of installation. This method is very simple…

  • SlipStream in SQL Server 2008 Setup

    Slipstream is a feature expected in earlier version of SQL server itself however from SQL Server 2008 SP1 its included. This is one of the most expected thing in SQL Server by DBAs since windows operating system has the feature already and the system admins can easily update their setup packages. Now we have the…

  • Creating Linked server to SYBASE from SQL Server

    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 datas from Sybase. First step in heterogeneous linked server is to create a ODBC connection to that RDBMS platform. For…

  • IP Address Blocking or Restriction in SQL 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…