How to Use PowerShell to Set Secure SA Passwords in Bulk
Learn how you can bulk set passwords using PowerShell for all your instances.
2022-09-16 (first published: 2022-08-17)
2,632 reads
Uncategorized
Convert UNIX Timestamps to DATE/TIMEs in SQL Server - Part#1
In Unix, a timestamp is a whole number that represents a date and time. Learn how we can convert those correctly in SQL Server.
2022-11-15 (first published: 2022-09-14)
37,302 reads
Things Move Fast
I have several things I’d like to say in the editorial today, but I feel I have to start off with my condolences to the family of Queen Elizabeth II. For that matter, my condolences to the people of Britain. This truly is the end of an era. Things do indeed move fast sometimes. Working […]
2022-09-10
136 reads
Developer Optimism
Developers, in general, are very optimistic about the code they write. This is likely one cause of their estimates of the time required being low, as well as the various bugs that slip through because of corner cases that appear for the problem being solved. Often developers think they've considered the various ways this code […]
2022-09-07
181 reads
SQL Ledger: Protecting Data in Azure SQL
Learn how you can set up and use Ledger tables in an Azure SQL Database to verify the integrity of your database changes.
2022-09-07
4,345 reads
Pick a Database, any Database…
All sorts of project and organizational analysis go into selecting the right database system for the requirements....or so you'd think.
2022-08-27
195 reads
2022-08-24
2,152 reads
When Is Technology Good Enough?
Technology advances, sometimes beyond what we need sometimes. Steve asks when things are good enough.
2022-08-22
126 reads
2022-08-17
631 reads
DBA to Data Engineer
A title change can come with a salary bump in some cases, but you might need to work to achieve both of those. Steve has a few ideas today.
2022-08-17
1,605 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...
Announcing SQL Server 2025
Comments posted to this topic are about the item Announcing SQL Server 2025
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