19 February 2022
How to completely uninstall SQL Server
This article will show you how to uninstall SQL Server completely. Follow the steps in this article, you also need to prepare the system to be able to reinstall SQL Server.
SQL Server
13 July 2021
How to Import Data from Script File into SQL Server
How to Import Data from Script file into MySQL Server? Detailed instructions on how to import data from SQL Server Management Studio (SSMS)
27 May 2021
Basic operations with Database in Microsoft SQL Server
Some basic operations with SQL Server database management system through the SQL Server Management Studio interface tool that you should understand.
25 May 2021
Steps to install Microsoft SQL Server on Windows 10
Instructions on how to install Microsoft SQL Server on Windows 10, a database management system from Microsoft. Install SQL Server and SSMS is a GUI tool to support SQL Server
25 May 2021
How to make a connection to SQL Server through SSMS
How to make connection to SQL Server through SSMS (SQL Server Management Studio)? The simplest way to create a connection to SQL Server via SSMS...
01 April 2021
How Does Virtualization Work with SQL Server & What Are The Benefits?
Virtualization has been used for years by organizations looking to liberate their software resources from the bonds of specific hardware devices and instead embrace a more flexible
25 February 2021
Instructions on how to connect to MySQL Server in IntelliJ
How to connect MySQL Server in IntelliJ? Detailed instructions on how to connect to MySQL Server in IntelliJ, it is time to quit MySQL Workbench
09 November 2020
What's new in SQL Server Management Studio 18.7?
The SQL Server Management Studio (SSMS) 18.7 release is available for download now. Today, we will be sharing some updates from the release and what's happening in SQL Server
25 May 2019
DAY function in SQL Server
The DAY function in SQL Server returns an integer that is the day of the month (from 1 to 31) from the time passed.
25 May 2019
GETDATE function in SQL Server
GETDATE function in SQL Server returns the current date of the system.
25 May 2019
GETUTCDATE function in SQL Server
This article will show you in detail how to use datetime GETUTCDATE () function in SQL Server with specific syntax and examples to better visualize and capture functions.
25 May 2019
MONTH function in SQL Server
This article will show you in detail how to use the datetime MONTH () processing function in SQL Server with specific syntax and examples to better visualize and capture functions.
25 May 2019
SQL Server YEAR function
SQL Server's YEAR function returns a 4-digit integer that is the year value in the timestamp passed.
25 May 2019
CAST function in SQL Server
The CAST function in SQL Server converts an expression from one data type to another.
25 May 2019
CONVERT function in SQL Server
The CONVERT function in SQL Server allows you to convert an expression to any desired data type but can follow a certain format (especially for the date data type).
25 May 2019
TRY_CAST function in SQL Server
The article will show you in detail how to use the TRY_CAST data type conversion function in SQL Server with specific syntax and examples to better visualize and capture functions.
25 May 2019
TRY_CONVERT function in SQL Server
This article will show you in detail how to use the TRY_CONVERT data type conversion function in SQL Server with specific syntax and examples to better visualize and capture
25 May 2019
Check version information in SQL Server
This article will show you in detail how to use the @@ VERSION query to check the information that SQL Server version is using.
25 May 2019
CASE statement in SQL Server
This article will show you in detail how to use the CASE statement handling function in SQL Server with specific syntax and examples to better visualize and capture functions.
25 May 2019
COALESCE statement in SQL Server
The COALESCE statement returns the expression with the first non-NULL value among the passed expressions.