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)
465 reads
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
9 reads
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)
221 reads
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
8 reads
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
5 reads
Endoh Collaborative harnesses the power of Automattic for Agencies to spend more time on their clients.
2024-07-26
4 reads
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)
407 reads
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)
279 reads
Whether it's "Made with love and WordPress" or "Bob Ross rocks," you can now customize footer credits on your website.
2024-07-24
2 reads
As a Software Engineer, I would like to replicate a copy of my database from on-premise infrastructure to AWS. This will require me to look for a perfect tool...
2024-07-24 (first published: 2024-07-20)
333 reads
I wanted to figure out how big (or approximately how big) my dump file...
This month, I prompted bloggers to discuss whether good enough is perfect. Thank you to all...
By Steve Jones
Recently a customer asked if SQL Compare and SQL Data Compare can be used...
I have a table. Structure in script below. I have to compare and see...
I have an application team that is insisting on daily (and for some, weekly)...
i see this in the definition of a linked server on our wh sql...
What does this code return in SSMS 20 from SQL Server 2019?
select '|' + CHAR(0)+'abc' + '|';See possible answers