Pages

▼

Saturday, April 15, 2023

MS-SQL Server - अनदेखा (एक जुनून)

अनदेखा


May be Dream but story to learn


Over so many years One DBA has learned so many things उनके नाम ने SQL Server को प्रसिद्ध भी किया!


काम ढूंढने में पहले कई जतन किए! फरवरी में शुरुवात की पर काम मई में मिला, दो प्रोजेक्ट मिले पर ज्यादा व्यापार मिला सोलर के एक प्रोजेक्ट में जहां हर साल बिजनेस प्रमोशन होता था, वहां एक बार एक आदमी हस्ते हुए बोले it's humor पर DBA ने कहा The humor is also known as 'Huge Database and More Records', Which type of work you have? आदमी ने कहा बस यही बात है थोड़ा ठीक करवा देना फिर एक नई बिजनेस डील भी मिल गई!


छांव पर भी पड़ती सूरज की धूप!


Monitoring - There are tips, refer below article


https://amit-sqldbasupport.blogspot.com/2022/12/sql-server-monitor-keyboard-shortcuts.html?m=1


Broadcast


https://learn.microsoft.com/en-us/answers/questions/47319/microsoft-sql-browser-broadcast



Best Regards



T. Amit Vaid S.


at

9 comments:

  1. AnonymousApril 28, 2023 at 5:53 PM

    Also, Loop through table records and execute Stored Proc with row data as params in sql server

    https://learn.microsoft.com/en-us/answers/questions/847097/loop-through-table-records-and-execute-stored-proc

    ReplyDelete
  2. AnonymousApril 28, 2023 at 5:57 PM

    Transaction Promotion

    https://learn.microsoft.com/en-us/sql/relational-databases/clr-integration-data-access-transactions/transaction-promotion?view=sql-server-ver16

    ReplyDelete
  3. AnonymousApril 29, 2023 at 5:54 PM

    Automated Patching for SQL Server on Azure virtual machines

    https://learn.microsoft.com/en-us/azure/azure-sql/virtual-machines/windows/automated-patching?view=azuresql

    System catalog views

    https://learn.microsoft.com/en-us/sql/relational-databases/system-catalog-views/catalog-views-transact-sql?view=sql-server-ver16

    Waittypes

    LATCH_EX
    LCK_M_IX_ABORT_BLOCKERS
    BROKER_TRANSMITTER
    PWAIT_HADR_CHANGE_NOTIFIER_TERMINATION_SYNC
    QUERY_OPTIMIZER_PRINT_MUTEX

    ReplyDelete
  4. AnonymousMay 2, 2023 at 8:06 AM

    Purpose of having MaxDOP option.

    https://social.msdn.microsoft.com/Forums/en-US/589a9d5f-d219-474e-a8ca-ceccb6ef53f0/strategy-to-handle-more-than-150-tb-of-data-in-sql-server?forum=sqldatabaseengine

    ReplyDelete
  5. AnonymousMay 4, 2023 at 11:44 AM

    WaitTypes

    BROKER_CONNECTION_RECEIVE_TASK
    FS_GARBAGE_COLLECTOR_SHUTDOWN

    Internal Use only
    ASYNC_OP_COMPLETION
    COLUMNSTORE_COLUMNDATASET_SESSION_LIST
    CONNECTION_ENDPOINT_LOCK
    FABRIC_HADR_TRANSPORT_CONNECTION
    FABRIC_REPLICA_CONTROLLER_STATE_AND_CONFIG
    GLOBAL_QUERY_CANCEL
    SCAN_CHAR_HASH_ARRAY_INITIALIZATION
    CHECK_SCANNER_MUTEX

    Best Regards

    T. Amit Vaid S.

    ReplyDelete
  6. AnonymousMay 11, 2023 at 12:44 PM

    A PatIndex with Two Examples

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

    A. Simple PATINDEX example
    B. Using a pattern with PATINDEX

    Sum

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

    Database RESTORE HEADERONLY

    https://learn.microsoft.com/en-us/sql/t-sql/statements/restore-statements-headeronly-transact-sql?view=sql-server-ver16

    ReplyDelete
  7. AnonymousMay 11, 2023 at 12:57 PM

    Critical Event IDs

    https://social.technet.microsoft.com/Forums/en-US/3400f9f7-7ff9-4527-a4cf-97ea49f6453a/critical-event-ids-to-monitor-sql-servers?forum=winservergen

    ReplyDelete
  8. AnonymousMay 14, 2023 at 11:40 AM

    Introducing App deployment in SQL Server Big Data Clusters

    https://learn.microsoft.com/en-us/sql/big-data-cluster/concept-application-deployment?view=sql-server-ver15

    ReplyDelete
  9. AnonymousSeptember 24, 2023 at 6:46 PM

    [Oraphaned Users, Azure Managed Services, Business Intelligence, Log backup of database using cmd]

    ReplyDelete