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” part. As you know, […]

Read More → Why my BIDS is slow in design mode ?

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 The SQL Server Instance […]

Read More → How you should set your firewall rules to be able to connect to a SQL Server 2005/2008 clustered instance

  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 versions of the JET OLE DB Provider and JET ODBC Drivers in […]

Read More → The points that you should think again and again using JET Database Engine in a multi-threaded application (like a classic ASP or ASP.Net web application)

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 an issue when they were about to put their web server farm on production.  Strangely […]

Read More → “Please take a shower before entering the connection pool” !

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 executed a query involving the linked server :  “Error 18456: Login failed for user ‘NT […]

Read More → How to set up a Kerberos Authentication Scenario with SQL Server Linked Servers