Since 1998, DevX has helped people start businesses, build websites, and provide enterprise technology to people globally. Interviewing the likes of Microsoft’s co-founder, Steve Ballmer, the publication brings comprehensive, reliable, and accessible insights to the Internet.
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
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
This class can help in simplifying most of the validation chores in your UI-intensive apps. The class “wraps” around a TextBox control and traps most of its events, to automatically
Introduction In this article I’ll move away from COM security to provide an overview about that vast subject generally referred as “Internet security”. As you will see, providing an effective
‘ 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
