SQL Server will increase policy management

This is not a huge structural change, nor a short commitment, and in fact, Microsoft has continued to base its SQL Server products on, and wants it to be aware of its enormous role in managing massive amounts of data.

A Microsoft Business Intelligence conference was held in Seattle in 2007, where top management demonstrated a blue view of the new generation of SQL SERVER---katmai. It will be released in 2008. Francois Ajenstat, head of Microsoft's product management department, said, but it also depends on the feedback from the community preview.

Similarly, Microsoft has pledged to customers that version 2008 of SQL Server also carries out a 24-36-month product release schedule. From SQL SERVER2000 to SQL SERVER2005, executives say, it's been 5 years, and this new version won't take too long. Ajenstat said the first community previews will take place within 30 days, and the new features will be added to the community preview.

Perhaps the most notable concern for it marketers is that this new version uses a framework called policy-based. That is, unlike traditional script-oriented operations, administrators can customize a set of database operations policies, such as query optimization, naming conventions, and backup recovery. "These strategies can be monitored, enforced, and alerted," Ajenstat said. ”

The company also claims that there is an improvement that adds a program called "Explorer" that can help database administrators optimize the system. For example, if multiple applications are issued at the same time, the Resource Manager helps determine the sequence of successive executions.

Makes it easier for users to store and manage unstructured data

New map features, called "File Flow", make it easier for users to manage unstructured data for stored documents and picture classes.

Microsoft's senior guidance analyst, Chris Allegro, said that after taking the advice of the consulting firm, Microsoft had only made a small, rather than a large, change to the original version, or feared it would end up failing again.

"also includes basic modules and tools," he says, "SQL SERVER2005 primarily on the engine, while Katamai focuses on operations." ”

Katamai also introduces the concept of an "Entity Framework" that allows administrators to stop accessing at the physical level, but from the entity level. For example, users are more likely to query a consumer or a product than to query physical storage. Today's users need to know where the data is stored and how to query it, Ajenstat said.

Katamai and Microsoft Office and SharePoint Associations

Katamai and Office have a deep connection with SharePoint, providing a lot of improvement in Word,sharepoint and excel in building reports. For example, the capabilities of multiple services such as reporting and analysis have reached the business intelligence architecture.

Some it vendors have started to use SQL Server's existing business intelligence (BI) and SharePoint as important workflow platforms. "Better business intelligence links are crucial to manipulating our business," says Jim Hill, a database manager at a company in Salt Lake City.

He added that many of today's companies use SharePoint, where employees can collect data as if they were a problem-solving center. The information assisted by the company determines the customer's buying pattern, helps to analyze whether the customer has a new round of purchase plans, etc., which enables the company to better perform its daily work.