MSSQL

  As a high-level security measure in SQL Server, if you do not want application developers to know the application’s user password, this article will …

  If all the indexes in the partition table are not aligned according to the partition, you will get an error like the following during …

  Introduction A service broker is a high availibity technique in SQL Server which was introduced from SQL Server 2005. This is primarily to send …

  I explained how to create a partition int the article named “How To Create Partition On SQL Server“. In this article I will share …

  We can not take the backup of the database and transfer it to the test environment for security reasons. Because the actual data should …

  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 …