Jeff Foushee
Principal {Various}, Humana Inc.
Louisville, Kentucky, United States
Actions
Jeff Foushee has blurred the line between developer and DBA since 1996. He collects knowledge in different programming languages, as well as collects attractions on RoadsideAmerica.com .
Area of Expertise
Topics
The T-SQL LIKE Operator, beyond %
It's no secret the T-SQL LIKE operator is not Regular Expression-strength, but you may not be aware of its capabilities beyond the %-wildcard. Let's explore the other special abilities it has.
Beginner-level class, 100-level class, lightning-talk
The T-SQL TRANSLATE() Operator
Do you or a loved one suffer from nested REPLACE() statements? You may be entitled to emotional compensation after learning about the TRANSLATE() function. Join me as we learn basic and nuanced behaviors of this undervalued syntax.
Beginner-level class, 100-level class, lightning-talk
The T-SQL PIVOT/UNPIVOT Operators
Ever wish your horizontal data were vertical for easier data storage, as well as vice-versa for reporting purposes? Are you writing elaborate routines to transform between them for one-time usage? Are your queries repeating “OUTER JOIN” or “UNION” so often that you wind up back in Kansas when you read them aloud? Let's visit SQL Server’s lesser-known PIVOT and UNPIVOT operators. After this session, you will no longer need to rotate your monitor!
Intermediate, 300-level class, 60-minute slot
Chew on That!: Sending DataTables and DataFrames to SQL Stored Procedures
Working with data row-by-row is a hassle. What if we could send an entire dataset to a stored procedure? Let's look at SQL Server User-Defined Table Types, least-privileged security, performance tuning, and advantages/disadvantages. We'll also look at code to call them from .NET, Python and PowerShell. There's something for both DBAs and developers!
Intermediate-level class, 200-level class, 45 - 60 minute slot
The T-SQL JSON Operators
Officer Reese, someone got semi-structured data in my relational! No worries; let's look at the various T-SQL functions we can use to query and create JSON data within SQL Server! Some of these functions are new for SQL Server 2022.
Beginner-level class, 200-level class, 60-minute slot
SQL Saturday Baton Rouge 2024 Sessionize Event
SQL Saturday RVA 2024 Sessionize Event
SQL Saturday Jacksonville #1068 Sessionize Event
lextalk Tech Q12024 Sessionize Event
philly.NET Code Camp 2023 Sessionize Event
Please note that Sessionize is not responsible for the accuracy or validity of the data provided by speakers. If you suspect this profile to be fake or spam, please let us know.
Jump to top