The SSIS Technology Map

By Tuesday, April 28, 2015 Permalink 5

Some time ago, I had the challenge of giving a 1-day introduction to SQL Server Integration Services. As you may expect, this was a difficult task because there is such much information related to SSIS that it was practically impossible to cover everything in only 1 day (9 hours to be precise). Knowing that the challenge ...

What is ITIL? In simple words please…

By Sunday, September 14, 2014 Permalink 2

For the last four weeks or so I have done some after-work study to get my ITIL® Foundation certification. In this post I share with you my understanding of ITIL® as a concept. The Information Technology Infrastructure Library or ITIL® can be seen as a set of best practices for IT service management. The classic definition ...

Shrinking SQL Server Transaction Logs

By Wednesday, September 10, 2014 Permalink 1

Under some specific circumstances you will find yourself in the need of reducing/shrinking the physical size of transaction logs. Let's see a quick example of how to achieve this: 1) You can use DBCC SQLPERF (LOGSPACE) to quickly and easily list the size and percentage of use of all your databases' transaction logs. You will get something like ...

SQL Server 2014 is here!

By Wednesday, September 10, 2014 Permalink 0

I believe that some of us are still catching up with all the new great features introduced by SQL Server 2012 and now there is more work to do as with April came the general availability of SQL Server 2014, so what's new with SQL Server 2014?With this release, perhaps due to the short time-span ...

Understanding Temporary tables, CTEs, and table variables performance

By Wednesday, November 6, 2013 Permalink 0

Recently a colleague had a rather interesting question, should we use a temporary table instead of a Common Table Expression (CTE) for this problem? Then he continues and says "CTEs are usually slower than temp tables". For this specific problem, aggregating and filtering 10 records, CTEs seemed to be the right solution; however, this is ...

Understanding SQL Server Isolation Levels

By Monday, October 7, 2013 Permalink 0

If you have been jumping around trying to find a simple, straightforward explanation of SQL Server isolation levels or simply trying to understand what "snapshot isolation" is, fear no more, hopefully you are in the right place to get even more confused. The reality is, there is not simple explanation for database isolation levels as ...

Understanding SQL Server Instances

By Tuesday, September 3, 2013 Permalink 0

A SQL Server instance is the installation/deployment of a SQL Server Database Engine, together with any other components such as Analysis Services or Reporting Services, in a computer. It is called instance because SQL Server can be installed several times on the same computer and; therefore, each installation represents a new "instance" of SQL Server ...

The SSIS Lookup Transformation

By Sunday, October 7, 2012 Permalink 3

The SSIS Lookup Transformation is a classic SSIS component where the values of  common columns between an input and a reference dataset are compared to extract additional columns of interest; that is, the objective is to add data from one dataset to other. Overall, a lookup transformation requires three elements: an input dataset, a reference ...