Dynamic Search Queries in T SQL The Ninja way | Advanced Dynamic TSQL| Dynamic sql query

Presentation Title: Dynamic Search Queries in T-SQL - The Ninja way ~ Eitan Blumin

Follow us on Twitter @CloudDataDriven & Facebook, LinkedIn at #clouddatadriven
Join Our LinkedIn Groups:
Join Our LinkedIn Pages:
Follow Us:
Join Our Meetup Group:
Please feel free to share this invitation to any people you think may be interested.

Agenda:
Introductions (2 mins)
Presentation (50 mins)
Q&A (10-15 mins)

Abstract:
What is the solution for implementing truly dynamic search queries? Not just a stored procedure with optional parameters, but something even more dynamic than that? Let the end-user choose the exact fields and, more importantly, the operator types to use on them, in order to get the results that they need. And how do you achieve this level of dynamic interactivity without risking SQL injection? This presentation will answer these questions and give you a solution involving some advanced T-SQL martial arts!

Bio:
Eitan Blumin is a Microsoft Data Platform MVP with decades of experience in all fields relating to Microsoft SQL Server databases (since the year 2005), including but not limited to: Database design, management, TSQL programming, performance tuning, replication, backup management, security management, high availability and disaster recovery, SSIS, SSRS, encryption and more.

Eitan Blumin is currently working as a Senior SQL Server Consultant, Solutions Architect, and DBA Team Leader at Madeira Data Solutions. Other than his day-to-day consultant work, he also co-hosts the popular "SQL Server Radio" podcast with Guy Glantser, writes professional materials for the SQL Server community, delivers professional presentations and courses, and serves as a pivotal source of expert knowledge for the Madeira team.