Tag Archives: SQLServer

Setting Up Merge Replication

‘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.

Posted in Database Programming | Tagged , , | Leave a comment

SQL Server Password cracker

Check out NGS Software SQLCrack

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

Posted in Database Programming | Tagged , , | Leave a comment

Images and SQL Server

Check out this excellent article Images and SQL Server from SQL Team.

This article tells you how to store and retrieve images in a SQL Server. Really good one.

Posted in Database Programming | Tagged , | Leave a comment

Estimate the Size of a Table

Have you ever wondered how to estimate the size of the SQL Server’s table? Then this artilce from MSDN might be very useful.

Check out Estimating the Size of a Table article

This will really handy in lot of situations.

Posted in Database Programming | Tagged , | Leave a comment

Unveil SQL Server Peak’s Performance

Check out this new article from MSDN 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

Posted in Database Programming | Tagged , , | Leave a comment