Tag Archives: SQLServer

Microsoft Visual Studio is unable to load this document

This issue has actually been on my TODO list for quite some time. Now I had to go back to an old SSIS package and do some changes, I got reminded of how annoying this bug is. The scenario is … Continue reading

Posted in Programming | Tagged , , | Leave a comment

SSIS Script Task and Proxy Auto Configuration (PAC) Script

Actually this post could have been divided into several topics, but currently time does not permit me to write that often. So this will be the whole shabang at once. We needed to import data from an external source, using … Continue reading

Posted in Programming | Tagged , , | Leave a comment

How to generate the alphabet from ASCII codes in T-SQL

Just now I had the requirement to create a loop in SSIS, and have that loop the alphabet. In order to facilitate that, I generated a T-SQL statement, that provides the alphabet including the Danish Æ, Ø and Å. If … Continue reading

Posted in Programming | Tagged , , | Leave a comment

Subtle differences in Teradata and SQL Server

Imagine the hair pulling experience, when you port knowledge from one RDBMS to another, and it just doesn’t work. I had one such experience today, when I had to generate a certain filter for at Query. I wanted to combine … Continue reading

Posted in Programming | Tagged , , | 2 Comments

Never loose your server list in SSMS again…

Having to install new laptops, re-install old ones, configuring virtual servers or whenever you get the opportunity to install SQL Server from scratch, you always end up with an empty list of servers, when you try to connect through SQL … Continue reading

Posted in Programming | Tagged , , | 3 Comments