Fix My Functions: Speeding Up Scalar and Table Valued UDFs (video)
Last week, I presented on the topic of TSQL User Defined Functions (UDFs) in SQL Server at the PASS Summit.
Last week, I presented on the topic of TSQL User Defined Functions (UDFs) in SQL Server at the PASS Summit.
It’s the second main-session day of the Summit for the Professional Association of SQL Server. I had a great breakfast this morning with Brent Ozar, along with Nathan and James from my first timer group. If you attend Summit for the first time in the future, this is a great program and you should join up.
Good morning from Seattle, at the Summit for the Professional Association of SQL Server.
I’m lucky enough to be sitting at the blogger table this morning, watching the keynote of announcements.
I’m excited to have a session accepted to GroupBy, a free online conference targeting the Microsoft data platform community. The conference is sponsored by Brent Ozar Unlimited, and sessions are chosen by community votes.
What if you could assess the performance level of your team by asking one simple question? In his recent webinar with Redgate, Gene Kim (@realgenekim) suggests that you can.
I was lucky to get an opportunity to present a session to some college students at Seminole State College in Florida last week.
I was in town for SQL Saturday Orlando– a fantastic event on its own. The organizers run a simultaneous seminar for students at the college studying software development and IT topics, and it’s an opportunity where they can hear from professionals in IT professions. I gave a session on interviewing best practices.
In this 20 minute session, I define scrum, continuous deployment, test driven development, DevOps, and related concepts. I close with a quick discussion of why Database Administrators and Developers should care about DevOps.
I recently set up Redgate’s SQL Change Automation in Visual Studio 2017, and I ran into a confusing error when I started trying to use it. For any other folks out there searching on “Unknown SQL Server Platform,” here’s how I got past it.
Spoiler: Visual Studio suggested updating Microsoft’s SQL Server Data Tools, which failed for me and wasted a lot of time. Updating Visual Studio did fix my issue.
Every now and again, someone asks if I write romance novels. Why? Well, let’s ask Bing who Kendra Little is…. To clarify, I am not married, I have dogs instead of children, and I prefer romances about strong women who bring SQL Servers to their knees. I also don’t think it’s possible to drink too much coffee. Most of those pictures are of me, but a careful reader will note that the biography at the top references a domain name that, sadly, dear reader, I do not own.
I’ve submitted a session proposal to the free, online GroupBy conference. Voting will open for sessions soon, but before then, you can help me out by reading my abstract. Is it a session you’d like to see? Got any constructive criticism that you think would make the session or abstract better? Let me know in the comments over on the abstract for “What ‘Digital Transformation’ Means, and How You Can Use It to Advance Your Career (Without Being a Robot)”
Copyright (c) 2024, Catalyze SQL, LLC; all rights reserved. Opinions expressed on this site are solely those of Kendra Little of Catalyze SQL, LLC. Content policy: Short excerpts of blog posts (3 sentences) may be republished, but longer excerpts and artwork cannot be shared without explicit permission.