Showing posts with label what is. Show all posts
Showing posts with label what is. Show all posts

What Is Acute Leukemia

Leukemia is a cancer of the blood cells. A progressive, malignant disease of the blood-forming organs, characterized by distorted proliferation and development of leukocytes and their precursors in the blood and bone marrow. Leukemias were originally termed acute or chronic based on life expectancy but now are classified according to cellular maturity. Acute leukemia consist of predominately immature cells. Chronic leukemia are composed of more mature cells.

Leukemia accounts for about 2% of all cancers. It strikes 9 out of every 100,000 people in the United States every year. Men are more likely to develop leukemia than women, and white people get the disease more than other racial or ethnic groups. Adults are 10 times more likely to develop leukemia than children. Leukemia occurs most often in the elderly. When leukemia occurs in children, it happens most often before age 4.

What Is Acute Leukemia
With acute leukemia, immature blood cells reproduce quickly in the bone marrow, where they eventually crowd out healthy cells. When present in high numbers, these immature, abnormal cells sometimes can spread to other organs, causing damage, especially in a type of leukemia called acute myeloid leukemia.

The two main types of acute leukemia involve different types of blood cells:
Acute myeloid leukemia accounts for 50% of leukemia diagnosed in teenagers and in people in their 20s. It is the most common acute leukemia in adults. It occurs when primitive blood-forming cells called myeloblasts reproduce without developing into normal blood cells. Immature myeloblast cells crowd the bone marrow and interfere with the production of healthy normal blood cells. This leads to anemia (not having enough red blood cells), bleeding and bruising (due to a lack of blood platelets, which help the blood to clot), and frequent infections because there are not enough protective white blood cells.

Acute lymphoid leukemia is the most common type of leukemia that affects children, mainly those younger than 10. Adults sometimes develop acute lymphoid leukemia, but it is rare in people older than 50. It occurs when primitive blood-forming cells called lymphoblasts reproduce without developing into normal blood cells. These abnormal cells crowd out Healthy Heart blood cells. They can collect in the lymph nodes and cause swelling.

READ MORE - What Is Acute Leukemia

What is Cystic Fibrosis?

Think you know What is Cystic Fibrosis?
Cystic Fibrosis is a passed down scenario importance that it isn't contaminated like a common cold, it's something you are endowed with. Main issues with someone who has Cystic Fibrosis is they have issues breathing and their individual body system doesn't take in fat and aminoacids that our systems needs to maintain itself. These are both causes of their speech and colon from successfully managed.

Cystic Fibrosis is a passed down scenario that 1 out of every 29 White-colored Individuals have. Actual, it may be a symptom-less CF gene importance it will not effect your health and fitness. But, if 2 symptom-less CF gene moms and dads have a child; the kid has a 25% probability of having this risky scenario. Many causes of this scenario are a shut-down in speech or abdominal areas of our bodies complicated the need for a improvement or deaths.

There are several Cystic Fibrosis organizations that offer interest towards this scenario in wish of improving cash for research and to offer team functions to go to to the needs of cystic fibrosis scientifically clinically diagnosed people.

Babies are often scientifically clinically diagnosed because it's much easier to recognize a problem when they are of this age. Since newborns normally eat, spend, and sleep; It's much easier to recognize issues that they are having at these functions and therefore tests are preformed to find out the best way to cope with the adverse action. Nevertheless, not everyone finds out as a kid that something is wrong within of them and in the event that health professionals find out out what their symptoms are, it allows health professionals determine what the recognize is.

A simple sweat evaluate is done to find out if cystic fibrosis may be the objective for any of the following aspects are happening such as breathing issues, hacking and coughing and hacking and coughing, or skin detecting like salt. A sweat evaluate shows the doctor that something isn't managing successfully within our systems and that our systems needs help so that it doesn't near down.

The Cystic Fibrosis organizations across the planet works to rid the planet of this passed down scenario that has the ability to mutate and make a cure for cystic fibrosis that much more complicated to research.

