Microsoft® is tightly integrating XML into the SQL Server™ relational database management system (RDBMS) to help developers build the next generation of Web and Enterprise applications. To start off this process, Microsoft has released a technology preview that provides XML integration with and dire

Once again Compaq has shown the ability to take industry standard building blocks — servers, storage and interconnect technology — and deliver maximum performance at industry standard price points. The combination of ProLiant servers, Compaq storage systems, ServerNet II interconnect, and Microso

Questions, Answers, and Tips About SQL Server Learn about the paging file's importance, SQL Server 7.0 evaluation version's hazards, build numbers, DBCC DBREINDEX and fragmentation, mysterious indexes, permissions problems, and performance tuning.

Questions, Answers, and Tips About SQL Server Investigate how to install multiple instances of SQL Server, use the TOP statement with a local variable, use UDFs in SQL Server 2000, store extended properties, and more.

By Jeffrey Bane – When it comes to database optimization for e-commerce, maximum performance for the Web user takes precedence over all else. Probably in no other type of dynamic application does SELECT statement performance take such priority over inserts and updates. (I say dynamic because an OLAP

Despite Zachman's rosy comments, the sailing has not been smooth for Microsoft with BizTalk Server and the underlying BizTalk Framework technology.

By Michael Otey – Despite the impressive Transaction Processing Performance Council (TPC) scores that Microsoft generated by using scale-out technology and SQL Server's federated-databases feature, it's too soon to count out scale-up technology based on SMP systems. Adding more processing po

By Brian Knight – Database Scanner 4.0.1 from Internet Security Systems (ISS) is a must-have for any DBA responsible for security. Database Scanner lets you set security policies on your SQL Server 7.0 and 6.x systems, then lets you audit your systems to see whether you're complying with those p

Oracle unveiled a new online service that lets business customers create a business home page, or portal, using a Web browser and an array of graphical tools.

This exam will definitely challenge your knowledge of administration tasks within SQL Server. For those who perform all of their administration using Enterprise Manager, you'll need to get out ISQL and learn how to perform all of your administration tasks at a command line level. All the command