Daily Coping 25 Jan 2023
Today’s coping tip is to be gentle with yourself when you make mistakes. I forgot about a commitment. I had agreed to do a webinar and prepare some content....
2023-01-25
5 reads
Blog Posts
Encryption, Comparing your Options in SQL Server
The question of encryption seems to be coming up a lot recently. I’ve had a number of people asking me about how to go about encrypting SQL Server. SQL...
2023-01-25 (first published: 2023-01-17)
416 reads
You can run a SQL Server Docker container on Apple M1 and M2 Silicon
Previously the only way to run SQL Server on Apple Silicon was via QEMU emulation or Colima (hat tip to Anthony Nocentino). Docker released beta support today for Apple’s...
2023-01-25 (first published: 2023-01-12)
184 reads
Daily Coping 24 Jan 2023
Today’s coping tip is to get outside and notice five beautiful things. I decided to do this on a snowy, stormy day in Denver. I was up early with...
2023-01-24
7 reads
Exam Cram with DataWeekender talk - Think Like a Certification Exam
Fresh off of a two-part, co-authored blog series on certification exams and test-taking prep, I've got a fresh batch of fun sample questions for the January 2023 Data Weekender Exam...
2023-01-24
9 reads
So, you're considering pursuing a certification exam
Part 1 of 2. This blog post is co-authored by Ajayi Anwansedo, PhD and William Assaf, who met and worked together at The Futures Fund, a STEM non-profit which offers introductory coding and...
2023-01-24 (first published: 2023-01-23)
33 reads
Daily Coping 23 Jan 2022
Today’s coping tip is to eat healthy today with some nourishing food. A few days before think I was getting ready for my daughter to leave for university. I...
2023-01-23
9 reads
SQL Server Quickie #44 – SQL Server on Docker
Today I have uploaded SQL Server Quickie #44 to YouTube. This time I’m talking about SQL Server on Docker.
2023-01-23 (first published: 2023-01-16)
205 reads
Updating Documents in Cosmos DB: A Step-by-Step Guide on Creating and Executing a Stored Procedure
Cosmos DB is a powerful, fully-managed, globally distributed, and multi-model database service provided by Microsoft Azure. One of its key features is the ability to create and execute stored...
2023-01-23 (first published: 2023-01-13)
11,370 reads
Creating a PostgreSQL Docker Container with a Volume on Windows
This post looks at how to set up a PostgreSQL container on Windows using Docker for Windows. I’ve seen a few posts, but I had to cobble together some...
2023-01-20 (first published: 2023-01-09)
301 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