अनदेखा
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.
9 comments:
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
Transaction Promotion
https://learn.microsoft.com/en-us/sql/relational-databases/clr-integration-data-access-transactions/transaction-promotion?view=sql-server-ver16
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
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
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.
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
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
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
[Oraphaned Users, Azure Managed Services, Business Intelligence, Log backup of database using cmd]
Post a Comment