My Tech Ed Experience ...
My Tech Ed. experience was very rich. And the data tier track I attended was fun filled.
SQL Server 'Yukon' - .Net Programming features
Speaker – Rajiv Sodhi, Developer Advisor – Microsoft India
Yukon is developing as a scalable, secure, enterprise data management platform. Key features are Enterprise Data Management, Programmability and Business Intelligence.
The session concentrated on Programmability aspect of Yukon server.
Notable features in Yukon are
- .Net Integration
- XML Support
- API Languages
- Developer Tools
- Relational Extensions.
With Integration of .Net in Yukon, we can program .Net Assemblies for SQL server and register them. We will have System.Data.SqlServer as a new namespace for integration.
With XML integration we can have new data type as XML and we can attach schema for the same.
XQuery can be used for retrieving specific XML elements.
The best feature would be SQL server exposing a web service that can be used on any platform.
I am also in the process of consolidating information from all the sites and release an consolidated features list ... :) ...
Useful Links :
http://www.itwriting.com/sqlyukon.php
http://www.win2000mag.net/Articles/Index.cfm?ArticleID=38509
http://www.fawcette.com/dotnetmag/2003_06/magazine/columns/sqlconnection/
http://www.sswug.org/see/15436
http://www.microsoft.com/sql/evaluation/yukon.asp
http://www.microsoft.com/sql/evaluation/bi/reportingservices.asp
http://www.microsoft.com/sql/evaluation/news/yukon.asp
http://www.fawcette.com/dotnetmag/2003_06/magazine/columns/sqlconnection/
http://searchwin2000.techtarget.com/qna/0,289202,sid1_gci911794,00.html
Extending SQL server functionality with User-Defined Functions: Hidden Tricks
Speaker – Srimathi, Sr. Software Architect, Vishwak Systems
The possibility of redefining system Stored Procedures as UDF has lots of exciting possibilities.
This practical session concentrated on some tips and tricks on combining UDFs and Indexed Views or indexed columns to combine extra flexibility and performance at the same time.
Many undocumented UDFs were demonstrated that could be used for optimizing the database queries
Useful Links:
http://www.novicksoftware.com/
http://www.sqlservercentral.com/columnists/achigrik/
http://www.umachandar.com/technical/SQL2000Scripts/Main.htm
http://www.extremeexperts.com/SQL/Articles/default.aspx
http://msdn.microsoft.com/library/default.asp?url=/nhp/Default.asp?contentid=28001860
http://www.sqlserverfaq.com/content/books/samples/springer/BenGanSC.pdf
http://www.microsoft.com/sql/
Designing for Performance
Speaker – Praveen Srivatsa, Director, In4Velocity, MSDN Regional Director
This was an interesting session was based on Planning, Optimizing for performance and Preserving Performance on SQL Server.
It highlighted the changes expected in Yukon.
Effective logging, Table width optimization for optimal storage, vertical and horizontal partitioning (covering) and fragmentation were explained in detail.
Some of the key notes I got from this session is the use of multiple columns can reduce selectivity. Some example in Matrix context is using extra joins like, If a table has a join on CMN_ApplicationsInstancesID and if there is a possibility of joining on CMN_Students also then use the same also. Because there are chances that SQL Server can find a better selectivity.
Useful Links :
http://www.sql-server-performance.com/
http://www.sqlteam.com/FilterTopics.asp?TopicID=103
http://www.sqlmag.com/Articles/Index.cfm?ArticleID=98
http://www.perftuning.com/
http://www.devarticles.com/art/1/489
http://www.only4gurus.com/v2/ShowCat.asp?Cat=SQL%20Server
http://gatton.uky.edu/Faculty/leepost/622/class4.html
http://www.txsqlusers.com/howto/DBCC_SHOWCONTIG.asp
http://www.databasejournal.com/features/mssql/article.php/2238211