The Relational Database is the Default
If you don't have a good reason not to, use a relational database. Always.
2017-12-07
99 reads
Editorials
2017-12-06
84 reads
A Christmas Bug
A bug in American Airlines scheduling could impact travelers, but certainly will impact their bottom line.
2017-12-04
89 reads
The Appearance of the Flat File Wizard.
After many barren years, Phil Factor is pleased to see the first signs of Spring in SSMS.
2017-12-04
84 reads
Certifying Schools
Schools don't necessarily teach people how to code, but they could do a better job.
2017-11-30
84 reads
2017-11-29
180 reads
We Need DevOps for Performance
CosmosDB has ways to tune performance based on throttle metrics. We probably need some DevOps style feedback and adjustment for relational systems.
2017-11-28
61 reads
A well-earned break from the database
Databases, like sheep, get get into some surprising scrapes. However, as long as you've planned for all the common mishaps, your conscience should be clear to take a well-earned holiday.
2017-11-27
63 reads
2017-11-24
69 reads
2017-11-23
38 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