Daniel Calbimonte

Author
Recent Posts

Daniel Calbimonte is a Microsoft Most Valuable Professional, Microsoft Certified Trainer and Microsoft Certified IT Professional for SQL Server. He is an accomplished SSIS author, teacher at IT Academies and has over 13 years of experience working with different databases.

He has worked for the government, oil companies, web sites, magazines and universities around the world. Daniel also regularly speaks at SQL Servers conferences and blogs. He writes SQL Server training materials for certification exams.

He also helps with translating SQLShack articles to Spanish

View all posts by Daniel Calbimonte

Latest posts by Daniel Calbimonte (see all)

PostgreSQL tutorial to create a user - November 12, 2023
PostgreSQL Tutorial for beginners - April 6, 2023
PSQL stored procedures overview and examples - February 14, 2023

PostgreSQL tutorial to create a user

November 12, 2023 by Daniel Calbimonte

Introduction to the PostgreSQL tutorial to create a user

In this article, we will show a PostgreSQL tutorial to create a user using PgAdmin and PL/PgSQL.

PostgreSQL Tutorial for beginners

April 6, 2023 by Daniel Calbimonte

Introduction to the PostgreSQL tutorial

In this article, we will have a tutorial to learn PostgreSQL. According to Statista, PostgreSQL is the 4^th 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.

PSQL stored procedures overview and examples

February 14, 2023 by Daniel Calbimonte

In this article, we will learn how to create PostgreSQL stored procedures using PSQL.

How to create Power BI reports

January 11, 2023 by Daniel Calbimonte

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.

SQL Server Tutorial

December 23, 2022 by Daniel Calbimonte

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.

SQL Boolean Tutorial

November 28, 2022 by Daniel Calbimonte

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.

ODBC drivers for Azure SQL

November 9, 2022 by Daniel Calbimonte

Introduction

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.

SQL Subtract dates

November 7, 2022 by Daniel Calbimonte

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.

SQL Partition overview

September 26, 2022 by Daniel Calbimonte

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 provide some guidance to automate the partition process.

ODBC Drivers in SSIS

September 23, 2022 by Daniel Calbimonte

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.

Getting started with Azure SQL Managed Instance

September 14, 2022 by Daniel Calbimonte

Introduction

In the previous article, Getting started with Azure SQL, we learned the basics to create an Azure SQL database.

SSMS 2016 – A FAQ manual

August 5, 2022 by Daniel Calbimonte

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?

SQL Server Data Tools for Visual Studio 2015

August 3, 2022 by Daniel Calbimonte

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.

Partitions in SQL Server

June 8, 2022 by Daniel Calbimonte

This article will show Partitions in SQL Server and how they work.

SQL Practice – common questions and answers for SQL skills

April 28, 2022 by Daniel Calbimonte

This article will show some important questions and answers to practice SQL.

Azure SQL – a FAQ article

January 12, 2022 by Daniel Calbimonte

Introduction

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.

SQL Server Developer Edition – a FAQ article

January 5, 2022 by Daniel Calbimonte

In this article, we will cover the most common questions about this nice SQL Server Developer Edition.

SQL Queries in SQL Server – a beginner’s guide

December 15, 2021 by Daniel Calbimonte

Introduction

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.

Go LSN in SQL Server

November 25, 2021 by Daniel Calbimonte

Introduction

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.

SQL commands in SQL Server

November 22, 2021 by Daniel Calbimonte

Introduction

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.

Database interview questions

June 11, 2021 by Daniel Calbimonte

Introduction

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:

SQL GO command in SQL Server

May 18, 2021 by Daniel Calbimonte

Introduction

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.

SQL Definition

April 21, 2021 by Daniel Calbimonte

Introduction

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.

SQL interview questions

September 3, 2020 by Daniel Calbimonte

Introduction

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.

SQL Certifications

August 7, 2020 by Daniel Calbimonte

Introduction

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.