Azure on Philippines

Understanding the Procedure Cache on SQL Azure

2010-07-28T15:00:51Z

Both SQL Server and SQL Azure have a procedure cache which is used to improve the performance of queries on the server. This blog post will talk about how the procedure cache works on SQL Azure. SQL Azure has a pool of memory that is used to store both Read More......(read more)

Improving Your I/O Performance

2010-07-27T16:22:29Z

As a DBA I have done a lot of work improving I/O performance for on-premise SQL Server installations. Usually it involves tweaking the storage system, balancing databases across RAID arrays, or expanding the count of files that the tempdb is using; these Read More......(read more)

Getting Started With Project Houston: Part 1

2010-07-26T14:55:40Z

Microsoft Project Code-Named “Houston” (Houston) is a light weight database management tool for SQL Azure. Houston can be used for basic database management tasks like authoring and executing queries, designing and editing a database schema, and editing Read More......(read more)

PowerPivot for the DBA: Part 3

2010-07-23T16:03:07Z

In this article I am going to continue to tie some simple terminology and methodology in business intelligence with Transact-SQL – bring it down to earth for the DBA. This is a continuation in a series of blog posts ( part 1 , part 2 ) that equates Transact Read More......(read more)

SQL Azure Supports Hierarchyid Data Type

2010-07-22T19:46:32Z

While this might seem like a non-announcement, the data type hierarchyid has just been added as a supported data type with SQL Azure Service Update 3, announced here . The hierarchyid data type is used to manage hierarchical data and tables that have Read More......(read more)

Real World Windows Azure: Interview with Johannes Schick, Chief Executive Officer, höltl Retail Solutions

2010-07-22T15:24:00Z

As part of the Real World Windows Azure series, we talked to Johannes Schick, CEO of höltl Retail Solutions, about using the Windows Azure platform to run the company's point-of-sale (POS) system. Here's what he had to say: MSDN: What service Read More......(read more)

CTP1 of Microsoft® Project Code-Named “Houston” now available

2010-07-21T13:18:00Z

At PDC ‘09, I showed a glimpse of a new Silverlight tool we were working on to allow you to develop and manage your SQL Azure databases. We showed updated versions of this at MIX’10 and TechEd North America 2010 and promised for a CTP this Read More......(read more)

New Windows Azure Service, The Archivist, Helps you Export, Archive and Analyze Tweets

2010-07-20T16:47:00Z

Ever wonder what happens to tweets after they disappear? Would you love a way to keep track of, analyze and even export tweets related to topics you care about? Enter The Archivist , a new lab/website from Mix Online built on Windows Azure that allows Read More......(read more)

Introduction to Open Data Protocol (OData) and SQL Azure

2010-07-20T15:18:55Z

The Open Data Protocol (OData) is an emerging standard for querying and updating data over the Web. OData is a REST-based protocol whose core focus is to maximize the interoperability between data services and clients that wish to access that data. It Read More......(read more)

Handling Transactions in SQL Azure

2010-07-19T15:15:18Z

In this article I am going to touch on some of the aspects of transaction handling in SQL Azure. Local Transactions SQL Azure supports local transactions. These types of transactions are done with the Transact-SQL commands BEGIN TRANSACTION , ROLLBACK Read More......(read more)

Windows Azure Architecture Guide – Part 1 Now Available

2010-07-19T04:43:00Z

As David Aiken recently mentioned on his blog , the Microsoft Patterns & Practices team has just released the Windows Azure Architecture Guide - Volume 1 . The first in a planned series about the Windows Azure platform, this book walks readers through Read More......(read more)

Video: Extending SQL Server Data to the Cloud using SQL Azure Data Sync

2010-07-16T22:04:51Z

In this first of a 3 part webcast series, Liam Cavanagh will show you how SQL Azure Data Sync enables on-premises SQL Server data to be easily shared with SQL Azure allowing you to extend your on-premises data to begin creating new cloud-based applications Read More......(read more)

Video: Using SQL Azure Data Sync Service to provide Geo-Replication of SQL Azure databases

2010-07-16T20:56:49Z

In this second of a 3 part webcast series, Liam Cavanagh introduces the Data Sync Service for SQL Azure. This service extends on the SQL Azure Data Sync tools’ ability to provide symmetry between SQL Server and SQL Azure where data changes at either Read More......(read more)

Video: New Business and Application Models with Microsoft SQL Azure

2010-07-16T18:04:00Z

SQL Azure enables businesses to increase profitability, realize new revenue streams and expand segment reach. In this video Sudhir Hasbe talks about how SQL Azure enables first mover advantage by reducing the time required for you to build and deploy Read More......(read more)

OCCMundial Named Second Most-Innovative Company with Windows Azure Solution

2010-07-16T16:53:59Z

InformationWeek Mexico just named OCCMundial as the second most innovative company in Mexico in its annual "50 Most Innovative Companies" issue. OCCMundial developed the largest job-listing website in the Mexican employment market and has more Read More......(read more)