icelava.net

Encountered an oddball of a problem today with our usergroup server. Event Type: ErrorEvent Source: MSSQLSERVEREvent Category: (4)Event ID: 17809Date:  8/5/2007Time:  10:46:58 PMUser:  N/AComputer: SGDOTNETDescription:Could not connect because the maximum number of '2' user connections has ...

What a night this has been. Yup, here I am in the office, half past 12 midnight. And still battling with this nascent laptop to get SQL Server installed properly. Previously I had problems trying to get Analysis Services to start. I thought maybe - maybe - it could be that I am using Windows Vista Home Premium, instead of Business, Enterprise, or ...

The biggest hurdle to installing new software is the unavoidable demand (not just a mere requirement) to spend that sitting time to learn it considerably to be useful and productive with it. This factor is increased exponentially when it is the operating system that gets upgraded. After going through the Ironman journey of simply getting ...

Developers who begin to bloat the size of their assemblies destined for CLR-enabled SQL Server instances may be hit with the following timeout problem when attempting to deploy from Visual Studio to a remote server: Timeout expired.  The timeout period elapsed prior to completion of the operation or the server is not responding. This ...

well since Microsoft could not fit in enough time to fit in into SQL Server 2005, we have to leave it to the folks at Red Gate Software to purchase Prompt SQL and publish it ready for both SQL Server 2000 and 2005! via Steven Smith. Those prayers with heavy beads of sweat and Santa wish lists can stop now....

I suppose I can consider myself a Stored Procedure ''fan''. Treating a database like a object and exposing ''methods'' for others to use is a nice way to encapsulate its internal structure. However, almost every application comes with the need for searches that can define different criteria based on users' preference/knowledge. These situations ...