Having a unique identifier (UID) to identify a customer across multiple databases is an important—and frequently overlooked—concept. In the traditional world of direct marketing, a combination of name and address, and sometimes telephone number, is normally used to uniquely identify each customer. But because of the likelihood of misspelling names and transposing numbers, this approach […]
Nevertheless, the transformation of the county fair into a supermarket is taking longer than originally anticipated. Use of the Internet for economic exchange clashes with the culture of freely available information, absence of a central authority, and the legitimate concerns regarding the security of information on the network. Security on the Internet is an afterthought; […]
The arguments in favor of the Internet sound, at a decade interval, like an echo of those that were previously formulated in praise of the Minitel. This passion for information technology is displayed in a context where ambitious growth rates are not physically sustainable, due to market saturation in rich countries, the progressive depletion of […]
JEPI (Joint Electronic Payment Initiative) is a joint initiative of the W3C and the CommerceNet consortium. The purpose is to allow a server to negotiate, with a client, the payment protocol advantageous to both parties. Membership of the JEPI project includes several suppliers of solutions for secure payments (Cybercash, GCTech), software (Microsof, IBM, OpenMarket), services […]
web-design, servers, clips, translation, data backup, digital
Spyware, Animation, server, electronic, Computer-Hardware
The proliferation of incompatible payment systems creates difficulties for all concerned — users, service suppliers, financial institutions, and regulatory bodies. History has shown repeatedly that the expansion of commerce requires a stable and uniform environment. Yet, in a single aspect of electronic commerce such as electronic purses, there are more than 20 commercialized schemes in […]
The automation and dematerialization of monetary exchanges are not objectives per se, but are solely means to improve the productivity of financial institutions. In this regard, an overabundance of standards, and sometimes their competition, may constitute a barrier to the establishment of electronic commerce. Even if some manufacturers think they can profit from this situation, […]
The modern monetary system freed itself of material support by replacing it with a generalized system of trust based on continuous growth. In the past, monetary creation was absolutely limited by the scarcity of materials to be exchanged or of precious metals for minting coins. Now, however, money liberated from a material basis, in particular […]
ecommerce, hosting, domain registration, electronics, digital, appliance
How Legal Wire tapping Works
CALEA requires that communications providers allow law enforcement officials to be able to listen in on phone conversations and get information about those phone calls, but only when the law enforcement agency has gotten approval for the tap.
The law enforcement agency goes before a judge and presents reasons a wiretap is […]
Throughout the history of the United States, one of the greatest political tensions has been that which balances personal privacy against the need for law enforcement to protect individuals and the country as a whole.
That tension has been with us from the very earliest days of the Republic. The Founding Fathers were extremely cognizant of […]
Creating a New User to Establish a Connection
Because this is a brand-new Web site, we do not have any users who can access our site. Remember when we created the SQLSpyNetUser?
Now we need to create a new user who has only limited rights. We don’t want anybody hacking the site, now do we?
Create a user […]
In this section we will build a very basic front end that makes a connection to our database, validates a user’s login, and retrieves (searches for) data. Although this is just a start, it will provide the building blocks you need to develop it further for your own needs.
This unlike the others, is more like […]
How do we know if we have any rows in a table? We use the COUNT function to return a count of the number of rows in a table. If you enter Listing into Query Analyzer we can check the data insert for the Spy table.
This will return the current number of rows (well actually […]
server, web-hosting, web-design, internet-service, domain hosting, computer
Shrinking a transaction log is a little different from shrinking a data file. The main difference is when the process occurs.
When a data file is shrunk, the task is performed almost immediately, whereas with a transaction log it is not. The log file is marked, so SQL Server 2000 knows that it needs to be […]
It gives me a chance to rave about some of the cool new functionality in SQL Server 2000. Plus, I can show you some of the things that are not totally relevant to our application but that you definitely will want to know as you continue developing and maintaining SQL Server.
Although the enhancements to the […]
The introduction of SQL Server 2000 enables us to have multiple instances of SQL Server running on a single machine. In the past we only had one instance of SQL Server, which in SQL Server 2000 is called the Default instance. Now we can have as many named instances as we want. Microsoft has tested […]
Indexes, like triggers, have always been a part of SQL Server but now we have even more features that we can take advantage of when creating indexes.
One of the biggest changes is allowing us to have an index on a computed column. A computed column is the answer from a sum. For example, consider a […]