View Event: Azure SQL Database – Where is my SQL Agent? You migrate your on-premise 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: 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 the Execution Plan.Do you know that now you can see how many pages are spilled to disk for a […]
SQL Server Management Studio (SSMS) was released on April 7th, 2020. You can download this latest version from this link. 18.5 is an update to 18.4 with these new items and bug fixes. One of the features added in this release is to select ‘Azure Data Studio‘ Notebook as a destination for Generate Scripts wizard. […]
Over some time, SQL Server Management Studio has expanded memory grant information. Memory grant provides memory grant estimate as well as actual runtime memory grant information. In this blog post, I will explain each element of ‘Memory Grant Info’, so we can get a better understanding of what those numbers mean? I am using this […]
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 […]
On May 26th @MarshaPierceDBA is showing us how to deploy SQL Server on containers. Should be a great session. It would... be great to see some #SQLFamily in attendance. Hope to virtually see you then! https://bit.ly/2Ks9zWg
