MSSQLTREK

I’m in the process of exploring all new cool features and enhancements of DENALI.  Thought of sharing the MSDN Library URL which explains all the NEW features of Denali at one Single Place.Please do follow the link http://msdn.microsoft.com/en-us/library/bb510411%28v=sql.110%29.aspx Have Fun! Happy Testing Denali:)

Custom Server Roles! Yes, this is a brand new enhancement Microsoft has provided in SQL Denali. Upto SQL Server 2008R2, We only had flexibility for creating Custom Database Roles. But the Server roles were fixed, which comes along with your installation. So, Let’s peak on how to create a custom Server Role…

Contained Database : A Brand new interesting feature introduced by Microsoft in SQL Server Denali(2011). let’s get straight to the point. Simple and straightforward use of contained Database(s) – Let’s say you’ve multiple applications sharing the same SQL Instance and you’ve multiple Jobs,Linked Servers, Logins for respective Databases. consider the scenario,…