-
One day This too shall pass
This is my recently favorite poem – from one of my favorite authors. The original version is in Chinese, a simple, but eloquent, poem. I translated it and tried to make it good. Well maybe not a perfect English version, and please forgive it lacks polish and talent. I just want to share my thoughts… Continue reading
-
Encrypting files in C#.NET using the Advanced Encryption Standard (AES)
Originally posted on Ira Lukhezo's blog: Cryptography One of the biggest challenges when dealing with the security and encryption for a system, is the determination of the correct ciphering paradigm. In .NET, there is a copious amount of libraries available for use in the System.Cryptography namespace. A significant amount of these libraries have been deprecated,… Continue reading
-
ways to transpose data in a SQL table from row-columns to column-rows?
from http://stackoverflow.com/questions/14066927/what-are-some-good-ways-to-transpose-data-in-a-sql-table-from-row-columns-to-col If you are using SQL Server 2005+, then you have a few options to transpose the data. Existing table has following Columns: AID (nvarchar unique) ASID (nvarchar unique) Milestone (M1, M2, M3…M100) MilestoneDate (datetime) Transposed data as follows: AID, ASID, M1 Date, M2 Date, M3 Date, M5 Date You can implement the PIVOT… Continue reading
-
Installing Greenplum Database: Community Edition on a Mac OS X 10.7
Originally posted on Data Warehouse: Some of the key features of Greenplum Database are: Massively Parallel Processing (MPP) Architecture for Loading and Query Processing Polymorphic Data Storage-MultiStorage/SSD Support Multi-level Partitioning with Dynamic Partitioning Elimination If you want to test this database on your Mac you can get a community edition that works… Continue reading
-
8 Ways to Optimize and Improve Performance of your SSIS Package—–Scenarios come to large data and ways to optimize the performance
http://thinknook.com/8-ways-to-optimize-your-ssis-package-2013-06-28/#!prettyPhoto 8 Ways to Optimize and Improve Performance of your SSIS Package 28JUN The title should actually read “8 Random Ways to Optimise SSIS”. One of the recent project I have been working on involved building a distributed (scaled-out) SSIS environment, this means multiple VMs with a standalone SSIS (2012 in Package mode) instances installed (so no… Continue reading
-
SOLUTIONS–FOR SSIS FRAMEWORK DSN
Solution . Configuration Management To recall the configuration management strategy, you want to start with an environment variable that points you to an XML configuration file. The configuration file modifies a SQL Server connection manager that is used by two more package configurations. You start by setting up your server. To begin, you must create… Continue reading
-
A good practise–SSIS MANAGEMENT FRAMEWORK DESIGN
Problem Whether you are creating an extraction, transformation, and loading (ETL) package, a maintenance package, or a simple process workflow, certain requirements are the same for every package. As a developer, you want to decrease your development and maintenance times. The rest of your team also has requirements for the package, which includes the following:… Continue reading
Vision Binary 