MSSQL

  SQL Server re-creates tempdb on predefined folders each time sql server service starts. In the article “How To Move The Tempdb Database To Another …

  We use letters like C, D, E when defining disks on “Windows Server”. If the number of our disks increases, we may not be …

  I explained how to change the disks of a normal database in the article “How To Change The Disk Of Database Files On SQL …

  With SQL Server Startup Parameters, the location of certain files in the startup phase of the SQL Server service, and some conditions in the …

  Sometimes SQL Server becomes inaccessible and DBA cannot even intervene. In such cases, there is a back door so that DBAs can find and …

  SQL Server Configuration Manager is a tool in which many settings of SQL Server are made. In this article, I’ll refer to many of …

  Most DBA usually define the SQL Server Service Account as the Administrator on the server. Actually, this authority is not necessary. You must not …

  Sometimes we need to change Collation after we have done SQL Server Installation. I will do my warning from the beginning. After changing Collation, …

  To create Availability Group(AG) Fail-over SQL Server Cluster with secondary replica we need 4 machines/VMs which are as follows Domain Controller: Machine Name: DC 192.168.1.71 …

  The File Table uses the technology of File Stream. It keeps file system data as a table. That is, you can access the data …