Charles Bachman and Pointer Chains
Joe Celko reminisces about the origins of databases and one of the early pioneers, Charles Bachman. He explains how pointer chains were used to traverse data in the NDL standard and referential integrity that we use today.
Balancing Performance and Readability
Developers need to consider not only system performance when writing code, but also how readability impacts code maintenance.
Different Ways to Import JSON Files into SQL Server
Nat Sundar explains the different ways to load JSON data into SQL Server, along the way also covering the use OpenRowset and OpenJSON functions to manage JSON data effectively.
If only the US would follow ...
Governments are requiring better security, and Steve wishes the US would follow.
Set-Based String Splitting table function
Describe and provide a set-based method that takes a multiple character split term and returns as a table
What is the State of My Transparent Data Encrypted Database?
When using Transparent Data Encryption, you might wonder “What is the state of my transparent data encrypted database?” Read on to learn the many different states that a transparent data encrypted database might go through.
TEMPDB Enhancements in SQL Server 2016
TEMPDB Enhancements in SQL Server 2016 - By default enforced to follow best practices.
Data Encryption Using Always Encrypted in SQL Server
The key challenge for application developers is to build a foolproof system to ensure data security. This is not only more intense, but more complex these days, as many organizations are planning to move their applications to the cloud. Read on to learn more.
Blogs
Houston AI-Lytics 2026–Powerpoint Slides
By Steve Jones
Thanks to everyone for attending my session on running a Local LLM. If you...
The Book of Redgate: Do the Right Things
By Steve Jones
I do believe that Redgate has been very customer focused since it’s inception. I’ve...
GenAI vs Dashboards: Not the Same (And Never Will Be)
By James Serra
There’s a question I’ve been hearing more and more lately, especially as Copilot, Fabric,...
Forums
Warning: Could not open global shared memory to communicate with performance DLL
Hi everyone I am getting below warning when I run SSIS: Warning: 0x80049304 at...
Let's Talk Community Events!
Comments posted to this topic are about the item Let's Talk Community Events!
that one limitation in replication
Hi as shown below a replication target requires a primary key. if we want...
Question of the Day
Detecting Deadlocks
By default, how often is the SQL Server Database Engine checking for deadlocks?
See possible answers