Wednesday, May 10, 2023

MS-SQL Server - विचार

विचार


सुनने में थोड़ा सा कन्फ्यूजिंग लगता है, जब हम Shield की बात करते है, तो सिर्फ Install Shield ध्यान में आता है, वैसे Database encryption भी एक प्रकार की shield ही होती है!

https://support.microsoft.com/en-us/topic/kb2820068-can-t-install-sql-server-by-using-installshield-or-bootstrapping-application-1fb621ed-926f-484d-36c1-589014ea2fa7

Decimal and Numeric

https://learn.microsoft.com/en-us/sql/t-sql/data-types/decimal-and-numeric-transact-sql?view=sql-server-ver16

Encryption
https://learn.microsoft.com/en-us/sql/relational-databases/security/encryption/sql-server-encryption?view=sql-server-ver16

Frequently asked questions, used terms and acronyms

https://learn.microsoft.com/en-us/troubleshoot/sql/releases/faq-acronyms

Additionally,

किसी भी बड़ी टेक्नोलॉजी ने जब खुद को मार्केट की requirements से थोड़ा मिलवाया तो तो नए customers का मौसम आया!


Overall Retry Attempts Requirement.

https://social.msdn.microsoft.com/Forums/sqlserver/en-US/b33d4321-8e36-4c7c-8635-2b2540a4148b/retry-attempts-in-sql-server-job-agent?forum=sqldatabaseengine


SQL Profiler is useful for Many Actions

- Performance Tuning

- Route Cause for specific error/issue

- Capture the Internal syntax

- To Find Specific user/client activity


DAC

https://learn.microsoft.com/en-us/sql/database-engine/configure-windows/diagnostic-connection-for-database-administrators?view=sql-server-ver16


सदा हो जय!


Best Regards


T. Amit Vaid S.

6 comments:

Anonymous said...

Change Subnet Mask in Windows 2012/SQL 2012 Always On Cluster

https://social.technet.microsoft.com/Forums/lync/en-US/049097c3-0abf-4d16-a402-685417fa1d75/change-subnet-mask-in-windows-2012sql-2012-always-on-cluster?forum=winserverClustering

Configure Database Mail

https://learn.microsoft.com/en-us/sql/relational-databases/database-mail/configure-database-mail?view=sql-server-ver16

Anonymous said...

RAM Configuration

https://learn.microsoft.com/en-us/sql/database-engine/configure-windows/server-memory-server-configuration-options?view=sql-server-ver16

Calculate total Man hours in SQL Server

https://learn.microsoft.com/en-us/answers/questions/977985/calculate-total-working-hours-in-sql-server

A log shipping configuration does not automatically fail over from the primary server to the secondary server.

https://learn.microsoft.com/en-us/sql/database-engine/log-shipping/about-log-shipping-sql-server?view=sql-server-ver16

Anonymous said...

How to Add Primary Key to Existing Table?

https://amit-sqldbasupport.blogspot.com/2022/12/sql-server-add-primary-key-to-existing.html?m=1

Anonymous said...

Tail-Log backups that have incomplete backup metadata

Tail log backups capture the tail of the log even if the database is offline, damaged, or missing data files.

https://learn.microsoft.com/en-us/sql/relational-databases/backup-restore/tail-log-backups-sql-server?view=sql-server-ver16

Anonymous said...

MSSQL Backup with Checksum

https://learn.microsoft.com/en-us/answers/questions/142643/mssql-backup-with-checksum

Purging and Archiving Tracking Data

https://learn.microsoft.com/en-us/biztalk/technical-guides/purging-and-archiving-tracking-data

Anonymous said...

यहां SQL Server का जहान!

Create Primary Keys

https://learn.microsoft.com/en-us/sql/relational-databases/tables/create-primary-keys?view=sql-server-ver16

नए features की बहार आई तो SQL Server छा गया!