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:

Anonymous said...

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

Anonymous said...

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

Anonymous said...

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

Anonymous said...

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.