9
How much does it cost? “Free” as in “free lunch” No charge download from Microsoft Freely redistribution license for ISVs No CALs required No per CPU license required Included with other Studio Express SKUs

13
What is Express Manager (XM)? Lightweight alternative –SQL Server Management Studio –Enterprise Manager and Query Analyzer Preferred way to work with SSX outside of a Studio SKU Works with any SQL Edition 2000 or higher Single Active Connection.NET Application

23
Using the AdventureWorks Database No databases installed by default AdventureWorks downloadable Blog post on how to install into for SSX –http://sqljunkies.com/WebLog/ktegels /archive/2005/01/27/6942.aspxhttp://sqljunkies.com/WebLog/ktegels /archive/2005/01/27/6942.aspx Test it out –SELECT COUNT(RESUME) AS RESUMES FROM HUMANRESOURCES.JOBCANDIDATE

24
Demo with SQLCMD

25
XQuery in Action Resumes as XML Get Education Experiences for candidates As a View As a Stored Procedure

26
XQuery with XM

27
XML is nice, but I want HTML! Query results as pre-render HTML Use XSLT to convert Do that with T-SQL how? Use SQLCLR features to call to System.Xml.Xsl Expose that as a T-SQL User Defined Function Use Visual Studio to build and deploy

31
Big Rocks SSX is Microsoft’s “free” version of SQL Server 2005 Secure in Design, by Default and in Deployment First CPU, First GB of RAM only, 4-gig limit on data Manage with Express Manager Supports most features like XQuery, SQLCLR, Replication and Service Broker Good choice for ISVs, small sites and as an entry-point

33
Call to Action Now is great time to start learning Follow my download and install primer to get going successfully –http://sqljunkies.com/WebLog/ktegels /archive/2005/01/27/6942.aspxhttp://sqljunkies.com/WebLog/ktegels /archive/2005/01/27/6942.aspx Install the beta on a disposable OS image and start trying things Visit us in the newsgroup to ask (and answer) questions