DBA Home Cleaning

  • Blogging about excited new Web Based Remote Desktop feature about to release.

    Excited as a DBA I know the pains of DBA when attempting to remote desktop “MSTSC” 🙂 (I know its all now old school) since 2016 MS is going to release web-based remote desktop which will be available side by side along with MSTSC. Here is the link for more information. https://cloudblogs.microsoft.com/enterprisemobility/2018/03/28/remote-desktop-web-client-public-preview/?MC=WinServer&MC=MSAzure&MC=SysMagSof&MC=Windows&MC=Virtual

  • Perfect Query for mailing about long running queries

    You need to change the Mail id and Mail Profie. DECLARE @subject AS varchar(100) = ‘Transaction longer than 60 seconds’ DECLARE @message AS varchar(130) = ‘All open transactions’ DECLARE @receivers AS varchar(100) = ‘Your mail id’ DECLARE @querytran AS varchar(MAX) = ‘SELECT b.session_id AS [Session ID], CAST(Db_name(a.database_id) AS VARCHAR(20)) AS [Database Name] c.command, Substring(st.TEXT, (…

  • SQL Error Log and Durability ,

    Hello There , Did you ever thought of durability of the SQL Error Log and Archived versions it keeps for analysis and diagnostics. In default SQL provides 6+1 archives i.e n+1 (n is always no of archives+1 is always existing one) so here is the caveat . For some this default works very well but…