Business Intelligence Features in Microsoft SQL Server 2008
The following BI tools are available in SQL Server version 2008 with a client access license
SSAS in SQL Server 2008
The SQL Server Analysis Services form the foundation for a meaningful analysis and fast processing of all business-relevant data. With the PowerPivot for Excel 2010 add-in, large amounts of data can be imported and analyzed directly from the data warehouse and then presented clearly according to the relevant aspects using Online Analytical Processing (OLAP). PowerPivot can be used to search for fields by name and named quantities as well as to search for relationships between tables that are not linked to each other. PowerPivot analyses can be made available to other employees in the SharePoint Document Libraries as reports.
The proven, well-known SQL Server Integration Services also provide the three important elements for Business Intelligence applications in the SQL 2008 version: In addition to analysis, these are also integration and reporting, which together form the prerequisite for all ETL processes - for this purpose, users with a CAL have a broad portfolio of tools for data warehousing at their disposal.
The SQL Server Reporting Services have been enhanced with a number of new features: Text fields can now be rotated up to 270 degrees, and page breaks are now allowed in tablix data and groups.
Master Data Services is a new tool in SQL Server 2008 that allows data to be centrally managed and at the same time securely delivered to various applications, including sensitive customer and account information required for transactions.
The Service Broker for SQL Server 2008 offers users with a CAL optimized options for distributing server loads across multiple databases. It also provides new queuing capabilities, making communication between different databases easier.
StreamInsight in SQL Server 2008 provides real-time control and processing of continuous data streams. StreamInsight is supported by CEP (Complex-Event-Processing) technology, which is mainly used in online commerce for processing credit card information, but also in logistics and network monitoring.
Report Builder V3.0
The new Report Builder V3.0 tool for SQL Server 2008 R2 optimizes the updated display of reports and graphics during editing, which has been enhanced with new data types in the geoinformation systems. Via SharePoint, individual areas can now also be published as web content.
The Microsoft Licensing Model with CALs for SQL Server 2008
In addition to the option of licensing SQL Server 2008 based on the number of physical and virtual processors used in an operating system environment, certain editions, such as SQL Standard, offer the alternative of first purchasing a separate server license to install the SQL software and then adding an appropriate number of client access licenses that entitle employees to use the SQL Services and the data they manage.
With a SQL Server 2008 CAL you can access the following editions of SQL Server 2008 (incl. previous versions): Standard, Enterprise, SBS, these are also available as server licenses from Wiresoft at a reasonable price.
License SQL Server 2008 very economically with the combination of server license plus client access licenses
The CAL licensing model for SQL Server 2008 offers an economic advantage, especially for companies and institutions with fewer employees accessing server data and services. This is because licensing per processor only offers an advantage with a larger number of clients, as there is no upper limit. With SQL CALs, however, you only purchase the exact number of individual licenses that you actually need in your organization. With Wiresoft you can adapt or extend your CALs needs at a reasonable price. Thus you avoid unnecessary costs caused by unused licenses and your employees are always correctly licensed. At the same time you profit with the Standard from the essential functions of SQL Server 2008.
Server/CAL Licensing for SQL Server 2008 - Step by Step
Before you decide to purchase either type of license for SQL Server 2008, you should be aware of your actual corporate client access license needs. This is because it is not possible to subsequently switch between the two license models "Per Processor" and "Server/CAL".
If you have decided on the often cheaper option of licensing server plus CALs, you should note that in this case the company server is licensed separately from the users who are to access it. Although the server license also contains two CALs, these only entitle administrators to manage the license server or to perform typical IT tasks. However, they do not allow employees to use the installed SQL Services. To do so, they need the CALs already mentioned, which are available as Device CAL or User CAL.
A SQL CAL is also required if the SQL server is not accessed directly but acts as a database for other server applications, such as SharePoint Server or Office Project Server.
User CAL and Device CAL for SQL Server 2008 differences
Client access licenses are - as briefly mentioned above - available in two types: as User CAL, which authorizes exactly one employee to access the SQL Server, and as Device CAL, which licenses exactly one Windows end device. Strictly speaking, the Microsoft licensing model regards these two as different licensing forms, even if they allow identical SQL Server functions to be used. Please note the following:
- A User CAL cannot be used as a Device CAL after the license has been issued - and vice versa.
- It is also not possible to transfer (license) the license assigned to a user or a terminal device to another user or terminal device - exception:
- You can switch from a Device CAL to a User CAL (or vice versa) if the SQL license comes with Software Assurance, and then only at the time of renewal of Software Assurance (or Volume License Agreement).
- A user or device CAL can only be used to access the company server. It does not entitle the user to log on to another company's server.
- It is possible to combine Device CALs and User CALs and thus use both client access licenses in parallel in one environment.
Below is a brief description of the respective advantages of user and device access licenses.
User CAL for SQL Server 2008
The Standard User CAL allows exactly one defined user to access SQL Server 2008 Services and the data managed there. Access can be made via any Windows end device, in addition to the conventional desktop PC or laptop, for example, also via tablet or mobile phone. The User CAL thus includes the possibility that access to the SQL Server is not locally bound and can therefore also be made from outside the server location in the company - e.g. in the home office or on the road. The User CAL therefore offers advantages for those employees who either do not use a fixed workstation or often use different end devices.
Device CAL for SQL Server 2008
The Standard Device CAL licenses a single device to use the SQL Server services. The only requirement is that the end device must be Windows and have Internet access. Thus, not only a desktop computer can be licensed with the Device CAL, but also a notebook or tablet or smartphone. Every employee in a company who is authorized to use this licensed device can thus access SQL Server 2008. Licensing with a Device CAL is particularly practical if a suitably equipped workstation is used alternately by different employees, as is common practice in shift work or for certain projects, for example.
Your licensing with Standards CALs for Microsoft SQL Server 2008 at Wiresoft
No matter if you want to supplement or cover your license requirements for SQL Server 2008 with CALs - Wiresoft offers you the corresponding SQL Device CALs as well as User CALs as particularly favorable single licenses. The advantage of buying a license from Wiresoft is a lower price compared to new CALs - with the same range of functions - and at the same time you acquire original Microsoft access licenses, which come from European companies and are 100 usable.
All CALs available in the Wiresoft Shop were checked by us before the sale exactly on authenticity, so that you as a customer have the certainty to acquire a fully operational software product with the license purchase. Because according to a judgement of the European Court of Justice it is legally allowed to buy and resell software products as well as licenses for server versions of Microsoft.
The license offer of Wiresoft enables you a particularly economic licensing: Instead of license packages you only buy exactly the number of client access licenses that you really need for your company to use SQL Server 2008. You can trust our expert advice, which is already used by many of our previous customers. If you have any questions about your customized licensing for SQL Server, simply contact us by email or phone, or chat with us.