search the articles directory
old Databases articles
Extracting and Transforming Data in SQL Server 2000 - ... can also specify a query as the source of the data which allows packages
to transform data by performing an action like running a query that ret...
Basic Terms of Structured Query Language (SQL) - ...up rules for data entry, and so on, which is expressed by a SQL sublanguage called Data Control Language (DCL). The next section discusses querying ...
Managing and Monitoring SQL Server 2000 Security - ..., or Mixed Mode.
If you are running SQL Server 2000, you will need to configure the SQL server to run in mixed mode to allow
the non-Win...
Managing Monitoring and Troubleshooting SQL Server 2000 - ...ns on what to do depending on the success or failure of each step in the job. Jobs are
assigned to an operator, a user who is responsible for tha...
Managing Monitoring and Troubleshooting SQL Server 2000 Databases - ... Establishing indexes can dramatically increase query performance, but can also adversely affect data modification
performance. Any changes to an...
Tips for Designing a Better SQL Database - ...se, or at least ensure that it can cope with the unusual situations. Even if a client tells you not to worry about the possibility of two people attem...
Why and When to Use a Database - ...able you to break data into specific parts. Retrieving data from a database is called querying. You’ll often see the term SQL query, which brief...
Creating SQL Server 2000 Databases - ...up manually. When a database is reattached, all files that have changed location must be specified.
Filegroups
Filegroups ar...
Developing Notification Services Applications in SQL server 2005 - ... look at each of these steps in more detail.
Defining the Application
The Notification Services developer uses a combination of XML...
SQL Server Service Broker Activation - ...d to handle the incoming
messages. If the stored procedure encounters an error, it can throw an exception and
be automatically recycled.
...
SQL Server 2005 Administrative Tools - ...sis Services commands. SQL
Server 2000 was limited to tracing relational database calls only. By having these
capabilities, you can use these ...
Notification Services in SQL server 2005 - ...tion Services applications consist of three
basic components: events, subscriptions, and notifications.
Events
In a Notificatio...
Understanding CLR and SQL Server 2005 Database Engine - ...th SQL Server 2005
brings with it the ability to create database objects using modern object-oriented
languages like VB.NET and C#. While thes...
BI Development Studio in SQL Server 2005 - ...ou use the BI Development Studio to work
with Analysis Services projects, to develop and deploy Reporting Services reports, and
to design Int...
SQL Server Service Broker Architecture - ... be able
to physically handle. Asynchronous queuing is found in many other highly scalable
applications, such as the operating system’s ...
A Brief History of Microsoft SQL Server - ... SQL Server to
Windows NT. The co-development effort cumulated in the release of SQL Server 4.0
for Windows NT. After the 4.0 release, Microso...
SQL Server 2005`s Design Goals - ...data access functionality to the largest
of organizations. To meet these enterprise demands, Microsoft has designed SQL
Server 2005 to be high...
Setting the Color of a Movie Clip - ...vieClip);
You can alternatively specify the movie clip name as a string:
my_color = new Color("myMovieClip");...
SQL Data Manipulation: Select Insert Delete and Modify SQL data - ...eate that now with the following statement:
mysql> CREATE DATABASE dmlexample;
Once created, we need to specify that we wish t...
Relational SQL Databases - ...te also that every row of data in the primary key must be unique to one another. Here is the statement required to create our database (called gam...
SQL Data Import Methods - ...we use \N to specify a field that contains NULL and an extra tab is required after each row of data to signify the end of that row. We have saved ...
Joining SQL Tables - ...them (although when the statement is executed the actual data is compared).
For an example of how we can use joining, let's look back to the...
Basic SQL syntax: Creating and Modifying tables and databases - ... there are two databases already created in the MySQL server. The mysql database contains administration information for the MySQL server and s...
Introduction to SQL - ...hat would have 100% support of the SQL standard.
Let's first look at some simple interactions that we can perform using the SQL language. Le...
What Is a Database - ...ins a player's name, age, and e-mail address. Once you have tables defined in your database, you can then add records into the tables. A record...
latest articles under "Databases"
Navigation: Categories » Computers and technology » Databases
Below is a list of all Databases articles. If you want to find a tutorial by keywords, all you have to do is a quick search in our directory. Just use the search option. The website search is powered by Google. But, if you want to read specific Databases tutorial, just point to it. The newest articles and tutorials are shown first in the list. To access the last ones, browse the pages 2, 3, 4... at the bottom.
Page# 1 (last added articles shown first)
Enter page# 1 (last added articles shown first)
Below is a list of all Databases articles. If you want to find a tutorial by keywords, all you have to do is a quick search in our directory. Just use the search option. The website search is powered by Google. But, if you want to read specific Databases tutorial, just point to it. The newest articles and tutorials are shown first in the list. To access the last ones, browse the pages 2, 3, 4... at the bottom.
Page# 1 (last added articles shown first)
Introduction to SQL (01/04/2008)
..." When this query is executed, the database would then return the password (which is geo321) from the user with the username george...
..." When this query is executed, the database would then return the password (which is geo321) from the user with the username george...
What Is a Database (01/04/2008)
... This is usually accomplished by means of unique identification numbers, although this identification can be done with any data type, but the most effective way is to do it with number types...
... This is usually accomplished by means of unique identification numbers, although this identification can be done with any data type, but the most effective way is to do it with number types...
Basic SQL syntax: Creating and Modifying tables and databases (12/20/2007)
... Note The following table lists the length and character restrictions that are imposed on the names of databases, tables, columns, and aliases...
... Note The following table lists the length and character restrictions that are imposed on the names of databases, tables, columns, and aliases...
Joining SQL Tables (12/12/2007)
...player = 'Henry'; So first we are selecting all the data from both the playerdata and relateenemies tables and then placing a condition upon the joining of the tables, so that data will only be selected where the username field in the playerdata table is equal to the enemy field in the relateenemies table...
...player = 'Henry'; So first we are selecting all the data from both the playerdata and relateenemies tables and then placing a condition upon the joining of the tables, so that data will only be selected where the username field in the playerdata table is equal to the enemy field in the relateenemies table...
SQL Data Import Methods (12/06/2007)
... If we now select all the information from the playerdata table, we can see that our five rows of data have been imported correctly into the database...
... If we now select all the information from the playerdata table, we can see that our five rows of data have been imported correctly into the database...
A Brief History of Microsoft SQL Server (03/26/2007)
...0 was the first release of SQL Server that was developed entirely by Microsoft...
...0 was the first release of SQL Server that was developed entirely by Microsoft...
SQL Server Service Broker Architecture (03/23/2007)
... Its goal is to take on the hard work of building asynchronous applications, and it does that by handling all of the heavy lifting for the asynchronous application...
... Its goal is to take on the hard work of building asynchronous applications, and it does that by handling all of the heavy lifting for the asynchronous application...
BI Development Studio in SQL Server 2005 (03/17/2007)
... Like the SQL Server Management Studio, the BI Development Studio doesn’t allow you to compile VB...
... Like the SQL Server Management Studio, the BI Development Studio doesn’t allow you to compile VB...
Notification Services in SQL server 2005 (03/15/2007)
... Hosted Providers Hosted event providers are directly executed by Notification Services...
... Hosted Providers Hosted event providers are directly executed by Notification Services...
SQL Server 2005 Administrative Tools (03/06/2007)
... The DTA has a rich, new interface and works with the newer features in SQL Server 2005; for instance, it will recommend partitioning your tables using the new table partitioning features in the database engine...
... The DTA has a rich, new interface and works with the newer features in SQL Server 2005; for instance, it will recommend partitioning your tables using the new table partitioning features in the database engine...
SQL Server Service Broker Activation (03/05/2007)
... SQL Server Service Broker queues don’t necessarily need to be associated with just stored procedures...
... SQL Server Service Broker queues don’t necessarily need to be associated with just stored procedures...
Developing Notification Services Applications in SQL server 2005 (02/26/2007)
... Compiling the Application After the schema and the rules have been created, the next step in building a Notification Services application is to compile all of the code and register a service that will run the Notification Services applications...
... Compiling the Application After the schema and the rules have been created, the next step in building a Notification Services application is to compile all of the code and register a service that will run the Notification Services applications...
Creating SQL Server 2000 Databases (10/24/2006)
... Filegroups also allow greater fault tolerance by granting the ability to spread the database over several physical disks...
... Filegroups also allow greater fault tolerance by granting the ability to spread the database over several physical disks...
Why and When to Use a Database (10/17/2006)
... Databases also allow you to set up rules that ensure that data remains consistent when you add, update, or delete data...
... Databases also allow you to set up rules that ensure that data remains consistent when you add, update, or delete data...
Managing Monitoring and Troubleshooting SQL Server 2000 Databases (10/03/2006)
... The extent of the hold depends on the options that have been configured on the lock...
... The extent of the hold depends on the options that have been configured on the lock...
Managing Monitoring and Troubleshooting SQL Server 2000 (09/28/2006)
... Instead of an alert, failed job results can be written to an application log...
... Instead of an alert, failed job results can be written to an application log...
Managing and Monitoring SQL Server 2000 Security (08/31/2006)
... Auditing The basis of auditing in SQL Server 2000 is the server side SQL Trace and the client side viewing utilities...
... Auditing The basis of auditing in SQL Server 2000 is the server side SQL Trace and the client side viewing utilities...
Basic Terms of Structured Query Language (SQL) (08/26/2006)
... A SQL sublanguage called Data Manipulation Language (DML) deals with queries and data manipulation...
... A SQL sublanguage called Data Manipulation Language (DML) deals with queries and data manipulation...
Extracting and Transforming Data in SQL Server 2000 (08/13/2006)
... Snapshot replication: all data from a publishing site is copied to all subscribing sites and individual changes are not replicated...
... Snapshot replication: all data from a publishing site is copied to all subscribing sites and individual changes are not replicated...
Enter page# 1 (last added articles shown first)