Microsoft Built Security From The Bottom Up Sql Server

1610 Words7 Pages
Microsoft built security from the bottom up in SQL Server 2005 and has aged in database security in each new version ever snice. SQL Server 2012 continues the trend with cool new features, like new server level roles, new algorithms, and new permissions. It also adds databases that are contained, which allow the end users to connect to the database without providing permission at the server level. This is an excellent idea to solve problems when you move to databases, but it sounds terrifying from a security context. There are other new security add-ons, along with tricks and shortcuts to old features. There is nothing really new in this current release, just further constriction and familiarizing to the countless ways companies use the database server.
In this research paper, there are a couple of features to explore in SQL Server 2012. My dream is by the end of this paper you will have all you need to choose if your database will be protected in SQL Server 2012. Because of the security features in SQL server 2005 the 2012 SQL server was a required advancement, but there may be other reasons why a consumer might not want to change to a new server besides security.
There are new SQL Server 2012 security features that Microsoft has provided to their database application program. The research paper will cover the most important features, which can be drilled down into four categories:
• Security management features, this comprises of schema groups and user-defined server

More about Microsoft Built Security From The Bottom Up Sql Server

Get Access