Hack / Protect / Predict – SQL Server (Slides for SQL Saturday Orlando 801)

Hi, I’m excited to share with you that I’ll be presenting this Saturday, October 6, 2018, at SQL Saturday Orlando. The most fun SQL Saturday event I’ve attended. It’s going to be my first time announcing this content on SQL Server 2019 (currently ctp 2) and SSMS 18 preview 4. Plus, maybe playing SQL Family Feud.

I tend to pack a lot of content into my presentations so the audience can take the most home. I am sharing my slides here, prior to the presentation, so we can cover all the demos at the session and have ample time for Q&A.

Please join me at Room 1 (means To Be Announced) at Seminole State College (Sanford/Lake Mary Campus) building UP at 11 am for SQL Saturday Orlando 801.


The presentation on Saturday turned out wonderful. I also received great feedback from the attendees. It was a pleasure to accomplish this goal and I look forward to speaking at SQL Saturday Orlando hopefully in 2019 on a new topic.



Title: Hack / Protect / Predict SQL Server – Come learn them.

Speaker: Fleitas, Hiram
Duration: 60 minutes
Track: Application & Database Development
Level: Advanced

In this session, I’ll show you how to hack SQL Server using a simple C# console application and other tools. Most importantly, I’ll show you how to protect vectors that perhaps you’re trying to use to safeguard sensitive data for GDPR compliance.

  1. Tabular Data Stream (TDS) Protocol
  2. Dynamic Data Masking
  3. Row Level Security (Yep…)
  4. Database Source Control

Perhaps, you’ve seen these exploits before but do you really know how to reproduce them? Or, how to even protect yourself against them? No worries, I’ll show you the way along with a load test.

Finally, I am very excited to share with you how to analyze text using pre-trained Machine Learning models to predict a sentiment, on-prem with SQL Server 2017.

  1. SQL ML / AI – A deep dive to predict the sentiment

Looking forward to meeting you all.

Hiram Fleitas is the Principal Database Architect at Universal Property and Casualty Insurance Company and leads the company’s intelligent edge using Microsoft’s data platform. He currently is developing database applications using Machine Learning models trained on claims, policy, and social media data to predict business opportunities for customer satisfaction and loyalty in real-time.

He has worked with SQL Server for 20 years, from version 6.0 to 2019 with some of the largest companies in the world. He’s spoken on SQL Server at User Groups, South Florida Code Camp, PASS SQL Saturdays, and corporate business events, often presenting talks on security, performance, devops, machine learning, and business intelligence. He coded his first program in BASIC when he was 13 years old as a school project and developed a passion for computers ever since.

Hiram is also a code contributor to several opensource projects and serves as an IS Flotilla Staff Officer for the United States Coast Guard Auxiliary. On his time off he mostly enjoys spending time with his wife Christina and two kids, Ocean and Skylar Fleitas. He also wakeboards, wakesurfs, snowboards and does endurance training events by GORUCK’s Cadre-led decorated combat veterans of Special Operations.


Date & Time:
Saturday – Oct 6, 2018
11:00 am – 12:00 pm Presentation

Seminole State College
Sanford/Lake Mary Campus
100 Weldon Blvd Building UP, Sanford, Florida, 32773
Room #: 2103

Follow #SQLSatOrlando on Twitter
Follow @HiramFleitas on Twitter

Leave a Reply

Please log in using one of these methods to post your comment:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.