Thursday, November 25, 2004

SQLyog GUI

SQLyog GUI: I found this MySQL Front end tool while searching for a replacement for phpMyAdmin . Really cool... It is similar to Query Analyser which comes with SQL Server. Just now installed it and playing around it.

Wednesday, November 17, 2004

Setting Up Merge Replication: A Step-by-step Guide

Setting Up Merge Replication: A Step-by-step Guide: 'Out of all the replication procedures available for SQL Server Merge Replication is the most difficult one to implement'. I had this thought till i found this article. This step-by-step guide clearly explains how to Setup up a Merge Replication. Check it out.

Thursday, October 28, 2004

NGS Software: NGSSQLCrack

NGS Software: NGSSQLCrack: "NGSSQLCrack

NGSSQLCrack is an innovative password cracking utility for Microsoft SQL Server 7 and 2000 that can assist enterprises in securing their infrastructures. NGSSQLCrack allows system administrators and security professionals to quickly scan systems for weak passwords that are susceptible to brute force attack, and guard against them. An handy tool if you are worried about the security in your network. Check it out for yourself

Microsoft SQL Server - Images and SQL Server - SQLTeam.com

Microsoft SQL Server - Images and SQL Server - SQLTeam.com: "This article tells u how u can store and retrieve images in a SQL Server. Good one"

Estimating the Size of a Table

Estimating the Size of a Table: "This article from MSDN tells u how to estimate the Size of a Table. This will really handy in lot of situations"

SQL Server 2000 Unveils Another Path to Peak Performance

SQL Server 2000 Unveils Another Path to Peak Performance: "Server 2000's powerful new support for indexed views promises to make your life easier while making your applications and queries run faster. Sound too good to be true? Indexed views let you precompute all sorts of joins, aggregations, and computations so that you don't have to write such conditions into every query. And Microsoft is reporting gains of 10 to 100 times in the performance of applications and queries that access indexed views instead of base tables. Although Oracle supports a similar feature called materialized views, SQL Server's new indexed views go far beyond what the competition offers"