View Event: New features in Management Studio — Performance Troubleshooting made easier! SQL Server Management Studio (SSMS) is now updated each month with the latest version of the SQL Client Tools. Which enabled rapid enhancement to Execution Plan. Do you know that you can now see how many pages are spilled to disk for a […]
Accessing runtime information of a query execution plan is vital to get a precise understanding of resource usage, execution patterns to resolve performance issues. Runtime statistics is beneficial while debugging query performance issues, such as long-running queries, and queries that run indefinitely and never finishes. Historically query completion was a prerequisite for the availability of […]
I thank Elizabeth Noble (blog|twitter) for hosting T-SQL Tuesday #123. The topic for this month is Automate Your Stress Away. I also want to acknowledge Adam Machanic’s vision behind this project. I learned a lot from some of the #TSQL Tuesday’s and participated in a few. Thank you, Steve Jones (blog|twitter), for coordinating this program. If you […]
View Event: Azure SQL Database – Where is my SQL Agent? You migrate your on-premises SQL Database to cloud, taking advantage of the PaaS offering of Azure SQL Database. You heard the promise of spinning up databases on demand and being able to scale up resources during high peak and scale down when not in […]
View Event: Kusto Query Language Kusto is a service for storing and running interactive analytics over Big Data. Kusto was designed from scratch to be a “big data” repository for Azure and easy to query using Kusto Query Language (KQL). As we make progress in our migration to the cloud, we are learning new ways to […]
