The struggle to renormalize data
You are given an export of a NoSQL database, in JSON, and asked to import it into a relational database. Sounds easy? It isn't and Phil Factor explain why.
2017-09-11
213 reads
Editorials
The Control Poll
Do you use version control for your databases? For your application code? Is there a time when you think it's not needed? Steve Jones asks the question today.
2017-09-08 (first published: 2013-05-17)
158 reads
Using Tools that Fit
Equipment can matter for IT professionals. Read a few thoughts from Andy Warren.
2017-09-07
63 reads
2017-09-06
260 reads
2017-09-05
305 reads
SQL Server in Space - HASSP
A successful launch, and recovery, of SQL Server running below a balloon.
2017-09-04
75 reads
2017-09-04
44 reads
Improving Log Shipping
Today Steve Jones looks at possible ways to improve log shipping and asks for your input as well.
2017-09-01
69 reads
Appreciating New Perspectives
Today Steve Jones talks about understanding and having empathy for other points of view.
2017-08-31
73 reads
Database Development Made Easy?
Today Steve Jones has a few thoughts on the complexity and cumbersome nature of database development.
2017-08-30
96 reads
Blogs
Dry-run xp_delete_file Before Actually Deleting Files?
By SQLPals
Dry-run xp_delete_file Before Actually Deleting Files? xp_delete_file doesn’t really have a...
Happy Thanksgiving! (USA Holiday)
By Brian Kelley
In the United States, today is Thanksgiving. The intent behind the holiday is to...
Getting SQL Server 2025 RTM Running in Containers on macOS
SQL Server 2025 RTM is here, and if you’re running Docker on macOS, you...
Forums
Cannot execute SQL cursor in Azure Query Editor (Preview)
Apologies if this is posted in the wrong forum, but I am trying to...
SQl Server 2014 linked server remote server
Hello all, I have a linked server created on an instance which only has...
Find all the tables in a database containing particular column value
Hi, I want to find all the tables name under a database where tables...
Question of the Day
The Ending Substring
In Azure SQL Database and SQL Server 2025, if I run this, what is returned?
SELECT '[' + SUBSTRING('Steve Jones', 7) + ']' See possible answers