Introducing Windows Azure- P51:The cloud platform is getting more and more attractive to the computing world. Today, service-oriented architecture (SOA) and aspect-oriented programming (AOP) techniques are widely used in enterprise solutions. A question an IT management team or a software development team may ask is, what is the next trend going to be? Cloud computing seems to be the right answer. | CHAPTER 8 SQL AZURE TCP Provider error 0 - An established connection was aborted by the software in your host machine. Figure 8-7. The connection can be resumed by clicking the Change Connection button from SQL Management Studio if the connection has been interrupted Create a Data Table Using SQL Server Management Studio A custom table can be created in the SQL Azure cloud database by using SQL Server Management Studio in a way that is pretty similar to creating a database on a server running in an on-premises environment. One difference for example is that the USE statement is not supported when using SQL Azure since we have used New Query to connect to the specific database already. If you need to access a different database you can start a new query by clicking the New Query button. To find more guidelines and limitations to using SQL Azure see http en-us library . Run the script in Listing 8-1 to create a data table called UserTable. The results are shown in Figure 8-8. Listing 8-1. SQL Script Used to Create a Data Table in SQL Azure CREATE TABLE dbo . UserTable UserID int IDENTITY 1 1 NOT NULL PRIMARY KEY CLUSTERED Password nvarchar 100 NULL FirstName nvarchar 100 NOT NULL LastName nvarchar 100 NOT NULL Timestamp timestamp NOT NULL GO INSERT INTO UserTable Password FirstName LastName Values password Henry Li GO SELECT COUNT FROM UserTable SELECT FROM UserTable 248 CHAPTER 8 SQL AZURE 3 Results j Messages No column name UserID Password First Name Last Name Timestamp 1 I 1 password Henry Li k00000000002A25AB Figure 8-8. Query results from Listing 8-1 Simple Benchmark Testing Results Results of a simple benchmark test for SQL Azure access are shown in Table 8-1. The scripts for the test follow. It may satisfy your curiosity as to the performance of the database in the cloud I certainly was curious . Figure 8-9 shows the Internet access bandwidth used to get the results of Table 8-1. A free speedtesting tool Speakeasy .
