Wednesday, May 24, 2023

MS-SQL Server - Joint Mentor

Joint Mentor


People often request for being a mentor. However, without being a part of any project and live support, it seems to be disconnected from latest technology. Hence I prefer to become a 'Joint Mentor' instead of Just Mentor.


Additionally,


IAM & PFS


https://techcommunity.microsoft.com/t5/sql-server-support-blog/sql-server-extents-pfs-gam-sgam-and-iam-and-related-corruptions/ba-p/1606011


Work with Directories and Paths in FileTables


https://learn.microsoft.com/en-us/sql/relational-databases/blob/work-with-directories-and-paths-in-filetables?view=sql-server-ver16


Building the connection URL


https://learn.microsoft.com/en-us/sql/connect/jdbc/building-the-connection-url?view=sql-server-ver16


Imp. Waittypes


HADR_TDS_LISTENER_SYNC_PROCESSING

PRINT_ROLLBACK_PROGRESS


Internal Use Only

COLUMNSTORE_COLUMNDATASET_SESSION_LIST

FABRIC_WAIT_FOR_BUILD_REPLICA_EVENT_PROCESSING

GLOBAL_TRAN_UCS_SESSION

FFT_NSO_FCB_RELEASE_CACHED_ENTRIES

FT_IFTS_CHUNK_BUFFER_PROTO_WORD_LIST

FT_IFTS_SHARED_MEMORY

FT_IFTS_CRAWL_BATCH_LIST



Doing Best Quality



T. Amit Vaid S.

2 comments:

Anonymous said...

Default Port
https://learn.microsoft.com/en-us/sql/database-engine/configure-windows/configure-a-server-to-listen-on-a-specific-tcp-port?view=sql-server-ver16

Shrink
https://learn.microsoft.com/en-us/sql/relational-databases/databases/shrink-a-database?view=sql-server-ver16

Anonymous said...

Generate T-SQL scripts from SQL Server command line tools
https://cloudblogs.microsoft.com/sqlserver/2017/05/17/try-new-sql-server-command-line-tools-to-generate-t-sql-scripts-and-monitor-dynamic-management-views/

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

Any query will be considered.


T. Amit Vaid S.