Joey D'Antoni Blogged: Joey D'Antoni https://www.dcac.com/2026/05/07/mastering-the-challenges-of-postgresql-high-availability-and-disaster-recovery/ Mastering the Challenges of PostgreSQL High Availability and Disaster Recovery #sqlserver
Mastering the Challenges of PostgreSQL High Availability and Disaster Recovery

In recent years, we’ve seen an upturn in adoption of the open-source database engine PostgreSQL. Commercial databases like Oracle and SQL Server can become quite expensive as applications grow to massive scale. Oracle licensing is complex and very expensive. While we at DCAC still love SQL Server and it’s at the heart of our business, we do see the demand for PostgreSQL cropping up amongst clients. PostgreSQL is a solid database engine—I’ve built applications on it, however as economist Milton Friedman famously said, “there is no such thing as a free lunch.” If you talk to any database expert, you’ll

Denny Cherry & Associates Consulting

How to Install #Microsoft SQL Server on #Ubuntu #VPS (10 Minute Quick-Start Guide)

This article provides a guide for how to install Microsoft SQL Server on Ubuntu VPS.
What is Microsoft SQL Server?
Microsoft SQL Server is a relational database management system (RDBMS) developed by Microsoft. It is used to store, retrieve, manage, and analyze data in a structured way using SQL (Structured ...
Continued 👉 https://blog.radwebhosting.com/install-microsoft-sql-server-on-ubuntu-vps/?utm_source=mastodon&utm_medium=social&utm_campaign=mastodon.social #sqlserver #apache #selfhosted #selfhosting #mssql #freetds

How to Install #Microsoft SQL Server on #Ubuntu #VPS (10 Minute Quick-Start Guide)

This article provides a guide for how to install Microsoft SQL Server on Ubuntu VPS.
What is Microsoft SQL Server?
Microsoft SQL Server is a relational database management system (RDBMS) developed by Microsoft. It is used to store, retrieve, manage, and analyze data in a structured way using SQL (Structured ...
Continued 👉 https://blog.radwebhosting.com/install-microsoft-sql-server-on-ubuntu-vps/?utm_source=mastodon&utm_medium=social&utm_campaign=mastodon.raddemo.host #mssql #selfhosting #selfhosted #freetds #sqlserver #apache

Blog post from the past:
In which I go over potential reasons for why some special characters end up corrupted and displayed as question marks, squares or something completely different in SQL Server.
https://vladdba.com/2024/10/04/characters-question-marks-squares-sql-server/
#sqlserver #sqldba #microsoftsqlserver #mssqlserver #mssql #mssqldba
Characters displayed as question marks or squares in SQL Server

In this post I'm going over potential reasons why some characters end up displayed as question marks or squares in SQL Server.

VladDBA
Dew Drop Weekly Newsletter #481 - Week Ending May 1, 2026

Dew Drop Weekly Newsletter #481 - Week Ending May 1, 2026

Zoho Campaigns

How to Install #Microsoft SQL Server on #Ubuntu #VPS (10 Minute Quick-Start Guide)

This article provides a guide for how to install Microsoft SQL Server on Ubuntu VPS.
What is Microsoft SQL Server?
Microsoft SQL Server is a relational database management system (RDBMS) developed by Microsoft. It is used to store, retrieve, manage, and analyze data in a structured way using SQL (Structured ...
Continued 👉 https://blog.radwebhosting.com/install-microsoft-sql-server-on-ubuntu-vps/?utm_source=mastodon&utm_medium=social&utm_campaign=mastodon.raddemo.host #freetds #apache #sqlserver #selfhosting #mssql #selfhosted

Sweet lord...

Started asking a few questions of my coworkers today. Here's what I've determined: a data analyst is going to build a 3,000 line stored procedure that brings our primary SQL host to its knees, which will be used to generate a horrific SSRS report for a C-level type, who will print it out and most likely put it on their desk and never even look at it.

#DBA
#SQLServer

New blog post:
My guideline on how to handle and test SQL Server backups to ensure their viability and avoid a "Schrödinger's backup" scenario.
https://vladdba.com/2026/04/23/test-sql-server-backups-schrodingers-backups/
#sqlserver #sqldba #microsoftsqlserver #mssqlserver #mssql #mssqldba #sql #azure
Test SQL Server backups to avoid Schrödinger's backups

This post is my guideline on how to handle and test SQL Server backups to ensure their viability and avoid a "Schrödinger's backup" scenario.

VladDBA
Joey D'Antoni Blogged: Joey D'Antoni https://www.dcac.com/?p=87121 Auto Draft #sqlserver
High Availability and Disaster Recovery in the Cloud

Editor’s Note: This was written before last Friday’s complete outage of Azure East US. Cloud failures are frequently regional in nature—you’re mission critical apps should be multi-region if they are very important to your business’s operations.

Denny Cherry & Associates Consulting