Finding Blocking Queries in SQL Azure
[This article was contributed by the SQL Azure team.]Slow or long-running queries can contribute to excessive resource consumption and be the consequence of blocked queries; in other words poor…
Product category: Databases
Current Selections
Refine results
Latest posts
Showing 371 – 378 of 378 posts found
Improving Your I/O Performance
[This article was contributed by the SQL Azure team.]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…
Published • 4 min read
Introduction to Open Data Protocol (OData) and SQL Azure
[This article was contributed by the SQL Azure team.] 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…
Azure SQL Database, Databases, How to
Published • 2 min read
Adding Users to Your SQL Azure Database
[This article was contributed by the SQL Azure team.]When you generate a SQL Azure server via the SQL Azure portal, you generate a user name and password at the same time. This is your administrative…
Published • 3 min read
BCP and SQL Azure
[This article was contributed by the SQL Azure team.]BCP is a great way to locally backup your SQL Azure data, and by modifying your BCP based backup files you can import data into SQL Azure as well.…
Exporting Data from SQL Azure: Import/Export Wizard
[This article was contributed by the SQL Azure team.]In this blog post we will show you how to export data from your SQL Azure database to a local SQL Server database using the SQL Server Import and…
Uniqueidentifier and Clustered Indexes
[This article was contributed by the SQL Azure team.]I love GUIDs -- the uniqueidentifier data type in SQL Server. I use them for everything, domain names, unique error message, and for primary keys…
Azure SQL Database, Databases, How to
Published • 8 min read
SQL Azure Connectivity Troubleshooting Guide
[This article was contributed by the SQL Azure team.]This post was put together by one of our incredible support engineers, Abi Iyer, to help you to troubleshoot some of the common connectivity error…