Trigon Blue

Products

Services

Text Market

Book of Knowledge (articles & whitepapers)

SQL Server 2005 Stored Procedure Programming
in T-SQL and .NET, 3rd Ed.

SQL Server 2000 Stored Procedure and XML Programming, 2nd Ed.

SQL Server 2000 Stored Procedure Programming

e-Business News

SQL Server News

About Us

Contact Us

Join Us

Links

Search


© 2003 - Trigon Blue Inc.  
All rights reserved.



Book of Knowledge

Information and published articles by Trigon Blue consultants:

Knowledge Management
Knowledge management seeks to maximize the application of your organization’s intellectual assets to the development and deployment of solutions that meet your customers’ business needs.

more...

Error Handling in T-SQL: From Casual to Religious
Most of us would agree that experienced programmers tend to be more adept at (and perhaps even more "religious" about) error handling than rookies. VB and C/C++ programmers are so spoiled by the error-handling tools in their IDEs that they sometimes forget good old-fashioned "roll your own" error handling. In this article, Dejan Sunderic provides some guidance for both DBAs and database application developers.

more...

Changing Column Length - Implication on Data Transfer Task in SSIS Package
I had a Data Transfer task based on a table. It was running fine, but then we decided to change the size of the field on both source and target table.

more...

Open Policy Manager to set Terminal Server timeouts
Get rd of annoying timeouts on Remote Desktop sessions.

more...

T-SQL in Microsoft SQL Server 7
The greatest improvements in SQL Server 7 are in the Transact SQL (T-SQL) language, and these deserve special attention.

more...

Ten Steps to Bringing Your Project Under Control
What to do when everything seems to be going wrong.

more...

B2B, e-Commerce, XML, BizTalk, RosettaNet
If you are attempting to follow the business of technology these days, the most common buzzwords you are coming up against are probably B2B, XML, and BizTalk.

more...

Desktop and File Sharing Architecture
Most desktop databases were originally designed for one or only a few users. 

more...

Client / Server Architecture
By understanding client/server architecture, it is easy to see how client/server databases that operate on a fast database server can drastically improve performance.

more...

Web-based Architecture
Until recently, only Web applications were able to publish information to the Web. Today, it is possible to create OLTP (OnLine Transaction Processing) systems through standard Web browsers.

more...

Distributed Architecture
To achieve the highest level of performance in request processing, the system architect must turn to Distributed Systems.

more...

Scalability of Business Applications
Trigon Blue Inc. can provide you with a full range of systems - from personal and workgroup solutions to departmental and enterprise systems.

more...

Lookup Tables in Access
When we say that a table is a lookup table for an other main table, it means that the lookup table contains values that will be used as the contents of a field located in the main table.

more...

Cross Database Dump and Load
SQL Enterprise Manager contains a Database/Object Transfer tool designed to ease the pain of transferring databases and individual objects from one place to another. This tool generates a script to recreate the selected objects and data in the target database. In most cases, the transfer occurs seamlessly. However, there are a number of scenarios in which it will generate errors.

more...

How to Set Up SQL Server 7.0 Desktop Edition
Where to find the setup program and how to run it.

more...

Solutions to Common Problems
A host of common problems with dependable solutions.

more...

Books that will change your professional life
Development, design, project management, SQL Server, Windows DNA, COM+, .NET

more...

 

Home | Products | Services | e-Business News | SQL Server News
About Us | Contact Us | Join Us | Links | Search