Better Writing
Are you a good writer? You should be. Steve Jones notes that communication skills are not only important, but that poor ones can set you apart in a way you might not like.
2023-03-15 (first published: 2014-01-20)
323 reads
Editorials
Watching the Watchers
This editorial was originally published on Jan 16, 2007. It is being republished today as Steve is on vacation. This one looks at the potential issues with data mining when data might be shared between companies.
2023-03-13 (first published: 2011-11-10)
146 reads
Sources of Inspiration
I honestly enjoy writing editorials. Something pops into my tiny brain next to something else, and I'm off. However, today, as I started to write on the topic of learning, I suddenly felt like I had just written this same editorial. I go and look, sure enough, several of my recent editorials have been on […]
2023-03-12 (first published: 2023-03-11)
82 reads
How Normal Is Your World?
Steve thinks the world is close to normal for him after the pandemic. What about you?
2023-03-10
150 reads
Has Everyone Had a Data Breach?
Not only is the security of our organization important, but that of our partners matters as well.
2023-03-08
131 reads
Nested Transactions
Steve Jones notes there aren't really nested transactions in SQL Server. And we all ought to know this.
2023-03-06
861 reads
The Top SQL Server Engine Errors
The SQL Server Support team published the top errors they see in calls. Steve has a few comments on what they're doing to help customers.
2023-03-04
318 reads
The Struggles to Keep Up with Growing Systems
The growing complexity of environments can cause struggles for many IT professionals. However, we need to ensure we are not making things worse.
2023-03-03
125 reads
Stale Data Causes Security Issues
Stale data from Microsoft has led to many systems being more vulnerable than they should have been. There's no excuse for this, from Microsoft or our own organizations.
2023-03-01
113 reads
Will ChatGPT Write Our Queries?
ChatGPT is in a lot of media as an artificial intelligence program that might change the world. Will it change the world for developers?
2023-02-27
628 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