-
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
-
Handling Escape Sequences in SSIS Expression String Literals
posted 1/27/2010 by DevinKnight – FROM http://www.bidn.com/blogs/DevinKnight/ssis/362/handling-escape-sequences-in-ssis-expression-string-literals The SSIS expression language is a powerful tool for a developer that gives you one method of making a package dynamic. When writing an expression there are a few things to be careful of that could potentially cause a stumbling block while writing code. For example, a common reason you may write expressions… Continue reading
-
Render and Email a Reporting Services Report using .Net
Originally posted on SQLUNINTERRUPTED: In an earlier post, I had described a customer scenario, where they would want to execute and render a report from a .Net application, and then send the rendered report as an email attachment. In the previous post, I had talked about how to generate a Tree View of the Report… Continue reading
-
HOW TO SEND SSRS REPORT AS EMAIL ATTACHMENT.http://mstecharchitect.blogspot.com/2009/01/how-to-send-ssrs-report-as-email.html
http://mstecharchitect.blogspot.com/2009/01/how-to-send-ssrs-report-as-email.html SSRS -SQL Server Reporting Server SQL Server Reporting Services provides access to the full functionality via Report Server Web service. The Web service uses Simple Object Access Protocol (SOAP) over HTTP and acts as a communications interface between client programs and the report server. Here is the URL to access Reporting Server… Continue reading
-
example：Combining Data from Multiple Relational Data Sources into One Table in PowerPivot for Excel
By: Dattatrey Sindol I have read a tip on Importing SQL Server Data from Multiple Data Sources into PowerPivot for Excel, which talks about bringing in data from two or more sources into PowerPivot and storing data from each source table/query as a separate PowerPivot table. I would like to know if there is a way… Continue reading
Vision Binary 