After creating XEvent sessions on Azure SQL Database, how do you find out target properties of these sessions? There are 2 easy ways – using SSMS User Interface or programmatically using T-SQL.
A good portion of Oregon SQL Server community is checking out Azure SQL Database. Read what kind of questions they ask and what you can learn from these questions.
My Azure SQL DB Monitoring and Performance Tuning slide deck from Oregon SQL Server User Group is available here.
Step-by-step guides with code samples on how to perform database backup to Azure Blob Storage with T-SQL in SQL Server 2012 SP1 CU2 / SQL Server 2014 and SQL Server 2016 using Credentials.
SQL Sentry Plan Explorer has a number of views available to help you understand the rich information stored within Execution Plan files. It also can provide you with additional details when you run Get Actual Plan on the query directly.
A #SQLCoop Review of Red Gate’s SQL Prompt for Clean and Tidy code, promoting readability, high comprehension and ease of navigation.