Thursday, September 22, 2005 - Posts

C# 3.0

Future Versions

C# 3.0 introduces several language extensions that build on C# 2.0 to support the creation and use of higher order, functional style class libraries. The extensions enable construction of compositional APIs that have equal expressive power of query languages in domains such as relational databases and XML.  

C# 3.0 Language Specification
Read about the proposed changes to the C# language.   

C# 3.0 Language Enhancements Hands-on Labs
Experiment with the proposed changes to C# 3.0 with these hands-on labs.  

LINQ Technology Preview

The LINQ Technology Preview includes samples, whitepapers, hands-on labs and compiler support to create LINQ-enabled applications using Beta 2 versions of Visual Studio 2005 or Visual C# 2005 Express Edition. Note: This is only for testing purposes. Features may change before launch.   

The LINQ Project

Get more information on the goals of The LINQ Project, the technologies behind many of the language enhancements proposed for C# 3.0.   

The LINQ Project General Forum

Ask questions about the LINQ Project. The LINQ Project delivers Language Integrated Query (LINQ) for objects, relational, XML, and other forms of data.   

LINQ on Channel9

Watch this Channel9 video with Anders Hejlsberg and Luca Bolognese as they explain what The LINQ Project is, and how it will help you create XML and data-driven applications.  

From TechEd to the PDC Anders Hejlsberg has emerged as very visible and active evangelist guiding the development of his wonder child C#.

posted Thursday, September 22, 2005 9:57 AM by paul with 0 Comments

Data Analysis in SQL Server 2005

NY Metro SQL Server User Group September 22nd Meeting

Topic: Data Analysis Using Ranking and Windowing Functions in SQL Server 2005
Speaker: Stephen Forte, Corzen, Inc.
Date: 6:00 PM on September 22, 2005
Place: Microsoft Office in Manhattan
The Axa Financial Building
1290 6th Avenue, NY, NY

SQL Server 2005 adds the functionality of a ranking expression that can be added to your resultset that is based on a ranking algorithm being applied to a column that you specify. This will come in handy for reporting and in .NET applications for paging and sorting in a grid as well as many other scenarios.

We’ll explore the ROW_NUMBER() function, which assigns a running count to each row and compare it to RANK() and DENSE_RANK(). Use these functions to solve complex SQL problems. Then we’ll look at custom percentile ranking using NTILE() and look at business and academic applications of NTILE(). Lastly, we’ll apply windowing functions to all of the four ranking functions with PARTITION BY to perform hard core aggregate functions.

How appropriate that Steve from NYCDOTNETDEV will be giving tonight’s talk as more then half of us in the NY SQL Server User Group are developers and also members of NYCDOTNETDEV, so it should be a fun meeting.

posted Thursday, September 22, 2005 7:25 AM by paul with 0 Comments