SQL Server 2005 Technical Links

Last Updated: July 26th 2004
Last Check of Links: July 26th 2004
Spot something wrong/missing? - Send me feedback and I will fix. Tx.

SQL Server 2005 Technical Links:

I built up this list while working with UK ISVs on beta 1 of SQL Server 2005 and plan to keep it up to date until I find a better list somewhere else! It certainly is not a definitive list - but equally, it is a long list! Enjoy.

SQL Server 2005 Product Site

• Main product site: https://www.microsoft.com/sql/yukon/productinfo/

• Contains several good technical papers from Microsoft including

  • Programming Features Overview https://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnsql90/html/sql_ovyukonnetprogfeatures.asp
  • XML Best Practices https://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnsql90/html/sql_YukonXMLBestPs.asp

• SQL Server 2005 Express (and download) https://lab.msdn.microsoft.com/express/sql/

MSDN SQL Server 2005 Developer Area

• Main MSDN site is https://msdn.microsoft.com/data/sqlsolutions/sql2005/default.aspx
• MSDN Magazine Feb 2004 has lots on Yukon. Here are just a few:
  • UDTs https://msdn.microsoft.com/msdnmag/issues/04/02/UDTsinYukon/default.aspx
  • New TSQL https://msdn.microsoft.com/msdnmag/issues/04/02/tsqlinyukon/default.aspx

WebCasts

• Microsoft SQL Server "Yukon" Overview https://msevents.microsoft.com/CUI/EventDetail.aspx?culture=en-US&EventID=1032243352
• All SQL Server Webcasts can be found at https://msdn.microsoft.com/sql/webcasts/default.aspx

Books

• Reporting Services (sample chapter) https://www.microsoft.com/sql/yukon/productinfo/samplechapters.asp
• Programming Yukon (sample chapter) https://www.theserverside.net/books/inreview/ProgrammingYukon/ProgrammingYukon.tss
• Reporting Services, Brian Larson (SQL 2000) https://www.amazon.co.uk/exec/obidos/ASIN/0072232161/
• Reporting Services, Anthony T. Mann (SQL 2000) https://www.amazon.co.uk/exec/obidos/ASIN/0972688897/
• Reporting Services, Paul Turley (SQL 2000) https://www.amazon.co.uk/exec/obidos/ASIN/0764568787/
• Not yet published
  • Introducing SQL Server 2005 for developers (Sept) https://www.amazon.co.uk/exec/obidos/ASIN/073561962X/
  • SQL Server 2005 Assemblies Revealed (Oct) https://www.amazon.co.uk/exec/obidos/ASIN/1590594126
  • SQL Serevr 2005 a developers notebook (Oct) https://www.amazon.co.uk/exec/obidos/ASIN/1590594126

Articles:

• Developer https://www.developer.com

  • CLR using server data https://www.developer.com/db/article.php/3289101
  • XML Data https://www.developer.com/db/article.php/3294151
  • DTS https://www.developer.com/db/article.php/3310051
  • Whats New https://www.developer.com/net/article.php/3099771
  • CLR Functions https://www.developer.com/db/article.php/3115101

• SQLJunkies https://www.sqljunkies.com/ -

  • TSQL Enhancements https://www.sqljunkies.com/Tutorial/F73E1FFE-0577-4630-B92E-C41CB7C5088F.scuk

  • Debugging SQL Server Web Services https://www.sqljunkies.com/HowTo/5CCAC423-1407-4A36-AF71-ED6A67D9646A.scuk 

  • Adventure Works Sample https://www.sqljunkies.com/Tutorial/4443D685-9F81-4298-ADE3-A244919BB03F.scuk

• C# Corner has several Yukon articles: https://www.c-sharpcorner.com/longhorn/Yukon.asp

• SQL Server Magazine - Many articles around May timeframe including:

  • Management Tools https://www.winnetmag.com/SQLServer/Article/ArticleID/42144/SQLServer_42144.html
  • What is new in DTS https://www.winnetmag.com/Article/ArticleID/42141/42141.html 
  • SQL Server 2005 Security https://www.winnetmag.com/Article/ArticleID/42031/42031.html 
  • Enhanced FOR XML statement https://www.winnetmag.com/Article/ArticleID/42348/42348.html
  • Create a User Defined Datatype https://www.winnetmag.com/Article/ArticleID/42169/42169.html

• Sqlservercentral contains several articles including:

  • SQL Server 2005 Express https://www.sqlservercentral.com/columnists/sjones/sqlserverexpress.asp
  • Survey results https://www.sqlservercentral.com/columnists/bknight/sqlserver2005surveyresults.asp 

• Misc:

  • Yukon Schema Seperation https://www.database-security.info/schema.asp

Yukon Blogs

• Eric Nelson (me!) from Microsoft UK posts on SQL https://blogs.msdn.com/ericnel
• As does his friend and colleague Tim Sneath  https://blogs.msdn.com/tims
• SQL Team WebLogs https://weblogs.sqlteam.com/
• Yukon beta 1 setup issues https://yukonblog.sqlteam.com/ 
• SQL Express Dev team https://blogs.msdn.com/sqlexpress 

Forums and Newsgroups

• SQL Server Express and SQL Server Mobile https://communities.microsoft.com/newsgroups/default.asp?icp=sqlserver2005&slcid=us 
• SQL Server Magazine Yukon Forum https://www.winnetmag.com/SQLServer/Forums/categories.cfm?catid=1692
• Yukon Beta forums (light usage) https://www.sqljunkies.com/Forums/ShowForumGroup.aspx?ForumGroupID=8.

Powerpoints (fancy doing a spot if internal evangelism?)

• Tech Ed 2004 has 15 decks to choose from https://msdn.microsoft.com/sql/teched/.

Hands On Labs

• Many from Tech Ed 2004 can be found here https://www.hands-on-labs.com/search.asp?key=%22SQL+Server+2005%22