My Tech Ed Experience … September 23rd, 2003

Vinod Kumar

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

        Share this article

        Tags:

        This entry was posted on Tuesday, September 23rd, 2003 at 15:59 and is filed under Uncategorized. You can follow any responses to this entry through the RSS 2.0 feed. You can leave a response, or trackback from your own site.

        Leave a Reply



         

        Email
        Print