Databases articles

How to check Oracle processes in windows using command line (02/16/2012)
... Alternate of ps command in windows (Great tip for Oracle DBA): No it is not TRUE. Really !!! Windows has own command to trace all running processes in the system. Using "tasklist" command Oracle DBA can able to trace all running processes in windows including oracle,sqlplus,exp,imp and others. Tasklist command is very closer to ps command. Using tasklist command Oracle DBA can able to access process ids, session ids, cpu time, and modules of running processes in Oracle on Windows....

Data Entry and the Various Industries that use this Service (02/10/2012)
... About data entry service Based on the types of business process, today you will find a wide array of data entry services, e.g., Online/Offline Data Entry, Legal Document Entry, Insurance Claim Entry, Card/Book/Image Entry. Watching the advantage of maintaining digital databank, industries are opening a new division 'data entry service' as back office operation. The demand of data entry service has grown remarkably and today it is considered as one of the profit making outsourcing job....

Different Forms and Variations of Data Entry (02/10/2012)
... You need to enter images to include photographs and attachments in magazines, yellow pages, novels and E-books. Scanned images are also required for card entry and in official file access. Another type of data entry is the insurance claim entry. This entry is done to aid the insurance holders of the companies. They have to file the claim on insurance in order to acquire the expenses for the respective services....

How Data Entry Services Benefit Industries And Why It Is Essential (02/10/2012)
... But the requirement is same - organizing data properly for future use. Apart from online and offline data entry, the data entry services also include image entry, book entry, card entry, hand-written entry, legal document entry and insurance claim entry. Data entry services are not only required to enter data into your business database. These services also provide you with services like data collection, processing and data extraction. All these works, which are quite time consuming tasks, can be done quickly and efficiently by data entry professionals....

What is meant by dirty data (06/09/2011)
... If you're in business, a database should reduce your costs or increase your revenues. If your organization is non-profit, a database should either reduce your costs, enable you to provide more service for the same cost, or enable you to provide more effective service immediately. No matter what industry you belong to, what your company background is, or which business you are involved in, database appending is always going to help you. Data appending & data management services will help you to improve the operational efficiency of your data. It will also help you to manage your data and secure your enterprise data through quarterly updation....

Managing Monitoring and Troubleshooting SQL Server 2000 (09/28/2010)
... Instead of an alert, failed job results can be written to an application log. To send an e-mail notification, the SQL Server Agent must have a MAPI-1 compliant e-mail client and a valid e-mail profile. An operator for the job must be named and the SQL Server Agent must have access to contact information for that operator. Alerts can be fired for reasons other than success or failure. The SQL Server Agent can be configured to alert an operator when designated events occur....

Managing and Monitoring SQL Server 2000 Security (08/31/2010)
... Auditing The basis of auditing in SQL Server 2000 is the server side SQL Trace and the client side viewing utilities. Auditing is configured using the SQL Profiler. With the SQL Profiler you can create a custom auditing scheme that allows you to audit nearly every event that is applied to server data and security. SQL Server 2000 allows login auditing similar to auditing available on Windows 2000/NT. Administrators can select the level of auditing that they require via the Enterprise Manager....

Basic Terms of Structured Query Language (SQL) (08/26/2010)
... A SQL sublanguage called Data Manipulation Language (DML) deals with queries and data manipulation. SQL allows you to pose a query (basically a question) to the database, and the database then provides the data that answers your query. For example, with a database that stores details of salespersons, car sales, type of cars sold, and so on, you might want to know how many cars each salesperson sold in each month and how much money they made the company. You could write a SQL query that asks this question and the database goes away and gets the data that answers it. A SQL query consists of various statements, clauses, and conditions....

