SQL Server Performance

A good list of How-To topics on SQLAzure

Discussion in 'Other SQL Server Blogs around the Web' started by Anonymous, Sep 30, 2010.

  1. Anonymous New Member

    <SPAN class=Apple-style-span style="WORD-SPACING:0px;FONT:medium 'Times New Roman';TEXT-TRANSFORM:none;TEXT-INDENT:0px;WHITE-SPACE:normal;LETTER-SPACING:normal;BORDER-COLLAPSE:separate;-webkit-border-horizontal-spacing:0px;-webkit-border-vertical-spacing:0px;-webkit-text-decorations-in-effect:none;-webkit-text-size-adjust:auto;-webkit-text-stroke-width:0px;orphans:2;widows:2;"><SPAN class=Apple-style-span style="FONT-SIZE:13px;FONT-FAMILY:'Segoe UI', Verdana, Arial;TEXT-ALIGN:left;"><TABLE class="" style="WIDTH:1115px;BORDER-COLLAPSE:collapse;"><TR style="VERTICAL-ALIGN:top;"><TH class="" style="PADDING-RIGHT:4px;PADDING-LEFT:4px;FONT-WEIGHT:normal;FONT-SIZE:1.07em;PADDING-BOTTOM:4px;PADDING-TOP:4px;FONT-STYLE:normal;FONT-FAMILY:'Segoe UI', Verdana, Arial;HEIGHT:21px;TEXT-ALIGN:left;">Topic</TH><TH class="" style="PADDING-RIGHT:4px;PADDING-LEFT:4px;FONT-WEIGHT:normal;FONT-SIZE:1.07em;PADDING-BOTTOM:4px;PADDING-TOP:4px;FONT-STYLE:normal;FONT-FAMILY:'Segoe UI', Verdana, Arial;HEIGHT:21px;TEXT-ALIGN:left;">Description</TH></TR><TR style="VERTICAL-ALIGN:top;"><TD class="" style="PADDING-RIGHT:4px;PADDING-LEFT:4px;PADDING-BOTTOM:4px;MARGIN:1px;LINE-HEIGHT:18px;PADDING-TOP:4px;"><P><A style="TEXT-DECORATION:none;" href="http://msdn.microsoft.com/en-us/library/ee336282.aspx">Guidelines for Connecting to SQL Azure Database</A></P></TD><TD class="" style="PADDING-RIGHT:4px;PADDING-LEFT:4px;PADDING-BOTTOM:4px;MARGIN:1px;LINE-HEIGHT:18px;PADDING-TOP:4px;"><P>Provides a list of general considerations when connecting to SQL Azure.</P></TD></TR><TR style="VERTICAL-ALIGN:top;"><TD class="" style="PADDING-RIGHT:4px;PADDING-LEFT:4px;PADDING-BOTTOM:4px;MARGIN:1px;LINE-HEIGHT:18px;PADDING-TOP:4px;"><P><A style="TEXT-DECORATION:none;" href="http://msdn.microsoft.com/en-us/library/ee336280.aspx">How to: Connect to SQL Azure Using sqlcmd</A></P></TD><TD class="" style="PADDING-RIGHT:4px;PADDING-LEFT:4px;PADDING-BOTTOM:4px;MARGIN:1px;LINE-HEIGHT:18px;PADDING-TOP:4px;"><P>Demonstrates how to connect to SQL Azure by using the sqlcmd utility.</P></TD></TR><TR style="VERTICAL-ALIGN:top;"><TD class="" style="PADDING-RIGHT:4px;PADDING-LEFT:4px;PADDING-BOTTOM:4px;MARGIN:1px;LINE-HEIGHT:18px;PADDING-TOP:4px;"><P><A style="TEXT-DECORATION:none;" href="http://msdn.microsoft.com/en-us/library/ee336243.aspx">How to: Connect to SQL Azure Using ADO.NET</A></P></TD><TD class="" style="PADDING-RIGHT:4px;PADDING-LEFT:4px;PADDING-BOTTOM:4px;MARGIN:1px;LINE-HEIGHT:18px;PADDING-TOP:4px;"><P>Demonstrates how to develop an application on SQL Azure by using ADO.NET.</P></TD></TR><TR style="VERTICAL-ALIGN:top;"><TD class="" style="PADDING-RIGHT:4px;PADDING-LEFT:4px;PADDING-BOTTOM:4px;MARGIN:1px;LINE-HEIGHT:18px;PADDING-TOP:4px;"><P><A style="TEXT-DECORATION:none;" href="http://msdn.microsoft.com/en-us/library/ee621781.aspx">How to: Connect to SQL Azure Through ASP.NET</A></P></TD><TD class="" style="PADDING-RIGHT:4px;PADDING-LEFT:4px;PADDING-BOTTOM:4px;MARGIN:1px;LINE-HEIGHT:18px;PADDING-TOP:4px;"><P>Demonstrates how to connect to SQL Azure by using ASP.NET in a Windows Azure Web Role.</P></TD></TR><TR style="VERTICAL-ALIGN:top;"><TD class="" style="PADDING-RIGHT:4px;PADDING-LEFT:4px;PADDING-BOTTOM:4px;MARGIN:1px;LINE-HEIGHT:18px;PADDING-TOP:4px;"><P><A style="TEXT-DECORATION:none;" href="http://msdn.microsoft.com/en-us/library/ee621789.aspx">How to: Connect to SQL Azure Through WCF (ADO.NET) Data Services</A></P></TD><TD class="" style="PADDING-RIGHT:4px;PADDING-LEFT:4px;PADDING-BOTTOM:4px;MARGIN:1px;LINE-HEIGHT:18px;PADDING-TOP:4px;"><P>Demonstrates how to connect to SQL Azure through a data service.</P></TD></TR><TR style="VERTICAL-ALIGN:top;"><TD class="" style="PADDING-RIGHT:4px;PADDING-LEFT:4px;PADDING-BOTTOM:4px;MARGIN:1px;LINE-HEIGHT:18px;PADDING-TOP:4px;"><P><A style="TEXT-DECORATION:none;" href="http://msdn.microsoft.com/en-us/library/ff394110.aspx">How to: Connect to SQL Azure Using PHP</A></P></TD><TD class="" style="PADDING-RIGHT:4px;PADDING-LEFT:4px;PADDING-BOTTOM:4px;MARGIN:1px;LINE-HEIGHT:18px;PADDING-TOP:4px;"><P>Demonstrates how to connect to SQL Azure by using PHP in a Windows Azure CGI Web Role.</P></TD></TR><TR style="VERTICAL-ALIGN:top;"><TD class="" style="PADDING-RIGHT:4px;PADDING-LEFT:4px;PADDING-BOTTOM:4px;MARGIN:1px;LINE-HEIGHT:18px;PADDING-TOP:4px;"><P><A style="TEXT-DECORATION:none;" href="http://msdn.microsoft.com/en-us/library/ff951633.aspx">How to: Connect to SQL Azure Using the ADO.NET Entity Framework</A></P></TD><TD class="" style="PADDING-RIGHT:4px;PADDING-LEFT:4px;PADDING-BOTTOM:4px;MARGIN:1px;LINE-HEIGHT:18px;PADDING-TOP:4px;"><P>Demonstrates how to connect to SQL Azure by using the ADO.NET Entity Framework.</P></TD></TR></TABLE></SPAN></SPAN><P><SPAN class=Apple-style-span style="WORD-SPACING:0px;FONT:medium 'Times New Roman';TEXT-TRANSFORM:none;TEXT-INDENT:0px;WHITE-SPACE:normal;LETTER-SPACING:normal;BORDER-COLLAPSE:separate;-webkit-border-horizontal-spacing:0px;-webkit-border-vertical-spacing:0px;-webkit-text-decorations-in-effect:none;-webkit-text-size-adjust:auto;-webkit-text-stroke-width:0px;orphans:2;widows:2;"><SPAN class=Apple-style-span style="FONT-SIZE:13px;FONT-FAMILY:'Segoe UI', Verdana, Arial;TEXT-ALIGN:left;">In addition to the above the differences when developing applications using SQL Azure Database&nbsp;and SQL Server is usage of .NET Framework programming languages, which come with Visual Studio 2008 or later: Microsoft Visual Basic, Microsoft Visual C#, or Microsoft Visual C++. You can also use the&nbsp;ADO.NET data provider for SQL Server, the&nbsp;SQL Server 2008 Native Client ODBC driver, and the SQL Server 2008&nbsp;Driver for PHP version 1.1.&nbsp;In addition,&nbsp;SQL Azure allows you to use&nbsp;a subset of the Transact-SQL&nbsp;query language to query a database and to insert, update, and delete data in tables in a database.</SPAN></SPAN></P><P><SPAN class=Apple-style-span style="WORD-SPACING:0px;FONT:medium 'Times New Roman';TEXT-TRANSFORM:none;TEXT-INDENT:0px;WHITE-SPACE:normal;LETTER-SPACING:normal;BORDER-COLLAPSE:separate;-webkit-border-horizontal-spacing:0px;-webkit-border-vertical-spacing:0px;-webkit-text-decorations-in-effect:none;-webkit-text-size-adjust:auto;-webkit-text-stroke-width:0px;orphans:2;widows:2;"><SPAN class=Apple-style-span style="FONT-SIZE:13px;FONT-FAMILY:'Segoe UI', Verdana, Arial;TEXT-ALIGN:left;"><SPAN class=Apple-style-span style="WORD-SPACING:0px;FONT:medium 'Times New Roman';TEXT-TRANSFORM:none;TEXT-INDENT:0px;WHITE-SPACE:normal;LETTER-SPACING:normal;BORDER-COLLAPSE:separate;-webkit-border-horizontal-spacing:0px;-webkit-border-vertical-spacing:0px;-webkit-text-decorations-in-effect:none;-webkit-text-size-adjust:auto;-webkit-text-stroke-width:0px;orphans:2;widows:2;"><SPAN class=Apple-style-span style="FONT-SIZE:13px;FONT-FAMILY:'Segoe UI', Verdana, Arial;TEXT-ALIGN:left;"><TABLE class="" style="WIDTH:1115px;BORDER-COLLAPSE:collapse;"><TR style="VERTICAL-ALIGN:top;"><TH class="" style="PADDING-RIGHT:4px;PADDING-LEFT:4px;FONT-WEIGHT:normal;FONT-SIZE:1.07em;PADDING-BOTTOM:4px;PADDING-TOP:4px;FONT-STYLE:normal;FONT-FAMILY:'Segoe UI', Verdana, Arial;HEIGHT:21px;TEXT-ALIGN:left;">Topic</TH><TH class="" style="PADDING-RIGHT:4px;PADDING-LEFT:4px;FONT-WEIGHT:normal;FONT-SIZE:1.07em;PADDING-BOTTOM:4px;PADDING-TOP:4px;FONT-STYLE:normal;FONT-FAMILY:'Segoe UI', Verdana, Arial;HEIGHT:21px;TEXT-ALIGN:left;">Description</TH></TR><TR style="VERTICAL-ALIGN:top;"><TD class="" style="PADDING-RIGHT:4px;PADDING-LEFT:4px;PADDING-BOTTOM:4px;MARGIN:1px;LINE-HEIGHT:18px;PADDING-TOP:4px;"><P><A style="TEXT-DECORATION:none;" href="http://msdn.microsoft.com/en-us/library/ee730903.aspx">Development Considerations in SQL Azure</A></P></TD><TD class="" style="PADDING-RIGHT:4px;PADDING-LEFT:4px;PADDING-BOTTOM:4px;MARGIN:1px;LINE-HEIGHT:18px;PADDING-TOP:4px;"><P>Describes some general considerations and recommended coding practices when developing SQL Azure applications.</P></TD></TR><TR style="VERTICAL-ALIGN:top;"><TD class="" style="PADDING-RIGHT:4px;PADDING-LEFT:4px;PADDING-BOTTOM:4px;MARGIN:1px;LINE-HEIGHT:18px;PADDING-TOP:4px;"><P><A style="TEXT-DECORATION:none;" href="http://msdn.microsoft.com/en-us/library/ee336250.aspx">Transact-SQL Support (SQL Azure Database)</A></P></TD><TD class="" style="PADDING-RIGHT:4px;PADDING-LEFT:4px;PADDING-BOTTOM:4px;MARGIN:1px;LINE-HEIGHT:18px;PADDING-TOP:4px;"><P>Provides an overview of the Transact-SQL support in&nbsp;SQL Azure.</P></TD></TR><TR style="VERTICAL-ALIGN:top;"><TD class="" style="PADDING-RIGHT:4px;PADDING-LEFT:4px;PADDING-BOTTOM:4px;MARGIN:1px;LINE-HEIGHT:18px;PADDING-TOP:4px;"><P><A style="TEXT-DECORATION:none;" href="http://msdn.microsoft.com/en-us/library/ee621784.aspx">SQL Server Tools and Utilities Support (SQL Azure Database)</A></P></TD><TD class="" style="PADDING-RIGHT:4px;PADDING-LEFT:4px;PADDING-BOTTOM:4px;MARGIN:1px;LINE-HEIGHT:18px;PADDING-TOP:4px;"><P>Provides information about the supported SQL Server tools and utilities.&nbsp;</P></TD></TR></TABLE></SPAN></SPAN></SPAN></SPAN></P><img src="http://sqlserver-qa.net/aggbug.aspx?PostID=9612" width="1" height="1">

Share This Page