Databases are the heart and soul of many of the recent enterprise applications and it is very essential to pay special attention to database programming. I've seen in many occasions where database programming is overlooked, thinking that it's something easy and can be done by anyone. This is

by Brad M. McGehee – In this article, I want to review another product from Red-Gate Software called SQL Data Compare. The names of these two products is very similar, so don’t get them confused. What SQL Data Compare does is to compare the data between two like databases, and if desired, it allows

Why does my inline or embedded SQL run faster than my stored procedures? Check it out for the answer.

Read how a 32-processor Unisys ES7000 running SQL Server 2000 surpassed the best performance of a 64-processor Sun/Oracle system.

From SQLTeam, Sherry writes "I have a table with form_id, lta_id, type, version and other stuff. My users are allowed to fill out a form multiple times. I need to keep the old versions, but for computations, I only want to add up the newest version. The rest of Sherry's question is in the bo

Q. Why does data disappear from the subscriber when you run a horizontally partitioned merge publication? A. Data that seems to “disappear” has been a problem since the release of merge replication in SQL Server 7.0. Merge replication gives you the ability to process a transaction on a su

Book by Brian Knight – At first blush, the title of this book sounds obscure. What exactly is meant by Admin 911? I didn't know either until I read through the book. Now that I understand what this book is all about, I would like to propose some alternate titles for this book: Advanced SQL Serve

Book by Mark Chaffin, Brian Knight, Todd Robinson – A lot of corporate databases are what's behind the Internet revolution. Professional SQL Server 2000 DTS gives DBAs and programmers a handy guide to getting the most out of the Data Transformation Services (DTS)–a flexible set of tools that wo

If accurate, usable information is important to you – and to your business – you need the award-winning dfPower Studio software from DataFlux. Check out what dfPower Studio allows you to:

Business today demands a different kind of database solution. Performance, scalability, and reliability are essential, and time to market is critical. Beyond these core enterprise qualities, SQL Server 2000 provides agility to your data management and analysis, allowing your organization to adapt qu