Slated for release on March 7, 2012 Microsoft SQL Server 2012 is presenting some completely new features. Probably the most significant changes to Microsoft’s database keeper will probably be the delivery of three separate editions. The easiest edition is known as, very fittingly, the conventional Edition. That one is helpful which are more fundamental analytical tasks. The following most feature wealthy edition may be the Business Intelligence edition, containing all of the features from the Standard with a few additional BI functionality. The Enterprise edition, which obviously includes all of the tools from the first couple of but additionally with a few spectacular features for big-scale applications, would be the best from the three. Another big area of the changes range from the elimination the SQL Server 2008 Data center edition the majority of its functionality continues to be packaged along with the very best-level Enterprise edition. Across the same lines, Microsoft can change the licensing structure in one according to processors to 1 according to cores.
With data visualization increasingly important to the prosperity of BI solutions, Microsoft has upped its game with a brand new feature known as Power View. Replacing Report Builder, Power View offers an interactive reporting atmosphere that’s available to more exploration and visualization of information. This is an improvement upon the present business intelligence tools, strengthening the self-service reporting functions. Also new in SQL 2012 is really a feature that can bring the most popular PowerPivot functionality from Stand out in to the business intelligence development studio: Analysis Service Tabular. This selection will have a similar options as with PowerPivot, together with additional abilities like partitioning, incremental updates, and role based security.
Prior to the actual software programs are released in March, developers are able to get hold of the brand new features for testing and training purposes at this time. Within the training package, offered at Microsoft.com Microsoft offers pre-configured presentations for instructors and people to understand more about additional features, which there are lots of greater than the narrow your search written above. You will find hands-on labs to enhance the presentations and demos from the additional features. The labs include HTML or Word scripts, an addiction checker to make certain your servers and knowledge atmosphere are outfitted using the proper software to function SQL 2012. If you’re missing something, there’s an installer to obtain the program needed for the greatest from the demo. Videos to describe the brand new features and the way to operate them match transcripts to help those learn and educate team people. Try the demos and instructional documents to ensure that once the real factor finally causes it to be towards the market, both you and your team are in front of the curve. You’ll anticipate to dig in and deliver leading edge methods to customers small and big.
Are you a business intelligence (BI) professional in need to design solution? Come and be a part of the Microsoft SQL server 2012 course offered by Comat where you learn the basics of dimensional modeling and watch yourself prosper in your career.