(Baya Pavliashvili) SQL Server supports up to 32,767 simultaneous connections per single instance, but you should never attempt to run an application supporting this many users on a single server. It would bring the server to its knees. If you have more than several hundred concurrent users, you typ
Other News
Invoking a stored procedure from a COBOL program
(Kent Milligan) I am attempting to invoke a stored procedure (SQL) from a COBOL program. The stored procedure returns ONE result set, so the last (meaningful) statement in the stored procedure is OPEN cursor name. Once I issue the CALL in the COBOL program, how do I associate the result set to somet
Other locking things to watch out for
(Chris Eaton) Here is a script you can run if you find yourself in a situation where your applications are running slow and you want to know if there are locking problems. This script will list all the applications currently running, who is the authorization ID running the application and from what
Reading and Writing Bound XML
(Ken Getz) I need to create a Windows application that includes a “search” form that interrogates an XML document and returns the results in a grid. I have an XML file I need to load, and after I have it loaded, I want to display its contents in the grid. Then, as users enter a value into a text box
Configuring ASP.NET 2.0 Application Services to Use SQL Server 2000 or SQL Server 2005
(Scott Guthrie) Describes how to set up the new ASP.NET Membership, Role Management, and Personalization services to use a regular SQL Server instead of Microsoft SQL Server Express.
Ellison Speaks On Oracle Partner Challenges, Security
(Barbara Darrow) For a guy who has spent considerably more than $10 billion in the last year or so, Oracle CEO Larry Ellison remains a cool cookie.
How Using GUIDs in SQL Server Affect Index Performance
(Zach Nichter) Recently, I was asked my opinion on a database design schema our company developers were working on. When I heard they were using GUID’s (Global Unique Identifier) as PK’s (primary keys), my jaw about dropped.
Using Java to Handle Custom WSDL Data Types
(Jeff Hanson) The onslaught of Web services messaging and XML-based data transfer has led to a need to express these message exchanges in some structured way. The Web services Description Language (WSDL) deals with this need by defining an XML grammar for exposing services as sets of endpoints for e
Licensing distributed DB2 Universal Database (DB2) Version 8 servers in a high availability environment
(Paul Zikopoulos) Customers choose DB2 Universal Database for Linux, UNIX, and Windows (DB2) because of its incredible time to value, ability to scale and integrate across disparate environments, its robustness, and the minimization of ‘down-time’ (both planned and unplanned). This article focus
Migration to MySQL with SQLyog ver 4.1.
(Peter Laursen) With the release of Webyog’s flagship product, SQLyog Enterprise version 4.1, a new ODBC “Power Tool” is introduced that replaces the old “ODBC import tool.” Starting with SQLyog version 4.2 it was re-named “SQLyog Migration Tool,” so this is the term that I will use in this text.