SQL Server provides various dates and time functions for different needs. In this article, we will focus on SQL subtract date functions with various examples.
Read more »

SQL Server provides various dates and time functions for different needs. In this article, we will focus on SQL subtract date functions with various examples.
Read more »In this article, we are going to learn some best practices that help to write more efficient SQL queries.
Queries are used to communicate with the databases and perform the database operations. Such as, we use the queries to update data on a database or retrieve data from the database. Because of these functions of queries, they are used extensively by people who also interact with databases. In addition to performing accurate database operations, a query also needs to be performance, fast and readable. At least knowing some practices when we write a query will help fulfill these criteria and improve the writing of more efficient queries.
Read more »This article briefly explains the SQL group by clause, when it should be used, and what we should consider when using it.
Read more »This article will explain the difference between SQL and MySQL. Many people get confused between several database terms like SQL, MySQL, SQL Server, or other SQL-related phrases. If you are a database professional, then you should be aware of the difference between SQL and MySQL or other phrases which have SQL words included like PostgreSQL, Cloud SQL, TSQL, etc. Most of these terms are divided between a query language and database software like TSQL and SQL are query languages whereas MySQL, SQL Server, and PostgreSQL are database software.
Read more »This article is a SQL Server Tutorial. If you want to learn how to install and start with SQL Server from 0, this is the place to start. We will teach you to install SQL Server, start your first queries, and explain the basics to start with SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), SQL Server Analysis Services (SSAS), Data Quality Services (DQS), Master Data Services (MDS) and Azure and more.
Read more »This article explores the RESTORE FILELISTONLY command in SQL Server with examples.
Performing a database backup is an integral part of a DBA’s job. Backups are taken to ensure that data can be recovered in an emergency. There are different restore mechanisms, and the SQL Server DBA needs to understand them to make the right decision in each situation.
Read more »This article will show how to get data from Azure SQL in the Serverless Python app.
Read more »This article aims to explain the WHERE, GROUP By, and HAVING clauses in detail. Also, we will see the difference between WHERE and HAVING with examples.
Read more »This article explores SQL Server functions to add or subtract dates in SQL Server.
Read more »Today, I will describe the SQL SUM () function along with its use cases in this article. There are various mathematical calculations we need to do in day-to-day business requirements. SQL Server offers various system functions which I have listed below to get these mathematical calculations easily by using them. One such requirement is to get the sum of values stored in a numeric column. We can use SQL Server system function SUM () to easily get the sum of the values stored in a numeric column of the table.
Read more »This article speaks about correlated subquery and why we need it when querying a SQL database.
Additionally, we are going to understand the difference between simple subqueries and correlated subqueries with the help of some easily understandable examples.
Read more »This article will explain various business continuity options available for Azure SQL PaaS services (SQL databases and SQL managed instances). Today we will learn about several options so that you can choose a suitable business continuity solution for your SQL databases provisioned in the Azure cloud.
Read more »Row Level Security is a very key requirement for most database or data lake applications. Most of the databases are having natively build row-level security but Synapse serverless SQL pool doesn’t support this inbuilt functionality. In this article, we will see how to implement it.
Read more »In this article, we will learn about different types of PostgreSQL joins with examples.
Read more »This article will provide a detailed walkthrough for retaining items in Cosmos DB for different durations and on different levels.
Read more »The SQL Boolean data type is not included in SQL Server. Other databases like Oracle and MySQL include the Boolean data type that accepts the values of TRUE, and FALSE.
Read more »This article will show different SQL timestamp functions available with examples.
Read more »SQL Server provides int, bigint, smallint and tinyint data for storing exact-number data. In this article, we will focus on int and bigint data types.
Read more »In this article, we will explain what the SQL injection attack is, why it could be hazardous, and how to defend our SQL database from this attack using parameterized queries and some third-party tools.
Read more »Today, I will demonstrate migrating or switching the backup policy from periodic to the continuous backup policy of an existing Azure Cosmos DB account. I have explained Cosmos DB backup policies in my last few articles which are given below for your reference to understand the topics.
Read more »This article will explore Continuous backup and steps to configure it for a new Azure Cosmos DB account or an existing Cosmos DB account. Azure Cosmos DB is a fully managed and highly secure, NoSQL database service on the Azure cloud that is designed for modern-day application development. It automatically runs backup for its databases on separate Azure blob storage at regular intervals without affecting the performance, availability, and provisioned resource units (RUs) to ensure data protection from a data recovery standpoint which can be needed in case of data corruption, deletion, or wrongly data updates.
Read more »This article will show the basics of hosting MySQL databases in Amazon Web Services (AWS).
Read more »In previous articles, we saw how to connect with ODBC to SQL Server using the ODBC Data Source Administrator in Windows. This time, we will connect to Azure and export the data from one table in Azure to SQL Server on-premises using SSIS.
Read more »In this article, we will show how to subtract dates using SQL Server. This article will be a learn-by-example article with a problem and a solution. But first, I will add some theory to understand the syntax of the DATEDIFF function which is the base of this article.
Read more »This article will explain about Global Distribution feature of Azure Cosmos DB and how to enable it to distribute data across regions. Azure Cosmos DB is developed to address modern application requirements in this digital era. There are different requirements to run web-based or online internet-facing applications smoothly. You need to cater enormous amount of data that can generate with very high velocity and this will cause huge numbers of read and write operations on the database. Your database needs to be responsive and quickly show the updated details for other customers. You might also need to address autoscale which will be used to address unpredictable workload during any discount offer, or festive seasons. These modern days applications must also develop in a way so that if you need to add another location to expand your business to the different regions so you don’t need to do many changes and it could be easily adjusted to expand the application for other regions.
Read more »© 2023 Quest Software Inc. ALL RIGHTS RESERVED. | GDPR | Terms of Use | Privacy