The Cloud Security Problem
Cloud security can be better than on-premises, but it requires work and knowledge.
2024-10-30
125 reads
Cloud Computing
Cloud vs On-premises
Is the cloud better or worse for a workload? One company, BlueSky, has moved on-premises despite their rapidly growing workload.
2024-07-17
347 reads
Cloud Transformation
There are lots of companies moving databases to the cloud. Steve has a few thoughts on how to evaluate this for your company.
2024-06-21
169 reads
The DBAccountant
Are DBAs going to be responsible for financial accounting for cloud resources as a part of their job? Steve has a few thoughts today.
2024-05-06
288 reads
The Cloud Database Cost Analysis
Managing costs in the cloud is something many companies are concerned about. Today Steve thinks that technical people will bear more responsibility for this in the future.
2024-03-27
275 reads
Auto Renew Subscriptions
Reserved resources in Azure can auto renew now, but Steve isn't sure if that makes our jobs easier.
2024-03-23
120 reads
Re-Evaluating the Cloud
An update from 37 Signals/Basecamp shows their expatriation from the cloud has been a success. Worth reading before you make too many moves to the cloud.
2024-01-10
210 reads
Interesting Aurora MySQL Feature: The Buffer Pool Survives Restarts
Lemme start this off by saying this is probably irrelevant to you. (It’s irrelevant to me, too.)
2024-01-05
Sending resource alerts on Managed Instance using db_mail
One of the biggest issue that you might experience in Managed Instance is reaching storage limit or finding out that you don't have enough CPU. In this case you would need to get the bigger instance; however, this is not instant operation. In this post, you will see how you can monitor resource usage and send email alerts if there is a risk that you might reach the limits.
2023-12-20
Try, Try Again, Until It's Right
A cloud migration for DoorDash interested Steve, primarily because it didn't work, but they were able to back out and try again.
2023-12-15
160 reads
Blogs
Advice I Like: Pyramid Schemes
By Steve Jones
If someone is trying to convince you it’s not a pyramid scheme, it’s a...
Using Prompt AI for a Travel Data Analysis
By Steve Jones
I was looking back at my year and decided to see if SQL Prompt...
FinOps for Kubernetes: Leveraging OpenCost, KubeGreen, and Kubecost for Cost Efficiency
In the era of cloud-native applications, Kubernetes has become the default standard platform for...
Forums
Database file shrink issue.
Hi experts, I have a 3+ TB database on a 2019 sql server which...
The North Star for the Year
Comments posted to this topic are about the item The North Star for the...
Multiple Escape Characters
Comments posted to this topic are about the item Multiple Escape Characters
Question of the Day
Multiple Escape Characters
In SQL Server 2025, I run this code (in a database with the appropriate collation):
SELECT UNISTR('%*3041%*308A%*304C%*3068 and good night', '%*') AS 'A Classic';
What is returned? See possible answers