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.
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
Flavors of SQL and its differences
In this session /exercise you will prepare your computer to run SQL*plus
To Start Up:
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.
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.
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.
Shrinking a Database in SQL server 2005
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.
Reporting services in SQL server 2005
Username: Demo User
Connection: My DataSource
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.
Account Creation and management in SQL server 2005/2008
Using SQL server management studio
Database: technoencyclopedia, techno
Login id: test
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.