Definition of Database
What is a database server?
A database server is a computer program that provides database services to other computer programs or computers, as defined by the client-server model. The term may also refer to a computer dedicated to running such a program.
|
|
Database
|
|
SQL Server Performance Tuning for SQL Server Developers
If you have been a DBA or SQL developer for very long, then you have probably run across some slow SQL Server-based applications. And often when this happens, everybody begins blaming everybody else for the problem. It's the network. It's the server hardware. It's SQL Server. It's the users. It's the database. And this goes on and on, but unfortunately, blame doesn't fix slow applications. The cure to most slow SQL Server-based applications is prevention, which includes careful up front analysis of the user's needs, thoughtful design, optimal coding, and appropriate implementation.
Read the Article
|
SQL Tutorial
Whether you are a beginner seeking SQL help, or a data warehousing veteran looking for a SQL refresher, you have come to the right place. This SQL tutorial site lists commonly-used SQL commands.
Read the Article
|
A Gentle Introduction to SQL
SQL stands for "Structured Query Language". This language allows us to pose complex questions of a database. It also provides a means of creating databases. SQL very widely used. Many database products support SQL, this means that if learn how to use SQL you can apply this knowledge to MS Access or SQL Server or to Oracle or Ingres and countless other databases.
Read the Article
|
Automated Standy for SQL Servers
Today's business critical applications and customer requirements demand high-availability of company data. Database Administrators (DBAs) are challenged to make the database systems available 24x7 and provide fast database response time. Utilizing a standby server provides a high level of data protection and fast recovery of data if the primary server goes down for whatever reason.
Read the Article
|
Migrating Your SQL Remote for ASE Environment to MobiLink
If SQL Remote for ASE is meeting all of your current needs, there may be no immediate need for you to migrate. However, changing external factors may trigger a move to newer technology, and there is a lot of functionality in MobiLink that does not exist in SQL Remote for ASE.
Read the Article
|
Database Change Management Best Practices - Innovartis
Typically, a database development project will suffer problems such as overwritten changes, code that won't compile, lost data and confusion over what has been applied to which database. Release into production becomes a chaotic and costly phase, with everybody fire-fighting and in panic mode. Can you afford to have one of your most expensive departments working with inefficient processes?
Read the Article
|
Technical Comparison - MySQL 4.1 vs. Microsoft SQL Server 2000
MySQL, is a open source database that is available from MySQL AB at their Web site, www.mysql.com. The advertising for MySQL claims that it is the most popular open source database in the world. The purpose of this paper is to create a list of features desirable to database developers and to compare MySQL 4.x to Microsoft SQL Server 2000.
Read the Article
|
An Enterprise-Class Approach to Application-Level Security
Most large organizations have already installed antivirus software, firewalls and even intrusion detection systems (IDSs) to protect their networks and host operating systems. But by comparison, enterprise-class applications have received relatively little attention, on the assumption that they are protected by firewalls and other defenses at the network perimeter. Yet these applications and databases are the major reason enterprises invest in IT in the first place, and the data they contain are often the enterprise's most valuable assets. Indeed, an enterprise without database security is like a bank with locks on the doors and armed guards by every entrance, but no vault.
Read the Article
|
|
|
Page: 1 2 3 4
Members currently browsing this category:
|
|