Microsoft SQL Server 2008 Enterprise Features
Microsoft SQL Server 2008 Enterprise makes it easier to bring your data together, to analyze it, and to report it. At the same time, it improves compression to provide your server with more free space, keeps your resources in check, and opens up new kinds of data and new ways to approach data. All of that, and it has new administrative abilities and much more.
Data Warehousing—Using a new tool called Data Collections, you can gather, organize, and analyze data on your SQL Server. Data Collection doesn’t just gather data either, it also purges old data, making sure you are only working with the data you need. Data Collection comes with report templates for the warehoused data analysis.
Upgraded reporting abilities—Report Builder gets a redesign and new templates are included in Visual Studio and Business Intelligence Development Studio. You have new graphs and charts, new gauges: all the reporting tools you need to present your data attractively and informatively.
Easier to perform important analysis—Cube and Dimension wizards will now autosuggestion dimensions and hierarchies, all while they take fewer clicks to build your cube.
Backup Compression—Disk space is always an important factor in running a server. You need as much of it as possible reserved for new data. Backup Compression aids in that goal by compressing backups as they are written. This can lead to faster processing, as well as more space.
Table and Index Compression—Backups aren’t the only data that receive new compression abilities in Microsoft SQL Server 2008 Enterprise, tables and indexes can now also be compressed. Table compression includes row and page compression. This process can save up to 40-60% of the space previously being used for the table.
Resource Governor—Running powerful SQL programs that provide new business insights requires a lot of processing power. To make sure no program uses up too much of your server’s resources, the Resource Governor can allow you to set limits on CPU and memory usage. This allows the system to continue functioning smoothly even when you are running resource-heavy programs.
Policy-Based Management—Gain more control over every instance on your server by setting new policies with Policy Management. This gives you more control through setting conditions on facets like: Credentials, Data Files, Databases, Indexes, Logins, Names, Schema, Servers, Tables, Users, and Views. These conditions decide what is appropriate for all of the above facets.
Geographic Information System—For the first time, Microsoft SQL Server includes Geographic Information System abilities. This allows for geometry and geographic data to be used on the server, which in turns, makes it possible to work with geographic locations, maps, and geographic artifacts.
Time and Date Data Types—Previous editions required that the date and time be stored together. While this was necessary in some cases, it wasn’t always. Now, with Microsoft SQL Server 2008 Enterprise, you can store either the date or the time separately. There’s also a more precise DATETIME2 available. This precision to within 100 nanoseconds and can be stored to 7 digits, although you can decide to store fewer. Another very useful inclusion for international businesses is DATETIMEOFFSET which stores dates and times that are time zone aware.
FILESTREAM—With FILESTREAM, you can store unstructured data like documents and images on the server. This allows you to back up that data, so it can easily be restored should the need arise. You can also control the security for that data by limited the access to it. While FILESTREAM is included in Microsoft SQL Server 2008 Enterprise, it is not automatically turned out. It must be enabled, but when done, it is a powerful tool.
Transparent Data Encryption—Make sure your data is encrypted when you need it to be with Transparent Data Encryption. This makes sure your data is encrypted at rest. If you detach your database, it remains encrypted. Your backups also remain encrypted. However, the data in use is not encrypted and can be accessed.
Changed Data Capture—Changed Data Capture, when enables, makes it possible to keep track of every change made to a database. Every change is recorded in a table. This allows you to track the whole history of the database. Updates split the change table so that one keeps the record of the old changes, while the other has the old changes and those after the update.