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"
Read More...
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
Read More...
Microsoft JET (Joint Engine Techonology) Database Engine is an implementation of JET Red and it should not be mixed with the JET Blue ESE (Extensible Storage Engine) which is the core of Microsoft Exchange and Active Directory. We had released the first
Read More...
Sometimes pools that we should pay attention to their "hygiene" are not only swimming pools. We should also be careful about our database "connection pool"s. Here comes the story behind this "philosophical" entrance ... One of our customers was reporting
Read More...
Let's say you've got a SQL Server (KIRK) containing a linked server against another SQL Server (SCOTTY) and you're connecting the KIRK from remote client machine (SPOCK) using SQL Server Management Studio and receiving the error message below when you
Read More...
