November 2009 SQL Lunches

#3-Understanding and Preventing SQL Injection

Report Builder
Speaker: Kevin Kline, Microsoft SQL Server MVP

View Recording: Watch Now!

Download:  Not Available

BIO: Kevin Kline is the Technical Strategy Manager for SQL Server Solutions at Quest Software. A Microsoft SQL Server MVP, Kevin is a founding board member of PASS and the author of several books including “SQL in a Nutshell” (O’Reilly & Associates). Kevin is a top-rated speaker at industry trade shows and has been active in the IT industry since 1986.

Topic: #3-Understanding and Preventing SQL Injection
SQL Injection attacks are one of the most common hacker tricks used on the web. Learn what a SQL injection attack is and why you should be concerned about them. Through demonstrations, witness different types of SQL injection attacks, how to find them, and how to block them.

#4-Reporting Services and Table-Valued Params

Report Builder
Speaker: Patrick LeBlanc

View Recording: Watch Now!

Download:  Not Available

BIO: Patrick LeBlanc is a Microsoft SQL Server and Business Intelligence Technical Solution Professional. He has written several blogs and articles on his blog at http://patrickdleblanc.com, www.sqlservercentral.com and www.bidn.com. Along with his 10+ years experience he holds a Masters of Science degree from Louisiana State University. He is the author and co-author of four SQL Server books. His past work experiences include Sr. Consultant at Pragmatic works and Database Architect at several companies. Prior to joining Microsoft he was awarded Microsoft MVP award for his contributions to the community.

Topic: #4-Reporting Services and Table-Valued Params
SQL Server Reporting Services 2005 introduced Mutli-Select Drop Down List. SQL Server 2008 introduced the Table-Valued Parameters (TVP). Natively Reporting Services does not support TVP. In this session I will provide a demonstration on how to seamlessly integrate to two features.