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 […]
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 […]
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 […]
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 […]
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 […]
Server, web hosting, domain, fonts, template, php
web hosting, web-design-software, fonts, photo
web hosting, php, web design, domain, font, photo
domain, web hosting, php, web design, fonts, photo
web hosting, web design, domain
Directory services should make things easier, not more difficult. Microsoft’s Active Directory (as well as other LDAP-based directories) uses the hierarchical treelike organization as spelled out by the X.500 standards, but the Active Directory also adapts the Windows NT domain system, by using DNS as a locator service, to the structure. That is, in addition […]