SQL Server Tips: Windows Azure & Slow-Running Queries

It's important to keep up with ongoing database technology changes, innovations, and resources. In an effort to help you weed through the overwhelming amount of material found on the Internet and posted on social media, let's take a look at a couple of recent SQL Server resources for busy DBAs.

SQL Database

As you may have guessed, there are a number of challenges associated with deployments of data services in Windows Azure, particular on SQL Database. A transition from existing, on-premise SQL Server installations is likely to require changes to structure and content, primarily due to limitations inherent to cloud-based Platform as a Service (PaaS) counterparts. Learn methods for deployment and migration of locally stored data from Marcin Policht in Database Journal, Migrating SQL Server Database to Windows Azure - Deploying SQL Database.

Troubleshooting Techniques For SQL Server DBAs

It's no surprise that one of the most common problems when running SQL Servers is slow queries. If you're using SQL Server 2008 R2 through SQL Server 2014, you have the option of two different methods to identify the slowly running queries: SQL Server Extended Events and SQL Server Profiler.

Get help on how to identify and fix speed issues in multiple versions of SQL Server from Troubleshooting Slow Servers.

Related: Troubleshooting Slow Servers