Cloud Databases
There are advantages of cloud databases when your workload requirements grow. Steve thinks it's useful to learn a bit about the options out there.
2022-09-30
540 reads
Editorials
The Right Connection
Making a connection to the wrong database had disastrous results for Travis-CI.
2022-09-28 (first published: 2018-04-19)
215 reads
2022-09-26 (first published: 2018-03-16)
345 reads
The Communication Channels at Work
The use of messaging dominates communication for Steve. Can you say the same thing?
2022-09-23
78 reads
Custom SQL Server on RDS
SQL Server on RDS has a more configurable option that allows you to meet the specific requirements of your application in a similar was as you would on-premises, while still being a managed service.
2022-09-21
184 reads
Are You a Traffic Cop?
A traffic cop isn't a great analogy for a DBA, but all too often it is an accurate one.
2022-09-19 (first published: 2018-03-20)
270 reads
Who Are You?
I was sitting here thinking about the editorial when Kathi Kellenberger came to mind. She would frequently write about her favorite show, Star Trek. I too have been a fan of Star Trek since I was very young. However, my favorite show is a little more obscure and not as many people have seen it, […]
2022-09-17
154 reads
Paying It Forward on the Internet
Helping others has been good for Steve's career and he encourages you to do it as well.
2022-09-16
118 reads
To Which Experts Should You Listen?
Many experts that speak to at events are working for vendors. Steve notes that this might mean they are making sales pitches, not not always.
2022-09-14
159 reads
The Challenge of Early Tech Decisions
We often live with our early decisions on technology, which can be a challenge over time.
2022-09-12
154 reads
Blogs
How to Run Databases on Kubernetes: An 8-Step Guide
In this step-by-step tutorial, learn how to run MySQL, PostgreSQL, MongoDB, and other stateful...
Episode 11 of Simple Talks: Oracle
By Steve Jones
The 11th episode is now live, recorded a few weeks ago at the PASS...
A New Word: Mornden
By Steve Jones
mornden – n. the self-container pajama universe shared by two people on a long...
Forums
What is the best index strategy for a table that gets truncated?
Hi everyone My SSIS package does a bulk insert of csv files into a...
Blob Storage automated downloads
Dipping my toes into the waters of Azure and of course before I get...
Question of the Day
Running Steve's Code
Can you run this code in any of your SQL Server 2019 databases without error?
CREATE OR ALTER PROCEDURE [dbo].[StevesAmazingProc]
AS
SELECT Consumer_ID ,
Trend_Category ,
Bit_Trace
FROM NewWorldDB.dbo.MarketTrend;
GO See possible answers