2022-12-02
78 reads
Editorials
Securing Your Instances
This week Steve Jones looks at moving the port numbers of your instances for a bit of security.
2022-11-25 (first published: 2017-01-13)
199 reads
AI Medical Record Scanning
Artificial Intelligence can help humans, both in diagnosis, but also in teaching medical professionals.
2022-11-23
136 reads
The Challenge of New Platforms
As our organizations grow, they may add new data stores. That might not be the best decision for staff as the amount of knowledge they need grows. Steve notes that you might seek to limit the number of technologies you support.
2022-11-21
194 reads
Challenging Yourself
Steve is challenging himself to do better, which means he might not hit his goals.
2022-11-18
100 reads
Self-Service Databases
When I first started work as a software developer, I knew that getting an environment set up where I could compile a project might take a few hours or a few days. The complexities of how people built software projects, the dependencies, and more were handled in a very immature manner. These days I can […]
2022-11-16
190 reads
What's the Edge Case?
Building software means not only considering the data people expect, but also edge cases. Steve asks if you know what those edge cases are?
2022-11-14
204 reads
Practical IOT
The use of IoT and lots of data is allowing governments to better serve their citizens.
2022-11-12
112 reads
Losing Skills Because of Automation
When I was younger, it seemed that everyone I worked with in technology knew how to build a computer. Most knew how to work with a BIOS, were comfortable with command lines, and could assemble complex compiler directives into a Make file. Over time, it seems many people, especially Windows and MacOS users, became focused […]
2022-11-11
201 reads
Psychological Safety
Building psychological safety inside of a company is hard, but it is important to build trust and develop a team.
2022-11-09
77 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