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 […]
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 […]
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, […]
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 […]
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 […]
sql server, server, database, web hosting, domain, software, computer
User-defined functions (UDFs) rock! UDFs allow us to create compliant units of Transact-SQL that can return either a scalar value or a table.
A scalar value returns a single value (as our UDF did) of the type we specify in the CREATE FUNCTION statement.
A table returns a table of results. It leverages the new data type […]
SQL Server 2000 introduces the Copy Database Wizard and an enhanced version of the Index Tuning Wizard. Let’s take a look at both of these wizards, starting with the Index Tuning Wizard.
Tuning Indexes
The Index Tuning Wizard will assess your workload and give you suggestions for creating optimal indexes and statistics for your databases. The wizard […]
The instance name must follow some rules, and these are listed here. These rules are from the SQL Server Setup Help provided with the CD for installation.
An instance name is not case sensitive.
An instance name cannot be the terms Default or MSSQLServer.
Instance names are limited to 16 characters.
The first character in the instance name must […]
Server, web hosting, domain, fonts, template, php
To finish the development of our Spy Net application, we must install a Web server of some sort onto our machines. We must set up our machine as a Web server so that we can leverage the deployment of the interface. The installation of Personal Web Server (PWS) for Windows 98 is covered in this […]
One of the main concerns of network administrators in the 1980s was that any person in the company network could easily install a modem in her computer and connect to computers outside the network. For digital telephone systems, this was not a problem. But for small businesses using an analog telephone system, this could present […]
TCP/IP was built using a layered approach. You may have heard about the OSI (Open Systems Interconnect or Open Systems Interconnection) Reference model that is used mostly as a framework around which a discussion of network protocols can be discussed. Developed in 1984 by the International Organization for Standardization (ISO), this model defines a protocol […]
FTP is used to transfer files between computers. It is a complex protocol that enables the exchange of data files using different methods of data representation and file storage. In its simplest form, FTP uses clear-text username and password exchanges and is not considered to be a very secure utility. FTP was originally created when […]
The Active Directory gives you one single enterprise-wide namespace. This namespace is used for accounts, resource objects, application configuration information, and so on. What you decide to store in the directory, beyond the default objects set up by the installation process, is up to you. namespace can be global, provided you organize your domains into […]
To make it easy to directory-enable any application, Microsoft has provided Active Directory Service Interfaces (ADSI). ADSI is a collection of several interfaces that can be used to access the Active Directory from within executable application programs. Programmers might want to use ADSI insteadof the LDAP C API because ADSI makes it possible to write […]
The schema in the Active Directory is stored in the directory. The schema comes preconfigured with the types of objects that you need in order to set up a Windows server and manage a network of computers. However, the Active Directory is flexible and extensible in that you can modify the existing objects to use […]