The cloud is a buzzword in the IT world. Oracle, Amazon and Microsoft with Microsoft Azure are offering Cloud Services to the public. Most of the companies plan to have part of their environments in the cloud to reduce the maintenance and security effort.
This article is about SQL Machine Learning which is one of the most interesting topics equally attractive to both beginners and professionals of different areas of expertise.
In this article, we will learn about one of the important statistical functions, the SQL Standard Deviation function.
Introduction to the PostgreSQL tutorial In this article, we will have a tutorial to learn PostgreSQL. According to Statista, PostgreSQL is the 4th most popular database in the world (the other ones are Oracle, SQL Server, and MySQL). That is why we think it is an important DBMS to learn.
This article will provide an understanding of how to effectively use group concatenation in MySQL.
In this article, we will learn how to work with MySQL foreign keys with a few examples.
This article talks about the commonly used scenarios of SQL Select Distinct in an easily understandable format equally suitable for beginners and professionals.
Microsoft Power BI is a very popular data visualization tool. In this article, we will discuss the most frequently asked Power BI Interview Questions and Answers.
This article will provide an introduction to SQL escape characters for using special characters and their characteristics.
In this article, we will learn how to create Power BI Reports. This article is created for newbies to start the Power BI world with a simple example. We will connect to SQL Server, show how to transform data from SQL Server in Power BI, and then we will create some reports, and play with […]
In this article, we will learn how to implement the median functionality and wrap it into a SQL median function
In this article, we are going to learn some best practices that help to write more efficient SQL queries. Introduction 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 […]
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 […]
This article explores the RESTORE FILELISTONLY command in SQL Server with examples. Introduction 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 […]
This article explores SQL Server functions to add or subtract dates in SQL Server.
In this article, we will learn about different types of PostgreSQL joins with examples.
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.
In this article, we will learn how to use the ERD Project feature of pgAdmin to work with an instance of Azure Database for PostgreSQL for data modeling.
This article explores different SQL Commands (functions) to return the current Date and Time (Timestamp) in SQL Server.
In this article, we will take a basic walkthrough of the psql environment and learn the commands to get acquainted with this tool.
Introduction In SQL Server there are several kinds of SQL partitions. However, in general, we can say that a partition is a way to divide a table (sometimes a view) into smaller pieces for performance purposes. In this article, we will explain what partition does mean for a table partition and SSAS. We will also […]
Introduction In previous articles, we learn how to configure PostgreSQL ODBC drivers, how to configure ODBC drivers for Azure Database for MySQL, the differences between OLE DB, ODBC, and ADO.net, how to configure Linked Servers using ODBC DRIVER. This time we will use the ODBC Drivers to connect in SSIS.
Introduction In this article, we will answer the most common questions related to SSMS 2016 like these ones: What is SSMS 2016? How to install SSMS 2016? What SSMS versions exist? Is SSMS 2016 compatible with any SQL Server version? What changes were made in SSMS 2016? How to uninstall SSMS 2016?
The SQL Server Data Tools for Visual Studio 2015 are tools used for different purposes like: Working in relational database projects. Creating multidimensional or tabular databases in Analysis Services. Using Integration Service projects to import and export data. Building Reports in reporting services.
This article talks about a golden rule called PRIDESTES DEPLOY to sort out any SQL BI (business intelligence) related issue and it is particularly useful for resolving database, data warehouse or even reporting related issues where the database is built through modern tools like Azure Data Studio.