Display :
Did not find what you want,
Be the first to write article on Database
Category: Database

What are SQL, MySQL, and TSQL?

SQL, MySQL, TSQL? What are these? If you’re not a geek, you will get confused with these three. Here are some information to guide you. Here are some information to guide you.

SQL (Structured Query Language)

Category: Database

Must Know About ODBC & DCOM

ODBC (Open Database Connectivity) is Microsoft's answers in favor of processing database in a variety of their programming languages. ODBC is a poor optional (non-object oriented) API for processing database. Open Database Connectivity supports the same application interface for processing database management systems (DBMS). Designers aimed to make it a sovereign of database systems, programming language, and OS. There is no Java corresponding to ODBC.

Category: Database

SQL Server: From the Past to the Future

The SQL Server was originally a joint project between, Microsoft, Sybase, and Ashton-Tate. In 1995, they parted ways and version 6.0 was the first edition released without input from Sybase. From version 7 onwards, Microsoft has rewritten the code, so as not to have to credit Sybase any longer, and be able to drop the Sybase copyright notices; which previously had to be included as an indication of its origin.

SQL Server 7.0

Category: Database

Flavors of SQL and its differences

To become a SQL expert, what are all that you need to learn? What are all the flavors in SQL and the differences between each? What is a database and what are the benefits and all sorts of details?

Starting-Up:

In this session /exercise you will prepare your computer to run SQL*plus

To Start Up:

Category: Database

Best Practices for using the Structured Query Language (SQL)

SQL (Structured Query Language) is an exceptionally high-performing database, universally accepted for its simplicity and well developed querying features that makes it distinct from its competitors in the industry. It facilitates the user with a structured organization of table structures and a relatively simple English language to query them.

Category: Database

Database Types

Database Definition:

A Database is an organized collection of information. An ORACLE database consists of tables, views, queries, and reports that are based on the tables. In an ORACLE database, you enter information you might otherwise put in a list, table, or forms. The entries information may be words, number, dates, or pieces of text. Thus, you can use an ORACLE database for organizing.

Category: Database

Communications Solutions Best Business Management

In the world of computers and information technology, communication is a very vital aspect. A major aspect in this field is Unified Communications. Unified Communication is a major collection of services that include all forms of calls and media messaging that are integrated into one system and can be easily managed by an individual or an organization.

Category: Database

Shrinking a Database in SQL server 2005

Introduction:

One important function of a database maintenance plan is to keep an eye on the size of your database. Database administrators use different techniques to maintain the size of the database.

One of the techniques is known as database shrinking.

In this article we will discuss how to shrink a database in SQL server 2005 and what are the different techniques of reducing primary and secondary databases, and log file size. Plus, what are the features introduced in SQL server 2005 that has helped in reducing the size of databases.

Database Shrinking:

Category: Database

Reporting services in SQL server 2005

Demo names:

Server: CONFIGWS1

Database: technoencyclopedia

Username: Demo User

Password: 123456789

Connection: My DataSource

Introduction:

In today’s competitive world, business is run through logic, not by rules. And to produce a logical plan, you need to have data or information in useful form. Every business requires reports daily, monthly, or yearly to manage their business cycle.

SQL server 2005 also provides a competitive and efficient solution for reporting called SQL server reporting services.

Category: Database

Account Creation and management in SQL server 2005/2008

Using SQL server management studio

Demo names

Database: technoencyclopedia, techno

Login id: test

Password: test

Table: techno

Introduction:

Securing a database has always been a center of focus since the technology has started to build the database systems. However, managing the user account and keeping the data secure has become much easier as the time passes.