//Cloud notes from my desk -Maheshk

"Fortunate are those who take the first steps.” ― Paulo Coelho

MS ISV Community Days – Lee Merdien,Bangalore

Recap of – MS ISV Community Days,Lee Merdien,Bangalore-

All about VS 2005 (SQL + ASP.NET + VS IDE )


Hmm, after a great event and presentation, I’m completly brain drained and no words to write..I feel great energy TODAY …YES

Here few important things i recovered from my diary.

I started using VS 2005 beta since this June 1’st.., so one month experience helped me to grab those concepts, slides and able to Visualize myself…but still few hidden concepts also learned regarding SQL 2005 and ASP.NET.

But as for VS 2005 is concerned i almost aware about new features….so i had a great time to visualize the DEMO and go ahead….

Here is the blog grows about ISV – Starts from 10.AM

10:00 AM – Welcome Note by Deepak Gulati (http://devfun.blogspot.com) "

Monad – new command line sheel for VS *Orcas – New version of Visual studio and Microsoft future roadmap…etc

10:30 AM – SQL Server 2005 for developers by Praveen Shirvastava(MVP)

Praveen started with clear picture & TOC of SQL 2005 and started listing one by one with interesting DEMO for each concepts.so overall great useful for DEVELOPERS perspective.

Audience fired few interesting queries, so it was a very good session so for all…well packed with good strength of 230 developers…

Here is the few important things to be considered,


(1) |SQL Server 2005 – featues * new |

|Reporting service,OLAP,Notification Services,DTS,Replication services,Relation DB|


(2) Best uses of SQLCLR Computations Functions, Scalar functions, Streaming table values using Sql reader

 I – Large computation (close to DB) – SQL CLR (day to day DB programmers easier)

II – Bunch of Join, Cursor – TSQL

 For simple CRUD commands say create,rename,update and delete – Not suggestable to use SQL CLR

 (3) XML in SQL ?

*Send and receive as XML

*Deal XML directly in the data table

*Xquery support

 *We can define XML as – column, Variable, stored proc

(4) CTE – Common table Expressions – for recursive calculations

Temp named resultset Replacement with subquery Can be used with select/insert/update/delete Starts with ‘WITH’ PIVOT – turns rows into columns (bunch of columns) and UNPIVOT the same

(5) Ranking and Windowing Functions : Row Number,Rank,Dense rank,NTILE(n) Ranking –Ordering , Windowing

(6) Output clause returns automatic output shows the user what data is updated or deleted

(7) Handling exceptions

@@Error set on each statement


11:45 AM – What’s new in Windows Forms in Visual Studio 2005 by Deepak gulati

*Deployment with ClickOnce – upload to file server, FTP Robust downloader & Installer Auto checking new updates etc..

*New controls Menustrip, Splitcontainer, tablelayout, binding source, backgroundworker, flow layout, toolstrip

*Forms code – using partial class [ design code + generated code ]

*Deployment – System.deployment

*App.config – read and write (app.settings)

1:00 PM – Lunch Break

2:15 PM – What’s new in Visual Studio 2005 and ASP.NET 2.0 by Deepak gulati

ASP.NET notable concepts

*Datasource controls, Master page, Themes, – stored inside master folder Security – Membership,Login controls, Role mgmt, create user wizard Web parts – weather, stock, customization, personalixation Health monitoring – perfcounters Localisation- etc..

* Data controls – Gridview – like the datagrid Details view – companion to grid view Datasource, DatasourceID DATAGRID – select, delete, update –very simple to use

*Automatic file compilation

*Precompilation – AXD, dll

*Cross page posting – pages can now post back to other pages, Control.postbackurl Previous.inputBox.text

3:45 PM – Registration for Hands on ISV Lab

And also moving today for hands on lab @ 3 PM –5PM Address : People skill learning pvt ltd,#181, II’nd floor, Amarjothi layout,Ring road, Dumlur Apart from this I got E-book on CD- A first look @ SQL server 2005 for developers – addison wesley publication…good one.

Few URLS shared during this presenations are,


http://lab.msdn.microsoft.com/vs2005 http://www.microsoft.com/india/msdn/isvcommunitydays/presentations.aspx

( PPT files available here )


Comments about yesterdays event or about this topic greatly welcomed…Catch u all with more stuff…unti stay tuned….

Mahe~ before my lunch


2005-07-08 - Posted by | MS Events in India (Bangalore)

1 Comment »

  1. Dear guy,i would like to attend ISV community days and other SQL Server 2005 seminors.Thanks with RegardsSenthil


    Comment by Unknown | 2005-07-26 | Reply

Leave a Reply

Please log in using one of these methods to post your comment:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

%d bloggers like this: