All articles: Others

Checkout our self-help content, created by our top Experts!
What Ports Does MySQL Use? – Querychat
In this article, we will find out what ports are, what is the MySQL default port and what are Client-Server, Administrative, Shell, Workbench, and Router connection ports in MySQL. What ports are?  How can a remote computer reach our computer? Right, through the IP address. And how can a remote...
How to Generate Scripts for Existing SQL Server Agent Jobs via SSMS – Querychat
In the article, we will learn how to generate scripts for existing jobs in SQL Server using SQL Server Management Studio (SSMS). We will also look into some examples where we will be creating jobs through Transact-SQL and then generating all the jobs back into a script in SSMS. In...
Transactions in SSIS – Querychat
Data integrity is one of the main concepts that should be implemented when dealing with data. This concept is supported by using transactions. This article elaborates on using transactions in SSIS: why and when we use transactions within the SSIS Microsoft technology. What is a Transaction? In a world of...
What is the Difference Between MySQL and MS SQL – Querychat
In this article, we will compare two different databases, namely the MySQL and MS SQL.  These database systems are widely used around the world and are popular with both large and small enterprises. MySQL vs MS SQL MS SQL was the first development of Microsoft, focused on corporate rather than...
What Port Does SQL Server Use? – Querychat
SQL Server is a multifunctional platform, thanks to Microsoft, we have the ability to connect many different functions to SQL Server. From the number of functions and the various ways to connect them, the question may arise which firewall port is suitable for each function. This article will help us...
The sqlservr Application (sqlservr.exe) – Querychat
When we open the Windows Task Manager and click on the Detail tab, we will see, among other processes, sqlservr.exe. We might wonder if this process is safe and not harmful, as sometimes it consumes a large amount of memory. In this article, we will find out more about this...
Common Indexing Best Practices – Querychat
Having an effective database system where users can quickly query their data is one of the top priorities when designing a database. This kind of effectiveness is mostly reflected in the smart design of SQL indexes. This article elaborates on best practices when it comes to indexing in SQL Server....
How to Create an ER Diagram in MySQL Workbench – Querychat
In this article, we will discover two ways of creating an ER diagram in the MySQL ER diagram tool, namely the MySQL Workbench.  MySQL Workbench is a multi-purpose database design program for database architects and administrators which allows them to configure servers, administer users and many others. An ER diagram...
SQL Server WHILE Loop – Querychat
Looping is used to execute one or more statements repeatedly. It is a standard feature of procedural languages, and T-SQL provides us with the WHILE statement for looping. In this article, we will learn its syntax and try it out in various examples. Note:  SQL Server only supports the WHILE...
How to ‘Go Back in Time’ using Temporal Tables – Querychat
SQL Server database supports system-versioned temporal tables, which is a feature that stores historical data. In this article, we will learn how to create a temporal table and track the history of each record in this table. Temporal tables were introduced in SQL Server 2016. They are not to be...
1 2 16 17