Money is a insane aspect on the planet, normally its used to buy what we need, want, and wish but in this scenario its needed to protect lifestyle because it'll offer more research and progressively find out a cure that allows you to protect many men and women in the main of their way of lifestyle when they are just beginning to find what being existing has to offer and to find yourself while being on the globe.

I wish you find out that this is a fight to find a cure, to power into unchartered techniques of technological innovation and find out how to fix what every kid with this passed down scenario is endowed with of no error of their own nor their moms and dads error. It's something that needs to be handled and the encounters that can be advised from those who withstand will keep a history that will encourage humans to fight the fantastic fight and remain the way of lifestyle that everyone desires to remain.

Read: Signs of Healthy Heart and Ovarian Cyst Symptoms
sumber: www.squidoo.com
READ MORE - What is Cystic Fibrosis?

What Is NTFS File System

What Is NTFS File System
The abbreviation for NTFS is New Technology File System is the standard file system of Windows NT. NTFS has several improvements over FAT such as improved support for metadata and the use of advanced data structures to improve performance, reliability and disk space utilization plus additional extensions such as security access control lists and file system journaling.

Its main drawback is its very limited support by non-Microsoft. NTFS has five versions: v1.0, v1.1 and v1.2 found in NT 3.51 and NT 4, v3.0 found in Windows 2000 and v3.1 found in Windows XP and Windows Server 2003. The features of Windows NT’s development are the addition of fields for indexing used by the Active Directory software.

NTFS uses B Trees to index file system data. Although complex to implement, this allows faster access times in some cases. A file system journal is used in order to guarantee the integrity of the file system itself. Systems using NTFS are known to have improved reliability compared to FAT file systems. NTFS Partitions can be read by Linux since Version 2.2.0. Linux 2.6 contains a new driver written by Anton. The creation and deletion of folders is not yet supported.

For historical reasons, the versions of Windows that do not support NTFS all keep internally as local zone time, and therefore so do all file systems other than NTFS that are supported by current versions of Windows. Therefore, NTFS are in GMT/UTC. As a result, especially shortly after one of the days on which local zone time changes, users may observe that some files have timestamps that are incorrect by one hour.

NTFS 5.0 was the third version of NTFS to be introduced to the Windows world by Microsoft. It included several new features: quotas, sparse file support, reparse points, distributed link tracking and the Encrypting File System (EFS) allows files to be associated with more than one data stream. Alternate streams are not detectable in the original file's size but are lost when the original file is deleted, or when the file is copied or moved to a partition that doesn't support ADS. While ADS is a useful feature, it can also easily eat up hard disk space if not detected or forgotten. File system quotas were introduced in NTFS 5.

They allow the administrator of a computer that runs a version of Windows that supports NTFS to set a threshold of disk space that users may utilize. It also allows administrators to keep a track of how much disk space each user is using. An administrator may specify a certain level of disk space that a user may use before they receive a warning, and then deny access to the user once they hit their upper limit of space.

This is called a sparse data set, and most things that generate such data sets are scientific applications, and they can generate very large sparse data sets. Because of this, Microsoft has implemented support for sparse files by only allocating disk space for regions that do not contain blocks of zero data.

An application that reads a sparse file reads it in the normal manner with the file system calculating what data should be returned based upon the file offset. Thus the latest version NTFS 5 provides the NTFS system to be called upon and to be prepared for the latest advancement of the following in the system.
READ MORE - What Is NTFS File System

What is a Unit Test Case

What is a Unit Test Case
A Unit Test Case is a part of code which guarantees that the a different part of code (system) fills in as looked for. To realize these wanted effects fast, test schema is needed .JUnit is impeccable unit test structure for java modifying dialect.

A formal composed unit test case is portrayed by a known include and by an anticipated yield, which is worked out when the test is executed. The known include might as well test a precondition and the looked for yield may as well test a postcondition.

There should be at slightest a few unit test cases for every necessity: one positive test and one negative test.

In the event that a prerequisite has sub-prerequisites, every sub-prerequisite should have at minimum a few test cases as positive and negative.

Read:
READ MORE - What is a Unit Test Case

What Is PDA - Personal Digital Assistance

