Selling Automation to Ops
Steve Jones thinks that DevOps is the wave of the future for most companies. He has a few ways to try and bridge the gap between development and Operations groups.
Using Redgate API to compare data in the same table
I needed to speed up some regression testing. Redgate Sql Data compare API helped me do it.
Configuring a MySQL Database on Amazon RDS
Although concerns about ownership and security persist, many companies have embraced cloud services and are reaping substantial financial rewards as a result. Rob Gravelle describes the different cloud database categories, and shows us how to configure an Amazon RDS MySQL database.
Being Careful with Schema Ownership
When you create a schema, you might accidentally make yourself the owner, which can cause issues later. Learn how to ensure that your schemas aren't owned by transient employees.
Modeling and Design Are More Important in DevOps
Steve notes that modeling and good database design can't be ignored in DevOps work.
A Primer on Defect Management
Defects in software can occur in any phase of the software creation process. The earlier and better they are managed, the easier they are to correct. In this article, Afsana Atar explains defect management, including prevention and resolution.
The Importance of Consistent Server Setup
In larger shops with multiple database servers, it is very important to have consistency.
Trigger Happy
This article looks at using triggers to audit and to prevent the performing of unintended actions.
Finding & Fixing Statistics Without Histograms
Men Without Hats were awesome. Statistics without histograms are terrible, but now they're easy to find and fix.
Blogs
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...
2025 Wrapped for Steve
By Steve Jones
I’ve often done some analysis of my year in different ways. Last year I...
Forums
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
reaching ftp thru winscp but erroring in ssis ftp task connection
Hi, below i show various results trying to reach our ftp site (a globalscape...
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