A Filipino Developers Community


  • Stored Procedure Versioning

    I have been wanting to put stored procedures in our current project under source control. Although changes to SPs will be minimal, we all know what we can get when we keep history of parts of our code and the ease of comparing them side by side. Searching...
    Posted to jokiz by jokiz on 06-17-2005
  • Banners in websites, what's the logic behind?

    Banners in websites, what's the logic behind? How do these websites and ecommerce companies manage banner/links advertisements. How do they hanlde banner statistics? Do they have an external repository for counting number of times an advertisement was...
    Posted to Rodel E. Dagumampan by rdagumampan on 06-17-2005
    Filed under:
  • SQL BOL(Books Online) Update

    I have just updated my SQL 2000 BOL for the first time and so far, I have noticed the annotations which are majority perf issues (my major concern in programming). You might just want to update yours as well...
    Posted to jokiz by jokiz on 06-16-2005
    Filed under: ,

    Knowing the scenarios involved with the different Isolation Levels for SQL Server, I was surprised to find out a number of stored procedures being used in a project I'm involved with, has retrieval operations with a NOLOCK switch. I was searching for...
    Posted to jokiz by jokiz on 06-16-2005
    Filed under: , , ,
  • Default JOIN type

    Just bumped into a stored procedure made by a teammate using just a JOIN operator on two tables: FROM authors JOIN titleauthors ON ... Confused me a bit until I asked her what it does and she told me that it defaults to an INNER JOIN operation. As usual...
    Posted to jokiz by jokiz on 06-15-2005
    Filed under: ,
  • IS and AS operator

    Boxing and unboxing in C# has a performance cost and the use of the IS and AS operator in casting objects is trivial for me. I thought before that: [code language="C#"] if (boxed is Person) { Person unboxed = boxed as Person; //do something } [/code]...
    Posted to jokiz by jokiz on 06-11-2005
    Filed under: , ,
  • Sending e-mails in SQL Server using XPSMTP

    XPSMTP is the easiest and fastest way to send e-mails in SQL Server. Its is so easy to use. All you need to do is download the DLL to the BINN directory of your SQL Server. Register the XP stored procedure and Grant permission to the stored procedure. XSMTP even supports MSDE. Best of all, IT'S ABSOLUTELY FREE!...
    Posted to Keith Rull by keithrull on 06-10-2005
    Filed under: , ,
  • Disabling AutoScroll for SQL Profiler

    The SQL Profiler is one of the tools that I used in monitoring an SQL Server. The problem I have before was since I always watch the central database during development, I just want to watch a specific block of execution so I use the Pause or Stop buttons...
    Posted to jokiz by jokiz on 06-09-2005
    Filed under: ,
  • Validating inputs with a Cancel button

    I have seen a number of posts like this on newsgroups and it is trivial especially for developers who misuse the events of normal WinForms controls. First are those who use the inefficient TextChanged event of the Windows Forms Textbox for validating...
    Posted to jokiz by jokiz on 06-08-2005
  • ASPNET Validation Controls

    I was reading Stephen Walther’s ASP.NET Unleased book when I found this excellent behavior of Validation Controls. Initially, I thought they just generate client-side scripts to validate them inputs. Then he raised the issue on some browsers with disabled...
    Posted to jokiz by jokiz on 06-08-2005
  • Collapse All in Solution Explorer

    I always use the collapse to definitions/toggle all outlining feature of VS editor. I have long wanted to be able to do the same with solution explorer and this afternoon, I was able to find a macro just for the collapse all through usenet. http://www...
    Posted to jokiz by jokiz on 06-02-2005
    Filed under: , ,
  • Escape the Crimson Room

    I got this from Sahil Malik and it is driving me crazy, i'll try to give it a try some other time, homeward bound...;p/youxi/images/04042203.swf
    Posted to jokiz by jokiz on 05-10-2005
    Filed under:
  • Intellisense - Ambigious name

    Guess what causes this kind of error message in Intellisense?
    Posted to jokiz by jokiz on 05-05-2005
  • Most Common VS IDE mistake

    I think the most common mistake that I always encounter with VS is on adding new projects. I have all the VS family installed (VB.NET, C#, etc.) and I sometimes use VB.NET just for trying some things out. When I want to add a new C# Console Project, I...
    Posted to jokiz by jokiz on 05-04-2005
    Filed under: , ,
  • ISnappinable Interface

    I recently conduct a through study on Microsoft Management Console. MMC is one windows components that i realy admire for its flexibility and power. I run to Code project and MSDN and found useful information on doing snapins and exploring interfaces...
    Posted to Rodel E. Dagumampan by rdagumampan on 05-03-2005
    Filed under:
Copyright DevPinoy 2005-2008