What Is PDA
The abbreviation goes for the name as Personal Digital Assistance. And as the name itself the PDA provides the assistance to many of its wide range of users. In appearance it is a small sized device that is enabled with a touch screen display.

The keyboard, head sets, battery charger are also available as accessories. The features include many personal organizer, outlook – email client, mp3, media players, telephone book, address book etc.

Considering the technical features of the device it includes the Operating system, Processors, Memory, Expansion slots, Displays, Keyboard, Wireless networking, voice and the internet, GPS – Global Positioning System, audio and video recorders, digital cameras, remote control.

There will also be an option for installing the desired software in it. The software may be like games and all other stuff that can be installed on a computer graphics. But obviously the features can’t be matched with that of a high end personal computer.

But in short it can be considered as a hand held personal computer. The PDA device is handy and mobile. The features of a mobile device are also available in it. The device apart from a communication hub can be treated as the organizer, scheduler, and the entertainer.

The GPS can be used as an assistant at time of traveling. The device can even show the road maps. This is possible due to the GPS receivers that can be added to the PDA’s expansion slots. The device also has the best screen display that can have the feature of touch screen.

The most important technical aspect of this device is the processor that is small but presently available in the capability of about 16 Mega Hertz to 400 Mega hertz. Even faster processors are found in the palm tops, and hand held computers.

The memory in the PDA can range from 2 MB to 2 GB. This memory can be used for storing all the information in the address book, and the clips and files. The data storage capability is also used. The networking and wireless connectivity over the internet is enabled by Wi-Fi networks or the Bluetooth technology.

Daily Use of PDA
PDA is a hand held device that is used to manage the daily chores of the user.

In short this is the device that is used by people in almost any category whether that of a professional, a student, lawyer, doctor and even house wives. The applications are just wide enough to be explained. The PDA in other words is a small but a powerful master organizer. The PDA that have high end functions are also available but the cost is slightly more than the normal ones; the higher functionality in the sense of wireless connectivity and mobility etc. The PDA is a device that has recently gained popularity.

The PDA’s can also carry the feature that could be used as a mobile phone. This feature is quite important as the situation demands right now. The PDA is also one of the most sought after device for the younger generations. The PDA is a sophisticated device.

The business personalities those who have higher appointments and all can make efficient usage of this device. This device can be used as the organizer and an appointment calendar also.

The feature of Bluetooth is also enabled in some devices. This is an important property of an electronic device that can be used to connect to the other devices in the vicinity of that area. The PDA can also be called as the synchronization tool. The synchronization is achieved by the way of a software program that helps in maintaining a duplicate scheduling program. And hence due to this feature no appointments need to be missed.

The enhancements may also include the software that is developed for the purpose of positioning. In other words most popularly referred to as the Global Positioning System. The PDA has its own memory that can store a lot of Documents. Also the features of Ms Office are available in it. For example the Power point presentations, the spreadsheets and the documentation tools.

There is power charger available in it. The keyboard is in-built. The head phones are also included. Apart from that the other software like games can also be run on it.
READ MORE - What Is PDA - Personal Digital Assistance

What Is A Cluster

What Is A Cluster
A cluster is a group of coupled computers that work closely so that it can be viewed it as a single computer. Clusters are commonly connected through fast local area networks. Clusters are generally used to deploy and to improve speed and reliability over single computer. High availability clusters are used for the purpose of improving the availability of services. They can operate to provide service when system components fail. There are many commercial implementations of High-Availability clusters for many operating systems.

The Linux-HA project is one commonly used free software HA package for the Linux OS. Load balancing clusters operate by having all workload come through one or more load-balancing front ends, which then distribute it to a collection of back end servers.

The Linux Virtual Server project provides one commonly used free software package for the Linux OS. High performance clusters are implemented primarily to provide increased performance by splitting a computational task across many different nodes in the cluster, and are most commonly used in scientific computing.

