Becoming a Better DBA
Steve has some advice on how to be a better DBA, or really better at whatever career you choose.
2022-06-15
254 reads
Editorials
Flawed Data Integration
These days we often have multiple applications that need to exchange data in use by customers. Steve shares a few thoughts on his recent experiences.
2022-06-13
136 reads
Building a PC
Steve has a few thoughts on building your own PC to help you with work or your career.
2022-06-10
230 reads
One or Many Databases
When you have multiple clients in your application, do you want one or many databases?
2022-06-08
354 reads
Are Cubes Dead?
Is the idea of an Analysis Services cube something that is no longer relevant for modern data analysis? Steve thinks it might be.
2022-06-06
984 reads
The Nightmare Letter
The GDPR may bring nightmare letters like the one linked to from the editorial.
2022-06-03 (first published: 2018-03-28)
253 reads
Production Subsets
Working with data in development or test environments can be challenging. This week Steve Jones asks how you might deal with the volume of data and whether you like subsets.
2022-06-01 (first published: 2014-08-22)
243 reads
Audit systems: a good idea or a mess to maintain?
Audit systems can be a good idea, but they can also be a mess to maintain.
2022-05-30 (first published: 2018-02-27)
287 reads
2022-05-28
204 reads
2022-05-27 (first published: 2018-02-08)
235 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