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 Failover Cluster with one instance. OK, easy, did this a couple of times. But then the customer came up with the Information, that the OS will be Windows Server 2012 R2. OK, older SQL on newer OS is very…

2

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 introduced in SQL 2005. No longer need for union all views and stuff like that, just insert, update, delete on a table without the need to remember how the table was partitioned over hundreds of single tables. I did a lot…

0

HDInsight…. how to upload data

I did some tests with the HDInsight CTP implementation on Windows. I have used theone on my own server machine not the HDInsight for Azure. I have installed it, and did the example that comes with the CTP. Ok, it worked, but Iwanted to upload some of my own data and create a hadoop table…

0

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 sensitive column in the database, better say in a dimension table.But, the column must show up in the cube when browsing, and it has to beclearly readable there. So the customer wanted to prevent that someone canselect…

1

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 query in Management Studio and it was fast. There was a filter in the query to limit the data for one day, realized with two SSIS Variables passed to the query with the…

1

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 fact that SSIS treats strings with regards to upper andlowercase. Today SQL Server databases are in nearly 99% of all cases installed ascase-insensitive. So you get your data to import from somewhere, directly froma database,…

2

Replication SQL Server to Sybase

I wanted to share some questions I came across during a migration from Sybase ASE to SQL Server 2008. Is it possible to do a transactional replication from SQL Server to Sybase? Yes, it is. You can replicate via the Sybase OLE DB driver, if you set it up as a linked Server. You can…

6

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 stand-alone SQL Servers (SQL 2000 and 2005) and one SQL 2005 cluster. When consolidating, first of all you must know about the workload on those servers. But how to find out the workload? Spending hours and days in…

0