sql azure - sql saturday chicago

SQL Azure Aaron Stanley King

• Benefits of SQL Azure• Features of SQL Azure• Demos, Demos, Demos!• How to query in SQL Azure• More Demos!• Recent News• SQL Azure Future• Questions and Answers

Our Goals for Today

“SQL Azure is a scalable and cost-effective on-demand data storage and query processing service. SQL Azure is a hosted application build on robust Microsoft SQL Server database and Windows Server technologies.”

What is SQL Azure?

Azure™ Services Platform:

SQL Azure is your data hosted by Microsoft with a strong service level agreement (SLA). The SLA not only ensures high availability but also performance and protection.

What is SQL Azure really?

Benefits of SQL Azure

• SQL Azure is built on robust SQL Server database technologies.

• SQL Server is a broad data platform that can handle all types of data, from creation to archival.

Robust SQL Server Support

• SQL Azure facilitates development. • Just like local development in SQL Express. • Its flexible data model supports any

programming language.

Ease of Application Development

• The SQL Azure database fabric is flexible and scales according to business needs.

• The service is supported by multiple servers.

Scalability

• Therefore, it has the ability to provide any required storage capacity.

• Also, there is no time delay due to server provisioning. The data is partitionedto meet these requirements.

Scalability

• Because SQL Azure is accessible via the Internet, it ensures the availability of data to users in any geographic location.

• Further, SQL Azure uses enterprise-grade hardware and program code, which are optimized for high throughput.

Availability

• SQL Azure provides organizations with secure data access and confidentiality.

• It is built on a relational database architecture that includes data protection.

Security

• With SQL Azure, multiple copies of data that you create or modify are stored across geographically distributed data centers.

• This ensures the safety of your data in the event of any disaster.

Security

SQL Azure provides you with a strong SLA that assures:• high availability• guaranteed performance• data protection• compliance• enterprise-level security features• real-time mirrored database replication

Strong Service Level Agreement

• Robust SQL Server support• Ease of application development• Scalability• Availability• Security• Strong SLA

Benefits of SQL Azure

• Benefits of SQL Azure • Features of SQL Azure• Demos, Demos, Demos!• How to query in SQL Azure• More Demos!• Recent News• SQL Azure Future• Questions and Answers

Our Goals for Today

• SQL Azure provides UNLIMITED data storage capacity.

• SQL Azure uses a PAY-AS-YOU-GROW pricing strategy.

• SQL Azure has $0 start up cost.• SQL Azure can be located close to your

users, even if you’re not.

Features of SQL Azure

SQL Azure• Anytime from Any place• Failure of one server will not

impact performance• Unlimited amount of data

SQL Server• On-premise data platform• Single point of failure• Data is restricted by

software and hardware

SQL Azure vs. SQL Server


Our Goals for Today

• Demos, Demos, Demos!• How to query in SQL Azure• More Demos!

Demos, Demos, Demos!

• ‘ANSI_NULLS’ is not a recognized SET option.• Deprecated feature ‘SET ANSI_PADDING OFF’ is not

supported in this version of SQL Server.• Deprecated feature ‘More than two-part column name’ is

not supported in this version of SQL Server.• Deprecated feature ‘Data types: text ntext or image’ is not

supported in this version of SQL Server.• Deprecated feature ‘Table hint without WITH’ is not

supported in this version of SQL Server.• Filegroup reference and partitioning scheme’ is not

supported in this version of SQL Server• fn_listextendedproperty is not supported

Things to watch out for


Our Goals for Today

• Production Level App Fabric• 50 Gb SQL Azure coming in June!• SQL Labs, oData• MARS• Fix for migration process from a

database such as MySQL is the ability to support multiple active resultsets.

• DataTier Application Support

Recent News!

SQL Azure Future?

Database

Reference Data

Reporting

ETLData Mining

Data Sync


Our Goals for Today

• Aaron Stanley King• Twitter• @trendoid• #sqlsat31

• [email protected]• www.aaronstanleyking.com

Thank you for coming to SQL SaturdayAny questions?

DIGIOP Technologies develops software and hybrid digital recorders that manage

network-based surveillance video at sites ranging from a single location to a large enterprise.

DIGIOP solutions provide real-time and recorded,

video-enhanced business intelligence

for security, operations, marketing, merchandising,

and IT groups.

DIGIOP Difference

• Cost-effective Hybrid systems = Analog + IP Cameras

• Powerful, easy-to-use server and remote software

• Reliable Dell hardware with world-class support

• Expandable platform lets you “Grow As You Go”

• Interoperability with cameras and devices

Seamless Software Integration

with back-office systems and devices provides

powerful business intelligence

Video Analytics for Business Intelligence

People CountingDwell Time / LoiteringMarketing Information

Queue ManagementTraffic Patterns

www.digiop.com800.968.3606

Aaron Stanley King

Twitter: @trenoid

Email: [email protected]

Blog: www.aaronstanleyking.com

http://www.digiop.com/

http://www.digiop.com/

sql azure - sql saturday chicago

Technology

features of sql azure

sql azure future

sql azure aaron stanley

recent news