Random MusingPutting it together one piece at a time...http://geekswithblogs.net/nestor/Default.aspxNestorhttp://geekswithblogs.net/nestor/Default.aspxSubtext2008-04-23T01:04:40ZVSTO not supporting side-by-side Office installationshttp://geekswithblogs.net/nestor/archive/2008/02/21/119886.aspx2008-02-21T21:58:13-12:00:002008-04-23T01:04:40ZIt took be a while before I realise that while Office 2003 and Office 2007 can be installed side by side, and that it doesn't really matter which version is installed first, it is an entirely different story when it comes to developing Office solutions using VSTO on a development environment with both version installed.
In a nutshell, it is not supported and highly unrecommended to have both versions installed when developing using VSTO. The main reason is due to the 2007 Primary Interop Assemblies overwriting the 2003 PIAs. Even though it might look as if everything works as expected, you are really using the Office 2007 PIAs when launching a Excel 2003 VSTO project. If you're lucky you might catch this if you open an excel worksheet in Designer mode within VS and VS loads 2007 Excel instead of 2003. Now this is dangerous as it's highly unpredictable what will happen when you package your 'finished' product and deploy into another client machine.
The solution is really to have only 1 version installed in your development environment at all time. Painful, yes, unfortunately this seems to be the only clean way to ensure that your development does not go uncharted territories.
For more information on this, you can look at Andrew Whitechapel's <a href="http://blogs.msdn.com/andreww/archive/2007/06/08/why-is-vs-development-not-supported-with-multiple-versions-of-office.aspx">here</a> and <a href="http://blogs.msdn.com/andreww/archive/2007/06/15/can-you-build-one-add-in-for-multiple-versions-of-office.aspx">here</a>
<img src="http://geekswithblogs.net/nestor/aggbug/119886.aspx" width="1" height="1" />http://geekswithblogs.net/nestor/comments/119886.aspx0http://geekswithblogs.net/nestor/comments/commentRss/119886.aspxhttp://geekswithblogs.net/nestor/services/trackbacks/119886.aspxTheming a Sharepoint Sitehttp://geekswithblogs.net/nestor/archive/2008/01/23/118816.aspx2008-01-23T01:37:58-12:00:002008-01-23T01:37:58Z<p>If you wish to create a custom theme in a WSS installation and wanted to install that theme into your Sharepoint installation, you will realize that there is no quick and easy one click method to do it. Below are the steps to illustrate what has to be done to upload a new theme to the WSS installation
</p><ol><li>After creating your theme, copy the content of the theme into the "C:\Program Files\Common Files\Microsoft Shared\web server extensions\12\TEMPLATE\THEMES" folder
</li><li>Open SPTHEMES.XML located in "C:\Program Files\Common Files\Microsoft Shared\web server extensions\12\TEMPLATE\LAYOUTS\1033"
</li><li>Add another child node to the <SPThemes> tag to reflect the name of your new theme
</li><li>Capture the screen of the new theme and save the file in "C:\Program Files\Common Files\Microsoft Shared\web server extensions\12\TEMPLATE\IMAGES". The name of the file is suppose to be the same as the name of the thumbnail as highlighted in point 3
</li></ol><p>And you're done!</p><img src="http://geekswithblogs.net/nestor/aggbug/118816.aspx" width="1" height="1" />http://geekswithblogs.net/nestor/comments/118816.aspx0http://geekswithblogs.net/nestor/comments/commentRss/118816.aspxhttp://geekswithblogs.net/nestor/services/trackbacks/118816.aspxThis server is not the indexer of this search applicationhttp://geekswithblogs.net/nestor/archive/2008/01/22/118812.aspx2008-01-22T21:16:46-12:00:002010-12-14T04:42:21Z<p>While installing WSS 3.0, I came across another strange error when I try to start my Search Service in the server farm. For some reason WSS refuses to acknowledge that the machine is the indexer. The setup was on single a 64 bit machine installed as a server farm. After reinstalling and re-confirming that everything is where it should be, I decided to try the most unlikely reason why it fails.
</p><p>I used the server name instead of its IP address when specifying the configuration. Strange enough, WSS stops denying the search service. </p><img src="http://geekswithblogs.net/nestor/aggbug/118812.aspx" width="1" height="1" />http://geekswithblogs.net/nestor/comments/118812.aspx5http://geekswithblogs.net/nestor/comments/commentRss/118812.aspxhttp://geekswithblogs.net/nestor/services/trackbacks/118812.aspxMachine.Config, Web.Config and Configuration Inheritancehttp://geekswithblogs.net/nestor/archive/2008/01/22/118809.aspx2008-01-22T17:46:11-12:00:002008-01-22T17:50:19Z<p>I was trying to set up a development server recently on a 64 bit machine with Windows Sharepoint Services 3.0 and came across this. After installing the server farm, while Sharepoint tries to load the Central Administration page, it popped up with this error
<p><img src="http://farm3.static.flickr.com/2096/2212698117_7d4f822c41_o.jpg" /> </p>
<p>This can be easily fixed by going to your parent web.config file under C:\Windows\Microsoft.NET\Framework\v2.0.50727\CONFIG and change to allowOverride="true", this allows the Sharepoint's webconfig to override the settings in your parent configuration file. Take note that your Machine.Config and Web.Config supersedes the settings in your custom web application's Web.Config file. Hence if there's a need to override the parent configuration, you have to explicitly allow that by setting the allowOverride to 'true' as mentioned above.</p><img src="http://geekswithblogs.net/nestor/aggbug/118809.aspx" width="1" height="1" />http://geekswithblogs.net/nestor/comments/118809.aspx1http://geekswithblogs.net/nestor/comments/commentRss/118809.aspxhttp://geekswithblogs.net/nestor/services/trackbacks/118809.aspxHow to get Oracle Drivers to work on an x64 Box for SSIShttp://geekswithblogs.net/nestor/archive/2008/01/22/118792.aspx2008-01-22T09:37:25-12:00:002010-05-20T12:33:40Z<p>Just a couple of weeks ago, I was tearing my hair out trying to meet a really tight timeline and at the same time trying to solve a technical issue which in my opinion is a total waste of time. If anyone of you had ever tried to make SSIS and Oracle work on a 64 bit machine, I am sure you know what I was referring to.
</p><p>Fortunately we have people like <a href="http://stevemchugh.blogspot.com/2007/02/adventures-of-ssis-and-oracle-in-64bit.html">Steve McHugh</a> and <a href="http://www.artisconsulting.com/Blogs/tabid/94/EntryID/5/Default.aspx">Greg Galloway</a>, who both wrote some excellent how-to articles addressing this issue. I've now grown so dependent on these articles (especially Greg Galloway's) that I'm ripping it off to put on my own blog site in case he takes the article down one day.
</p><p>"<span style="color:#4f6228">If all you want to do is run scheduled packages under the x64 version of SSIS, you can just do step 2. If you want to develop packages on this box or run the SQL Server Import/Export Wizard, then you need to do all the steps.
</span></p><ol><li><span style="color:#4f6228">Download the latest 32-bit drivers and install them. We would suggest <a href="http://www.oracle.com/technology/software/tech/windows/odpnet/utilsoft.html">Oracle10g Release 2 ODAC</a>.
</span></li><li><span style="color:#4f6228">Download the latest 64-bit drivers and install them. We would suggest <a href="http://www.oracle.com/technology/software/tech/windows/odpnet/64-bit/index.html">Oracle10g Release 2 ODAC (64-bit) 10.2.0.3 for Windows x64.</a>
</span></li><li><span style="color:#4f6228">Because you have several drivers installed, we suggest you add a TNS_ADMIN environment variable which says "C:\TNS" and then move your tnsnames.ora and sqlnet.ora files to that one "C:\TNS" directory. You can add a TNS_ADMIN environment variable by right clicking My Computer on your desktop, choosing Properties, flipping to the Advanced tab, clicking the Environment Variables button, and adding that variable.
</span></li><li><span style="color:#4f6228">Note: During one install of the drivers, it failed because it couldn't find gacutil.exe. If you get that failure, uninstall the Oracle driver you just tried to install, then copy gacutil.exe and gacutil.exe.config from <C:\program files\Microsoft Visual Studio 8\SDK\v2.0\Bin> to <C:\program files (x86)\Microsoft Visual Studio 8\SDK\v2.0\Bin>. The most recent time we did the installs, this was not a problem, so maybe Oracle has fixed this issue.
</span></li><li><div><span style="color:#4f6228">All 32-bit SQL Server applications start under the "Program Files (x86)" directory. You need to fix them so they start in the "Progra~2" directory. The following steps will need to be rerun after every subsequent SQL service pack is installed.
</span></div><ol><li><span style="color:#4f6228">To fix the SQL Server Import/Export Wizard so you can launch it from Management Studio, fix the reference to it in the registry by running the "SQL import-export wizard on 64-bit server.reg" file that I have included in the ZIP file below. (That registry file fixes the HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\Microsoft\MSDTS\Setup\WizardPath registry path.)
</span></li><li><span style="color:#4f6228">The shortcuts to SQL Server Management Studio and SQL Server Business Intelligence Development Studio need to be fixed. Unfortunately, you can't just change the shortcut, because Windows automatically expands the "Progra~2". Instead, create a bat file that launches the EXE, then change the shortcut to point to the bat file. These bat files and shortcuts are included in the ZIP file below. Basically, those bat files look like: <br /><em>start /B "C:\Progra~2\Microsoft Visual Studio 8\Common7\IDE" "C:\Progra~2\Microsoft Visual Studio 8\Common7\IDE\devenv.exe"</em>
</span></li><li><div><span style="color:#4f6228">When you double-click a .sln file, the path it uses for Visual Studio needs to be fixed. If you only have Visual Studio 2005 (i.e. SQL Server 2005) installed on this server, you can make the following change. Open the C drive… Go to the Tools menu… Folder Options… Flip to the File Types tab… Type in SLN to skip down to the SLN file type… Click the Advanced button… Highlight the "Open" action… Click Edit… Change the path to say:<em>
</em></span></div><p><span style="color:#4f6228"><em>"C:\Progra~2\Microsoft Visual Studio 8\Common7\IDE\devenv.exe" "%1"
</em></span></p><p><span style="color:#4f6228">Consider fixing any other file extensions you wish to double click which should launch 32-bit processes.<em>
</em></span></p></li><li><span style="color:#4f6228">Fix the PATH environment variable by changing any reference that says "C:\Program Files (x86)\Microsoft SQL Server\" to "C:\Progra~2\Microsoft SQL Server\". And change any reference to "C:\Program Files (x86)\Microsoft Visual Studio 8" to "C:\Progra~2\Microsoft Visual Studio 8". Environment variables can be edited by right clicking My Computer on your desktop, choosing Properties, flipping to the Advanced tab, clicking the Environment Variables button, choosing the Path system variable, and clicking Edit.
</span></li><li><span style="color:#4f6228">Fix the shortcuts for other 32-bit applications that need to connect to Oracle (such as Toad) as outlined in step B above.
</span></li></ol></li><li><span style="color:#4f6228">We had trouble when our master SSIS package launched child packages out-of-process if those child packages needed to connect to Oracle. We decided to change those Execute Package Tasks to run in-process, and we didn't investigate further.
</span></li><li><span style="color:#4f6228">You will probably have to set the <a href="http://blogs.conchango.com/jamiethomson/archive/2005/10/25/SSIS_3A00_-Connect-to-Oracle.aspx">AlwaysUseDefaultCodePage</a> property to True on the OLE DB Source components in your data flow tasks that pull from Oracle.
</span></li></ol><p><span style="color:#4f6228">Download a <a href="http://www.artisconsulting.com/Portals/0/Blog/Files/3/5/oracle%20x64%20fix.zip">oracle x64 fix.zip</a> which contains a couple of shortcuts and the .reg file used in step 5a above.
</span></p><p><span style="color:#4f6228">Miscellaneous Note: To setup a linked server to Oracle, review this <a href="http://maxolbi.blogspot.com/2007/07/configuring-link-from-ms-sql-2005-to.html">post</a> by Max Oleznyuk</span>."
</p><p>It also helps to know (from Steve's article) the following
</p><ul><li>Visual Studio (BIDS) is 32 bit
</li><li>SQL Server Management Studio is 32 bit
</li><li>dtexecui.exe is 32 bit
</li><li>dtexec.exe comes in 32 bit and 64 bit
</li><li>Oracle Provider comes in 32 bit and 64 bit
</li><li>SQLAgent is 64 bit
</li></ul><p>If Greg or Steve is reading this post, thanks a lot for making the installation/configuration so easy. Good on ya!
</p><img src="http://geekswithblogs.net/nestor/aggbug/118792.aspx" width="1" height="1" />http://geekswithblogs.net/nestor/comments/118792.aspx7http://geekswithblogs.net/nestor/comments/commentRss/118792.aspxhttp://geekswithblogs.net/nestor/services/trackbacks/118792.aspxOnline Drive with Gmailhttp://geekswithblogs.net/nestor/archive/2008/01/22/118776.aspx2008-01-22T05:05:34-12:00:002008-01-22T17:02:52Z<p>I recently stumbled upon an excellent shell extension for Windows which allows users to map your regular Gmail account as a virtual online drive on your computer. I thought this is an example of how technology is converging. Simply download the setup files, extract it into a temporary folder and run the setup.exe. Once done, you will see a Gmail drive in your explorer. Clicking it will bring up a username and password prompt for the first time. Once you're login, you can start to use your regular Gmail account as an online backup drive.
</p><p>You can download the setup files from <a href="http://www.viksoe.dk/code/gmail.htm">here</a>
</p><p>As mentioned in the site, it will be a good idea to create a label and a filter with <em>GMAILFS </em>to archive these files so as to prevent your inbox from clogging up.</p><img src="http://geekswithblogs.net/nestor/aggbug/118776.aspx" width="1" height="1" />http://geekswithblogs.net/nestor/comments/118776.aspx0http://geekswithblogs.net/nestor/comments/commentRss/118776.aspxhttp://geekswithblogs.net/nestor/services/trackbacks/118776.aspxDesigning for Slowly Changing Dimension and Rapid Changing Dimensionshttp://geekswithblogs.net/nestor/archive/2007/09/03/115125.aspx2007-09-03T09:34:52-12:00:002007-09-03T09:38:40Z<p>SCD (Slow Changing Dimension) has been a very common scenario for data warehouses and there are many established and proven techniques that can be used to solve the problems. This includes the usage of SCD Type II (Insert only) or SCD Type I (Update only) methodology. When we start to look at designing a system that caters for real time information, it's very common that we will meet the same problems, with the exception that the dimension doesn't change slowly, but rapidly. Moreover, they normally are very large in size.
</p><p>Adopting the SCD Type II methodology will often mean that we will need to insert new records into the same dimensional table. This is fine and works well if the table is not too large and that the changes doesn't happen frequently. However, if the table is some multi-million size large and changes happens every few minutes, we will need a better solution than storing them in one large SCD table.
</p><p>The solution to this is to break out that dimensional table into sub dimensional tables which are rapidly changing in nature and add another foreign key into the fact table to reference that key. This technique can be applied to any dimensional attribute or to any more dimensions so that loading and data insertion can be kept to a manageable size.
</p><p>For example, if there's a Customer Dimension table
</p><p>Customer Key Name Country<br />1001 John USA
</p><p>If John changed his state to Australia, we can justify this as a SCD Type II (for historical recording) and insert the table so that we have
</p><p>Customer Key Name Country<br />1001 John USA<br />1002 John Australia
</p><p>and in the fact table we can have something like
</p><p>Fact Table<br />Fact_ID Customer Key Field1<br />1 1001 $10<br />2 1002 $10
</p><p>and there we have our typical SCD Type II. However, if this Customer Dimension table is multi-million rows in size with changes happening every few minutes, and that you need to have an ETL process that runs it for every 15 minutes, it will an issue if this table is to be updated as a normal TYPE II. The solution is to split it up into manageable size.
</p><p>Customer Dimension<br />Customer Key Name<br />1001 John
</p><p>Country Dimension<br />Country Key Country<br />2001 USA<br />2002 Australia
</p><p>Then the fact table will be
</p><p>Fact ID Customer Key Country Key Field1<br />1 1001 2001 $10<br />2 1001 2002 $10
</p><p>With this technique, you can then further split your dimensions into different groups and have the database manage a smaller group of data insertions for fields that change and fields that doesn't change as often. On top of that, you can subgroup the attributes to record ranges instead of absolute figures.
</p><p>However, even with this technique, if and when possible, a denormalized table will always be better than an over-normalized tables schema in a data warehouse
</p><img src="http://geekswithblogs.net/nestor/aggbug/115125.aspx" width="1" height="1" />http://geekswithblogs.net/nestor/comments/115125.aspx1http://geekswithblogs.net/nestor/comments/commentRss/115125.aspxhttp://geekswithblogs.net/nestor/services/trackbacks/115125.aspxImplementation of Real Time Business Intelligencehttp://geekswithblogs.net/nestor/archive/2007/08/30/115077.aspx2007-08-30T16:58:15-12:00:002007-08-30T20:23:43Z<p>While there have many takes and talks about Business Intelligence 2.0, which is really BI working in a SOA environment, the technology behind Business Intelligence hasn't seems to mature to the state where we can really have real time performance without sacrificing some traditional BI systems characteristics. SQL Server 2005 did a great job in getting us closer to Real Time Business Intelligence through the introduction of Proactive Caching as well as SSIS's dimensional destination. However, things get tricky when we try to set up a system with the following requirements
</p><ul><li>Real Time data
</li><li>Large SCD Dimensions
</li><li>Very Large Data Warehouses
</li></ul><p>Part of my consulting work includes designing architectures for Business Intelligence and SOA systems. After some considerable research on 'Best Practices', the options are basically between these 2
</p><p><span style="text-decoration:underline"><strong>UDM to connect directly into the OLTP relational database and into SSAS
</strong></span></p><p>While this will enable us to be truly real time with proactive caching, there is a big catch which cannot be ignored. It is obvious that if a system is set up this way, we will have the following issues to worry about
</p><ul><li>No data cleansing and data quality check
</li><li>No dimension versioning with SCD Type II
</li><li>No surrogate keys
</li><li>Unable to hold historical data unless OLTP system archives them
</li></ul><p>This almost contradict the entire philosophy behind having a Business Intelligence system as we're basically going through a big round to connect for traditional reporting with the advantage of being able to connect multiple data sources in the UDM for 'single version of truth'
</p><p><span style="text-decoration:underline"><strong>UDM to connect into Datawarehouse and into SSAS
</strong></span></p><p>While this sounds like a good idea, present technologies haven't gotten us to a comfortable level with this arrangement yet. What this mean is that we will not be able to achieve a real 'Real Time' scenario. The shortcomings are as follows
</p><ul><li>Will ETL take too long to process and hence unable to catch up?
</li><li>Will there be competition on hardware resource resulting from ETL and SSAS processing competing with each other, and hence increasing costs due to the need to have separate installations of each?
</li><li>Real Time scope will have to be 'lengthen'
</li><li>More complex system development and maintenance due to the need to store historical partitions and current partitions
</strong></span></p><p>While there is really no ideal solution to this (yet, I hope someone might correct me here!). There are a few possible workarounds so that you can get your job done. You can either
</p><ul><li>Adapt option 1 if the requirements allows (which is quite likely)
</li><li><div>Split the project into 2 sub projects
</div><ul><li>Real-time system without historical audit and X% tolerance for unclean data
</li><li>Historical data warehouse with ability to report of reports coming from the Real-time system.
</li></ul></li><li><div>Adapt option 2 and work with your project sponsors and stakeholders on the definition of 'Real-time'
</div><ul><li>Work on the slightly more complex environment and try to simplify it as much as you can
</li></ul></li></ul><p>I'm actually more inclined towards the last option as in my experience; it is easier to justify system limitations to business users, then trying to explain why data doesn't reconcile with 2 different systems. I hope this blog entry will give someone out there with some insight with the available options currently.</p><img src="http://geekswithblogs.net/nestor/aggbug/115077.aspx" width="1" height="1" />http://geekswithblogs.net/nestor/comments/115077.aspx0http://geekswithblogs.net/nestor/comments/commentRss/115077.aspxhttp://geekswithblogs.net/nestor/services/trackbacks/115077.aspxReal Time BI with SCD Type II?http://geekswithblogs.net/nestor/archive/2007/08/29/115045.aspx2007-08-29T07:29:47-12:00:002007-08-30T20:23:58Z<p>Is this even possible? I've been trying to design a BI system on SQL Server 2005 with strict constraints to maintain a 'single version of truth'. One of the hardest things in this system is to provide Real Time data views with historical audit. To make things more exciting, many of the dimensions are slowly changing dimensions.
</p><p>Proactive Caching in SSAS seems to address the issue of Real Time BI in a good sense. We're actually able to get pretty good performance on a ROLAP engine thanks to this neat feature. However, it seems like we're trying to merge two entirely different things here when we need to have a Real Time Business Intelligence System which is capable of capturing historical changes and do some dimensional versioning. Since proactive caching really works its charm when we do a direct connection to the OLTP relational database, we will be really missing out on the ETL / Cleansing layer. In short, we will have no area where we can do SCD Type II transformation.
</p><p>There are other ways in which we can use SSIS with dimension destination, but I doubt if this approach will yield good performance and results.
</p><p>There are probably some other ways in which this can be achieved, such as splitting the system into 2 different sub systems, one to cater for Real Time needs, and the other for historical data analysis. I'm not too happy with this as well, as it takes away the 'single version of truth' away from a Business Intelligence system.
</p><p>Comments anyone?</p><img src="http://geekswithblogs.net/nestor/aggbug/115045.aspx" width="1" height="1" />http://geekswithblogs.net/nestor/comments/115045.aspx0http://geekswithblogs.net/nestor/comments/commentRss/115045.aspxhttp://geekswithblogs.net/nestor/services/trackbacks/115045.aspxT-SQL – 1 million records in 1 secondhttp://geekswithblogs.net/nestor/archive/2007/08/23/114925.aspx2007-08-23T10:44:30-12:00:002007-08-30T20:24:24Z<p>I thought this is worth noting. This is the <a href="http://blog.namwarrizvi.com/2007/08/generating-1-million-rows-in-less-than.html">way</a> to generate 1 million records within 1 second in SQL Server 2005. I'll have the code pasted here so that I can have a reference the next time I need to use it. As Namwar Rizvi said, this code is proposed <strong>in SQL Server 2005 TSQL Querying</strong> by <strong>Microsoft press</strong>.
</p><p><br />--Declare a variable to hold the<br />--count of rows to be generated
</p><p>Declare @p_NumberOfRows Bigint
</p><p>--We need 1 million rows
</p><p>With Base As<br />(<br />Select 1 as n<br />Union All<br />Select n+1 From Base Where n < Ceiling(SQRT(@p_NumberOfRows))<br />),<br />Expand As<br />(<br />Select 1 as C<br />From Base as B1, Base as B2<br />),<br />Nums As<br />(<br />Select Row_Number() OVER(ORDER BY C) As n<br />From Expand<br />)<br />Select n from Nums Where n<=@p_NumberOfRows<br /><br />--Remove Maximum Recursion level constraint
</p><p>OPTION (MaxRecursion 0);
</p><img src="http://geekswithblogs.net/nestor/aggbug/114925.aspx" width="1" height="1" />http://geekswithblogs.net/nestor/comments/114925.aspx3http://geekswithblogs.net/nestor/comments/commentRss/114925.aspxhttp://geekswithblogs.net/nestor/services/trackbacks/114925.aspxBlogging from Word 2007http://geekswithblogs.net/nestor/archive/2007/08/20/114814.aspx2007-08-20T12:57:18-12:00:002007-08-30T20:24:35Z<p>It has been a while since I last posted. Thanks to all the changes that's happening in my life. New job, new role, new technology and a new laptop. Anyway, so I heard that Word 2007 supports blog publication, which is a really neat feature.
</p><p>I got it set up with the following few steps
</p><ol><li>Select publish to Blog
</li><li>Select 'others' for blog type
</li><li>Type in 'http://geekswithblogs.net/(your blog)/services/metablogapi.aspx'
</li></ol><p>There you go, start blogging away. Cheers. </p><img src="http://geekswithblogs.net/nestor/aggbug/114814.aspx" width="1" height="1" />http://geekswithblogs.net/nestor/comments/114814.aspx3http://geekswithblogs.net/nestor/comments/commentRss/114814.aspxhttp://geekswithblogs.net/nestor/services/trackbacks/114814.aspxSQLServer Vs MySQLhttp://geekswithblogs.net/nestor/archive/2007/07/01/113626.aspx2007-07-01T21:49:55-12:00:002007-07-01T21:49:55Z<p>Here's a pretty decent comparison done on <a href="http://swik.net/MySQL/MySQL+vs+MS+SQL+Server" target="_blank">SQLServer against MySQL</a>. I'm not a big fan of MySQL, but recently I got into a project which requires me to evaluate the possibility of using MySQL on a enterprise level datawarehouse. </p> <p>As horrific as it may sound to me, I need to convince with technical proof, that MySQL is not suitable for enterprise level datawarehousing.</p> <p>If there's anyone out that who's already using MySQL on an enterprise, it'll be great to hear from you!</p><img src="http://geekswithblogs.net/nestor/aggbug/113626.aspx" width="1" height="1" />http://geekswithblogs.net/nestor/comments/113626.aspx0http://geekswithblogs.net/nestor/comments/commentRss/113626.aspxhttp://geekswithblogs.net/nestor/services/trackbacks/113626.aspxHow do you invoke a Workflow from WCF Service?http://geekswithblogs.net/nestor/archive/2007/04/11/111359.aspx2007-04-11T11:32:00-12:00:002007-04-11T11:32:00Z<p>It took me a while to come to this blog post from <a href="http://community.bartdesmet.net/blogs/bart/archive/2006/09/04/4392.aspx" target="_blank">Bart</a>. He wrote a very simple and easy to understand article on how you can invoke a workflow engine from a IIS / Self Hosted WCF service. </p> <p>This is very useful from the layered architecture perspective since most service-oriented systems will not have the presentation layer calling the workflow engine directly. More often than not (depending on the complexity of the system), you will want to inject a communication service layer in the middle to handle the Workflow call. </p> <p>Great article there, <a href="http://community.bartdesmet.net/blogs/bart/archive/2006/09/04/4392.aspx" target="_blank">go read it</a> if you're into this kind of architecture.</p><img src="http://geekswithblogs.net/nestor/aggbug/111359.aspx" width="1" height="1" />http://geekswithblogs.net/nestor/comments/111359.aspx0http://geekswithblogs.net/nestor/comments/commentRss/111359.aspxhttp://geekswithblogs.net/nestor/services/trackbacks/111359.aspxQuick guide in accessing WCF Service via Web Applicationhttp://geekswithblogs.net/nestor/archive/2007/03/06/108044.aspx2007-03-06T10:40:00-12:00:002007-03-06T10:40:00Z<P>I was writing a proof of concept which uses WCF, WF and ASP.Net 2.0 and across some problems when I tried to call a WCF service from the web application client. Turned out that I spent an hour wasted trying to debug my application because I did not place the proxy.cs file into the App_Code of the web application. </P>
<P>I had it documented down and wrote a simple and straight forward tutorial on how you can use a web application to access and call a WCF Service. The article is uploaded into the article section <A href="http://geekswithblogs.net/nestor/articles/108042.aspx">here</A><BR><BR>Hopefully this tutorial can be useful for someone. </P><img src="http://geekswithblogs.net/nestor/aggbug/108044.aspx" width="1" height="1" />http://geekswithblogs.net/nestor/comments/108044.aspx1http://geekswithblogs.net/nestor/comments/commentRss/108044.aspxhttp://geekswithblogs.net/nestor/services/trackbacks/108044.aspxiPhone, WPF and Pocket PChttp://geekswithblogs.net/nestor/archive/2007/03/05/107929.aspx2007-03-05T09:16:00-12:00:002007-03-05T09:16:00Z<p>I was pretty excited over Apple's new <a href="http://www.apple.com/iphone/" target="_blank">iPhone</a> after witnessing its slick interface in YouTube, and decided that my dependency on the Pocket PC driven by the Windows Mobile platform will have to go.</p> <p>That is until I see <a href="http://www.engadget.com/2007/03/01/pocket-pc-gets-iphone-makeover/" target="_blank">this</a>. </p> <p><a href="http://tzywen.com/modules.php?name=News&file=article&sid=331" target="_blank">Somebody</a> actually made an iPhone replica sitting on the Pocket PC. Very impressive. It's a shame that the video has been taken down on YouTube due to pressures from you-know-who. The interface replica was written using a PPC development tool called <a href="http://www.arianesoft.ca/" target="_blank">PPL (Pocket PC Language) by ArianeSoft.</a></p> <p>Now that a look at the new <a href="http://www.engadget.com/2007/02/23/samsung-ultra-messaging-a-peek-at-the-future-of-windows-mobile/" target="_blank">Samsung Ultra Messaging</a> on Windows Mobile 6. In my opinion, it looked very similar to iPhone's interface style. </p> <p>Now for those of us who has been fooling around with WPF, we're well aware that WPF will serve as a very good SDK for development of applications look and behave like iPhone, or even better. I wonder if Microsoft is already looking at making Windows Mobile 6 capable of running WPF applications?</p><img src="http://geekswithblogs.net/nestor/aggbug/107929.aspx" width="1" height="1" />http://geekswithblogs.net/nestor/comments/107929.aspx0http://geekswithblogs.net/nestor/comments/commentRss/107929.aspxhttp://geekswithblogs.net/nestor/services/trackbacks/107929.aspx