Many C++ programmers will be familiar with the tidal wave of recompilations that occur when a seemingly unrelated header file is changed. C++ file dependencies need to be managed otherwise

There are two undocumented encryption functions. They are not supported by Microsoft, and I have had problems with some SQL Server service packs when using these functions. That being said,

By default, SQL Server 7.0 installation sets up SQL Server to run in a case insensitive mode. For most applications this may work great, but there are certain situations were

Certain applications require business logic to determine the last day of the month. This is the case for accounting applications that perform such tasks as invoice processing and customer billing.

When tuning SQL Server applications, a certain degree of hands-on experimenting must occur. Index options, table design, and locking options are items that can be modified to increase performance. When

Whenever a client application needs to send Transact-SQL to SQL Server, send it in the form of a stored procedure instead of a script or dynamic Transact-SQL. This not only

When a stored procedure is first executed (and it does not have the WITH RECOMPILE option), it is optimized and a query plan is compiled and cached in SQL Server’s

The new INSTEAD OF functionality is not exactly like a trigger, but similar. Unlike AFTER triggers, the INSTEAD OF trigger replaces the incoming transaction data modification statement with its own

Orphan SQL Server connections can decrease SQL Server performance. An orphan connection occurs when SQL Server keeps the connection open, even though it is not being used. There are two

This tip is for when you want to place an action after a time gap between two occurrences (for example, to invalidate an unused session after some permitted time, or

Depending on the version of Windows targeted, there are two different ways to run a VB application during the boot process.Under Windows 9x systems, place a Shell command in the

Private Declare Function LogonUser Lib “Advapi32” Alias “LogonUserA” (ByVal _ lpszUserName As String, ByVal lpszDomain As String, _ ByVal lpszPassword As String, ByVal dwLogonType As Long, _ ByVal dwLogonProvider As

Encapsulation is a fundamental principle in object orientation. Encapsulation restricts direct access to a data member of a class. Instead, users query the object itself in order to get or

Look at the following program. It compiles correctly under every standard-conforming compiler. At first, this may seem surprising because seemingly, because it’s impossible delete an object which is not a

The auto_ptr class template respects polymorphism and destroys derived objects of base pointers properly. In the following program, an auto_ptr is actually bound to a B * pointer, where B

A function call such as the following: classname::funcname(); is a qualified call. Qualified disambiguate function names. They are needed, for instance, in a class that inherits from several base classes,

Here’s a very common error. You define a class but forgot to add a semicolon after the closing }. For example: class Mylist{public: Mylist(); ~Mylist(); //..more member functions} // missing

Because static class members are not associated with a particular object of their class, you can access them even if you haven’t instantiated any object. In the following example, the

The escape sequence ‘a’ is the ASCII code for a beep. To emit a beep from your program, output this escape sequence to the standard output. For example: const char

C++ defines four possible forms for a class’s copy constructor. For a class called X, a copy constructor can have one of the following forms: X(X&);X(const X&);X(volatile X&);X(const volatile X&);

Technically speaking, constructors have no name. This may seem strange at first because you define a constructor for class X as X::X(). However, this construct is not the name of

A reader asked me the following questions: “Can a function that returns something, throw a exception and still return a value?” Lets’ look at a concrete example: int f(){ if

‘ evaluate the transposed matrix” a transposed matrix is the array you get when’ you “rotate” a bi-dimensional arrayFunction TransposeMatrix(arr() As Double) As Double() Dim startRow As Long, startCol As

Option Explicit’ Evalutate the 16-bit CRC (Cyclic Redundancy Checksum) of an array of bytes” If you omit the second argument, the entire array is consideredFunction Crc16(cp() As Byte, Optional ByVal

‘ VBA’s intrinsic Rnd function returns numbers evenly’ distributed between 0 and 1. Each number in that’ interval has equal probability of being returned’ for any given function call.’ This

‘ Converts a decimal value into fractional parts as integers’ (based on the concept of Continued Fractions)’ Examples of usage:’ Call DeclToFrac(0.125, a, b) ‘ 1 and 8 are returned

The following technique will allow you to free your tablespaces from Oracle

In Visual Basic, it is not possible to measure time with more precision than one second. This code allows the user to measure time passed in increments less than one