Chrissy LeMaire

In AI for Everyday IT you’ll learn how to: Write effective prompts for common IT tasks Optimize report generation, document handling, and workplace communication Resolve IT conflicts and crises Acquire new skills and upgrade your resume AI for help desk, database administration and systems administration Incorporate AI into DevOps processes and create AI-powered applications Simplify time-consuming people management tasks

Every organization has valuable data trapped in PDFs - from invoices to medical records to compliance documents. This session demonstrates a practical solution using OpenAI's Structured Outputs, PowerShell, and SQL Server to automate this tedious process. Through live demonstrations, I'll show you how to build a reliable pipeline that extracts data from PDFs and loads it directly into SQL Server tables. You'll see real examples using veterinary records, but the techniques apply to any PDF-based data. We'll explore how to handle common challenges like inconsistent formatting and missing data, and discuss strategies for improving accuracy. The session includes practical demonstrations of: - Converting PDFs to structured text using AI - Creating effective JSON schemas for data validation - Building a PowerShell pipeline for automated processing - Loading the extracted data into SQL Server You will learn: - How to implement OpenAI's Structured Outputs for data extraction - Techniques for validating and cleaning AI-extracted data - Methods for handling arrays and nested data structures in PDFs - Tips for optimizing AI accuracy and reducing processing time - Best practices for automating PDF-to-SQL workflows This session is for database professionals looking to automate manual data entry from PDFs. Learn how AI can replace hours of copying and pasting with an automated solution.

Presented at Data Ceili in Dublin. In this session, I compared services like ChatGPT, Claude, Microsoft Copilot and Google Gemini. I also showed how I use chatbots in unexpected ways, how to get free AI access from GitHub using GitHub Models and how AI can be used to extract unstructured data from PDFs! I'll also address some of the privacy concerns and how to mitigate them.

Did a 5 minute presentation where I showed how to use GitHub Models, for free, to extract unstructured data into SQL Server.

Showing real world use-cases for AI. For over 2 decades, I've wanted this functionality and I'm pumped to have it as a SharePoint Developer.

Using GitHub Models to learn more about Structured Output, aimed at systems and automation engineers

Exposing more Automation Engineers to GitHub Models

Another blog post intended to help automators explore GitHub Models and AI in general using a GUI.