It's Not Yours
We may talk about our databases, but hopefully most of us know we don't own the data.
2022-05-25 (first published: 2018-01-17)
227 reads
Editorials
It's the Engineers
The staff that build your systems are more important than your choice of technology.
2022-05-23 (first published: 2018-01-08)
229 reads
Moving on but not far
During my technical career, I’ve changed companies several times. I even worked as an independent contractor for three years. One thing I have never done before was switch departments and roles within one company. That’s about to change in a couple of weeks as I move from Simple Talk Editor and DevOps Advocate in Marketing […]
2022-05-21
95 reads
Job Interviews: What is Normalization?
Do you know how to answer normalization questions in an interview? Steve Jones gives you a few ideas and recommends you brush up on your knowledge.
2022-05-20 (first published: 2018-01-11)
631 reads
The General Database Platform
It seems that many people who choose NoSQL platforms still need relational features. Steve speculates on why.
2022-05-18
149 reads
2022-05-16 (first published: 2018-01-15)
242 reads
Will Hosted Services Take Your Job?
This week I was honored to be able to attend, and present a session at, SQLDay in Wroclaw Poland. I fell in love with Poland the very first time I attended this event, so I look forward to any time I can go again. This year, Pavel Potasinski presented the keynote: The Evolution of the […]
2022-05-14
117 reads
2022-05-13
1,405 reads
Living Up To Your Word
Steve feels it is not only important to keep your word, but communicate clearly what you mean to others.
2022-05-11
305 reads
Crazy Interview Questions
Interviews are always a challenge, but sometimes there are crazy questions. We can do better, especially in terms of how we evaluate the answer to a question.
2022-05-09
527 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
Issue with CPU Affinity Configuration on a SQL Server VM with 30 vCPUs
Hello , I'm having an issue with a SQL Server VM that has 30...
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...
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