User Tips: Calculate the Date After a Given Number of Business Days   30 Apr 2006 00:00 GMT

An issue came up recently where a client needed to wait a certain number of business days before taking an action. In particular, they wanted to know, given a certain date (such as today), on what date should the action be taken if we must wait 15 business days. A business day is defined as any weekday that is not a holiday.

I provided this capability using a user defined function (UDF) in SQL Server 2000. Read on to learn more!

See all User Tips...
Read More >

Source: 4GuysFromRolla

Search Engine Indexing Limits: Where Do the Bots Stop?   28 Apr 2006 04:00 GMT
Ever wondered how much of each of your pages is being crawled by the search engines? Serge has, which is why he conducted an experiment to test the exact page size that could be crawled by the search bots, and identify the indexation limit of each. Here, he reveals the results of his study.
Source: SitePoint

Domain-specific Modeling: Making Code Generation Complete   27 Apr 2006 18:35 GMT
Domain-specific modeling is most successful when the models let you generate complete working code, without the need for post-generation code modifications or additions. The examples and guidelines in this article show you how.
Source: DevX

Accelerate your VS 2005 skills with 59 core and advanced online workshops from Microsoft Learning   27 Apr 2006 18:01 GMT
Learn by doing in these hands-on workshops. Each online workshop covers a specific topic within one of 4 main areas, Windows and Web Development, Data/XML and Distributed Application development. Each workshop includes both C# and Visual Basic code.
Source: MSDN

Creating a Generic Message Display Page for ASP.NET   27 Apr 2006 01:10 GMT
Find out how to create a generic message class that displays an attractive, informative message in your Web application—with just one line of code.
Source: DevX

Create Reports from Any Data Source Using SQL Server Reporting Services Custom Data Extensions   26 Apr 2006 00:04 GMT
SQL Server Reporting Services makes it easy to build reports from database data, but what if the data isn't in a database? This article shows you how to take advantage of Reporting Services' unique extensibility model to build reports from ADO.NET datasets.
Source: DevX

A More Efficient Method for Paging Through Large Result Sets   26 Apr 2006 00:00 GMT

It is amazing the amount of cycles, hardware and brain ware, go into paging results efficiently. Recently Scott Mitchell authored an article titled Efficiently Paging Through Large Result Sets in SQL Server 2000 that looked at a stored procedure that returned a particular "page" of data from a table. After examining Scott's approach, I saw some potential improvements in his method. (If you haven't yet perused Scott's technique, take a moment to do so before continuing here, as this article builds upon Scott's example.)

Scott's approach made use of a table variable to generate a synthetic ID to act as a row counter. Every time a page is requested, all of the data in the table being paged must be read and inserted into the table variable in order to generate the synthetic ID, at which point a SELECT statement returns just those records whose IDs fall within the desired range. While Scott's method is faster than blindly returning all of the records, his approach can be greatly improved by using ROWCOUNT to greatly reduce the number of records that must be read and inserted into the table variable.

In this article we'll look at two ways to improve Scott's method. The first approach uses a table variable (just like Scott's), but utilizes the SET ROWCOUNT command to reduce the number of records read and inserted into the table variable. The second technique more cleverly uses SET ROWCOUNT to provide an even more efficient approach than the first. Read on to learn more!
Read More >

Source: 4GuysFromRolla

Solve Problems when Running ASP.NET Web Applications and Skype Simultaneously   25 Apr 2006 18:03 GMT
Skype automatically uses port 80 if it's not otherwise occupied. This causes an error when you try to open Web applications in .NET.
Source: DevX

How to Win With Google AdWords   24 Apr 2006 09:02 GMT
If you're not on the Google AdWords bandwagon, you should be! As Neil explains, this system, which is making money for site owners around the world, is easy to set up and use, and makes campaign tracking and tweaking a cinch.
Source: SitePoint

Sample Application: Fabrikam Fine Furniture   21 Apr 2006 23:58 GMT
The Fabrikam Fine Furniture reference application is a feature-rich, fully-functional reference application to assist you in building mobile PC and Tablet PC solutions.
Source: MSDN