Blog of Wolfgang Werner

Install of SQL Server 2012 on Windows Server 2012 R2

I recently had a customer engagement where the customer wanted to install a SQL 2012 two node...

Author: Wolfgang Werner MSFT Date: 12/13/2013

Partitioning… some tricks and hints to create the switch in and out table

Partitioning of tables in SQL Server is commonly used since the transparent partitioning was...

Author: Wolfgang Werner MSFT Date: 04/16/2013

HDInsight.... how to upload data

I did some tests with the HDInsight CTP implementation on Windows. I have used theone on my own...

Author: Wolfgang Werner MSFT Date: 12/10/2012

Column encrypted in Database, but decrypted in clear text in Cube

In one of my last projects I have had the following challenge: The customer wanted meto encrypt a...

Author: Wolfgang Werner MSFT Date: 12/04/2012

SSIS - what to do if query is slow

I have had a problem at a customer where a source query in a data flow task was slow. I ran the...

Author: Wolfgang Werner MSFT Date: 09/28/2011

Be careful with string comparisons in SSIS

I have worked a lot with SSIS the last few months, and in every project with SSIS Icome across the...

Author: Wolfgang Werner MSFT Date: 09/09/2011

Replication SQL Server to Sybase

I wanted to share some questions I came across during a migration from Sybase ASE to SQL Server...

Author: Wolfgang Werner MSFT Date: 06/08/2011

Some hints and tips for the MAPS tool

A few weeks ago I had a small SQL consolidation project. The target was to consolidate five...

Author: Wolfgang Werner MSFT Date: 05/18/2011