In Visual Studio 2008 or Visual Studio 2010 , you've started developing your Data project and let's say you're designing your DataSet s through Visual Studio's nice DataSet Designer just by drag/dropping your entities (tables, views) into the designer , from "Server Explorer" that you connected to your...

One of our customers was saying that their SSIS Project with some complex "Data Flow Task"s with lots of Lookup Transformations was opening very slowly in BIDS ("Business Intelligence Development Studio") or I don't know if I should say "Visual Studio" ... The very first thing that I check was "validation...

Let's say you have got a SQL Server 2005/2008 cluster with two nodes. Here's the configuration in detail : Cluster name : MYCLUSTER Cluster IP : 192.168.0.10 Node 1 (active node) hostname : NODE1 Node 1 IP : 192.168.0.11 Node 2 (passive node) hostname : NODE2 Node 2 IP : 192.168.0.12...