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 […]
Because member and customer data are among the most valuable assets your company has, guaranteeing their security and integrity is critical. Customers want to be sure that information about their preferences and behavior will remain private and won’t end up in the wrong hands. If you can’t give your customers that assurance or control who […]
Information Process
A merchant site that accepts electronic payments must include the following processing functions: (1) promotion; (2) welcoming; (3) payment; and (4) back-office.
Promotion
Successful implementation of a merchant site depends on a variety of factors, including site promotion. This can be done through fliers sent to the client or through fidelity programs. The promotion server can […]
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; […]
web-design, servers, clips, translation, data backup, digital
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, […]
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 […]
A client network utility tool allows us to change the way that a client machine talks to SQL Server 2000.
On our installation all that is really available to us is TCP/IP, but on a Windows NT/2000 machine, we see several other protocols. The most common, other than TCP/IP, is Named Pipes. See Appendix B, “Installing […]
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 […]
sql server, server, database, web hosting, domain, software, computer
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 […]
sql server, servers, web hosting, domain, web-design software, fonts, php, writing, software, laptop, computer