With the new version of SQL Server available in a a few days, you might wonder what’s in it for you?

If you are in the Montréal area, don’t miss the official launch organized by the Montreal .NET Community and sponsored by Microsoft.

Présentations will be in French.

 

Where: Microsoft Montreal office

When: Saturday April 12

Cost: free (including pizza) but you must reserve your place.

To RSVP, visit http://www.meetup.com/dotnetmontreal/events/139950192/


altOn Monday I did two presentations at the Montreal .NET Community.

A quick talk on SQL Server Compact Edition 4 first, then I did a huge demo on Visual Studio LightSwitch.

 

Download the slides

 

For LightSwitch I advise you to check my ppt from TechDays Canada because I just had 1 slide at the UG…

Download my LightSwitch demo (LightSwitch beta 1)


For those in Montreal area, this is tomorrow.

Language(s): English.
Product(s): BizTalk Server, SQL Server, Visual Studio and Windows.
Audience(s): Developer and IT Professional.
Related Industry: Education,Financial Services,Government,Professional Services,Telecommunications.

Event Overview

Winter Tour 2006 – Application Platform

Keeping up with the latest tools, techniques and best practices is tough when your fulltime job keeps you in the trenches and heads down. Take this opportunity to learn the best practices in designing, developing, testing, deploying and managing data driven applications. If you are working with the Microsoft based platform or technologies such as SQL Server, Windows, Visual Studio or BizTalk, then this event will help you!  The four sessions will look at real world scenarios of building and deploying an internet application and walk through common challenges and solutions that many companies and individuals face. You will leave this event with a better understanding of the key Microsoft based technologies and best practices to help you with your job and provide you with a great opportunity to network with your peers in the industry.

There will be a common session in the morning; followed by two separate afternoon tracks to allow for a deeper discussion on role specific needs.

Morning Sessions (combined audiences):

Session 1 – Designing the architecture

Session 2 – Building, deploying and maintaining the application

MSDN Afternoon Track (for developers)

Session 3 – Developing a web based application on the Microsoft-based applicationplatform

Session 4 – Building a strong data foundation to your application

TechNet Afternoon Track (for IT Pros)

Session 3 – Enhancing Scalability and Availability of the Microsoft Application Platform

Session 4 – Managing and Monitoring the Microsoft Application Platform


AGENDA

8:00 AM  Registration

9:00 AM  Presentation

Event Overview

Winter Tour 2006 – Application Platform

Keeping up with the latest tools, techniques and best practices is tough when your fulltime job keeps you in the trenches and heads down. Take this opportunity to learn the best practices in designing, developing, testing, deploying and managing data driven applications. If you are working with the Microsoft based platform or technologies such as SQL Server, Windows, Visual Studio or BizTalk, then this event will help you!  The four sessions will look at real world scenarios of building and deploying an internet application and walk through common challenges and solutions that many companies and individuals face. You will leave this event with a better understanding of the key Microsoft based technologies and best practices to help you with your job and provide you with a great opportunity to network with your peers in the industry.

There will be a common session in the morning; followed by two separate afternoon tracks to allow for a deeper discussion on role specific needs.

Morning Sessions (combined audiences):

Session 1 – Designing the architecture

Session 2 – Building, deploying and maintaining the application

MSDN Afternoon Track (for developers)

Session 3 – Developing a web based application on the Microsoft-based applicationplatform

Session 4 – Building a strong data foundation to your application

TechNet Afternoon Track (for IT Pros)

Session 3 – Enhancing Scalability and Availability of the Microsoft Application Platform

Session 4 – Managing and Monitoring the Microsoft Application Platform


AGENDA

8:00 AM  Registration

9:00 AM  Presentation

https://msevents.microsoft.com/cui/eventdetail.aspx?culture=en-ca&eventid=1032319202


These days I was working on a web app dealing with large amount of data.
When it comes to display these data we use GridView and enable pagination in one click.
First thing to know is by default ASP.NET 2.0 GridView default paging is very poor in terms of performance because it first gets all data from db, and then trims the results to render the current page. And it does the same when you change to next page and the others!
Note that it was the same problem with ASP.NET 1.x DataGrid, then you had to implement custom paging to make things smart, that means getting only data that you need to display if you have multiple pages in your grid.

With ASP.NET 2.0 you can very easily use custom paging, without writing a line of code behind!
Scott Mitchell wrote a very good article on how to implement this using the SQL Server 2005 new ROW_NUMBER() keyword and configuring your Object Data Source properly :

Custom Paging in ASP.NET 2.0 with SQL Server 2005

Problem is my current app is using SQL Server 2000…
But chance is Greg Hamilton wrote a very nice tutorial to do the same in SQL Server 2000 using the SET ROWCOUNT command :

A More Efficient Method for Paging Through Large Result Sets in SQL Server 2000

One more thing on the same idea of performance, many people, when creating primary key/foreign key relationships for joigning tables forget that while an index is automatically created on the primary key column, an index for a foreign key IS NOT automatically created, and must be created manually if needed. That could help if your paging’s query use JOIN clauses.

And the final touch, now that we have Top efficient SQL work, we can move the GridView inside an ASP.NET AJAX UpdatePanel and let users navigate through data without PostBack!

Quick and Smart !