Thursday, December 3, 2009

SSIS Slow - Ole DB Data Flow Optimazation

Do you build SSIS (SQL Server Integration Services) Packages?
Are you constantly running into Visual Studio acting sluggish or giving you "Microsoft Visual Studio is Busy"?

In my case, I use views a lot when I'm querying my source data (for reasons of maintainability). When you use views in an OLE DB Source, anytime you change the scope of what you are working on, e.g. jumping back to the control flow and then back into the Data Flow, Visual Studio rebuilds its meta-data and does validation checks to see if source or destination attributes have changed.

Resolution
Set AccessMode to "SQL Command"
And set SqlCommand to a Select query of your view.
Example:
SELECT * FROM v_MyView

Why does this work?

"...it calls OpenRowset in the validation phase to retrieve column metadata, and later in the execution phase to read out the data.

Testing has shown that using a SELECT statement can be at least an order of magnitude faster, because the adapter issues the specified command directly through the provider and fetches the data using sp_prepare without executing the command, avoiding the extra roundtrip and a possibly inappropriate cached query plan."

If you have any questions... Just ask, I'll be happy to assist where I can.

Wednesday, November 18, 2009

Facebook Redirects to Myspace

My wife just came across this interesting issue.

When she goes to http://www.facebook.com/ it redirects to a Myspace.com user's Samuel Garcia (SR388) profile.

Quickest resolution
For Vista and above:
is to go to your start menu -> All Programs -> Accessories. Right click on Command Prompt and click "Run as Administrator". Approve the escalation.

Copy and past the following command


ipconfig /flushdns


You should get...

Windows IP Configuration

Successfully flushed the DNS Resolver Cache.

Next clear your browsers cookie and cache... and maybe restart your browser for kicks.

I hope that helps.

FYI: I'm trying to track down why this is happening. I believe it has to do with a recently discovered DNS exploit. I'll continue to look into it.

In the mean time, if you could please reply to this post with your Internet provider and general location, city/state I would be much obliged so I can attempt to develop a pattern.

Thanks!
Mike

Tuesday, March 3, 2009

Joomla Tips and Tricks- #1

How to change / set the Joomla template programmatically from within a Joomla 1.5 component.


function my_method() {
global $mainframe;
$mainframe->setTemplate = "my-template-name";
}


Bam... "That was easy!"

Saturday, February 7, 2009

Crystal Reports ActiveX Designer (0x80043AE3) Invalid TLV record.

If you get a "Crystal Reports ActiveX Designer (0x80043AE3) Invalid TLV record." error.

Uninstall all versions of Crystal Reports and reinstall the version you intend to use. This is indicative of a Crystal Reports COM object mismatch, e.g. Trying to run a Crystal 9 report through the Crystal 8 COM.

That is all..