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


Details
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:
• https://www.linkedin.com/groups/12485934/
• https://www.linkedin.com/groups/12531517/
Join Our LinkedIn Pages:
• https://www.linkedin.com/company/futuredatadriven
• https://www.linkedin.com/company/data-driven-community
Follow Us:
• https://twitter.com/CloudDataDriven
• https://www.eventbrite.com/u/507632298011#profile-following
Join Our Meetup Group:
• https://www.meetup.com/cloud-data-driven/
This event is online. You may need to install MS-Teams: https://www.microsoft.com/en-us/microsoft-teams/download-app
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.
Follow Us On Social Media AT #clouddatadriven
Join Our Social Media User Group
LinkedIn 👉 https://bit.ly/3676SV3
Facebook 👉 https://bit.ly/2XUggXV
Eventbrite 👉 https://bit.ly/3sHxO7K
YouTube 👉 https://bit.ly/38SRFsA
Meetup 👉 https://bit.ly/3a0v5gT
Twitter 👉 https://bit.ly/3akl1iW

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