Bare Metal
Today Steve talks about bare metal servers and virtual machines. He wonders if any of you still run bare metal.
2023-07-10
351 reads
Editorials
The Data Professional Social Graph
Two weeks ago, I had the opportunity to hear a keynote by Vik Fearing at Swiss PGDay 2023. He talked about Property Graphs and the Graph Query Language (not to be confused with GraphQL), a recent addition to the SQL:2023 standard. The discussion was mostly theoretical in nature because only Oracle has a current implementation […]
2023-07-08
99 reads
2023-07-07 (first published: 2018-09-13)
386 reads
Fitting Into RAM
Will your database fit into RAM? Steve Jones asks you to think about the possibility.
2023-07-05 (first published: 2018-09-21)
285 reads
The Changing Landscape of Community
We have a guest editorial today from Mala Mahadevan on the changing data community.
2023-07-03
143 reads
Keep Sharing
I was given a little reward the other day. My son came home telling me that the manufacturing company he works for wants to build some custom test equipment using Arduino-style controller chips. I've been experimenting, pretty darned lightly so far, with these over the last year. He starts asking me about which controllers I […]
2023-07-01
74 reads
Planning for a Bad Day
If you found out you were being laid off, would you be ready? Steve thinks you should be lightly planning for this to happen.
2023-06-30
156 reads
Securing All Your Connections
Microsoft is recommending more security for SQL Servers, including dev and test instances. Do you agree this is a good idea? Would you implement this?
2023-06-28
206 reads
Concurrency Challenges Around Schema Changes
A post on distributed systems and how schema changes are handled caught Steve's eye. See if you agree with how he thinks this should work.
2023-06-26
140 reads
2023-06-24
163 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