The clusters are commonly used to run the programs which have designed to exploit the availability on clusters. Clustering can provide best performance. The cluster consists of Power Mac G5s; the first commodity clustering product was ARC net, developed by Data point in 1977. ARC net wasn't a commercial success and clustering didn't really take off until DEC released their lackluster product in the 1980s for the VAX/VMS operating system.

The history of cluster computing is intimately with the evolution of networking technology. High-performance clusters are implemented primarily to provide increased performance by splitting a computational task across many different nodes in the cluster, and are most commonly used in scientific computing. One of the more popular HPC implementations is a cluster with nodes running Linux as the OS and free software to implement the parallelism. This configuration is often referred to as a Beowulf cluster. Such clusters commonly run custom programs which have been designed to exploit the parallelism available on HPC clusters.

Many such programs use libraries such as MPI which are specially designed for writing scientific applications for HPC computer. Load balancing clusters operate by having all workload come through one or more load-balancing front ends, which then distribute it to a collection of back end servers. Although they are implemented primarily for improved performance, they commonly include high-availability features as well. Such a cluster of computers is sometimes referred to as a server farm.

As networking technology has become cheaper and faster, cluster computers have become significantly more attractive. The term cluster encompasses a number of different algorithms and methods for grouping objects of similar kind into respective categories. The cluster analysis can be used to discover structures in data without providing an interpretation. In other words, cluster analysis simply discovers structures in data without explaining why they exist. Thus, the cluster can be thought of as a group of computers which is viewed as a single computer.
READ MORE - What Is A Cluster

What is JUnit

What is JUnit
JUnit is a unit testing schema for the Java Programming Language. It's important in the test driven development, and is one of a family of unit testing systems by and large reputed to be xUnit.

JUnit supports the thought of "first testing then coding", which attention on setting up the test information for a bit of code which might be tested first then after that could be achieved .

This way is like "test a little, code a little, test a little, code a little..." which expands programmer gainfulness and stability of system code that decreases programmer anxiety and the time spent on debugging.
READ MORE - What is JUnit

What Is Multiplexing

What is Multiplexing ? Multiplexing is a form of data transmission in which one communication channel carries several transmissions at the same time. The telephone lines that carry our daily conversations can carry thousands or even more of conversations at a time using multiplexing concept. The exact number of simultaneous transmission depends on the type of communication channel and the data transmission rate.

Economics of scale play an important role in the telephone system. It costs essentially the same amount of money to install and maintain a high-bandwidth trunk as low-bandwidth trunk between two switching officers. Consequently, telephone companies have developed elaborate schemes for multiplexing many conversations over a single physical trunk.

Accordingly, the communication channel is shared in such a way as to maximum the utilization of the channel capacity. Thus the method of dividing a single channel into many channels so that a number of independent signals may be transmitted on it is known as Multiplexing.

Multiplexing schemes can be divided into two basic categories:
  • Frequency Division Multiplexing FDM
  • Time Division Multiplexing TDM
READ MORE - What Is Multiplexing

What is CAD - Computer Aided Design

What is CAD - Computer Aided Design
Computer Aided Design (CAD) and computer Aided Manufacturing (CAM) system is another name for the application of computers in the field of engineering design and production in industries. By using a CAD system, a civil engineer can draw a plan of a building or house to be constructed.

There are graphic CAD software with which a civil engineer can display the model of a house intended to be built, so that this customer must be satisfied with the architecture planned for that construction. The customer may given the effect in his house although the house is not yet constructed.

Complex engine parts, machine parts can be drafted and designed by a mechanical engineer using a CAD system consisting of a computer autocad software and graphic input device mouse and a color monitor as a output device to visualize the new design.

Computer Aided Manufacture (CAM) involve the use of computer. CNC machines, Robots in production plants for mass production at short intervals of time. Precision oriented tools manufacturing make use of computer for controlling quality supervising and precision cutting operations.

What is CAD, the generaly CAD is abbreviation from Computer Aided Design.
READ MORE - What is CAD - Computer Aided Design

What is the Human Digestive System

What is the Human Digestive System - The human digestive system breaks down food mechanically and then converts it chemically into substances that can be absorbed by the body.

