Feature of SQL SERVER 2008
Interoperability In many cases, SQL Server data must be available to applications outside of your Microsoft Windows infrastructure. With the strong presence of mainframe systems, UNIX and Linux environments, Java platforms, etc., data interoperability requirements may be extensive.
Performance often means different things to different people. To the end user, it is typically about how fast they can get their data. For an administrator, the primary concern is maximizing overall throughput. These are often conflicting goals, and the database system must be able to balance them.
Security The integrity of your data is only as good as your ability to secure it, but security These days goes beyond the typical authentication/authorization issues of the past. We must Also be able to manage encryption processes, backup security, etc., while at the same time Being proactive to prevent the security exposures of tomorrow.
High Availability What good is having the data if it is not available to the people who need it when they need it? A good enterprise framework must ensure that we have adequate Redundancy and the means to minimize downtime. Every second that the data system is not available can mean lost revenue, and in some cases, legal repercussions.
Automation The more complex and larger a system becomes, the more important it is to be able to automate routine tasks and proactive maintenance to ensure that data availability and Integrity is maintained. Otherwise, the typical database administrator (DBA) will be completely Overwhelmed with day to day maintenance.
Centralized Reporting Storing data isn’t much use if you can’t get data out when you need it in the formats that you need. A number of reporting environments are available. Whichever one you use, it is essential that the reporting tier be efficient, be flexible, and have the lowest possible footprint in terms of resource consumption. SQL Server 2008 is available in a number of different versions. The primary distributions are the Standard and Enterprise editions. Additionally, Microsoft has release four specialized editions of SQL Server, namely Workgroup, Web, Compact, Developer, and Express. Each has its advantages and disadvantages. Because the Compact version specifically targets embedded systems, we will not discuss it here. All of the following editions come in 32-bit and 64-bit versions, although only Enterprise and Developer versions support IA64.
SQL Server Express Edition
Intended for embeddable, lightweight, and •u standalone solutions
• Supports one CPU
• 1GB maximum addressable memory
• 4GB maximum database size
• Free download and distribution
SQL Server Workgroup Edition
• Intended for small user loads, low-use web applications, etc.
• Supports two CPUs
• 4GB maximum addressable memory on 64-bit. OS Maximum on 32-bit
• No maximum database size
• Intended for larger traffic web applications
• Supports four CPUs
• OS maximum memory support
Intended for most applications
• Supports four CPUs
• Memory up to OS maximum
• Provides the highest level of scalability and enterprise features
• Unlimited CPUs to OS maximum
• Memory up to OS maximum
• Numerous enterprise features not found in the Standard Edition such as:
• Database mirroring
• Database snapshots
• Online indexing
• Online page restores
• Distributed partitioned views
• Numerous business intelligence (BI) features not found in the Standard Edition, such as:
• Scale-out report servers
• Infinite click-through reports
• Text mining
• OLAP dimension and cell write back
• Functionally equivalent to Enterprise Edition
• Licensed only for development environments, not to be used in production
Choosing the right edition is important. It needs to satisfy your current needs as well as your Projected ones. You need to make sure that your database will support your performance and Scalability requirements. You must also consider database size and the need for enterprise data and BI features. A few specific features are worth mentioning. These are the big ones. Not all of them will fit into your enterprise plan, but some may, and the fact that they all are bundled with SQL Server can be incredibly convenient and cost-effective.
Support for Unstructured Data For the average database administrator (DBA), there are two kinds of data: the data in the database (structured data) and everything else (unstructured data). Unfortunately, most organizations have a significant amount of unstructured data that they must manage ranging from documents to pictures to proprietary data. Through FILESTREAM data, large binary data streams can be stored in the file system without sacrificing the transactional integrity of the database system.
Policy-Based Management Policies make it easier to enforce best practices and standards. You can configure policies such as naming conventions, configuration standards, and coding standards. You can enforce these centrally for the entire organization. Not only does this simplify enforcement of standards, it also allows central modification of policies as needed.
SQL Server Integration Services (SSIS) SQL Server Integration Services (SSIS) provide exchange/transform/load (ETL) unctionality for SQL Server 2008.
SQL Server Reporting Services (SSRS) Although not a new feature, this is, in our opinion, one of the most important enterprise features that SQL Server provides. The tight integration with SQL Server and the exposure of the reporting engine through a standard web services interface make Reporting Services one of the most compelling reporting solutions available for SQL Server 2008. Enterprise features such as web report distribution, subscriptions, and infinite click-through make this ne feature you should definitely evaluate for inclusion in your enterprise data architecture.
Full-Text Search Services Full-text indexing and special query syntax let you effectively search large text blocks for patterns, word forms, proximities, and other elements. SQL Server 2008 provides some compelling enhancements to the full-text set of services. They include features such as improved full-text index management and performance enhancements.
Business Intelligence Business Intelligence (BI) content is critical to the success of SQL Server 2008. The BI agenda for SQL Server 2008 was very aggressive. One of the reasons that the schedule slipped for SQL Server 2008 was that the BI features needed a bit more polishing. The cornerstone of this version’s BI functionality is SQL Server Analysis Services. Supporting data warehousing through multidimensional data models (data cubes). Analysis Services provides mechanisms for analyzing and mining the large data volumes that most organizations have collected over the years. It is also highly integrated with other services, relying on SSIS for warehouse loading and SSRS for reporting on multidimensional data, including ad hoc reporting through the report builder.