MSSQL

  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 …

  Full-text Search used to search for columns with large text, such as varchar (max). You can do the same with LIKE, but LIKE will …

  The File Stream structure keeps the BLOB objects (document, image, video, etc.) integrated with the database on the NTFS File system on the server. …

In this article, we will install SQL Server 2014. Other versions can be installed in similar ways. Stand-Alone means installing only one instance on a …

  In SQL Server, sometimes you do not want anyone to see the contents of an important column in an important table. In such a …

You may want to move a database containing “File Stream” data to another disk with the detach attach method. Moving a database containing “File Stream” …