SQL Server 2012 High Availability
The AlwaysOn Availability Groups feature is a high-availability and disaster-recovery solution that provides an enterprise-level alternative to database mirroring. Introduced in Microsoft SQL Server 2012, AlwaysOn Availability Groups maximizes the availability of a set of user databases for an enterprise. Deploying AlwaysOn Availability Groups involves creating and configuring one or more availability groups. Each availability group is a container for a discrete set of user databases, known as availability databases, that fail over together. An availability group can have multiple possible failover targets (secondary replicas). Moreover, you can configure secondary replicas to support read-only access to secondary databases and for performing backups on secondary databases.
SQL Server Extended Events
Extended events are the new way to collect as much or as little information as is necessary to troubleshoot or identify a performance problem. Extended events not only replace traces, but exceeds them! We’ll take a look at this new feature and how collecting performance data becomes much more robust!
PowerPivot
PowerPivot is a powerful data mashup and data exploration tool based on xVelocity in-memory technologies providing unmatched analytical performance to process billions of rows at the speed of thought. We’ll cover, at a high level, what PowerPivot provides for business intelligence strategy for your company.
Sound like a good agenda?
We thought so too! Seating is limited so please RSVP to: SMMUG@unifiedtechnologies.com