White Paper by Mark Harvey – This is the first article in a series that is being published on the benefits of the Gnosis Transaction Manager for Microsoft SQL Server.Our present relational database system architectures, while providing the capability to handle substantially more data with fa
Tag: sql server
Mimer SQL Validator
All too often people find themselves locked into a specific DBMS because their SQL code doesn’t conform to the SQL standard.<br><br>Here at Upright Database Technology, we pride ourselves on conforming to the SQL standard and we play an active roll in the Database Languages standardization group whi
Create a SQL Server Maintenance Plan
by Josef Finsel – Maintenance plans can make your life easier by giving you the freedom to automate routine database-administration functions. With a maintenance plan, you can have the server update statistics routinely, ensuring that ad hoc queries are optimized. Maintenance plans allow the server
Wait on 64-bit Itanium
By Michael Otey – After more than a year’s delay, Intel recently released its Itanium chip to OEMs such as Dell, Hewlett-Packard (HP), and IBM, making 64-bit Wintel systems a reality. To coincide with the initial Itanium release, Microsoft in the third quarter is providing two 64-bit versions of Win
Essential Skills for Microsoft Business Intelligence
Microsoft offers a powerful set of Business Intelligence tools. They are easy to use, but people need to learn about them in order to use them effectively. We believe our class will give you the ability to successfully implement Business Intelligence in your organization.
Useful Things to Do with SELECT
By Michael Otey – The T-SQL SELECT statement is the primary tool for retrieving data from SQL Server, but SELECT also has several other interesting uses. Here are seven useful things that you can do with SELECT besides returning rowsets to your application.
ActiveX : Active Query
Active Query allows you to include end user oriented SQL query builder into your application. Your users receive the ultimate ability to build their own queries and it is not necessary for them to understand your database design or table relationships. They do not see real tables and real field name
Building a Mail Queue System
This article demonstrates an email queue system using SQL Server and VB Script. This overcomes the limitations of the Sending SMTP Mail using a Stored Procedure method.
PointBase Micro 4.0
What do you get when you cross J2ME, SQL, and company that has already built a successful business providing Java-based database solutions? In this case, the answer is PointBase Micro, from California-based PointBase, Inc.
Use the Correct ASP (ADO) Syntax to Enable Connection Pooling for Best SQL Server Performance
by Brian Lockwood – There is much confusion about how to actually implement connection pooling in VB/VBScript code. In this article I have actually tested various ASP syntax variations and verified the results when using connection pooling.