Simple sugars are, for the most part, absorbed unchanged. However, starch, fats, and proteins generally need to be broken down by the digestive fluids before they can be utilized. A variety of enzymes perform this function, each having particular substrates upon which it can act. For example, the enzyme amylase, present in saliva, breaks down starch into sugar. Similarly, in the stomach the enzyme pepsin breaks down proteins into short peptides.

The digestive tract is composed of the organs shown in the figure at right. In the mouth, the tongue and teeth crush food and mix it with saliva. When swallowed the masticated food passes down the esophagus to the stomach. As the food passes the glottis, the epiglottis closes to prevent choking.

The stomach secretes acidic digestive fluids which aid in breaking down the food (pepsin is active only in an acidic solution).

Bile is produced in the liver and stored in the gall bladder. Within the small intestine, bile acts as a surfactant, coating lipid particles, allowing their dispersion, and thus making them accessible to the enzyme pancreatic lipase, which breaks them down into simpler molecules that can be absorbed through the walls of the intestine.

The large intestine absorbs water from the matter passed undigested through the small intestine. It then ejects the dehydrated waste from the body.

The human digestive system is one of the largest and most evolved systems in the human body. however, its complexity also opens us up to many disorders and diseases. How does it work and why does it fail so often?

The basic function of the digestive system is to convert food materials into usable energy and to provide our bodies with material its needs to grow and maintain itself. This long process has evolved to be very efficient- grabbing as many nutrients out of food as possible and leaving all unusable material to be excreted.

The organs of the digestive system on this site have been divided into early, middle, and late for simplicity sake. In the human body, the digestive system is really made up of a long, what can be thought as, tube called the Alimentry Canal or GI Tract.

The GI tract begin in the mouth and ends in the Anus. To aid the process of digestion, several accessory organs line the GI tract. These organs include the Salivary Glands, Teeth and Tongue, Liver, Gallbladder, and Pancreas. These organs produce saliva, bile, and several other important catabolic (breakdown) enzymes. These molecules are added the the orderly flow of food in the GI Tract via several ducts.

The basic strategy of digestion is to break down all food into basic molecules and then absorb the useful ones. The specific roles of each section and organ is covered at the left: early, middle, and late digestion.

Your digestive system consists of organs that break down food into components that your body uses for energy and for building and repairing cells and tissues.

Food passes down the throat, down through a muscular tube called the esophagus, and into the stomach, where food continues to be broken down. The partially digested food passes into a short tube called the duodenum (first part of the small intestine). The jejunum and ileum are also part of the small intestine. The liver, the gallbladder, and the pancreas produce enzymes and substances that help with digestion in the small intestine.

The last section of the digestive tract is the large intestine, which includes the cecum, colon, and rectum. The appendix is a branch off the large intestine. it has no known function. Indigestible remains of food are expelled through the anus.
What is Breast Cancer? and What is Anemia?
READ MORE - What is the Human Digestive System

What is Anemia

What is Anemia, do you've heard? Anemia is a condition in which the body does not have enough healthy red blood cells. Red blood cells provide oxygen to body tissues. General Symptoms: You may have no symptoms if the anemia is mild. Anemia occurs when there isn't enough hemoglobin (an iron-protein compound in red blood cells that transports oxygen) in the blood and there are too few red blood cells. Anemias are the most common blood disorder; there are several types of anemia. They are usually caused by an iron deficiency. In Canada, approximately 20% of women, 50% of pregnant women, and 3% of men are iron deficient. Overall, it occurs in two out of 1,000 people.

Some infants may need extra iron, especially if they are bottle-fed with cow's milk. This is why doctors often prescribe iron supplements during infancy and why infant diets are iron fortified and only iron-fortified formulas should be used.

The body needs the iron to make hemoglobin. Except in cases of malnourished infants, iron deficiency is almost always caused by long-term blood loss due to factors such as heavy menstrual periods, peptic ulcer disease, long-term ASA use, colon cancer, uterine cancer, and malignancies (cancerous tumors). It may also occur if there's not enough iron-containing food in the person's diet or if there's poor absorption of iron (such as in the case of people who have had gastric bypass surgery).

