By Alexander Chigrik – Should you have connection problems, review this troubleshooting checklist to find potential solutions.

MSmerge_contents causes problems for anyone that is running merge replication for any length of time. The problem is that MSmerge_contents will grow forever unless you manage it. Merge replication makes very heavy use of MSmerge_contents which can cause problems as the size grows. This is normall

You will experience one or more of the following problems when you publish a database with a binary collation for merge replication on a prior build of SQL Server and you upgrade to SQL Server 2000 SP3, or when you try to publish a database with binary collation for merge replication, after you inst

ON Technology (Nasdaq: ONTC), a leading provider of enterprise infrastructure management solutions, announced the immediate availability of the ON Application Developers Kit (ADK). The new offering provides a series of open programming interfaces that significantly reduce implementation time by all

By Brian Moran – Remember the OS? It’s that boring piece of software that our database engines run on. We database professionals strive for performance improvement. But while we’re worrying about tweaks, we forget about the easy changes.

By Keith Furman – According to a new report from research firm Gartner, the database market experienced a decline in sales in 2002, but Microsoft SQL Server experienced a substantial increase in sales and market share. In 2002, economic troubles hit the database market, which saw sales decline 7 per

by Susan Harkins, Martin W. P. Reid – SQL Server Views don’t support the ORDER BY clause, but that shouldn’t stop you from bringing order to your data. This article teaches you how to sort the results of a View, despite this small limitation.

Want to figure out how big your data tables are? SQL Server Magazine’s Brian Moran shows you how to query the system tables for this info without perform COUNT* functions on every table in the database.

by Eli Leiba – Here are several procedures that you can use to “move” all of your user databases from one SQL Server to another with ease.

By Vyas Kondreddi – Microsoft released Data Transformation Services (DTS) along with SQL Server 7.0. A very powerful, easy to use, graphical tool for importing, exporting and transforming data, which is only available as a costly add-on in other RDBMS products like Oracle. Prior to SQL Server 7.0, a