110 likes | 251 Views
SQL Server Code Name “Denali”-2012. Atdhe Buja , BA MCTS SQL Server 2008, MCITP Database Administrator 2008, OCA Oracle 11g Administration atdhe.buja@hotmail.com http://atdhebuja.wordpress.com/. Business Requirements Constantly Growing.
E N D
SQL Server Code Name “Denali”-2012 AtdheBuja, BAMCTS SQL Server 2008, MCITP Database Administrator 2008, OCA Oracle 11g Administrationatdhe.buja@hotmail.comhttp://atdhebuja.wordpress.com/
Business Requirements Constantly Growing “The End of the Database as We Know It – noDISK, noSQL, Cloudy”, Donald Feinberg, Gartner IT Symposium, October 2010
Mission Critical Confidence • MISSION CRITICAL CONFIDENCE • SQL SERVER AlwaysOn • Availability Groups • Failover Cluster Instances • Active Secondaries
Project “Apollo” • Full-Text Search performance – NEAR operator & languages Czech, Greek • Table Partitioning up to 15,000 10x query performance with project “Apollo”
Audit support across editions • SQL Audit for all editions • User-defined Audit • Audit Filtering • Audit Resilience • Default Schema for Windows Groups • User-defined server roles for better separation of duties • Contained database authentication • SharePoint & Active Directory integration for secure
Rapid data exploration with project“Crescent” & Power Pivot • Reporting services project “Crescent” • interaction;web; exploration of data; visual appearance • Power Pivot – DAX (Data Analysis Expressions) • Rendering to Microsoft Office Word & Excel Open XML formats
Credible, Consistent Data Master Data Services - MDS Data Quality Services - DQS Integration Services - SSIS
Cloud on Your Terms • SQL Server Developer Tools Code Name “Juneau” • Data-tier Application Component (DAC) Framework & parity with SQL Azure • Power Shell 2.0
Extend any data, anywhere • (beyond relational) • FileTable • Full Globe Spatial support • Greater interoperability and support for web app
Concluzion • Denali is a significant product that helps customers to continue to build andsupport critical cases, now with more confidence and very high efficiency. Newtools and improvements enable significant progress at all levels within theorganization and technology for symmetry cloud server applications across private and public cloud computing helps customers stay agile for the future.