This form of anemia occurs quite often in pre-menopausal women because women lose blood during menstruation. Pregnant women who don't take iron supplements may develop iron deficiency anemia because their iron stores are used as a source of hemoglobin for the baby.

Many people, however, are unaware of just how tired they were until after they've been treated.

In addition to feeling tired and having less energy, the person may have pale skin, gums, nail beds, and eyelid linings. Eventually, if anemia becomes severe enough, the heartbeat may become more rapid and noticeable.

Other symptoms of iron deficiency anemias may include:
  • irritability
  • weakness
  • shortness of breath
  • low blood pressure (especially when going from lying or sitting to standing)
  • sore tongue
  • brittle nails
  • unusual food cravings (called pica)
  • decreased appetite (especially in children)
  • headache
To diagnose anemia, your doctor may recommend:
Physical exam. During a physical exam your doctor may listen to your heart and your breathing. Your doctor may also place his or her hands on your abdomen to feel the size of your liver and spleen.

Complete blood count (CBC). A CBC is used to count the number of blood cells in a sample of your blood. For anemia, your doctor will be interested in the levels of the red blood cells contained in the blood (hematocrit) and the hemoglobin in your blood.

Normal adult hematocrit values vary from one medical practice to another, but are generally between 38.8 and 50 percent for men and 34.9 and 44.5 percent for women. Normal adult hemoglobin values are generally 13.5 to 17.5 grams per deciliter for men and 12 to 15.5 grams per deciliter for women.

A test to determine the size and shape of your red blood cells. Some of your red blood cells may also be examined for unusual size, shape and color. Doing so can help pinpoint a diagnosis. For example, in iron deficiency anemia, red blood cells are smaller and paler in color than normal. In vitamin deficiency anemias, red blood cells are enlarged and fewer in number.

Additional tests
If you receive a diagnosis of anemia, your doctor may order additional tests to determine the underlying cause. For example, iron deficiency anemia can result from chronic bleeding of ulcers, benign polyps in the colon, colon cancer, tumors, or kidney failure. Your doctor may test for these and other conditions that may underlie the anemia.

Occasionally, it may be necessary to study a sample of your bone marrow to diagnose anemia. read another about cancer: What is breast cancer
READ MORE - What is Anemia

What is a SQL Server

Do you know, What is a SQL Server ?
SQL Server is a Relational Database Management System (RDBMS) from Microsoft. It is also known as MS SQL or simply SQL Server. It is an Enterprise level database application just like Oracle, DB2 or MySQL Database. As such it is able to store and manage millions of data records for any small to large corporation. There are several different versions of MS SQL in production, the most common ones are SQL Server 2005 and SQL Server 2008. If you want to try a free SQL Server version for 180 days so you can kick the tires, please visit this Microsoft site.
http://adf.ly/DLlVU

What is a SQL Server 2005?
SQL Server 2005 (formerly codenamed "Yukon") was released in October 2005. It included native support for managing XML data, in addition to relational data. For this purpose, it defined an xml data type that could be used either as a data type in database columns or as literals in queries. XML columns can be associated with XSD schemas XML data being stored is verified against the schema. XML is converted to an internal binary data type before being stored in the database. Specialized indexing methods were made available for XML data.

XML data is queried using XQuery. SQL Server 2005 added some extensions to the T-SQL language to allow embedding XQuery queries in T-SQL. In addition, it also defines a new extension to XQuery, called XML DML, that allows query-based modifications to XML data. SQL Server 2005 also allows a database server to be exposed over web services using Tabular Data Stream (TDS) packets encapsulated within SOAP (protocol) requests. When the data is accessed over web services, results are returned as XML.

Common Language Runtime (CLR) integration was introduced with this version, enabling one to write SQL code as Managed Code by the CLR. For relational data, T-SQL has been augmented with error handling features (try/catch) and support for recursive queries with CTEs (Common Table Expressions). SQL Server 2005 has also been enhanced with new indexing algorithms, syntax and better error recovery systems.

