Step by step tutorial to create a SQL Server database using SSMS (SQL Server Management Studio). How to create a SQL Server database with SQL Server Management Studio, i.e. SSMS. In this tutorial, let’s learn how to add […]
SQL Server DBA
Tutorials on SQL Server Database Administration, or DBA, to manage databases, users and security. With examples of SQL Server scripts to create databases. And also modify, maintain and delete MS SQL databases. But also how to maintain database servers and instances.
Managing SQL Server databases with DBA tutorials
First of all, how do you create a SQL Server database? It is possible to create a database from a T-SQL script or from the SSMS GUI without writing SQL code.
How to fix the SQL Server error Cannot drop the database because it is currently in use? Also know as the 3702 error, the SQL Server error Cannot drop the database because it is currently in use is
How to download the Microsoft SQL Server 2019 developer edition for free? SQL Server 2019 developer is the free edition, and the download contains the full set of available features. It also provides a real option for evaluation
In any database system, is of utmost importance to properly manage SQL Server security. It is the cornerstone of protecting sensitive data and ensuring that only authorized personnel can access and modify it. In the context of SQL
How to create a new SQL Server user with SQL Server Management Studio (SSMS)? This SQL Server administration tutorial explains how to create a SQL Server user login with SSMS, used to connect to the databases of an
How to clear the SQL Server transaction log and fix the error 9002? It is time to clear the transaction log when a SQL Server database is slow, or the available disk space is getting abnormally small. Indeed,
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.
How to install a second instance of SQL Server? During the first installation of SQL Server, there are two options for the instances, te first option is to install the default instance, the other option is to install
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
Display the SQL Server version number with details using a query? Using SQL Server Management Studio, here is a query to display SQL Server exact version. It is possible by using simple T-SQL queries and stored procedures. For