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.
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 …
Cannot drop the database because it is currently in use SQL Server Error Read More »
How to download the Microsoft SQL Server 2019 developer edition for free? SQL Server 2019 developer is the free edition, …
How to download the SQL Server 2019 developer edition for free? Read More »
In any database system, is of utmost importance to properly manage SQL Server security. It is the cornerstone of protecting …
Tutorial to create a SQL Server database with SSMS (SQL Server Management Studio). How to create a SQL Server database …
How to create a new SQL Server user with SQL Server Management Studio (SSMS)? This SQL Server administration tutorial explains …
Create SQL Server user with SSMS and set up access rights Read More »
How to clear the SQL Server transaction log and fix the error 9002? It is time to clear the transaction …
Clear the SQL Server transaction log and fix the 9002 error Read More »
How to delete a SQL Server database with a script? And delete all associated files? These files are the .mdf, …
How to install a second instance of SQL Server? During the first installation of SQL Server, there are two options …
In order to create a new SQL Server database with one script, just follow this article and especially the code …
Display the SQL Server version number with details using a query? Using SQL Server Management Studio, here is a query …
