Kevin Wilkie
Sherpa of Data in all of it's various forms, i.e. Power BI, Tableau, R, SQL Server, Oracle, PostGres, etc...
Alpharetta, Georgia, United States
Actions
Kevin has been wrangling data and dodging dirty reads for over 15 years — back when SQL Server 6.5 was considered "modern" and query tuning meant praying to the optimizer gods.
His journey began as an "Accidental DBA" — one misfired report and suddenly he was deep in sys.objects, pretending sp_who2 was an actual plan. Since then, he's played nearly every role in the SQL Server ecosystem: SQL Developer, BI Associate, Production DBA, and now a Data Architect with a mission.
These days, Kevin spends his time normalizing chaos, denormalizing silos, and preaching the gospel of clean, well-modeled data. He’s been known to pivot on the fly, avoid Cartesian relationships, and bring deadlocks back to life — all while gently reminding teams that SELECT * is a cry for help.
If it involves data, Kevin's in — tuning queries, architecting solutions, or just nerding out about why surrogate keys are misunderstood. He’s not just passionate about data — he’s got a clustered index on it.
Area of Expertise
Topics
The Function of Windowing Functions
In the past, we have all had the need to return a result set and provide information on this with regard to a persons previous or future records. Or, alternatively, you have needed to get a single record for an individual - maybe the first, maybe the last.
Doing this without windowing functions is possible but why punish yourself?!
Come to learn about general windowing functions that we should all know, as well as some that you may not be aware of!
For example, did you know you can use count(*) as a windowed function in addition to general aggregate?
Finding the Right Data Types
Have you ever truly wondered what the right data type is for your SQL tables? I mean, we use the standard ones, but are they really the right ones?
We'll review the ever expanding data types that are available and why we would use one over another. We'll go over not just SQL Server data types but a few other databases as well.
Seamlessly Integrating On-Prem SQL Server Data with Snowflake and Microsoft Fabric
Join us for an in-depth technical session on transforming your data architecture with the seamless integration of On-Premises SQL Server to Snowflake and Microsoft Fabric. Discover the strategies and best practices for setting up efficient data pipelines, ensuring data consistency, and overcoming common challenges.
We will explore a real-world scenario and showcase advanced techniques for optimizing performance and scalability. We will guide you through the end-to-end process, from initial setup to execution.
Whether you want to enhance your data analytics capabilities or streamline your data management, this session offers invaluable insights and practical solutions.
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