Vidhya Sagar - Blog

Use xp_logininfo to retrieve AD group members list

Vidhya Sagar — Tue, 23 Feb 2010 18:11:43 +0000

I was discussing with one of my colleague and during the discussion he told me that he is not able to view the list of members available in a AD group since he don’t have permission on AD forest. Normally to retrieve this he will sent the request to the AD team and they will [...]

DotNet 3.5 on Windows 7 to Install SQL Server 2008

Vidhya Sagar — Thu, 21 Jan 2010 02:22:35 +0000

This is a quick post to install or enable .Net 3.5 on windows 7. Last couple of weeks I’m seeing more questions on installing SQL Server 2008 in windows 7 and the users are unable to install SQL Server 2008 pre-requisite (.Net 3.5 ). To Install SQL Server 2008, windows installer 4.5 & .Net 3.5 [...]

SQL Server Joins

Vidhya Sagar — Mon, 18 Jan 2010 01:08:37 +0000

SQL Server Joins

Merge Drop Slipstream Setup – SQL Server 2008

Vidhya Sagar — Tue, 05 Jan 2010 15:39:14 +0000

Merge Drop Slipstream Setup – SQL Server 2008

Basic Slipstream Setup – SQL Server 2008

Vidhya Sagar — Mon, 04 Jan 2010 15:54:17 +0000

Basic Slipstream Setup – SQL Server 2008

Happy New Year 2010

Vidhya Sagar — Thu, 31 Dec 2009 02:43:22 +0000

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. I wish [...]

SlipStream in SQL Server 2008 Setup

Vidhya Sagar — Wed, 30 Dec 2009 07:02:53 +0000

SlipStream in SQL Server 2008 Setup

Change \ Transfer Schema for all Objects

Vidhya Sagar — Mon, 21 Dec 2009 15:00:55 +0000

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 [...]

Creating Linked server to SYBASE from SQL Server

Vidhya Sagar — Sat, 05 Dec 2009 02:10:09 +0000

Creating Linked server to SYBASE from SQL Server

IP Address Blocking or Restriction in SQL Server

Vidhya Sagar — Thu, 03 Dec 2009 06:03:40 +0000

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 [...]