MSSQL

  SQL Server 2017 is supported on Red Hat Enterprise Linux (RHEL), SUSE Linux Enterprise Server (SLES), and Ubuntu. It is also supported as a …

  For Always on Perrequisite Refer Document Prerequisite For AlwaysOn Basic Availability Groups in SQL Server 2016 in Standard Edition OR SQL Server Mirroring in …

  We explained how to get the create script of all objects belonging to the database in the article titled “How To Get Script of …

  I mentioned that we can not get the script of the partitioned tables by right clicking on the SSMS and using the Script To …

  Partition is the process of dividing tables and indexes into parts. For example, I have a table with a size of 1 TB. And …

  AlwaysOn Basic Availability Groups provide a high availability solution for SQL Server 2016 Standard Edition. This new functionality will replace database mirroring, which is a …

  In this article I will explain some information about SQL Server System databases. System databases are created automatically when you install SQL Server. The …

  In some cases, there may not be enough space on the disks where the database files are located. For this reason, you may need …

General Concepts: First of all, the database has two files by default. These are data file with mdf extension (called Primary Data File) and transaction …

When designing a database, it is necessary to analyze the disk requirement correctly and determine the size of the disks from the beginning. Sometimes things …