« Back to home

Paging with SQL Server has always been a pain. Although SQL Server 2005 introduced some features that made it possible to page results efficiently more easily than ever before. Paging in SQL Server 2005 at 15 Seconds shows you how to do it with the new ROW_NUMBER() function.…

Read more »

Werner Schuster posted at InfoQ an article entitled “Microsoft Surpasses Java’s Dynamic Language Support” trying to show where .NET is doing better than Java. Some of the highlights are: Microsoft CLR (Common Language Runtime), LINQ and the support for multiple languages DLR (Dynamic Language Runtime) .NET modularization and versioning…

Read more »

LINQ (Language Integrated Query) is one of the most promising technologies for Microsoft®’s .NET. Here are some great resources for those interested in learning more about this generic data query API: LINQ/C# Learning Guide - Quick look at the LINQ extensions and the upcoming release of C# 3.0 in general LINQ in Action - Learn about LINQ, LINQ to SQL (DLINQ) and LINQ to XML (XLINQ) Hooked on LINQ - Developers’ Wiki for .…

Read more »

Great resources for MSSQL DBAs. Taken from InfoQ: Mark Souza of Microsoft has announced a new web site for database administrators and developers called SQL Server - Best Practices. This site offers a wide range of material from top 10 lists suitable for novices to the in-depth technical white papers needed by seasoned professionals. Topics include capacity planning, database mirroring, and bulk data loading. Over a dozen scripts for troubleshooting and performance tuning are also available.…

Read more »

For those who want to take off into the wide blue yonder of ASP.NET 2.0, read Cristian and Zak’s ASP.NET 2.0: A Getting Started Guide. You’ll tame the installation process, sink your teeth into two ASP.NET languages, and conquer .NET programming basics with your bare hands. Finally, you’ll pull server controls, user controls, master pages, and CSS into the beginnings of an application.…

Read more »

Scott Guthrie, Microsoft’s ASP.NET and Atlas development guru, has posted a two-part article on using the Language Integrated Query, or LINQ, within ASP.NET projects. Part 1 how to create the ASP.NET page using LINQ, using rich collections of strings, refactoring collections, working with .NET Standard Query Operations and using Anonymous types. Part 2 details about DLINQ, or LINQ for databases, such as creating a DLINQ-enabled object model, hierarchical binding and basic pagination.…

Read more »

A Web site should present visitors with a simple yet flexible navigation structure so that they can travel to various parts of the site easily. ASP.NET 2.0 provides a feature called SiteMap that helps you implement this functionality. This article explains what site maps are and describes how to develop Web site navigation structures that use them.…

Read more »