‘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.
Category Archives: Database Programming
Setting Up Merge Replication
Posted in Database Programming Tagged Merge, Replication, SQLServer 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 Cracking, Password, SQLServer 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 Images, SQLServer 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 Article, SQLServer 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 Index, Performance, SQLServer Leave a comment