I needed to come up with an estimated cost to store 120TB of data in Azure Blob Storage. Most objects will never need to be retrieved. Few of the objects will be retrieved once or twice a year. It made sense to put these objects in archive access tier instead of hot or cold access […]
This is a session about new features in SQL Server Management Studio and runtime data exposed via showplan. Microsoft’s goal is to make showplan, one stop shop for query performance troubleshooting. I presented the session to following user groups and events. Rhode Island SQL Server User Group on February 07, 2018 PASS DBA Virtual Chapter on […]
I thank Adam Machanic (b|t) for hosting TSQL Tuesday #100. Topic for this month is Looking Forward 100 Months. I also want to acknowledge Adam’s vision behind this project. I learned a lot from some of the #TSQL Tuesday’s and participated in few. Since I saw the invitation from Adam Machanic about TSQL Tuesday #100 , it took me […]
On February 15, 2018, SQL Server Management Studio 17.5 was released. A new feature called “Data Discovery & Classification” was launched with this release. You can read about this feature in the following posts. SQL Data Discovery and Classification What’s new in SSMS 17.5: Data Discovery and Classification Since this feature was released a common question was […]
This is a session about Azure Automation service and how you can perform some of SQL Agent functionality against Azure SQL Database using runbook. I presented the session to following user groups and events. PASS DBA Virtual Chapter (Asia Pacific Region) on November 15, 2017 PASS DBA Virtual Chapter on February 28, 2018 Boston Azure DataFest […]
