MSSQL

  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” …

  It is a setting made on windows so that SQL Server can work with higher performance. This setting can be made on Windows Server …

  We mentioned the Contained Database in our article titled “How To Move Logins To Another Instance (sp_help_revlogin)“. A Contained Database is a type of …

  If you do not use a contained database, you must also move your logins when you move the database to another instance. You can …

  From the Security tab, right-click on Logins and click on new login. In the window that opens, we give a name to Login from …

  If you want to make a change in more than one session database at the same time, the control to prevent sessions from adversely …