Master database file or MDF file is a primary database file that contains fields, tables, indexes, stored procedures and other data in SQL Server. Like other data files, this file is also susceptible ...

This article describes how to set or change the database collation by using SQL Server Management Studio (SSMS) or [!INCLUDE tsql]. If no database collation is specified, the server collation is used.

This article will guide you through the installation and configuration stages of MySQL for your particular Operating System. What is a MySQL database? MySQL is a multi-user access database that stores ...

In the previous post in this series, I provided some T-SQL scripts that can check key settings and highlight possible issues you need to address. This post aims to provide some feedback and ...

Collation describes the code page, case sensitivity, accent sensitivity, and language or alphabet in use. This SQL Server tip illustrates how you can force the use of any specific collation. Collation ...