Daniel Calbimonte

Daniel Calbimonte
Latest posts by Daniel Calbimonte (see all)
Power BI Desktop - Get data

How to create Power BI reports

January 11, 2023 by

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 »
SSMS

SQL Server Tutorial

December 23, 2022 by

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 »
Get age in SQL Server based on bithdate

SQL Subtract dates

November 7, 2022 by

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 »
SSDT Internet Sales

SQL Partition overview

September 26, 2022 by

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.

Read more »

SQL Queries in SQL Server – a beginner’s guide

December 15, 2021 by

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.

Read more »
Exploring a SQL log with a SQL Server logs reading tool

Go LSN in SQL Server

November 25, 2021 by

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.

Read more »

SQL commands in SQL Server

November 22, 2021 by

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.

Read more »

Database interview questions

June 11, 2021 by

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:

Read more »

SQL Definition

April 21, 2021 by

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.

Read more »
SQL Certification list

SQL Certifications

August 7, 2020 by

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.

Read more »