CIOL Network DataQuest PCQuest Voice&Data LivingDigitalIndia DQWeek DQChannelIndia Cybermedia Dice
CyberMedia
 
 | Videos Audio  Contest  Newsletters  Whitepapers  Specials  RSS
Login | Register
Topic Center-SQL
Tips & Tricks
Speed tips for SQL server SELECT 
statements
The query runs in the Northwind database and is designed to pull out the maximum unit price for each order in the database.
 
News
DiscountASP.NET's new panel with SQL backup API
This new API is part of DiscountASP.NET's Open Control Panel Initiative, with a goal to offer an open hosting system framework that provides customers with maximum control over their hosting presence management.
 
SQL Server 2005 Integration Services
The new SSIS feature of SQL Server 2005 allows you to perform all the tasks of Data Transformation Services and more. A look at the Control Flow Runtime engine this time.
 
SAP, MS extend alliance for MS SQL Server
The new alliance will offer database conversion tools, documented best practices & deployment services support to ensure a nondisruptive transition to enterprise service-oriented architecture.
 
Tutorials
The fundamentals of SQL queries

This tutorial describes how to retrieve rows from a relational database table, retrieve specific columns, retrieve specific rows, reform logical operations on retrieved data, and use wildcard characters in search conditions.
 
Multiply Column Values in SQL 
Server
Got confused on how to get this requirement in a single statement without using T-SQL. Check this solution.
 
Easy way to develop in MySQL
Toad is a tool for developers and DBAs who use MySQL database. This Open Source tool from Quest Software is a utility tool for database developers providing them with productivity features and functionalities for rapidly creating and executing queries.
Download
SQL data examiner 1.2.0.15
This compares and synchronizes the contents of Microsoft SQL Server databases, takes care of the routine manual tasks, thus simplifying the work of a DBA.		 SQL Balance for MySQL
Now there is no need to compare and synchronize databases run by MySQL manually, wasting valuable and quite expensive DBA's time .		 Blind SQL Injection
This is a hacking method that allows an unauthorized attacker to access a database server. It is facilitated by a common coding blunder: the program accepts data from a client and executes SQL queries without first validating the client’s input.