By Barbara Darrow – Microsoft’s new 64-bit SQL Server 2000 will help solution providers better serve midsize businesses as well as enterprise accounts, industry executives said.

by Daniel Grandestaff – If you are planning a Pocket PC based mobile application using SQL Server for CE you need to understand the replication options and mechanisms.

In some corners of the IT world, there is very little real competition and no question who leads the market. For example, Microsoft has the lock on desktop operating systems and Apache rules Web servers, and no one expects that to change in the near future. There is a little more suspense when it co

by Randy Dyess – Deleting duplicate SQL Server records is not as easy as you might expect. Learn how to identify and delete duplicate records in this article.

Recompilations might be the source of the slower stored procedure speed. To find out for sure, you need to do some performance investigation, such as looking at Showplans for each type of query versus calling the stored procedures and comparing query plan cache hits to cache misses.

Price, performance, product limitations – how SQL Server 2000 stacks up against Sybase ASE 12.5.

by Glen Kunene – If data is the core asset of all applications, why is database security so often relegated to a secondary consideration? Two database security experts explain why locking down your database should be a top priority and offer solutions for making it happen.

by Simon Galbraith – Migrating database changes from the development database to the testing, staging, and live databases poses plenty of challenges. Learn why using an automated tool is the best way to deal with these challenges.

Writing a script that works with multiple databases spread across multiple servers isn’t as easy as you might think. Read how Alexander Kozak leveraged the notion of context switching to help him automate an onerous task.

by Randy Dyess – Learn how to take advantage of SQL Server startup options.