Font Size

SCREEN

Profile

Layout

Direction

Menu Style

Cpanel

Encylopedia

SQL Server Express 2008

SQL Server Express 2008

About:

Microsoft SQL Server Express, a freely-downloadable and -distributable version of Microsoft's SQL Server relational database management system, comprises a database specifically targeted for embedded and smaller-scale applications. Unlike its predecessor, MSDE, it lacks a concurrent workload-governor to "limit performance if the database engine receives more work than is typical of a small number of users."[1] It does, however, have a number of technical restrictions which make it undesirable for large-scale deployments, including:
  • maximum database size of 4 GB per database (compared to 2 GB in the former MSDE). The 4 GB limit applies per database (log files excluded); but in some scenarios users can access more data through the use of multiple interconnected databases.
  • hardware-utilization limits:
    • Single physical CPU, multiple cores[2]
    • 1 GB of RAM (runs on any size RAM system, but uses only 1 GB)
  • absence of the SQL Server Agent service
  •  

wikipedia.com

Read more...

Discuss this article
You need to log in or register to participate in this discussion.

Green Computing

Green computing, the study and practice of efficient and eco-friendly computing resources, is now under the attention of not only environmental organizations, but also businesses from other industries. In recent years, companies in the computer industry have come to realize that going green is in their best interest, both in terms of public relations and reduced costs. This article will take a look at several green initiatives currently under way in the computer industry, as well as issues that have been raised regarding these initiatives. We will also have a talk with VIA to learn more about the future of green computing.

Read more...

Discuss this article
You need to log in or register to participate in this discussion.

The top 10 IT disasters of all time

Following the loss of the personal records of some 25 million child benefit recipients by Her Majesty's Revenue & Customs this month, the UK government will be acutely aware of how quickly mismanagement of technology can lead to serious problems.

While technology wasn't to blame per se in the HMRC data loss, there are plenty of recorded examples where faulty hardware and software have cost the organizations concerned dearly, both financially and in terms of reputation — and resulted in some near misses for the public.

Here's our considered list of some of the worst IT-related disasters and failures. The order is subjective — with number one being the worst — so feel free to comment using the Talkback facility below if you disagree or have suggestions for disasters we may have missed.

Read more...

Discuss this article
You need to log in or register to participate in this discussion.