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

In today’s competitive job market, securing a role in database management is difficult. SQL (Structured Query Language) remains a fundamental skill for database administrators, software developers, ...

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

If you’re looking for a simple-to-use web-based GUI for administering your relational MySQL databases and then some, Adminer may be what you’re looking for. If you’re creating a web application using ...

Download SSMS 17.6 and review the Release Notes to get started. SSMS 17.6 provides support for almost all feature areas on SQL Server 2008 through the latest SQL Server 2017, which is now generally ...

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