SQL Server DB

Download SQL Server 2019 developer free edition (MSSQL)

Where to download the MS SQL Server 2019 developer free edition ? It’s the free edition and contains the full set of available features. It also provides a real option for evaluation for developments, tests, and proof of concepts. Nevertheless, it is not for use in a production environment. Indeed, SQL developers must install the DBMS tool locally to understand its architecture and operation.

SQL Server DB

Empty the SQL Server transaction log and fix error 9002

How to empty the SQL Server transaction log and fix the error 9002 ? Microsoft SQL Server database is slow, or the available disk space is getting abnormally small? To solve this problem, it is sometimes enough to empty the SQL Server transaction log and reduce the files in the SQL Server database. Often, during this operation, this message appears “The database transaction log

SQL Server DB

Delete SQL Server database with a script

How to delete a SQL Server database with a script? And delete all associated files? These files are the .mdf, .ndf, .ldf files and also the .bak backup files. Use the SQL Server Drop database command as below. With a check beforehand to avoid errors. It runs the command only if the SQL Server database exists on the given server and instance. Here are

SQL Server DB

Cannot drop the database because it is currently in use in Sql Server

How to avoid the SQL error Cannot drop the database because it is currently in use ? Also know as the 3702 SQL Server error. It is possible to manage SQL databases with scripts or via the various windows of SQL Server Management Studio. For example, you can simply delete a database with a SQL DROP DATABASE command. However, if there are active connections

SQL Server DB

Install a second instance of SQL Server

How to install a second instance of SQL Server ? During the first installation of SQL Server, there are two options. The first option is to install the default instance, the other option is to install an instance named SQL. To install another instance, follow the steps below and adapt according to the SQL Server configuration. How to add multiple additional instances with SQL

SQL Server DB

Create a database with SSMS

Tutorial to create a SQL Server database with SSMS. Use the SSMS software to create a new database without any script How to create a SQL Server database with SQL Server Management Studio also called SSMS ? In this tutorial, let us see how to add a new SQL Server database. Indeed, to start, it’s mandatory to create a SQL Server database to start

SQL Server DB

Create a SQL Server database with a script

In order to create a new SQL Server database with one script, just follow this article and especially the code snippet. To create a Microsoft database with a Transact-SQL script, use the CREATE DATABASE function as explained in this post. First, a database represents the main part of a Relational Database Management System. An RDBMS contains and runs databases. A database contains SQL objects

SQL Server DB

Display SQL Server detailed version with a query

How to display the SQL Server detailed version number with a simple SQL Server query? Using SQL Server Management Studio, to get the exact version of the SQL Server installation, it is possible by using simple T-SQL queries. For example, it is very helpful to know the exact version of SQL Server installed. Especially when working on security patches and upgrades. But also, when