Hoeist!? Blog of Colin Raaijmakers.

Hoeist!? Blog of Colin Raaijmakers.

Top 10 features of Microsoft SQL 2008 R2

Development

 

Microsoft SQL Server 2008 R2 is the latest release of SQL Server. This article will introduce the top 10 features and benefits of SQL Server 2008 R2.

Report Builder 3.0

Report Builder 3.0 is a report authoring environment for business users who prefer to work in the Microsoft Office environment.

SQL Server 2008 R2 Datacenter

Built on SQL Server Enterprise, SQL Server 2008 R2 Datacenter is designed to deliver a high-performing data platform that provides the highest levels of scalability for large application workloads, virtualization and consolidation, and management for an organization’s database infrastructure. Datacenter helps enable organizations to cost effectively scale their mission-critical environment.

SQL Server 2008 R2 Parallel Data Warehouse

Microsoft SQL Server 2008 R2 Parallel Data Warehouse (previously code named project "Madison") is a highly scalable appliance that delivers performance at low cost through a massively parallel processing (MPP).

StreamInsight

Data volumes are exploding with event data streaming from sources such as RFID, sensors and web logs across industries including manufacturing, financial services and utilities.  The size and frequency of the data make it challenging to store for data mining and analysis.  The ability to monitor, analyze and act on the data in motion provides significant opportunity to make more informed business decisions in near real-time.

Master Data Services

Master Data Services helps enterprises standardize the data people rely on to make critical business decisions. With Master Data Services, IT organizations can centrally manage critical data assets companywide and across diverse systems, enable more people to securely manage master data directly, and ensure the integrity of information over time.

PowerPivot for SharePoint

Microsoft SQL Server PowerPivot for SharePoint extends SharePoint 2010 and Excel Services to add server-side processing, collaboration, and document management support for the PowerPivot workbooks that you publish to SharePoint.

Data-Tier Application

A new single unit of deployment, Data-tier Application, packages database schema (database, tables, stored procedures, etc) with deployment requirements and can be extracted from existing applications or created in Microsoft Visual Studio®—accelerating deployments and upgrades.

Unicode Compression

Unicode compression in SQL Server 2008 R2 uses an implementation of the Standard Compression Scheme for Unicode (SCSU) algorithm to compress Unicode values that are stored in row or page compressed objects. For these compressed objects, Unicode compression is automatic for nchar(n) and nvarchar(n) columns. The SQL Server Database Engine stores Unicode data as 2 bytes, regardless of locale. This is known as UCS-2 encoding. For some locales, the implementation of SCSU compression in SQL Server 2008 R2 can save up to 50 percent in storage space.

SQL Server Utility

SQL Server customers have a requirement to manage their SQL Server environment as a whole, addressed in this release through the concept of application and multiserver management in the SQL Server Utility.

Multi Server Dashboards

Investments in application and multi-server management will help organizations proactively manage database environments efficiently at scale through centralized visibility into resource utilization and streamlined consolidation and upgrade initiatives across the application lifecycle—all with tools that make it fast and easy.

Read more on: http://www.databasejournal.com/features/mssql/article.php/3857466/Top-10-Features-of-SQL-2008-R2.htm
Read more on: http://cio.nl/internationaal-nieuws/20712/review-microsoft-sql-server-2008-r2.html

Read more about, Top 10 features of Microsoft SQL 2008 R2

Tags: microsoft, sql, 2008, r2, windows, features

Published: Monday, November 15, 2010

Remote Shutdown

Windows

Use the following command in your command prompt (Start, Run, Cmd) to reboot a remote computer.

shutdown /r /f /m \\[Remote_IP] /t 0 /d p:0:0 /c "Reboot"

Read more about, Remote Shutdown

Tags: windows, remote, shutdown

Published: Wednesday, April 01, 2009

Remote Desktop Windows Vista

Windows

Sometimes when connecting from Windows Vista to Windows Server 2003, the connections get lost.
Use the following command in your command prompt (Start, Run, Cmd) for better results.

netsh interface tcp set global autotuninglevel=disabled

Read more about, Remote Desktop Windows Vista

Tags: windows, rdp, remote, desktop, vista

Published: Wednesday, April 01, 2009