Daily Coping 8 Mar 2023
Today’s coping tip is ask someone how their day is going and really listen to them. I had the chance to do this with one of the kids I...
2023-03-08
10 reads
Blog Posts
Documentation vs Automation
Originally, I was going to write a post on troubleshooting SQL Server. This is because I’m writing up and reviewing a lot of documentation at my current job. I’ll...
2023-03-08 (first published: 2023-03-01)
437 reads
T-SQL Tuesday #159– Resolutions
I missed T-SQL Tuesday last month. I got busy and distracted with some travel. For #159, Deepthi Goguri hosted. I’ve enjoyed watching her blog and grow her knowledge the...
2023-03-08
72 reads
Daily Coping 7 Mar 2023
Today’s coping tip is give positive comments to as many people as possible today. On a travel day, I made an effort here. Those are always better for me,...
2023-03-07
19 reads
Synapse Analytics workspace – deployment challenges
Azure Synapse Analytics is not just “another service” in the Azure. It’s very comprehensive set of tools rather than one-goal-tool (like Azure Key Vault or even Storage Account). On...
2023-03-07
34 reads
Daily Coping 6 Mar 2023
Today’s coping tip is to make plans with a friend and catch up with them. I decided to reach out to a friend and make time to catch up....
2023-03-06
13 reads
TOGAF 9 Certified Exam Breakdown
In the last post I hadn’t found the breakdown of questions for the exam. The Open Group does publish the TOGAF 9 Certified Study Guide (link goes to the...
2023-03-06
50 reads
Understanding the TOGAF 9 Foundation Exam
When I teach the ISACA Certified Information Systems Auditor (CISA) course, one of the things I walk candidates through is how the test is structured and how much each...
2023-03-06 (first published: 2023-02-28)
285 reads
What Happens on Azure SQL Database?
Last week I posted the results from using Extended Events to snoop on what happens inside an AWS RDS database. This week, I’m taking a look at what happens...
2023-03-06 (first published: 2023-02-27)
415 reads
#PGSQLPhriday 006: What I Wish I Knew While Learning PostgreSQL
Well, for those who don’t know me, I’m just barely started on my PostgreSQL journey. So, what the heck can I contribute to this conversation? Not much, but I...
2023-03-03
21 reads
Blogs
I recommend Smart Brevity (book) for communications
By Brian Kelley
Following the advice in Smart Brevity improves communication.
SQL Server 2025 Developer Edition – One size fits all
By John
Microsoft has released SQL Server 2025, bringing big improvements to its main database engine....
Monday Monitor Tips: Learning While Using the Tool
By Steve Jones
A customer was asking about what certain items in Redgate Monitor mean. They have...
Forums
Switch partition: NULL boundary id
I have table: t1 in schema1 with 19 billion records. I have another table...
Minimally Viable Security
Comments posted to this topic are about the item Minimally Viable Security
Encoding NULL
Comments posted to this topic are about the item Encoding NULL
Question of the Day
Encoding NULL
What is returned from this code in SQL Server 2025?
SELECT BASE64_ENCODE(NULL)See possible answers