Data Modeling Information
Data modeling can be challenging for many reasons. Steve talks about the choices you make in how you store data should be a part of that.
2023-04-19
273 reads
Editorials
Coming Out of the Cloud
Google announced a local version of their cloud databases that companies can install for developers.
2023-04-17
188 reads
Moore's Law: Navigating the Pace of Technological Change
Technology has always been a driving force in shaping our world, propelling us forward into new realms of innovation and progress. One of the most famous concepts in technology is Moore's Law, which suggests that the number of transistors on a microchip doubles approximately every two years, leading to exponential increases in computing power. In […]
2023-04-15
135 reads
The Loss of Knowledge
The loss of developer knowledge can be impactful for an organization. Steve notes that they should do more to retain their staff.
2023-04-14
174 reads
Big Data Downsides
Too much data, especially for some data analysis isn't good for diversity of any product domain.
2023-04-12
144 reads
2023-04-10
309 reads
Keeping Things Running
Today and tomorrow, as I write this, the Green Country Hamfest will be running up in Claremore, OK. Tomorrow morning, I'll be there to check out the tables and maybe pick up some new radio gear. I'll also be volunteering to help run the doors. Largely it involves just checking to be sure people paid […]
2023-04-08
71 reads
What motivates you to do your best?
In today's guest editorial: the motivation to do our best must come from within.
2023-04-07 (first published: 2017-02-17)
183 reads
Information Schema Strangeness
An extra column in an information_schema view had Steve digging into standards.
2023-04-05
171 reads
Living With Broken Software
Steve has to use software that is broken, but it's OK. It actually works well enough.
2023-04-03
110 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