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:

Anonymous said...

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

Anonymous said...

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 बनाती है हमें हमारी प्रैक्टिस और निरंतर परिश्रम से सही गंतव्य निर्धारित होगा!

Amit Vaids Blog said...

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