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 […]
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
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 […]
As you move into a multi-user environment, security, user, and resource management will become key to the performance and integrity of your application. Some of these security features are available on Windows 2000 only.
Understanding Kerberos and Security Delegation
Unfortunately, we cannot take advantage of these new enhancements. We are not running Windows 2000—maybe that’s a good […]
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 […]