July 2010 - Posts

I Miss You SQL Server Agent: Part 1 by SQL Azure Team Blog

Currently, SQL Azure doesn’t support running SQL Server Agent in the cloud. If you need SQL Server Agent type functionality for SQL Azure, you can use a Windows Azure worker role and some custom code, I will show you how in this blog post series. “Secret...

Windows Azure AppFabric LABS August Release, Breaking Changes Announcement and Scheduled Maintenance by Windows Azure platform AppFabric Team Blog

The Windows Azure AppFabric LABS August release is expected to be released on August 5, 2010 (Thursday). Users will have NO access to the AppFabric LABS portal and services during the scheduled maintenance down time. When: START: August 5, 2010, 10am...

Real World Windows Azure: Interview with Arzeda Corp. by Windows Azure

As part of the Real World Windows Azure series, we talked to Alexandre Zanghellini, Cofounder at Arzeda, and Yih-En Andrew Ban, Project Leader and Scientist at Arzeda, about using the Windows Azure platform to power the company's compute-heavy enzyme...

Programmatically Changing the Firewall Settings by SQL Azure Team Blog

SQL Azure has two types of access control: SQL Authentication logins and passwords and a server side firewall that restricts access by IP address. This blog post will discuss how to programmatically modify the firewall settings. For information about...

Understanding the Procedure Cache on SQL Azure by SQL Azure Team Blog

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...

Improving Your I/O Performance by SQL Azure Team Blog

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...

Getting Started With Project Houston: Part 1 by SQL Azure Team Blog

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...

PowerPivot for the DBA: Part 3 by SQL Azure Team Blog

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...

SQL Azure Supports Hierarchyid Data Type by SQL Azure Team Blog

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...

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

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...

CTP1 of Microsoft® Project Code-Named “Houston” now available by SQL Azure Team Blog

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...

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

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...

Introduction to Open Data Protocol (OData) and SQL Azure by SQL Azure Team Blog

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...

Handling Transaction in SQL Azure by SQL Azure Team Blog

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...

Windows Azure Architecture Guide – Part 1 Now Available by Windows Azure

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...
More Posts Next page »
Powered by Community Server (Non-Commercial Edition), by Telligent Systems