|
6:30 – 6:40 Announcements
6:40 – 8:15 1. Copy files to SQL Server 's host file system with SMO - Lee D. Johnson
2. Using a multi - select check box report to pass parameters to a report - Paul S. Waters
3. SQL Server Tips and Tricks - Group participation
8:15 – 8:30 Closing remarks and give-a-ways (We have Windows 7, an XBOX game and a bunch of stuff from Quest Software to give-a-way)
Copy files to SQL Server 's host file system with SMO
Have you ever needed to write files to a SQL Server? When you backup and restore data using Management Studio there is a dialog that maps to the SQL Servers file structure. This dialog is not available with SMO and there were many times I needed this functionality myself, but was without any libraries for this behavior. I will show you how to leverage some Stored Procedures to accomplish the same type of dialog, and show you how I went about to learning how to use them.
Using a multi - select checkbox report to pass parameters to a report
Sometimes the built-in method for selecting parameters for a report are not user friendly. This presentation will show how to create a multi - select checkbox report to select record Ids and then pass them to another report.
SQL Server Tips and Tricks
Bring your SQL tips and tricks to share with the group. Don't think you have any or afraid of being heckled by the audience then be ready to take notes.
Lee D. Johnson
I have been a professional programmer since 1995. I have worked in such fields as point of sale, internet communications, gage management, warehouse inventory, accounting and education. Early in my career I was specialized in communications, anything from RS232 to Winsock to low level protocols. The past few years I have been with CSI and specialized in data conversion, database development, and software design. My current position with CSI is Development Database Administrator / Software Developer. All my current development revolves around .Net and SQL Server.
|