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.
Read more »
In this article, we will learn how to create PostgreSQL stored procedures using PSQL.
Read more »
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 the options available in Power BI.
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 »
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 »
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 »
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 provide some guidance to automate the partition process.
Read more »
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.
Read more »
In the previous article, Getting started with Azure SQL, we learned the basics to create an Azure SQL database.
Read more »
In this article, we will answer the most common questions related to SSMS 2016 like these ones:
The SQL Server Data Tools for Visual Studio 2015 are tools used for different purposes like:
This article will show Partitions in SQL Server and how they work.
Read more »
This article will show some important questions and answers to practice SQL.
Read more »
In this article, we will talk about Azure SQL. The article will compile the FAQ about this topic. The article will cover FAQ related to concepts for newbies, prices, some common features, migration and several links for references to get higher details on specific topics.
Read more »
In this article, we will cover the most common questions about this nice SQL Server Developer Edition.
Read more »
Creating SQL Queries is a straightforward process. This article is made in SQL Server, but most of the content can be applied to Oracle, PostgreSQL, MySQL, MariaDB and other databases with few changes. The SQL queries allow us to send queries to a database. In this article, we will have a fast, practical tutorial about doing your own queries from scratch.
Read more »
If you are reading this article is because you read about the SQL Server transaction log and you want to go to the LSN to restore information. This article will explain what is the LSN and show some tables, views, and system functions used to retrieve LSN information. We will also learn how to restore information using the Transaction Log information. We will also find out if there is a Go LSN command. So, if you want to learn more about the transaction log and want to recover some information using the logs, you are in the right place.
Read more »
If you are here, it means that you want to learn the SQL commands. This article applies to SQL Server especially, but most of the theory is similar to Oracle, MySQL, MariaDB, PostgreSQL, and other databases. The SQL commands are instructions that we send to the database to get information, manipulate the information or create objects, modify them, and handle the access to the information.
Read more »
If you are applying to a new DBA job or a job that requires database knowledge, you probably want to study the most common questions in an interview. If that is your case, this article may be useful. The article contains typical questions about databases. The database interview questions that are typical are the following:
Read more »
If you are using SQL Server and saw a GO command in a T-SQL script and you do not know what that GO is used for, this article is for you. In this article, we will explain what the SQL GO command is when to use it, and some tips about using it.
Read more »
In this article, we will provide a SQL definition and we will explain what it is, and we will also talk about the SQL extensions. We will also provide some examples of SQL Syntax.
Read more »
If you are applying for a SQL Server Administration or Development job, you may need to study and practice for the interview. It is a common mistake to go for an interview without studying.
Read more »
Many people ask me how to get the Microsoft SQL Certification. SQL Server has a lot of certifications and specializations. In this article, we will provide an introduction to each of them and provide some tips related. At the time of this publication, we are under the Coronavirus era. Many people are at home with free time. Instead of watching all the bad COVID 19 news, it is a great idea to earn a new certification.
Read more »
In this article, we’ll take a look at a brief TSQL history and a few examples of loops, conditionals, and stored procedures
Read more »© 2023 Quest Software Inc. ALL RIGHTS RESERVED. | GDPR | Terms of Use | Privacy
