Slow Start - Testaments and Books</h1> <article> <h1>Slow Start - Testaments and Books</h1> <p>jop — Wed, 26 Nov 2008 02:32:00 GMT</p> Here is my answer to Keith's Bible App challenge . I know the deadline has already passed but I want to do it the TDD way, so here it is. Again, the requirements. The user should be able to search for books based on a selected Testament (Old and New). The user should be able to see the contents of each Book The user should be able to search the contents of the Bible based on different search criterias like "Luke", "Genesis 1", "John 3:16", "love", "Abraham"...(<a href="http://devpinoy.org/blogs/jop/archive/2008/11/26/slow-start-testaments-and-books.aspx">read more</a>) </article> <article> <h1>TDD Step by Step, Part 2: The Database</h1> <p>cruizer — Mon, 24 Nov 2008 03:37:00 GMT</p> Welcome to part two of our series on building a Windows application using test-driven development (TDD). In the previous article we drove the design of our entity classes and data access layer by means of unit tests. The unit tests acted more as specifications for the system rather than tests, since we actually weren’t testing any output from our system. We simply used the tests to illustrate how we want to interact with our data access layer and what properties are exposed for each entity...(<a href="http://devpinoy.org/blogs/cruizer/archive/2008/11/24/tdd-step-by-step-part-2-the-database.aspx">read more</a>) </article> <article> <h1>TDD Step by Step, Part 1</h1> <p>cruizer — Mon, 24 Nov 2008 00:37:00 GMT</p> In a hot discussion thread in msforums.ph about the value of unit testing and adopting test-driven development (TDD), a suggestion was made to illustrate how TDD is used in creating a simple application, specifically Keith's October code challenge . In response to that, I've decided to write a series of articles showing exactly how this can be done. I guess there's no better way to show the value of TDD than by showing how it's done! I'll be using Visual Studio 2008 for this tutorial...(<a href="http://devpinoy.org/blogs/cruizer/archive/2008/11/24/tdd-step-by-step-part-1.aspx">read more</a>) </article> <article> <h1>Markdown Viewer</h1> <p>jop — Mon, 24 Nov 2008 00:30:00 GMT</p> I'm not really fond of browser based text editors - especially the one used in here in devpinoy. I still write my posts using my favorite editor - gvim , and then paste them over to the blog software. That is sufficient if you are only writing plain text all the time. What if you wanted to have code in your post and you want it to have syntax highlighting? The only browser-based editor that I can tolerate is the one in StackOverflow and it uses Markdown . Markdown is a text-to-HTML conversion...(<a href="http://devpinoy.org/blogs/jop/archive/2008/11/24/markdown-viewer.aspx">read more</a>) </article> <article> <h1>JUnit with Netbeans</h1> <p>lamia — Sun, 16 Nov 2008 03:39:00 GMT</p> <p>In my office, TDD is a new methodology that we've just began adopting. My senior wrote a TestCase class before he left the company. Thanks to him, I got some sample codes to study.</p> <p>After baby sitting, I decided to open my computer and fire up netbeans. We're using RAD at my work btw, I could use eclipse but I like netbeans for learning something new or trying out small things. Oh, that makes me an unofficial netbeans evangelist at the same time! Lolz!</p> <p>Using the JBible app I created a few weeks ago, I created a simple JUnit test class that tests one of my DAO(Data Access Object) methods. </p> <p></p> <p> </p> <p>What did I gain?</p> <p>1. For some reason, I actually enjoyed doing it.</p> <p>2. I can now officially perform TDD at my work! Though it may take a while to improve on that. My knowledge of TDD is not so advanced afterall.</p> <p>3. I don't know if it's right to say, but in netbeans you get instant profiling of your methods(if you look on the lower-left where the test status are).</p> <p> </p> <p>There are probably more complicated scenarios to test against. For now, this will do for me.</p> <p>Below is the code I used for testing. Please forgive the formatting. Also, if you have comments on things like how I can improve my test code, please don't hesitate to comment. I would also appreciate if you could give me pointers so I could get better at this.</p> <p>Special thanks to Jop and Cruizer, though I may never become an advocate of TDD as you are guys.</p> <p><br />package org.devpinoy.bibleapp.dao.test;<br /><br />import java.sql.SQLException;<br />import java.util.List;<br />import java.util.logging.Level;<br />import java.util.logging.Logger;<br />import org.devpinoy.bibleapp.dao.BibleDAO;<br />import org.devpinoy.bibleapp.dao.DAOHelper;<br />import org.devpinoy.bibleapp.dao.exceptions.NoBookFoundException;<br />import org.devpinoy.bibleapp.dao.impl.BibleDAOImpl;<br />import org.devpinoy.bibleapp.dto.Book;<br />import org.junit.After;<br />import org.junit.AfterClass;<br />import org.junit.Before;<br />import org.junit.BeforeClass;<br />import org.junit.Test;<br />import static org.junit.Assert.*;<br /><br />public class BibleDAOTest {<br /><br /> BibleDAO bibleDAO;<br /> <br /> public BibleDAOTest() {<br /> }<br /><br /> @BeforeClass<br /> public static void setUpClass() throws Exception {<br /> }<br /><br /> @AfterClass<br /> public static void tearDownClass() throws Exception {<br /> }<br /><br /> @Before<br /> public void setUp() {<br /> try {<br /> bibleDAO = new BibleDAOImpl(DAOHelper.getAccessDBConnection("C:/BibleDB/BibleDB.mdb"));<br /> }<br /> catch (SQLException ex) {<br /> Logger.getLogger(BibleDAOTest.class.getName()).log(Level.SEVERE, null, ex);<br /> }<br /> }<br /><br /> @After<br /> public void tearDown() {<br /> bibleDAO = null;<br /> }<br /> <br /> @Test<br /> public void bibleDAOTest(){<br /> assertNotNull("BibleDAO is null, everything else will fail", bibleDAO);<br /> }<br /> <br /> @Test<br /> public void getBookListTest(){<br /> List bookList = null;<br /> <br /> try {<br /> bookList = bibleDAO.getBookList();<br /> } <br /> catch (NoBookFoundException ex) {<br /> Logger.getLogger(BibleDAOTest.class.getName()).log(Level.SEVERE, null, ex);<br /> }<br /> <br /> assertNotNull("List should not be null", bookList);<br /> assertTrue("List should have value greater than zero", bookList.size() > 0);<br /> <br /> System.out.println("Book list size: " + bookList.size() );<br /> <br /> for (int i = 0; i < bookList.size(); i++){<br /> Book book = (Book)bookList.get(i);<br /> <br /> System.out.println("Book" + i + ": " + book);<br /> <br /> assertTrue("Only book instance should exist inside getBookList", book instanceof Book);<br /> assertNotNull("Book should not be null", book);<br /> }<br /> <br /> }<br /> <br /> @Test<br /> public void testNothing(){<br /> System.out.println("Testing nothing");<br /> }<br /><br />}</p> <p> </p><div style="clear:both;"></div> </article> <article> <h1>Creating SQL Server Login From A Domain Account To Access System Directory</h1> <p>marl — Sat, 15 Nov 2008 08:00:00 GMT</p> <p><span style="color:#2a2a2a;font-family:Verdana;"> <p style="line-height:1.5em;margin-right:0px;margin-bottom:15px;margin-left:0px;margin-top:-10px;border-bottom-width:1px;border-bottom-style:solid;border-bottom-color:#b0b0b0;padding:0px;" class="date">Posted by <a style="font-weight:bold;text-decoration:none;color:#0b6d90;" href="http://dbalink.wordpress.com/">MarlonRibunal</a></p> <div style="overflow-x:hidden;overflow-y:hidden;" class="entry"> <div class="snap_preview"> <p style="line-height:1.5em;margin-top:0px;margin-right:0px;margin-bottom:15px;margin-left:0px;padding:0px;">I was having a problem accessing a folder via an extended procedure. The extended procedure accepts a DirectoryInfo variable (File Path) and it returns the File Size and File Count within the folder (much like right-clicking a folder and choosing the “Properties” from the context menu). I need the info to monitor the file size of specific folders for a SSRS report.</p> <p style="line-height:1.5em;margin-top:0px;margin-right:0px;margin-bottom:15px;margin-left:0px;padding:0px;">Executing the extended procedure causes the SQL Server to throw the following error:</p> <p style="text-align:center;line-height:1.5em;margin-top:0px;margin-right:0px;margin-bottom:15px;margin-left:0px;padding:0px;" class="MsoNormal"></p> <p style="line-height:1.5em;margin-top:0px;margin-right:0px;margin-bottom:15px;margin-left:0px;padding:0px;" class="MsoNormal">The SQL Server Error Log translates this to be a “EXCEPTION_ACCESS_VIOLATION”. Switching to Windows Authentication would not solve the problem. I could not really drill down to the error because it is apparent that this is a Windows Operating System error. My lack of familiarity with the network environment makes it hard for me to investigate the error. The Windows Event Viewer could not give me useful information pertaining to the error. I do not want to tweak the access rules on the folders that my extended procedure needs in fear of opening holes of vulnerability (these folders are being used by a ASP.NET Web application for file storage).</p> <p style="line-height:1.5em;margin-top:0px;margin-right:0px;margin-bottom:15px;margin-left:0px;padding:0px;" class="MsoNormal">To circumvent a possible security violation and to keep the security compliance intact, I decided to map the <a style="font-weight:bold;text-decoration:none;color:#0b6d90;" href="http://msdn.microsoft.com/en-us/library/ms675915(VS.85).aspx">Domain Account</a> to a SQL Server Login. That solved the access violation error. </p> <p style="line-height:1.5em;margin-top:0px;margin-right:0px;margin-bottom:15px;margin-left:0px;padding:0px;" class="MsoNormal">This is how you create a SQL Server Login from a Domain Account:</p> <p style="line-height:1.5em;margin-top:0px;margin-right:0px;margin-bottom:15px;margin-left:0px;padding:0px;" class="MsoNormal"></p> <p style="line-height:1.5em;margin-top:0px;margin-right:0px;margin-bottom:15px;margin-left:0px;padding:0px;" class="MsoNormal"> </p> <p style="line-height:1.5em;margin-top:0px;margin-right:0px;margin-bottom:15px;margin-left:0px;padding:0px;" class="MsoNormal"> <a style="font-weight:bold;text-decoration:none;color:#0b6d90;" href="http://www.dotnetkicks.com/kick/?url=http%3a%2f%2fdbalink.wordpress.com%2f2008%2f11%2f14%2fcreating-sql-server-login-from-a-domain-account-to-access-system-directory%2f"></a></p> <p style="line-height:1.5em;margin-top:0px;margin-right:0px;margin-bottom:15px;margin-left:0px;padding:0px;" class="MsoNormal">[Cross-Posted from my other blog: <a href="http://dbalink.wordpress.com/">http://dbalink.wordpress.com</a>]</p> </div> </div> </span></p><div style="clear:both;"></div> </article> <article> <h1>IsNullOrEmpty with a Twist on T-SQL</h1> <p>dotnetrandz — Tue, 11 Nov 2008 14:39:00 GMT</p> <p>This may be very elementary for others but I am happy to find a solution on my problem on finding the equivalent of .NET's IsNullOrEmpty with a twist on T-SQL. It's with a twist because I am hoping to find a similar solution that IsNull function is doing: The T-SQL <code style="font-size:12px;"><span style="color:blue;">select</span> <span style="color:#ff00dc;">isnull</span>(columnName, <span style="color:red;">'Value is null'</span>) <span style="color:blue;">from</span> myTable</code> means return the value of 'columnName' column if it is not null, otherwise, return <code style="font-size:12px;"><span style="color:red;">'Value is null'</span> </code> string. </p> <p>I was hoping to extend this functionality by adding a check for empty string. So my search for <code>IsNullOrEmpty</code> for T-SQL began.</p> <p> The solution I found was actually very simple. No need for UDF. See below: </p> <p> <code style="font-size:12px;"><span style="color:blue;">select</span> Id, <span style="color:#ff00dc;">isnull</span>(<span style="color:#ff00dc;">nullif</span>(StreetName,<span style="color:red;">''</span>)+<span style="color:red;">', '</span>,<span style="color:red;">''</span>) <span style="color:blue;">from</span> Addresses</code>.</p> <p>This means, if the value of StreetName is not null or empty, return the value of StreetName plus the comma (,), otherwise, return an empty string.</p> <p>There may be a solution or solutions that addresses the same issue but with the limited time that I have, this is enough for me for now.</p><div style="clear:both;"></div> </article> <article> <h1>Free Coding Assistance Add-in for Visual Studio 2008 from DevExpress</h1> <p>keithrull — Fri, 07 Nov 2008 18:24:00 GMT</p> <p> I just love the guys from <a href="http://www.devexpress.com/">DevExpress</a>!</p> <p>First, they gave away a free version of Refactor! for <a href="http://www.devexpress.com/Products/Visual_Studio_Add-in/VBRefactor/">VB.NET</a>, <a href="http://www.devexpress.com/Products/Visual_Studio_Add-in/RefactorASP/">ASP.NET</a> and <a href="http://www.devexpress.com/Products/Visual_Studio_Add-in/RefactorCPP/">C++</a>. Next, they gave away their <a href="http://www.devexpress.com/Products/Free/WebRegistration/">.NET components</a> for FREE and I mean really FREE! And now they are treating us with <a href="http://www.devexpress.com/Products/Visual_Studio_Add-in/CodeRushX/">CodeRush Xpress</a>!</p> <blockquote style="margin-right:0px;" dir="ltr"> <p><em><span style="font-family:Georgia;"><strong>"</strong>CodeRush Xpress is freely available to all Visual Studio 2008 developers and offers a comprehensive suite of tools that enable you and your team to simplify and shape complex code - making it easier to read and less costly to maintain.<strong>"</strong></span></em></p> </blockquote> <p>I've been using CodeRush + Refactor Pro! for 3+ years now and I could say that it is great productivity tool for any .NET developer. I just love it! It's one of those things that would get you hooked to it wit your first Ctrl+~. </p> <p>To prove my point that this is great, look at what happened to <a href="http://www.codinghorror.com/blog">Jeff</a>'s IDE <a href="http://www.codinghorror.com/blog/archives/000528.html">after installing CodeRush and Refactor</a>!</p> <p></p> <p>Seriously, It really makes coding that fun when you have CodeRush and Refactor Pro installed (I'm not saying you can play a game inside your IDE, but you got the point right?).</p> <p>CodeRush Xpress installs a subset of the functionality that you can find with CodeRush and Refactor Pro! but it's worth the download considering the amount of productivity you will gain from these set of functionalities:</p> <blockquote> <p>CodeRush Xpress includes the following features.</p> <ul> <li>Duplicate Line </li> <li>Highlight All References </li> <li>Increase or Reduce Selection </li> <li>Smart Clipboard Operations </li> <li>Generate from Using (TDD) </li> <li>Quick Navigation Window </li> <li>Quick File Navigation </li> </ul> <p>Additionally CodeRush XPress includes this refactorings</p> <ul> <li>Add Block Delimiters </li> <li>Combine Conditionals </li> <li>Compress to Lambda Expression </li> <li>Compress to Ternary Expression </li> <li>Convert to Auto-implemented Property </li> <li>Convert to Initializer </li> <li>Create Backing Store </li> <li>Decompose Initializer </li> <li>Decompose Parameter </li> <li>Expand Lambda Expression </li> <li>Expand Ternary Expression </li> <li>Extract Method </li> <li>Flatten Conditional </li> <li>Inline Delegate </li> <li>Inline Temp </li> <li>Introduce Local </li> <li>Make Explicit </li> <li>Make Implicit </li> <li>Move Type to File </li> <li>Name Anonymous Method </li> <li>Name Anonymous Type </li> <li>Reverse Conditional </li> <li>Split Conditional </li> <li>Use String.Format </li> <li>Use StringBuilder </li> </ul> </blockquote> <p>What are you waiting for? Go ahead and download <a href="http://www.devexpress.com/Products/Visual_Studio_Add-in/CodeRushX/">CodeRushX</a>! I promise you, you wont regret it!</p><div style="clear:both;"></div> </article> <article> <h1>Not a PC</h1> <p>jop — Fri, 07 Nov 2008 09:14:00 GMT</p> (Please visit the site to view this media) John Hodgman: A brief digression on matters of lost time....(<a href="http://devpinoy.org/blogs/jop/archive/2008/11/07/i-m-not-just-a-pc.aspx">read more</a>) </article> <article> <h1>And so it began...</h1> <p>dotnetrandz — Fri, 07 Nov 2008 05:25:00 GMT</p> <p>A great <a target="_blank" title="Lao Tzu" href="http://www.quotationspage.com/quotes/Lao-tzu/">Chinese philosopher</a> once said, "<i>A journey of a thousand miles begins with a single step</i>."</p> <p>Today, I am taking my first step in a journey that I hope will be fruitful and useful, both for me and whoever may have the chance to read my blogs.</p><div style="clear:both;"></div> </article> <article> <h1>Google Tech Talks -- Unit Testing</h1> <p>jop — Thu, 06 Nov 2008 23:35:00 GMT</p> (Please visit the site to view this media) A 32-min intro on unit testing. Watch it. Four stars....(<a href="http://devpinoy.org/blogs/jop/archive/2008/11/07/google-tech-talks-unit-testing.aspx">read more</a>) </article> <article> <h1>How To: Moving Data Files</h1> <p>marl — Thu, 06 Nov 2008 23:10:00 GMT</p> <p><span style="color:#2a2a2a;font-family:Verdana;"> <h2 style="font-size:1.6em;color:#606060;"><span style="color:#2a2a2a;font-weight:normal;line-height:20px;"><span style="font-size:xx-small;">Posted by </span><a href="http://dbalink.wordpress.com/" style="font-weight:bold;text-decoration:none;color:#0b6d90;"><span style="font-size:xx-small;">MarlonRibunal</span></a></span></h2> <div class="entrytext" style="overflow-x:hidden;overflow-y:hidden;padding-top:0px;"> <div class="snap_preview"> <p style="line-height:1.5em;margin-top:0px;margin-right:0px;margin-bottom:15px;margin-left:0px;padding:0px;">In this post let’s move a data file from its default location to another location. I have created a database I called “Test” for the demo. First let’s just check where the data file is currently stored:</p> <p style="line-height:1.5em;margin-top:0px;margin-right:0px;margin-bottom:15px;margin-left:0px;padding:0px;"></p> <p style="line-height:1.5em;margin-top:0px;margin-right:0px;margin-bottom:15px;margin-left:0px;padding:0px;">The “Test” database needs to be put offline before we can move the data file. We do that by issuing the following ALTER DATABASE statement:</p> <p style="line-height:1.5em;margin-top:0px;margin-right:0px;margin-bottom:15px;margin-left:0px;padding:0px;"></p> <p style="line-height:1.5em;margin-top:0px;margin-right:0px;margin-bottom:15px;margin-left:0px;padding:0px;">To actually move the data file, we issue another ALTER DATABASE statement:</p> <p style="line-height:1.5em;margin-top:0px;margin-right:0px;margin-bottom:15px;margin-left:0px;padding:0px;"></p> <p style="line-height:1.5em;margin-top:0px;margin-right:0px;margin-bottom:15px;margin-left:0px;padding:0px;">After you issue that command, you should get the following message:</p> <blockquote style="padding-top:10px;padding-right:10px;padding-bottom:0px;padding-left:10px;margin:30px;border:1px dashed #b0b0b0;"> <p style="line-height:1.5em;margin-top:0px;margin-right:0px;margin-bottom:10px;margin-left:0px;padding:0px;">The file “TEST” has been modified in the system catalog. The new path will be used the next time the database is started.</p> </blockquote> <p style="line-height:1.5em;margin-top:0px;margin-right:0px;margin-bottom:15px;margin-left:0px;padding:0px;">Now, we can move the data file to the new directory we specified (Cut-and-Paste or Drag-and-Drop, your choice) . Let’s double check if we have successfully moved the data file to the new location; but, we need to put the TEST database back online first:</p> <p style="line-height:1.5em;margin-top:0px;margin-right:0px;margin-bottom:15px;margin-left:0px;padding:0px;"></p> <p style="line-height:1.5em;margin-top:0px;margin-right:0px;margin-bottom:15px;margin-left:0px;padding:0px;">Let’s query the sys.master_files again to make sure we have our data file where we want it:</p> <p style="text-align:center;line-height:1.5em;margin-top:0px;margin-right:0px;margin-bottom:15px;margin-left:0px;padding:0px;"></p> <p style="text-align:left;line-height:1.5em;margin-top:0px;margin-right:0px;margin-bottom:15px;margin-left:0px;padding:0px;"> </p> <p style="text-align:left;line-height:1.5em;margin-top:0px;margin-right:0px;margin-bottom:15px;margin-left:0px;padding:0px;"> </p> <p style="line-height:1.5em;margin-top:0px;margin-right:0px;margin-bottom:15px;margin-left:0px;padding:0px;"><a href="http://www.dotnetkicks.com/kick/?url=http%3a%2f%2fdbalink.wordpress.com%2f2008%2f11%2f06%2fhow-to-moving-data-files%2f" style="font-weight:bold;text-decoration:none;color:#0b6d90;"></a></p> <p style="line-height:1.5em;margin-top:0px;margin-right:0px;margin-bottom:15px;margin-left:0px;padding:0px;">[Cross-posted from my other blog <a href="http://dbalink.wordpress.com">http://dbalink.wordpress.com</a> ]</p> </div> </div> </span></p><div style="clear:both;"></div> </article> <article> <h1>I told you so.</h1> <p>jop — Tue, 04 Nov 2008 11:10:00 GMT</p> I can't stop but smile at what I've written in this forum thread . A decade ago, I am constantly having this similar debate with my managers, project leader, team leader, quality engineers, etc. about the merits of unit testing. As I was still inexperienced then, I am not really in favor of unit testing because (1) I'm the one doing the task, (2) I have to spend a lot of time doing it - that takes away from 'coding' time, and (3) I can't see the benefit of doing it because...(<a href="http://devpinoy.org/blogs/jop/archive/2008/11/04/i-told-you-so.aspx">read more</a>) </article> <article> <h1>Microsoft Office SharePoint Server 2007 and Windows SharePoint Services 3.0 SP2</h1> <p>elczara — Tue, 04 Nov 2008 07:48:00 GMT</p> <p>The Microsoft SharePoint Product Group and the Microsoft Office Service Pack Team announced the Service Pack 2 for Microsoft Office System which will be released between February and April 2009. Some SharePoint-related highlights that we could expect are: </p> <ol> <li><span style="font-family:'Calibri','sans-serif';"><font size="2"><font face="Tahoma">Performance and manageability improvements including STSADM commands for repairing links between source and target pages.</font></font></span> </li> <li><span style="font-family:'Calibri','sans-serif';"></span><span style="font-family:'Calibri','sans-serif';"><font face="Tahoma"><font size="2">Improvements to read-only content databases and index rebuild timer jobs.</font></font></span></li> </ol> <p><span style="font-family:'Calibri','sans-serif';"><font face="Tahoma" size="2">For more information:</font></span> </p> <p><span style="font-family:'Calibri','sans-serif';"><font face="Tahoma" size="2" color="#81a5f8"><a href="http://http//blogs.msdn.com/sharepoint/archive/2008/10/24/prepare-for-the-upcoming-office-sharepoint-server-2007-and-windows-sharepoint-services-3-0-service-pack-2.aspx" target="_blank">Microsoft SharePoint Team</a></font></span> </p> <p><span style="font-family:'Calibri','sans-serif';"><font face="Tahoma" size="2" color="#81a5f8"><a href="http://blogs.technet.com/office_sustained_engineering/archive/2008/10/22/announcing-service-pack-2-sp2-for-the-2007-microsoft-office-system.aspx" target="_blank">Office Sustained Engineering</a></font></span> </p> <p><span style="font-family:'Calibri','sans-serif';"><font face="Tahoma" size="2">Thanks.</font></span></p><div style="clear:both;"></div> </article> <article> <h1>Data Access with LINQ</h1> <p>cruizer — Mon, 03 Nov 2008 23:25:00 GMT</p> I discussed LINQ (LINQ to objects, XML, then SQL) during the Microsoft TechFEST event here in Singapore, and the slides are here . You can download the sample code as well....(<a href="http://devpinoy.org/blogs/cruizer/archive/2008/11/04/data-access-with-linq.aspx">read more</a>) </article> <article> <h1>JBible - A Java based Bible Application</h1> <p>lamia — Sun, 02 Nov 2008 14:30:00 GMT</p> <p>Well... It was one hell of a week for me and I needed something to remind me how fun programming is. Or used to be hehehe.</p> <p>This was supposed to be an entry to Keith's contest, I unfortunately fell ill a few days before the deadline and wasn't able to continue with it. I had the change to continue working with it so rather than playing video games, I sitted and turned on my computer, and started coding. I tried to stick to my original concept eventhough I've already seen other people's submission (or screenshots).</p> <p>Aside from my first statement, basically the motivation to continue with this app are the following:</p> <p>1. Spread the Gospel</p> <p>2. Utilize Netbean's Swing Editor, I had a lot of fun using it. I had no prior professional experience with Swing so netbeans really made up for that shortcoming.</p> <p>3. Demonstrate to young and starting Java developers how a database driven Swing app might be built using Java. This is actually also my first database driven Swing application.</p> <p>You can open the source in Netbeans 6.1, you need JDK 1.6 installed.</p> <p>God Bless! ;)</p> <p> </p> <p>UPDATE 11/03/2008: I just included an executable jar in the zip file. </p> <p>You also need to place your database in C:\BibleDB\BibleDB.mdb</p> <p>Enjoy!</p> <p></p> <p></p> <p> </p> <p></p> <p> </p> <p> </p><div style="clear:both;"></div> </article> <article> <h1>Microsoft SharePoint Services in Azure Services Platform</h1> <p>elczara — Sun, 02 Nov 2008 05:27:00 GMT</p> <div>With Azure Services Platform in the future, we can build, extend, and enhance our applications in the cloud utilizing SharePoint technology as a building block. The Azure Services Platform is an internet-scale cloud services platform hosted in Microsoft data centers, which provides an operating system and a set of developer services that can be used individually or together, including Live Services, .NET Services, SQL Services, Microsoft SharePoint Services, and Microsoft Dynamics CRM Services.</div> <div> </div> <div>For more information:</div> <div> </div> <div><a href="http://www.microsoft.com/azure/default.mspx" target="_blank"><span style="color:#81a5f8;">Azure Services Platform Site</span></a></div> <div><a href="http://blogs.msdn.com/sharepoint/archive/2008/10/27/pdc-2008-announcing-azure-services-platform-and-microsoft-sharepoint-services.aspx" target="_blank"><span style="color:#81a5f8;">Microsoft SharePoint Team Blog</span></a></div> <div><span style="color:#81a5f8;"></span> </div> <div>Thanks...</div><div style="clear:both;"></div> </article> <article> <h1>WCF: Shifting from HTTP to TCP</h1> <p>cruizer — Sat, 01 Nov 2008 07:23:00 GMT</p> We've decided to shift our project's WCF services from HTTP to TCP. Why? We've got a few reasons: Performance is important. We all know the TCP-based protocol (used by NetTcpBinding) is faster and has lower latency than the HTTP-based protocol (BasicHttpBinding and WsDualHttpBinding). The system was initially envisioned to have its services available to other platforms (even non-.NET). This meant .NET Remoting was out of the picture, and we had to go with web standards. It turns out that...(<a href="http://devpinoy.org/blogs/cruizer/archive/2008/11/01/wcf-shifting-from-http-to-tcp.aspx">read more</a>) </article> <article> <h1>SharePoint Auditing</h1> <p>elczara — Fri, 31 Oct 2008 06:09:00 GMT</p> <p>Microsoft Office SharePoint Server 2007 is bundled with several audit reports valuable to analyze activity across a site collection, or a specific library or list. With the Configure Audit Settings, we could construct the site collection level auditing, and with Information Management Policy we can define the library level policy. The reports can be readily saved in a useful format for review. </p> <p><a href="http://elczara.spaces.live.com/blog/cns!554EC06D366AC9D5!832.entry" target="_blank" title="Details">Details and demonstration videos</a>...</p><div style="clear:both;"></div> </article> <article> <h1>KeithRull.NBible: A WPF Bible Application</h1> <p>keithrull — Fri, 31 Oct 2008 00:09:00 GMT</p> <p> A week ago, I started a contest <strong><a href="http://devpinoy.org/blogs/keithrull/archive/2008/10/21/devpinoy-code-contest-for-october-2008.aspx">at DevPinoy.org</a></strong> about writing a Bible application and a few people have asked me if I tried my own challenge. I actually did took the challenge and built my own Bible application. I wasn't able to post it as soon as I wanted to do it due to time constrainst. What I built is a WPF Bible application but still needs some polishing to truely call it a "WPF app". </p> <p>Now let's begin the tour of the WPF app that I built.</p> <p>The screen below shows the main interface for the program. The first tab is the browsing tab that allows the user to select a Book and a Chapter they want and displays the contents of your selection on the list below the Comboxes</p> <p></p> <p>The bold letters on the upper right side of the list tells you what book and chapter you are currently reading</p> <p></p> <p>The second tab is the search tab. This tab has a textbox that allows you to enter your search parameters</p> <p></p> <p>It allows you to search by keyword\s</p> <p></p> <p>By book and chapter</p> <p></p> <p>or by specifying the Book, Chapter and Verse</p> <p></p> <p>There are a few more things that I wanted to add this app but wasn't able to do so like building a TreeView similar to <strong><a href="http://devpinoy.org/blogs/keithrull/archive/2008/10/27/devpinoy-code-challenge-for-2008-winner.aspx">CryptoKnight's implementation</a></strong> that allows you to see the Document Map and also a matching word highlighting on the search screen would be a great addition too. Another thing that could be improve is refactoring the code and making the service layer a little bit more generic. I wanted to refactor it a bit more after I finished it but never had a chance to do so. I'll leave it as is for now and hope to update it in the future.</p> <p>There's a lot more improvements I could think of but I'll leave it for you guys to check and comment on what I could do with this app to improve it. Maybe we could make it an OpenSource application someday.</p> <p>Anyhow, you can get the source code for this project here. <a href="http://www.keithrull.com/content/binary/KeithRull.NBible.zip"><strong>KeithRull.NBible.zip (1.84 MB)</strong></a></p> <p>Thanks to everyone who tried the challenge. I promise to do more of these type of contest in the future. </p> <p>Again, Thank you, God Bless and Mabuhay ka Filipino Developer!</p><div style="clear:both;"></div> </article> <article> <h1>How To: Summarize Aggregated Data Using Pivot in TSQL</h1> <p>marl — Thu, 30 Oct 2008 05:00:00 GMT</p> <p><span style="color:#2a2a2a;font-family:Verdana;"> <div class="entry" style="overflow-x:hidden;overflow-y:hidden;"> <div class="snap_preview"> <p style="line-height:1.5em;margin-top:0px;margin-right:0px;margin-bottom:15px;margin-left:0px;padding:0px;"><span style="color:#000000;font-family:'Times New Roman';line-height:normal;"> <div style="font-family:Verdana, Arial, Helvetica, sans-serif;font-size:10px;background-image:initial;background-repeat:initial;background-attachment:initial;-webkit-background-clip:initial;-webkit-background-origin:initial;background-color:#ffffff;color:#000000;background-position:initial initial;padding:0.6em;margin:0px;"> <p>This <a href="http://stackoverflow.com/questions/248990/summarize-aggregated-data">question</a> posted on<a href="http://stackoverflow.com/"> StackOverflow.com</a> caught my attention. This is a common data requirement specially in Data Analysis. It goes like this:</p> <blockquote> <p>I have a table like as follows:</p> <pre>SoftwareName Count Country Project 15 Canada Visio 12 Canada Project 10 USA Visio 5 USA</pre> <p>How do I query it to give me a summary like...</p> <pre>SoftwareName Canada USA Total Project 15 10 25 Visio 12 5 17</pre> <p>How to do in T-SQL?</p> </blockquote> <p>Here's my solution to the problem - A Walkthrough:</p> <p>Let's create our test table ("SoftwareDemo")</p> <blockquote> <p> <code style="font-size:12px;"><span style="color:blue;">USE</span> [Test]<br />GO</code></p> <p><code style="font-size:12px;"><span style="color:blue;">CREATE</span> <span style="color:blue;">TABLE</span> [dbo].[SoftwareDemo](<br /> [SoftwareName] [<span style="color:blue;">nvarchar</span>](50) <span style="color:gray;">NOT</span> <span style="color:#a9a9a9;">NULL</span>,<br /> [<span style="color:#ff00dc;">Count</span>] [<span style="color:blue;">int</span>] <span style="color:gray;">NOT</span> <span style="color:#a9a9a9;">NULL</span>,<br /> [Country] [<span style="color:blue;">nvarchar</span>](50) <span style="color:gray;">NOT</span> <span style="color:#a9a9a9;">NULL</span><br />) <span style="color:blue;">ON</span> [<span style="color:blue;">PRIMARY</span>]<br /></code></p> </blockquote> <p>Then, let's insert the sample data:</p> <blockquote> <p><code style="font-size:12px;"><span style="color:blue;">INSERT</span> <span style="color:blue;">INTO</span> SoftwareDemo <span style="color:blue;">VALUES</span> (<span style="color:red;">'Project'</span>, 15, <span style="color:red;">'Canada'</span>)<br /><span style="color:blue;">INSERT</span> <span style="color:blue;">INTO</span> SoftwareDemo <span style="color:blue;">VALUES</span> (<span style="color:red;">'Visio'</span>, 12, <span style="color:red;">'Canada'</span>)<br /><span style="color:blue;">INSERT</span> <span style="color:blue;">INTO</span> SoftwareDemo <span style="color:blue;">VALUES</span> (<span style="color:red;">'Project'</span>, 10, <span style="color:red;">'USA'</span>)<br /><span style="color:blue;">INSERT</span> <span style="color:blue;">INTO</span> SoftwareDemo <span style="color:blue;">VALUES</span> (<span style="color:red;">'Visio'</span>, 5, <span style="color:red;">'USA'</span>)</code></p> <p> </p> </blockquote> <p>Here's our PIVOT query:</p> <blockquote> <p><code style="font-size:12px;"><span style="color:blue;">SELECT</span> Softwarename, Canada, USA, Canada + USA <span style="color:blue;">AS</span> TOTAL <span style="color:blue;">FROM</span> SoftwareDemo <br /> PIVOT <br /> (<br /> <span style="color:#ff00dc;">SUM</span>([<span style="color:#ff00dc;">Count</span>])<br /> <span style="color:blue;">FOR</span> Country<br /> <span style="color:gray;">IN</span> (Canada, USA)<br /> ) <span style="color:blue;">AS</span> x</code></p> </blockquote> <p> </p> <p><code style="font-size:12px;">SoftwareName Canada USA Total<br /><span style="color:#008000;">-------------------------------------------------- ----------- ----------- -----------</span><br />Project 15 10 25<br />Visio 12 5 17</code></p> <p><code style="font-size:12px;">(2 row(s) affected)</code></p> <p><code style="font-size:12px;">(1 row(s) affected)</code></p> <p> </p> <p>Here's our PIVOT TSQL in action:</p> <p><a href="http://dbalink.files.wordpress.com/2008/10/pivot.jpg"></a></p> <p> </p> <p>[Cross-Posted from my other blog <a href="http://dbalink.wordpress.com">http://dbalink.wordpress.com - Marlon Ribunal</a> ]</p> </div> </span></p> <p style="line-height:1.5em;margin-top:0px;margin-right:0px;margin-bottom:15px;margin-left:0px;padding:0px;"><code style="font-size:1.1em;"></code></p> </div> </div> </span></p><div style="clear:both;"></div> </article> <article> <h1>SharePoint Usage Analytics</h1> <p>elczara — Wed, 29 Oct 2008 05:53:00 GMT</p> <p>We must enable usage analytics to measure our SharePoint site usage and performance through the Site Usage Reports and Site Collection Usage Reports of Microsoft Office SharePoint Server 2007 or through Site Usage Reports provided by Microsoft Office SharePoint Designer 2007. </p> <p><a href="http://elczara.spaces.live.com/blog/cns!554EC06D366AC9D5!829.entry" target="_blank" title="Details">Details and demonstation videos</a>...</p><div style="clear:both;"></div> </article> <article> <h1>A mind-opening article</h1> <p>cruizer — Wed, 29 Oct 2008 02:19:00 GMT</p> From MSDN Magazine: Test Your Security IQ Most C/C++ developers should be able to spot all of the security bugs illustrated in the examples; C# coders would find this very informative....(<a href="http://devpinoy.org/blogs/cruizer/archive/2008/10/29/a-mind-opening-article.aspx">read more</a>) </article> <article> <h1>DevPinoy Code Challenge for 2008 Winner</h1> <p>keithrull — Tue, 28 Oct 2008 04:53:00 GMT</p> <p><em><strong>This contest isn't about building a super-mega-ultra-logic-twisting application... It's about taking the challenge and stepping up to show what you got.</strong></em></p> <p>When I started this challenge I was hoping that a lot of Filipino developers would be interested in taking part in such a contest, especially knowing that the prize for this challenge is something that a lot of developers would love to have on their toolbox... Sadly, only one person was willing to stand in the plate and take the challenge in building a Bible application.</p> <p>Without any further delay, I present to you Leon "CryptoKnight" Tayson's submission to the DevPinoy Code Challenge 2008 called eBible.</p> <p> </p> <p><strong><a href="http://devpinoy.org/media/p/31390.aspx" class="null">>> Download eBible here <<</a></strong></p> <p>Congratulations CryptoKnight! You are the winner for this month's Code Challenge. Please let me know your choice among these prizes: <strong>IntelliJ IDEA, ReSharper, Team City(one Build Agent), dotTrace and JetBrain's forthcoming Ruby IDE</strong></p> <p>I hope a lot more people will join our Code Challenges. It's a fun way to learn plus it puts your skills into test. Till next time... Mabuhay ka, Filipino Developer!</p><div style="clear:both;"></div> </article> <article> <h1>GridView To DataSet To Excel</h1> <p>patrick — Sun, 26 Oct 2008 13:50:00 GMT</p> <p>I made a post in my <a href="http://superpatrick.wordpress.com/2008/10/27/gridview-to-dataset-to-excelgridview-to-dataset-to-excel/">Wordpress blog</a> on how to export GridView data to DataSet and eventually to an XML Excel Spreadsheet.</p> <p>You may view the entry there and feel free to post your comments/suggestions.</p><div style="clear:both;"></div> </article> </main></body></html>