Month: March 2013

Warning! Latest Windows 8 updates and SSD Acceleration!

So last night upon returning home, I found one of my super machines wanting to be restarted so that it could start to apply a batch of Windows 8 updates to it. This particular machine is one of the Z series motherboards which uses an SSD card as a cache drive for the primary drive (in this case a 1 TB ) so that your most used stuff gets cached but you still get the benefit of  having a very large drive. It is an incredibly fast combo that gives you the best of both worlds….faster boot up and apps just scream in loading up if they are in the cache. Upon restarting, I got introduced to what appears to be the new Windows 8 sad face blue screen. No biggie, it says it is gathering some information and sending it off or something like that before rebooting. After rebooting, it would go to the recovery screen ..I pick automatic recovery mode so that it should try to self-heal itself. It reboots…self-healing mode…BAM! Sad face screen again… (Sigh). I guess it is time to go back to yesterday’s image but 1 TB will take a while. So reboot…..recovery screen…. recover from image… error cannot find …. recover from specific image…..error cannot find…. (sigh)…so possibly a disk problem? I do the following … 1. Check BIOS 2. Run various CHKDSK...

Read More

SSIS Execute SQL Task : Mapping Parameters And Result Sets

A very common scenario in an ETL process is one in which you need to call out to some configuration tables to figure out some values that it needs to use somewhere downstream in the process. Quite often you also want to pass in some parameters as well. So in this article I will be addressing both of those scenarios. To start, you will just need to drop an Execute SQL Task item onto the Control Flow of an SSIS package and set up the initial configuration so that it is basically given a connection string Now we want to enter in our SQL statement that will contain the parameters. In this case we are using a SQL Server connection and I will be calling a stored procedure. So I will provide ?s for each of the parameters involved. So my statement look like this… exec Staging.usp_GetTicketQueries ?,?,? I could also be more verbose if I wanted to exec Staging.usp_GetTicketQueries  @StartDate=?,@EndDate=?,@SomeOtherValue=? but it isn’t entirely necessary. Now that I have the statement ready I just need to click on the Parameter Mapping menu item on the left hand side and map my parameters. Notice that there isn’t anything really tricky here. I line out the variables that will be used with the appropriate type and size. The only part that trips a lot of people up is the fourth...

Read More

Capitalism Works! Even for Hackers?

InfoWorld is finally reporting on a rather disheartening trend that I have watched over the past year or so, which is the rise of the consumer black markets for malware. That’s right, just when you thought that those wily hackers couldn’t get any worse, they have finally figured out that it isn’t really nearly as profitable doing all that work yourself. Instead what you should do is go out and package up your knowledge and sell it out on the marketplace. It used to be  that you would put all of your work into creating series of botnets out there. Basically a mass of compromised PCs that is waiting at your beckon call to do something. Of course, it was up to you to figure out what that something was…so you would sit around and wait for the right opportunities to present themselves…but not anymore. Now you can go out on the market and sell your botnets for around $1000.00 for a 10,000 computer unit. That sounds like a lot right? Not really… 10K is small. Facebook helped the FBI take down a botnet of over 11 million computers just last December… that’s right 11 MILLION …. CNET – Facebook helps FBI take down $850M botnet crime ring .  That’s’ right .. the botnet was worth about $850 MILLION! So if you would like to see all the gory...

Read More