Tag Archives: SQLServer

Filtering SQL Agent Jobs

I suspect that any developer who has been near a SQL Server for more than just a short while, you will be able to recognize a list of SQL Agent jobs that can no longer can be seen in its full … Continue reading

Posted in Programming | Tagged , , | Leave a comment

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

p5rn7vb 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 Å. … 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