Pages

Tuesday, May 9, 2023

MS-SQL Server - More Records

More Records


टेघड़ी, मतलब टेराबाइट को समझाने की घड़ी आ चुकी है, under some circumstances we don't automate purging/archiving by which, in result, database keeps on growing, T-SQL या फिर PowerShell Gallery के मॉड्यूल की मदद से ये संभव हो सकता है, जिन्हे सालों तक archive logs की जरूरत है, वो टेराबाइट usage के निम्न संखित customers होते हैं, ये बात समझने के बाद मैंने कहा की अब SQL Server ही लूंगा!


Again and again I repeat, a great compliment is achieved when people observe benefit.


Additionally,


Introducing data virtualization with PolyBase


https://learn.microsoft.com/en-us/sql/relational-databases/polybase/polybase-guide?view=sql-server-ver16


SQL Server में है सबका मन!


Best Regards



T. Amit Vaid S.

4 comments:

  1. Backup History

    https://learn.microsoft.com/en-us/sql/relational-databases/backup-restore/backup-history-and-header-information-sql-server?view=sql-server-ver16

    Manclute Practical

    https://amit-sqldbasupport.blogspot.com/2023/04/ms-sql-server-manclute-practical.html?m=1

    Top

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

    ReplyDelete
  2. Database Engine events and errors (0 to 999)

    https://learn.microsoft.com/en-us/sql/relational-databases/errors-events/database-engine-events-and-errors-0-to-999?view=sql-server-ver16

    ReplyDelete
  3. SQL Server 2008 R2 is not supported on Windows 10 or Windows Server 2016.

    SQL Server 2008 is not supported on Windows 10 or Windows Server 2016.

    https://learn.microsoft.com/en-us/troubleshoot/sql/general/use-sql-server-in-windows

    ReplyDelete
  4. Netstat Usage
    https://learn.microsoft.com/en-us/windows-server/administration/windows-commands/netstat

    Other Topics
    Database Purity By running CheckDB

    Pricing / Charges
    https://www.microsoft.com/en-in/sql-server/sql-server-2019-pricing

    https://learn.microsoft.com/en-us/sql/connect/jdbc/download-microsoft-jdbc-driver-for-sql-server?view=sql-server-ver16
    When you download the driver, there are multiple JAR files. The name of the JAR file indicates the version of Java that it supports.

    ReplyDelete