Pages

Monday, May 1, 2023

MS-SQL Server - Virtual Machine & Prerequisites for FC

Virtual Machine & Prerequisites for FC..


Azure VM.

https://azure.microsoft.com/en-us/products/virtual-machines/sql-server

LCK_M_RIn_U

HADR_SEEDING_LIMIT_BACKUPS

[.        |

[< >    |


Mathematical Function

           |

           |


Prerequisites for Failover Cluster


https://learn.microsoft.com/en-us/sql/sql-server/failover-clusters/install/before-installing-failover-clustering?view=sql-server-ver16


{

Microsoft Dynamics NAV, SQLTRACE_WAIT_ENTRIES & COALESCE


https://community.dynamics.com/blogs/post/?postid=8a1a2597-2382-43bb-aa0c-c6dfaf72fc22


SQLTRACE_WAIT_ENTRIES

Occurs while a SQL Trace event queue waits for packets to arrive on the queue.

}


Best Regards



T. Amit Vaid S.


3 comments:

  1. Daily backup, lag function, Expression lambdas
    SQL Server Error: Msg 8114, Level 16 error on Insert Statement
    https://learn.microsoft.com/en-us/answers/questions/153215/sql-server-error-msg-8114-level-16-error-on-insert

    Rule Engine
    https://learn.microsoft.com/en-us/biztalk/core/rule-engine

    Safe Mode
    https://learn.microsoft.com/en-us/sql/database-engine/configure-windows/start-sql-server-in-single-user-mode?view=sql-server-ver16

    Linked Server Permission
    https://learn.microsoft.com/en-us/answers/questions/312622/who-can-read-data-from-linked-server

    String LEN
    https://learn.microsoft.com/en-us/sql/t-sql/functions/len-transact-sql?view=sql-server-ver16

    ReplyDelete
  2. Visual Database Tools & High Availability

    https://learn.microsoft.com/en-us/sql/ssms/visual-db-tools/visual-database-tools?view=sql-server-ver16

    हम नए फीचर्स का सही समय पर लाभ उठाते रहते हैं, पर एरर लॉग में अगर मेजर चंक ऑफ लॉग सिर्फ logins का होगा तो समझ लीजिए की सिक्योरिटी रिलेटेड इश्यू है,

    कठौर DBA बनाती है हमें हमारी प्रैक्टिस और निरंतर परिश्रम से सही गंतव्य निर्धारित होगा!

    ReplyDelete
  3. Select * from sys.dm_hadr_availability_group_states;Gor

    SUM, AVG Functions, Destination & Coalesce

    https://learn.microsoft.com/en-us/sql/t-sql/functions/sum-transact-sql?view=sql-server-ver16

    https://learn.microsoft.com/en-us/sql/integration-services/data-flow/sql-server-destination?view=sql-server-ver16

    https://learn.microsoft.com/en-us/sql/t-sql/language-elements/coalesce-transact-sql?view=sql-server-ver16

    Visual Database Tools & High Availability, Port
    Named Instance vs Default Instance

    ReplyDelete