My first experience as speaker in SQLBits

6 years ago

First at all, I would like to start this simple blog saying: Thank you everyone who was part of this…

Implementing CTE for filling gaps inside a sequence

6 years ago

This is the second article of a series dedicated to implementing Recursive Common Table Expression in different kind of scenarios,…

Using recursive CTE for generating a specific number of rows

6 years ago

I remember the first time that I discovered the amazing feature called Common Table Expression (CTE), it was during my…

Soft skills and Why we must improve them

6 years ago

The stereotypes are an “easy” and “toxic” way of grouping and split the people, we can find it in every…

Deploying SQL Scripts with PowerShell

6 years ago

I always have considered the Continuous Delivery (CD) for Database world as one of the last frontiers to cross, it…

Dealing with errors for SQL_Variant datatype in MS SQL Server

6 years ago

I have to confess; I have had traumatic experiences with variant data type in my beginning as a software developer,…

Generating a Workload for SQL Server

6 years ago

There are some special scenarios where we require to generate a customized workload in our SQL Server instance, these could…

How to import a Flat File into a SQL Server database using SSIS

6 years ago

The purpose of this article is to show you how you can use SSIS for doing a classic task –…