Pages

▼

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.

at

6 comments:

  1. AnonymousMay 10, 2023 at 4:35 PM

    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

    ReplyDelete
  2. AnonymousMay 12, 2023 at 11:04 AM

    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

    ReplyDelete
  3. AnonymousMay 12, 2023 at 11:50 AM

    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

    ReplyDelete
  4. AnonymousMay 12, 2023 at 12:29 PM

    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

    ReplyDelete
  5. AnonymousMay 12, 2023 at 12:54 PM

    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

    ReplyDelete
  6. AnonymousMay 12, 2023 at 1:04 PM

    यहां 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 छा गया!

    ReplyDelete