Why We’re Partnering With Perplexity
The short answer is: You’ll be eligible for a piece of the pie, plus increased traffic to your website.
2024-07-30
19 reads
Blog Posts
Calling a REST Endpoint from Azure SQL DB
External REST endpoint invocation in Azure SQL DB went GA in August 2023. Whereas before, we might have needed an intermediate technology to make a REST call to an...
2024-07-29 (first published: 2024-07-23)
517 reads
DevOps Days Minneapolis
Once again, I’m off to a conference next week. This time it is DevOps Days Minneapolis. I haven’t been to a DevOps Days event, though I always enjoy DevOps...
2024-07-29
24 reads
The Importance of Patch Management to Avoid Downtime
A recent Microsoft outage caused by a bad patch pushed out to Windows instances managed by CrowdStrike has thrown a spotlight on the critical importance of effective patch management....
2024-07-29 (first published: 2024-07-19)
236 reads
SQL Saturday Baton Rouge 2024–Resources
For my talk at SQL Saturday Baton Rouge 2024, here are the resources. Slides: Architecting Zero Downtime.pptx GitHub: https://github.com/way0utwest/ZeroDowntime If you have questions, reach out.
2024-07-27
20 reads
A New Word: Vicarous
vicarous – adj. curious to know what someone else would do if they were in your shoes, eager to watch another actor put their own spin on the character...
2024-07-26
28 reads
Automattic for Agencies x Endoh Collaborative: A Match Made in WordPress Heaven
Endoh Collaborative harnesses the power of Automattic for Agencies to spend more time on their clients.
2024-07-26
16 reads
MVP No more, But It’s OK
Embracing Limitations: Finding Strength and Purpose in Hard Times For four years, I was honored to receive the MVP award for my work in the
The post MVP No more,...
2024-07-26 (first published: 2024-07-12)
436 reads
T-SQL Tuesday #176: One piece of advice for Past Steve
I almost missed this month, so this is also a good #SQLNewBlogger post. I thought about it for a few minutes as I ate breakfast at my desk and...
2024-07-26 (first published: 2024-07-09)
298 reads
Customizable Footer Credits Are Here
Whether it's "Made with love and WordPress" or "Bob Ross rocks," you can now customize footer credits on your website.
2024-07-24
15 reads
Blogs
Advice I Like: Respect
By Steve Jones
“Don’t aim to have others like you; aim to have them respect you.” –...
Blue Sky Programming – The Optimism Trap
Many years ago, before I joined Oracle, I was working on a major modernisation...
Setting Up a Mac for Data Engineering and AI Work
If you work with data pipelines, SQL, notebooks, or machine learning models, a Mac...
Forums
SQL Art, Part 4: Happy 4th of July — A British DBA's Guide to Celebrating a War We Don't Talk About
Comments posted to this topic are about the item SQL Art, Part 4: Happy...
locking down agent for new user on our dev machine
hi , a new user wants to be able to add sql agent jobs...
SQL Server Enum Implementation: A Single-Row View Strategy for Avoiding Magic Values
Comments posted to this topic are about the item SQL Server Enum Implementation: A...
Question of the Day
BIT_COUNT I
In SQL Server 2025, I have a table (dbo.UserPermission) that contains this data:
UserID UserPermissions 15 23 37What is returned when I run this code:
select bit_count(UserPermissions) as PermissionCount from dbo.UserPermission where UserID = 3;See possible answers