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 15+ years of experience with SQL Server and has worked with the product since version 6.5, although he remembers with distaste the early versions of the product. He started working with SQL Server as an "Accidental" DBA and has moved up through the ranks as a SQL Developer, a BI Associate, and Production DBA at various parts of his career. Currently, he works as a Data Architect spreading the gospel of how great data can be to anyone and everyone who will listen.
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