The Cloud Security Problem
Cloud security can be better than on-premises, but it requires work and knowledge.
2024-10-30
130 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
356 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
276 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
124 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
211 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
162 reads
Blogs
A New Word: on tenderhooks
By Steve Jones
on tenderhooks – adj. feeling the primal satisfaction of being needed by someone, which...
Ramblings about data communities and your contributions, no excuses
By DataOnWheels
I have been active in the data community throughout my career. I have met...
SQL Server Journey till 2025 (brief)
By Vinay Thakur
Quick Summary for Microsoft SQL Server till 2025, I am fortunate to be part...
Forums
Ola Hallengren Index Optimize Maintenance can we have data compression = page
I have a quick question on Ola Hallengren Index Optimize Maintenance . Do we...
how do i map the "current" object entry in for each to one variable
hi, in an ssis for each loop over an object variable called MyListVariable, i...
Simulating Mercury’s Orbital Motion Using Pure T-SQL (NASA 2025 Dataset)
SQL Server is typically viewed as a transactional or analytical database engine. However, it...
Question of the Day
String Similarity I
On SQL Server 2025, when I run this, what is returned?
SELECT EDIT_DISTANCE_SIMILARITY('SQL Server', 'MySQL') See possible answers