Extracting and Transforming Data in SQL Server 2000 (08/13/2010)
... Snapshot replication: all data from a publishing site is copied to all subscribing sites and individual changes are not replicated. 2. Transactional replication: One server is a publisher and other servers subscribe to articles that are published. An article is an individual set of data to be replicated. All changes to the data are made at the publisher’s server and are then replicated to the subscribers....

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. So what would happen if there were two users with the username george? Well, the database would return a recordset (there is the possibility of getting an actual array to the programming language, but it must first be retrieved row-by-row from the database via the recordset object) containing the passwords for the records that it found. Unless you specifically want users to have the same usernames, the best way around this would be to check for duplicate usernames when you are inputting the users' data into your game or defining the username as a primary key. Let's look at another simple example for listing all the high scores from a game in a descending order (i.e....

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. Therefore, each record that is added to a table in a relational database will be automatically assigned a unique number if the field is numeric and if a sequence and a trigger is defined to the table to do that. There are database packages that can do this almost automatically by defining that the field is an identity field. This unique field will differentiate it from all other entries in the same table (but not entries in other tables). This allows us to optimize the data within the database as we can simply make a field in a table an integer (or any data type—actually, sometimes there are situations where varchar (string) fields are better reference fields than integer)....

Installing MySQL Server (01/04/2008)
...cnf file. You can use this as a template to create your own my.cnf file. Once you start the installation, it will first ask you which type of setup you would prefer: typical, compact, or custom installation. Here we will select the Typical option, as it will install all the components that we require in order to work with MySQL....

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. Identifier Max Length Valid Characters Database 64 All valid directory name characters except "." and "/". Table 64 All valid directory name characters except "." and "/"....

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. If we just left it with the single condition, it would return the full results from both tables for each enemy in the relateenemies table. So our second condition limits the results to only show Henry's enemies by comparing the player field in the relateenemies table to the string Henry. Useful, eh? .....

Relational SQL Databases (12/06/2007)
... This is done by means of a link table. A link table is really just a normal database table, but its main purpose is to relate data in some way or another to conserve space and optimize the way the database accesses the information. Let's create two link tables, one for relating friends and one for relating enemies to each other. Following are the statements that are required to accomplish this. Note If link tables are used, the optimized way is to store INT values there and have an ID field with auto_increment in the playerdata table as a primary key....

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. Importing from a Native Source Another method available to use for importing data is using the Microsoft Excel spreadsheet program or any other application that can export data as tab-delimited data. For this example, however, we will use Microsoft Excel. Let's enter another five rows of data that we wish to add to our playerdata table in Excel. Once this is done, it should look similar to the figure below: Once our data is entered, we need to save the data in a format that MySQL can understand....

SQL Data Manipulation: Select Insert Delete and Modify SQL data (12/05/2007)
...co.uk', NULL) Notice how the feedback from the console tells us that one row has been affected. Hence, we have added one row to our sampletable table. We can then use a command called SELECT to view the data in the table. We will go into more detail about this command later in this tutotial, as it is very important, but for now we will just use it blindly....

Setting the Color of a Movie Clip (07/06/2007)
... The Color.setRGB( ) method applies a single color value to the movie clip targeted by the Color object (as specified when the Color object was created), filling the entire movie clip shape with a single color. The color value can be of any valid ActionScript numeric format. The following examples both apply a solid blue color to the targeted movie clip: my_color.setRGB(0x0000FF); // Hexadecimal my_color....

SQL Server 2005`s Design Goals (04/04/2007)
... However, all that has changed. Beginning with the release of SQL Server 7, Microsoft made great strides in the scalability of the SQL Server platform. Using distributed partitioned views, SQL Server 7 jumped to the top of the TPC-C, and, in fact, its scores were so overwhelming that SQL Server 7 was a contributing factor to the TPC (Transaction Processing Councils) decision to break the transactional TPC-C test into clustered and nonclustered divisions. Although Microsoft and SQL Server 7 owned the clustered TPC-C score, demonstrating its ability to scale out across multiple systems, there was still some doubt about the platform’s ability to scale up on a single platform. That too changed with the launch of Windows Server 2003 and the announcement of SQL Server 2000 Enterprise Edition 64-bit where Microsoft announced that for the first time Microsoft SQL Server reached the top of the nonclustered TPC-C scores....

A Brief History of Microsoft SQL Server (03/26/2007)
...0 was the first release of SQL Server that was developed entirely by Microsoft. In 1996, Microsoft updated SQL Server with the 6.5 release. After a two-year development cycle, Microsoft released the vastly updated SQL Server 7.0 release in 1998....