Database

Online free code generator for databases in C#/VB.NET

Using your existing database you can create stored procedure and you can also create your database here and then it creates code for C#/VB.NET object model class code, Data layer code, and stored procedures.

What is oracle Data Guard ?

We all hear about Database protection in huge databases like Oracle and others. Lets understand and see how the Oracle Data Guard helps what it is and how it benefit us. Its been used in big organisation which stores lot of information and data on their Databases.

The Most Used Concepts : Relational Data Model and Set Theory.

In this article I explain about Relational Data Model and Set Theory. This is because, RDBMS is the most useful feature of database and it represents the data in tabular form.

How to Choose a Data Access Strategy while developing Application

Choosing a proper data access strategy for your application may be one of the most important and far reaching decisions you have to make. It is strongly recommended that you put a considerable amount of thought into this decision.

Using SQL Server Management Studio efficiently - Finding content in Files

SQL Server Management Studio is one of the most widely used editor for Microsoft SQL Server. Search is an important features we need most of the time. While using MS Management Studio we often need to search on file. This article demonstrates how to do in easy steps.

How to use the Set Command in VBA?

In this Article, I present to you Set command of VBA. Lets learn How to write and how set Command is useful for Excel application development. With the help of Set command we can access the data from the excel database. It may be helpful for Excel application developer.

How to generate insert statement for existing data in SQL Server Management studio?

In this article I have explained about how to create insert statement for previously stored data in the SQL Server Database table. Here I used SSMS Tools pack (SSMS tools pack is a add-in for SQL Server management studio). For example we have one table in the database with several data we need to move that table data in to another system SQL Server database same structured table.

SQL String Functions..

Some of the comparision between Sql Server and Oracle

In the below description it gives some of the comparision between oracle and Sql Server and their usage with some sample example by comparing the Sql Server with Oracle queries. And by knowing this you can select which database will suit for your project.

Save Your Time on Exporting Data from Database to PDF

Easily Export Data from Datatable to PDF. Enable preview and modify data information.

SQL Server tool to generate Insert Script of table data

Read and insert bulk of data from excel to database in one shot.

Read and insert bulk of data from excel to database in one shot with the help of dataset.

Tool for creating PHP files for ur MYSQL database for editing, updating or deleating

Tool for creating PHP files for ur MYSQL database for editing, updating or deleating

CheckSum function

CHECKSUM_AGG can be used to detect changes in a table. The order of the rows in the table does not affect the result of CHECKSUM_AGG. Also, CHECKSUM_AGG functions may be used with the DISTINCT keyword and the GROUP BY clause. If one of the values in the expression list changes, the checksum of the list also generally changes. However, there is a small chance that the checksum will not change. CHECKSUM_AGG has similar functionality with other aggregate functions.

SQLQueryStress

SPGen - Stored Procedure Generator

SQL Prompt - Intelligence in SQL Query Analyzer

Teratrax Job Scheduler

Teratrax Database Manager

Teratrax Database Compare

Teratrax Performance Monitor

SQLDirect .NET

SQL Server Comparison Tool

Free Database Compare

Flecto