Another BI & Programming Blog - Jason Yousef

Hi, ever tried to read or write to an excel file and got that error?  "The 'Microsoft.ACE.OLEDB.12.0' provider is not registered on the local machine." Well it just happened to me today, I just got a freshly built machine, windows 7 ultimate 64BIT, 12 GB RAM, and Office 2010 installed. Anyway after investigating the issue, just make sure and load the 2007 Office System Driver: Data Connectivity Components from: http://www.microsoft.com/downloads/en/details.aspx?FamilyID=7554F536-8C28-4598-9B72-EF94E038C891&displaylang=en That solved the issue for me..

To create a restore point in windows 7: 1-click the Start button (the windows logo round button), right-clicking Computer, and then click Properties, that will give you the system properties. 2-In the left pane, click System protection. 3-Click the System Protection tab, and then click Create. 4-It'll prompt for a description,  type a description, and then click Create. That's It!!

Sweet and short, like the post title said, it is the online version of the MDX Studio product. The full version can be downloaded from http://www.mosha.com/msolap/mdxstudio.htm For discussion, bug reports, feature suggestions etc - please visit MDX Studio forum . http://mdx.mosha.com/default.aspx

I had hard time today trying to find out where Microsoft hed the Activity monitor in SQL 2008, it's in the tool bar itself, as a graph icon, dispite it's old location in 2005 under the tools menu.

Arabic_CI_AS is the test collation, and being used in my work environment. This white paper is helps a lot .. http://technet.microsoft.com/en-us/library/cc295829%28SQL.90%29.aspx Gives you a detailed overview of the Arabic collation.

HI, Today's post is short and sweet, ever wondered how to do dynamic year in the footer using the PHP language... Actually it's so simple... <?php echo date('Y') ;?> Hope that helps....

Just came across these links, hope it helps in making any decisions or migration... SQL Server 2008 Vs MySQL http://www.microsoft.com/sqlserver/2008/en/us/compare-mysql.aspx SQL Server 2008 Vs IBM DB2 http://www.microsoft.com/sqlserver/2008/en/us/compare-ibm-db2.aspx SQL Server 2008 Vs Oracle http://www.microsoft.com/sqlserver/2008/en/us/compare-oracle.aspx