Business Intelligence, MCT [email protected] • Intertech Employee since 2005 • Instructor of Microsoft SQL Server and .NET Programming • Mostly training, some consulting • Worked with SQL Server since v6.5 • ETL: DTS 2000, SSIS 2005 to current • Reporting: Access and SSRS 2005 to current • Cubes/Data Mining: SSAS 2005 to current • Azure: SQL databases, Web Role, Cloud Services, Azure Machine Learning
Avanade • Over 20 years of industry experience Worked for wide range of companies in Twin Cities Mostly new product development • Other interests Boy Scouts, Lions Club Cycling FRC Programming Mentor EV Owner 4/15/2016 4
Central, India – South, India – West GENERALLY AVAILABLE 6 new regions announced: Canada Central, Canada East, Germany Central, Germany North East, United Kingdom (2 – regions TBD)
by Azure IoT >500Million Users in Azure Active Directory 777Trillion Storage Transactions per day >1.5Million SQL Databases running on Azure >40% Revenue from Start-ups and ISVs Azure momentum
a service on the Windows Azure Platform Ideal for both simple and complex applications Enterprise-ready with automatic support for HA Designed to scale out elastically with demand Get started quickly Choose a plan Choose a billing option Provision servers Ready to get started? Let’s jump into development
in Azure Storage and geo-replicated Creates a side-by-side copy, non-disruptive Backups retention policy: 7, 14 or 35 days Automated export of logical backups for long-term backup protection Point-in-time restore - “oops recovery”
stand-by secondary Replicate to pre-paired Azure region Automatic data replication, asynchronous Opt-in via REST API, PowerShell or Azure Portal Microsoft-managed, RTO<24h, RPO<1 hr Standard geo-replication
readable secondaries Replicate to any Azure region Automatic data replication, asynchronous REST API, PowerShell or Azure Portal RTO<1h, RPO<5m, you choose when to failover Active geo-replication
views in the portal for at-a-glance insights Pre-defined Power View reports for deep visual analysis on Audit log data Audit logs reside in your Azure Storage account Available in Basic, Standard, and Premium Auditing
types: char, varchar, nchar, nvarchar, text, ntext, image, xml, varbinary(max), or FILESTREAM Handles high query volume Common use cases: Searching websites, product catalogs, news items and more Document management systems Any applications that need to provide search capabilities over data stored in a SQL Database Full-Text Search
XML Index - speed up access to elements and attributes CREATE PRIMARY XML INDEX XML_Order_Items ON Sales.Order (Items); Secondary XML Index – help resolve specific XQuery expressions rapidly XML Indexes
near-real time Diagnose blocked or long-running queries, resource bottlenecks, poor query plans, and more Help improve capacity planning Use familiar T-SQL language Dynamic Management Views (DMV)
mbenko
palkan
tammyeverts
codingconduct
kneath
aarron
geoffreycrofte
techseoconnect
cromwellryan
katarinadahlin
matthewcrist
reverentgeek
jakevdp
![Send me Feedback! http://bit.ly/bqtMDC13 www.benkoTIPS.com @mbenko [email protected]](https://files.speakerdeck.com/presentations/76a0d6d085c84f10bd32cdaab5145808/slide_4.jpg){kind=link}
