How Many Days Can You Survive?
A disaster in LA affected many companies, some of which were innocent bystanders to the event. Steve talks about the need to have some plans in place.
2023-06-05
124 reads
Editorials
Trust!
The difference between a low trust society (few individuals within a trust circle outside your family and/or tribe) and a high trust society (general trust of individuals beyond immediate family/tribe associations) generally speaking can be measured as the difference between a low tech (low trust) and high tech (high trust) society. Yes, exceptions abound, but […]
2023-06-03
102 reads
Better Communication Through Less Messaging
Steve notes that sometimes we message too often, but that's a human problem, not a tool issue.
2023-06-02
146 reads
Scaling Up Monitoring
How do we design a monitoring system? The Amazon Prime team realized they didn't do a good job and changed their architecture.
2023-05-31
170 reads
2023-05-29
113 reads
Validating Password Expiration
Steve notes that password expiration is important for SQL Logins, but he knows this isn't always configured when logins are created, or checked later to see if it is still enabled.
2023-05-27
564 reads
AI Thoughts on the Build Keynote
Today Steve has a few thoughts, and links, from the Build Keynote last week, which featured AI technology.
2023-05-26
157 reads
The Best Graph
Today Steve discusses visualizations and how we would think about the information a client gets from them.
2023-05-24
192 reads
Database APIs
Today Steve talks APIs, which are important in much of software development. He thinks we ought to treat our database schema as part of an API.
2023-05-22
280 reads
Empathetic Design
An old sport saying goes like this “I could beat them with one arm tied behind my back.” Well, after six weeks with my arm in a sling, I am in awe of whoever tries that because everything is a lot harder. Like washing your hand and then drying it, becomes more of a challenge […]
2023-05-20
101 reads
Blogs
Learn Better: Pause to Review More
By Brian Kelley
If you want to learn better, pause more in your learning to intentionally review.
Azure SQL Managed Instance Next-Gen: Bring on the IOPS
By John
If you’ve used Azure SQL Managed Instance General Purpose, you know the drill: to...
SQL, MDX, DAX – the languages of data
By DataOnWheels
Ramblings of a retired data architect Let me start by saying that I have...
Forums
Two foreign keys to the same table. Can't cascade deletes.
Not sure if this is really a relational theory question but it seems about...
Connecting Power BI to SSAS and effective user not working
Hi everyone, Below is a consolidated summary of what we validated Architecture & data...
High Availability setup - has anyone seen this method?
Hi all, I recently moved to a new employer who have their HA setup...
Question of the Day
Encoding URLs
I have this data in a SQL Server 2025 table:
CREATE TABLE Response ( ResponseID INT NOT NULL CONSTRAINT ResponsePK PRIMARY KEY , ResponseVal VARBINARY(5000) ) GOIf I want to get a value from this table that I can add to a URL in a browser, which of these code items produces a result I can use? See possible answers