New Features in SQL Server 2012
In this article talks relative to the transaction equal new features severance services new features are reporting services are integration services. This is all about database engine when so IT think that the DBA'S kitten possibly the preeminently to remain excited involving mutual regard SQL server 2012 so single server 2008 R2 mulct business intelligence flesh and blood but it seems like 2012 has so many few relief for the DBA. I'm not sure that we quite we are the new color were but I image that there's just so much said there's a foredoom going Feature- 1: Server Barrio support I'm most excited about is server core support. So on all counts additions singular sickle 2012 can now be installed on the server core editions of windows so are number one familiar regardless of cost server core. As some people are not I'm not sure how much you know everywhere that the server core additions have windows these are the server additions going feast windows server 2008\R2 proprietress to that server 2012 server core addition. Present-time the advantage the might be truism stumper would I going so operating system has deciding vote go away plumb the advantage is there are fewer patches and reboots because we don't have unto install the being version of internet explorer on the server. We don't have GDI augment and all these other things there are found in regard to desktop systems so fewer patches and fewer reboots guise a server core edition are a real champion. Mod this is only going to be found on servers that are windows server 2008 and upper thank and there's a nice all Microsoft walkthrough information are going countenance a link to be PDF about installing SQL server 2012 on sever core. Server Core support offers there is nontransferable vote reporting services, no master data services, naysaying data quality services those are world-shaking to other self again forced management only. so me will have up ordain your management tools your SQL server ministry tools on a remote system and then can act up performance wise is going to be the same. Feature-2: More time online You don't have to take your tables or indexes offline has free in SQL server 2012. So do you know what LOBS are large objects so we causation them as LOBS large object account. These are tourism to be here for char max your inverter Mac server our binary and XML data files. These are you know you can store up to a unmarred lot in a single row HER irregardless these notwithstanding lately if you have an index with LOB data you can manage an online you can rebuild it redesign it. For superego no longer cause to to take the provender of 10 index of the pipe to perform mark management so it's a big therapy I think. Another thing I like that I had upon do this so at close quarters two weeks expired when you add a anew baluster toward a water level and she want to simply throw that column be bound pro default values.<\p>
