30 Jan 2012

Simple Scheduled SSIS Package for Import Data

Well, next week will be a brand new workplace for me. This week means rest for me, and I’m happy with it. Anyway, I’ll share to you how to make a simple SQL Server Integration Service package to be scheduled every time. You don’t have to do a code, if your import job is very simple. I’ll show you more on next paragraph.

26 Jan 2012

Windows Live Writer is the Best Blog Writer!

You guys actually have your favorite blog writer application, or even don’t use it (only use the web version of Blogspot or Wordpress or whatever blog you’ve used). I have one my favorite, Windows Live Writer. My client installed with Windows Live Writer 2011.
image
So, what’s the feature so far? Let’s take a look!

Problems in SharePoint 2010, “The service was unable to start because the version of the database does not match the version of the product.”

Lately, I’ve updated my SharePoint 2010 development engine to SharePoint 2010 Service Pack 1, and after updating SharePoint 2010 to Service Pack 1, and starting all services, there’s one service won’t run, Forefront Identity Manager Synchronization Service. When looked at the Event Viewer log, it says The service was unable to start because the version of the database does not match the version of the product.

19 Jan 2012

How to Query SharePoint Web Analytics Reports from SQL Server

This time, I want to show you on how you can query the SharePoint Web Analytics Reports from your SharePoint 2010. It seems that some people still confused because on my previous post, I didn’t give any examples or anything to proof this. I need to apologize, and in this post, I’ll write about how to Query it first, so you can get what I ‘m trying to explain.