Category Archives: SQL Server

Search SQL Error Logs using TSQL – xp_readerrorlog

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

Using Idera to investigate a problem during specific time

I had a situation to troubleshoot a performance problem on a server which occurred a few days back. Following is quick reference on how Idera can be used to drill down details. 1. Select History Icon and select the time … Continue reading

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

All Databases without geo-replica on Azure Server

Query to find all Azure database without geo-replica configured.

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

SQL database and backup size of all databases on a server

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

TSQL – Restore database,store filelistonly, restore on litespeed server

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

TSQL to find size of all databases on a Server – Azure

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

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