The SQL Server MERGE statement is an incredibly useful tool for carrying out DML operations based on comparing two tables or two data sets. Usage of this statement is actually like performing multiple operations in a single statement.
This article will explore three use cases that border on ensuring data between an online table and a history table in sync.
Read MoreWhen we install the SQL Server, it also installs the following services:
In this article, we are going to learn the following methods to manage SQL Server services:
Let us examine all these methods.
Read MoreSQL Server 2019 was introduced in November 2019. The RTM version of SQL Server 2019 is 15.0.2000.5. To learn about the new features presented in this version, you may refer to SQL Server 2019 New Features.
The current article briefly explains the process of SQL Server 2019 installation on Windows Server 2016.
Read MoreThis article aims to share the basics of SQL Server Management Studio, commonly known as SSMS, and some useful tips on working with it. Also, it highlights the importance of SSMS as database development and administration tool.
It is always good to clarify the SSMS definition(s) first. Let’s review some of the definitions from the database perspective.
Read MoreAn SQL Server database contains primary data files, secondary data files (optional), and transaction log files.
The primary and secondary datafiles contain tables, database objects, schema, and data.
The file extension of the primary database file is *.mdf, and the file extension of the secondary data file is *.ndf.
The transaction log files store all the changes made by the transactions (insert, update, and delete). If the SQL Server restarts unexpectedly or crashes, the database engine rolls the incomplete transaction back before the point of failure using the Transaction log file.
The extension of the transaction log file is *.ldf. You might want to refer to this article to understand the Transaction Log Files architecture.
In this article, I am going to explain how we can manage the database files (MDF files) in SQL Server 2019.
Read MoreThe first time Karl heard of SQL Server CTE was when he was looking for something to make his SQL code easier for the eye. It’s kind of a headache when you look at it. Anton, his concerned colleague, asked him about CTE. Karl thought Anton was referring to his headache. Maybe he heard it all wrong, so he answered, “Of course not.” The funny thing is, he was referring to Chronic Traumatic Encephalopathy, also a CTE – a neurodegenerative disease caused by repeated head injuries. But based on Karl’s response, Anton knew for sure that his colleague was clueless about what he was saying.
What a crazy way to introduce CTEs! So, before you get into the same boat, let’s clarify, what is SQL CTE or Common Table Expressions in the SQL world?
You can read the basics here. Meanwhile, we’ll learn a bit more about what happened in this unusual story.
Read MoreIt is the second part of the series focused on the SQL Server Management Studio usage. You will learn the database design core concepts and issues and get a walkthrough to design a simple SQL database with SSMS (SQL Server Management Studio).
Read MoreIn the previous article, I explained how we could install Ubuntu 18.04 and SQL Server 2019 on the virtual machines. Now, before we proceed further, let’s go through the configuration.
Read MoreThis article talks about the practical use of the SQL COALESCE function regarding some professional life scenarios. It highlights the importance of correct and in-time use of this function to address the database-related problems.
Additionally, we will implement the particular steps required to solve the problems with the help of this function.
Read MoreThis article is primarily written for beginners. Still, it covers some interesting and often forgotten database designing concepts that are equally attractive for SQL database professionals.
The current part focuses on the database designing concepts and their mapping to SQL Database tables, columns, and relationships. If you understand the backgrounds of databases and tools we are about to use, you will design your first SQL database with confidence.
Read More