Monthly Archives: January 2017

Find In-Memory table in a given database

Note: In Azure if we use premium database functions we can not downgrade those databases into standard pricing tier. We need to remove premium database features before downgrading to Standard tier. I had to create multiple database copies to reproduce … Continue reading

Posted in SQL, SQL Query, SQL Server, Uncategorized | Tagged , , , , , , , , , | Leave a comment

TSQL to find Databases, corresponding elastic pool names and DB edition – Azure

Note: User has no option to change the edition/Service tier of master database. This is expected to change based on the number of databases on a given Azure SQL Server. But Microsoft has the ability to change to address performance … Continue reading

Posted in SQL, SQL Server, Uncategorized | Tagged , , , | Leave a comment

Create SQL Script to restore Transaction logs

I was part of a Major incident this week and we had to restore days worth of transaction logs on multiple databases. Created SQL Query which generates the restore script

Posted in Script, SQL, SQL Query, SQL Server, Uncategorized | Tagged , , , , , , | Leave a comment

TSQL to find database count in each Elastic pool and its storage utilization – Azure

Posted in Azure, Script, SQL, SQL Server, Uncategorized | Tagged , , , , | Leave a comment

Find Drive size and free space using TSQL

Posted in SQL, SQL Query | Tagged , , , , | Leave a comment