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
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:
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