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.

In my recent article I've reported about a nice free alternative to manage SQL databases, which, from the same UI can manage also MySQL databases. I thought that it might be a good idea to actually ...

-- 15.0.2070.41 GDR1 11/4/2019 https://support.microsoft.com/en-us/help/4517790/servicing-update-for-sql-server-2019-rtm -- 15.0.4003.23 CU1 1/7/2020 https://support ...

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 ...