Slides and Demos from Financial Services Developer Conference in NY

I promised to make the presentation and demos available here and here they are:

Presentation: https://www.tsqlnet.com/downloads/fsgdevcon/fsgdevcon_presentation.zip

Data Integration Demo: https://www.tsqlnet.com/downloads/fsgdevcon/fsgdevcon_demo.zip

I have only demo #1 shared here. Demo is on data integration and was run on SQL Server 2005 April CTP. I demonstrate a few uses of OPENROWSET BULK and relational, custom, semi or unstructured files using format files, UDTs, TVFs, XML data types and SINGLE_BLOB options. Very similar to the example in my earlier blog entry: https://blogs.msdn.com/cbiyikoglu/archive/2005/03/17/398321.aspx

Demo #2 was on the great profiler and perfmon integration we achieved: if you'd like to see it for yourself, just record perfmon and profiler together against sql server while you have some decent load. Then open the profiler data you save and use "file>import performance data" to bring in correlated perfmon data. Just play with selecting a range from perfmon or clicking commands in profiler etc.

Let me know if you have trouble getting the data integration demo to work or if you have any questions. As I said I am very interested in hearing about the testing you guys are doing on SQL Server 2005 and would love to hear about any backward compatibility issues and any numbers comparing your SQL Server 2000 and 2005 numbers on the same HW.