Tag Archives: SQLServer

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

Microsoft SQL Server 2014 CTP2 Data Tools BI templates for VS2012

In case you missed it, here is the Microsoft SQL Server 2014 CTP2 Data Tools Business Intelligence project templates for Visual Studio 2012. http://www.microsoft.com/en-us/download/details.aspx?id=40736 This fixes one major pain on my laptop: No longer need for SSDT on one machine … Continue reading

Posted in Programming | Tagged , , | Leave a comment