When you try to turn on virtual machines in Microsoft Virtual Server 2005, you may receive messages that state that the computer is out of memory. This problem occurs when the following conditions are true:d • You are running Virtual Server 2005 and Microsoft SQL Server 2000 as peer applications

(Juval Lowy) Both Internet and intranet applications often require a custom store for user accounts and roles. ASP.NET 2.0 provides an out-of-the-box provider model as well as a SQL Sever database just for that propose. Unfortunately, the only way to administer the credentials databases is via Visua

(Muthusamy Anantha Kumar) After the release of SQL Server 7.0, SQL Server is not just an RDBMS. It also provides services like Extraction Transformation and Loading, Online Analytical processing etc. This evolution of SQL Server added additional responsibilities to the database administrative tasks.

(Arthur Fuller) There are many ways that you can use randomly selected rows; they’re especially effective when you want to add dynamism to a site. For instance, you could randomly select a product to present as Today’s Featured Product, or QA could generate a random call list to gauge customer satis

(William Pearson) In this article, we will continue the examination of “MDX for drilling up and down” that we began in Set Functions: The DRILLDOWNMEMBER() Function. We discussed the nature of drilldown, in our last article, stating that it comprises an analytical technique through which means an in

(Geert Vanhove) This article is the third in a series of four where I share my findings on baselining, monitoring, stress testing and performance tuning. It builds on the foundations of my previous articles on baselining and monitoring.

(Darshan Singh) You may know that Service Broker gets disabled when a database is restored or when a database is attached. What if you need to enable it whenever a database is restored? This is just one example, but what if you want to perform some similar post-restore actions?

Consider the following scenario: • You call the CreateEx method at the same time on more than one thread in a multiple-thread application. • The multiple-thread application uses the Virtual Device Interface feature of Microsoft SQL Server 2000.

(Brian Walker) This tip continues the system stored procedure series with a routine to list run history for selected SQL Agent jobs. (R)

(Don Schlichting) This article will explore the new Row Versioning feature in SQL 2005, and the two new transaction isolation levels that take advantage of it: Read Committed Snapshot and Snapshot Isolation.