Data pages are checksummed for better error resiliency, and optimistic concurrency support has been added for better performance. Permissions and access control have been made more granular and the query processor handles concurrent execution of queries in a more efficient way. Partitions on tables and indexes are supported natively, so scaling out a database onto a cluster is easier. SQL CLR was introduced with SQL Server 2005 to let it integrate with the .NET Framework.

SQL Server 2005 introduced "MARS" (Multiple Active Results Sets), a method of allowing usage of database connections for multiple purposes.

SQL Server 2005 introduced DMVs (Dynamic Management Views), which are specialized views and functions that return server state information that can be used to monitor the health of a server instance, diagnose problems, and tune performance.

Service Pack 1 (SP1) of SQL Server 2005 introduced Database Mirroring, a high availability option that provides redundancy and failover capabilities at the database level. Failover can be performed manually or can be configured for automatic failover. Automatic failover requires a witness partner and an operating mode of synchronous (also known as high-safety or full safety).

What is a SQL Server 2008?
SQL Server 2008 was released on August 6, 2008 and aims to make data management self-tuning, self organizing, and self maintaining with the development of SQL Server Always On technologies, to provide near-zero downtime. SQL Server 2008 also includes support for structured and semi-structured data, including digital media formats for pictures, audio, video and other multimedia data. In current versions, such multimedia data can be stored as BLOBs (binary large objects), but they are generic bitstreams.

Intrinsic awareness of multimedia data will allow specialized functions to be performed on them. According to Paul Flessner, senior Vice President, Server Applications, Microsoft Corp., SQL Server 2008 can be a data storage backend for different varieties of data: XML, email, time/calendar, file, document, spatial, etc as well as perform search, query, analysis, sharing, and synchronization across all data types.

Other new data types include specialized date and time types and a Spatial data type for location-dependent data. Better support for unstructured and semi-structured data is provided using the new FILESTREAM data type, which can be used to reference any file stored on the file system.

Structured data and metadata about the file is stored in SQL Server database, whereas the unstructured component is stored in the file system. Such files can be accessed both via Win32 file handling APIs as well as via SQL Server using T-SQL, doing the latter accesses the file data as a BLOB. Backing up and restoring the database backs up or restores the referenced files as well. SQL Server 2008 also natively supports hierarchical data, and includes T-SQL constructs to directly deal with them, without using recursive queries.

The Full-text search functionality has been integrated with the database engine. According to a Microsoft technical article, this simplifies management and improves performance.

Spatial data will be stored in two types. A "Flat Earth" (GEOMETRY or planar) data type represents geospatial data which has been projected from its native, spherical, coordinate system into a plane. A "Round Earth" data type (GEOGRAPHY) uses an ellipsoidal model in which the Earth is defined as a single continuous entity which does not suffer from the singularities such as the international dateline, poles, or map projection zone "edges". Approximately 70 methods are available to represent spatial operations for the Open Geospatial Consortium Simple Features for SQL, Version 1.1.

SQL Server includes better compression features, which also helps in improving scalability. It enhanced the indexing algorithms and introduced the notion of filtered indexes. It also includes Resource Governor that allows reserving resources for certain users or workflows. It also includes capabilities for transparent encryption of data (TDE) as well as compression of backups. SQL Server 2008 supports the ADO.NET Entity Framework and the reporting tools, replication, and data definition will be built around the Entity Data Model. SQL Server Reporting Services will gain charting capabilities from the integration of the data visualization products from Dundas Data Visualization, Inc., which was acquired by Microsoft.

On the management side, SQL Server 2008 includes the Declarative Management Framework which allows configuring policies and constraints, on the entire database or certain tables, declaratively. The version of SQL Server Management Studio included with SQL Server 2008 supports IntelliSense for SQL queries against a SQL Server 2008 Database Engine. SQL Server 2008 also makes the databases available via Windows PowerShell providers and management functionality available as Cmdlets, so that the server and all the running instances can be managed from Windows PowerShell.

What is SQL Server information intended for knowledge and education for the first user knowing internet network and computer network.
READ MORE - What is a SQL Server