Being able to boost
the performance of your systems is important if you want your organization to
stay competitive. You will notice a lot of significant updates in SQL Server Standard 2012. Some of the
editions also contain notable changes and they are offered as distinct
licensing models. SQL Server 2012 gives performance a boost along with BI and
upgrades in development.
Here are some of the most significant features of SQL Server 2012
1.
Server Core Support
Windows Server Core
can give you the infrastructure apps that you need which will enable you to
gain back-end services. You do not need a graphical user interface on the
server per se. Moreover, Windows Server Core provides a more efficient
installation and stronger security. This also reduces the need to perform
patching.
2.
DQS
Data Quality Services
allows users to ascertain that their databases have very precise and accurate
data. This is achieved by data cleansing care of the DQS and the modification
or removal of incorrect data. DQS in SQL 2012 also provides intelligent data
analysis when it culls information from different sources.
3.
T-SQL Updates
SQL 2012 provides
enhancements in the T-SQL. These include sequence support, and a new operator
that does TRY_CONVERT when it comes to converting data. This also serves the
OFFSET and SET very well in order to page data. Data formatting is made even
easier because of the new FORMAT() and there is a THROW operator that goes with
Server 2012’s windowing functions.
4.
Databases
The databases in SQL
Server 2012 are very well contained. This makes it easy if you need to deploy
new ones and to migrate databases within different Server instances. So if
someone is utilizing a contained database, that person would not need log in
information for that particular instance of SQL Server. This is because the
authentications are found within the database itself. The absence of
configuration dependencies is also an added feature of the contained databases.
5.
The Columnar Index
The primary function
of this is to support the warehousing of data. This feature includes the high
performance and high compression tech that PowerPivot has and applies it to the
relational database of SQL Server 2012. These indexes store data in a column
fashion and query results are project as needed. This dramatically improves
query performance.
These are just some of
the most notable changes in download SQL Server Standard 2012.