Free E-Book on SQL Server 2012 available


If you want to check out the features and basic administration of SQL Server 2012, here is the link for a free E-Book.

The book is divided in two parts:
Part 1 – Database Administration
Part 2 – Business Intelligence Development

Here are some of the new features of SQL Server 2012 described in the e-book:

1. Microsoft’s first cloud-ready information platform
2. It works across a variety of devices and data sources, from desktops, phones, and tablets, to datacenters and both private and public clouds
3. There are over 250 new improvements associated with this release
4. Introduction of new capabilities like FileTables and statistical semantic search.
5. AlwaysOn Availability Groups – It protects databases and allows for multiple databases to fail over as a single unit.
6. Support for Windows Server Core – Installing SQL Server 2012 on Windows Server Core
is now supported. Windows Server Core is a scaled-down edition of the Windows operating
system and requires approximately 50 to 60 percent fewer reboots when patching servers.
7. Partition Support Increased To dramatically boost scalability and performance associated with large tables and data warehouses, SQL Server 2012 now supports up to 15,000 partitions per table by default (previous version of SQL Server was limited to 1000 partitions by default.)
8. Achieve Maximum Scalability with Windows Server 2008 R2. SQL Server 2012 can achieve maximum scalability when running on Windows Server 2008 R2 because it supports up to 256 logical processors and 2 terabytes of memory in a single operating system instance.
9. A new Insert Snippet menu. It offers developers a categorized list of snippets to choose from to streamline code.
10. Contained Databases – Users are authenticated directly into a user database
without the dependency of logins in the Database Engine. This feature facilitates better portability of user databases among servers because contained databases have no external dependencies.
11. Security Enhancements such as User-defined server roles for easier separation of duties; Audit enhancements to improve compliance and resiliency; Simplified security management, with a default schema for groups; Contained Database Authentication, which provides database authentication that uses self-contained access information without the need for server logins; SharePoint and Active Directory security models for higher data security in end-user reports.
12. It comes in three main editions; Each edition comes in a 32-bit and 64-bit version. The main editions are the following: Standard edition; Business Intelligence edition; Enterprise edition

List of errors of the e-book.

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s


%d bloggers like this: