itcamp 2011 - cristian lefter - sql server code-name denali
DESCRIPTION
TRANSCRIPT
@itcampro / #itcampro Premium conference on Microsoft’s Dev and ITPro technologies
SQL Server code-name "Denali"
Cristian Lefter
SQL Server MVP
http://sqlserver.ro
@itcampro / #itcampro Premium conference on Microsoft’s Dev and ITPro technologies
IT Camp 2011
• Thanks for coming!
• ITCamp is made possible by our sponsors:
@itcampro / #itcampro Premium conference on Microsoft’s Dev and ITPro technologies
Agenda
• Trends in the world of databases
• Microsoft answers and directions
@itcampro / #itcampro Premium conference on Microsoft’s Dev and ITPro technologies
Trends in the world of database
• NOSQL
• Column oriented databases
• Streaming information
• Cloud
@itcampro / #itcampro Premium conference on Microsoft’s Dev and ITPro technologies
NoSQL
• Things have changed
• The estimated volume of digital data 1.2 zettabytes (ZB) (1 ZB is approximately 1,000,000,000 TB)
• Key-Value Stores, Document Databases, and Graph Databases
@itcampro / #itcampro Premium conference on Microsoft’s Dev and ITPro technologies
Why NoSQL
• Let’s take Twitter for example
• In 2010 Twitter users generate 12 TB of data daily = 4PB per year
• 12 TB is approximately 9 million 3 ½ floppy disks = 9 million 3 ½ floppy disks is more than 800 km
@itcampro / #itcampro Premium conference on Microsoft’s Dev and ITPro technologies
Why NoSQL cont.
If I want to write 12TB of data at a rate of 100MB/s
… it will take more than 35 h > 24 h
@itcampro / #itcampro Premium conference on Microsoft’s Dev and ITPro technologies
NoSQL proposal
• Solution: distributed key/value stores that provide unlimited scalability to store data
• Open-source projects: Hadoop, Voldemort, Cassandra, CouchDB, Dynomite, MongoDB
• Proprietary cloud based data stores: Google App Engine 's Datastore, Amazon SimpleDBForce, Windows Azure Storage Services, Force.com Database Services.
@itcampro / #itcampro Premium conference on Microsoft’s Dev and ITPro technologies
NoSQL related
http://research.microsoft.com/projects/trinity/
@itcampro / #itcampro Premium conference on Microsoft’s Dev and ITPro technologies
Microsoft answers and directions
• Azure platform
• VertiPAQ
• StreamInsight
• AlwaysOn
• Contained Databases
@itcampro / #itcampro Premium conference on Microsoft’s Dev and ITPro technologies
AlwaysOn
• SQL Server AlwaysOn is a HADR solution
@itcampro / #itcampro Premium conference on Microsoft’s Dev and ITPro technologies
AlwaysOn – feature accountability
• Instance level / database level availability • Failover a set of databases • Multiple secondaries • Synchronous / Asynchronous • Auto / Manual failover • Flexible failover policy • Configuration wizard • Dashboard • Diagnostics
@itcampro / #itcampro Premium conference on Microsoft’s Dev and ITPro technologies
o Multi-database failover
o Multiple secondaries
o Total of 4 secondaries
o 2 synchronous secondaries
o 1 automatic failover pair
o Synchronous and asynchronous data movement
o Built in compression and encryption
o Automatic and manual failover
o Flexible failover policy
o Application failover using virtual name
o Configuration Wizard
o Dashboard
o System Center Integration
o Rich diagnostic infrastructure
o File-stream replication
Flexible
o Active Secondary
o Readable Secondary
o Backup from Secondary
o Automation using power-shell
AlwaysOn – feature accountability (cont.)
@itcampro / #itcampro Premium conference on Microsoft’s Dev and ITPro technologies
AlwaysOn – concepts
• Availability group – a set of user databases that can fail over as a single unit
• Availability replicas – set of failover partners • Primary replica - maintains the primary copy
of each database (allows read/write access) • For each primary database, a secondary
replica - maintains a failover copy of the database known as a secondary database
• AlwaysOn Failover Cluster Instance - provides protection for the entire instance
@itcampro / #itcampro Premium conference on Microsoft’s Dev and ITPro technologies
AlwaysOn Failover Cluster Instance
Adds the following to the SQL Server Failover Clustering capabilities:
• Multi-site clustering across subnets
• Flexible failover policy for better control
• Improved diagnostics
• tempdb on local drive for better query performance
@itcampro / #itcampro Premium conference on Microsoft’s Dev and ITPro technologies
AlwaysOn in CTP1
• Failover a group of databases • Add a single secondary using the asynchronous availability mode • Force failover to the asynchronous secondary • Suspend and resume data movement • Enable the secondary for read and execute read query on the
secondary • Create a virtual name for the availability group and have
application connect using the virtual name • Configuring availability group using Transact-SQL, AlwaysOn
wizard, Powershell • Troubleshoot using DMVs, Performance Monitor Counters and
Extended events • Create a multi-site cluster across subnets • Enable flexible failover policy • Improved diagnostics
@itcampro / #itcampro Premium conference on Microsoft’s Dev and ITPro technologies
Vertipaq
• PowerPivot
• Storage mode for Analysis Services
• Columnstore index
@itcampro / #itcampro Premium conference on Microsoft’s Dev and ITPro technologies
Vertipaq row store vs. column store
@itcampro / #itcampro Premium conference on Microsoft’s Dev and ITPro technologies
Denali - features list
• AlwaysOn • Windows Server Core support • Query performance - Project “Apollo” (column store
index) • Project “Crescent” & PowerPivot • BI Semantic Model • Data Quality Services • Scale on demand from devices to datacenter to cloud • Project “Juneau” - Write applications once, run
anywhere with • Online operations include reindexing of LOB columns
and addition of non-null columns
@itcampro / #itcampro Premium conference on Microsoft’s Dev and ITPro technologies
Last but not least
The good news: IT changes from cost center to a profit(revenue) center!
@itcampro / #itcampro Premium conference on Microsoft’s Dev and ITPro technologies
THANK YOU!
@itcampro / #itcampro Premium conference on Microsoft’s Dev and ITPro technologies
Don’t forget!
Get your free Azure pass!
• 30+15 days, no CC req’d
– http://bit.ly/ITCAMP11
– Promo code: ITCAMP11
We want your feedback!
• Win a WP7 smartphone
– Fill in your feedback forms
– Raffle: end of the day