Explains a critical Azure Policy limitation where databases created via SSMS on SQL Managed Instance bypass policy enforcement, posing security risks.
SQL Server 2019 has ended mainstream support, leaving users with only security patches. This article outlines the implications and next steps.
A guide to monitoring SingleStore database clusters using the sdb-admin toolkit, covering status checks, resource usage, and troubleshooting.
Strategies for optimizing Amazon RDS costs on AWS, including right-sizing instances, storage optimization, and using Graviton processors.
A technical guide on configuring SQL Managed Instance on Azure Arc, covering parameters for creation, resource allocation, and storage options.
Explains the importance of transactional DDL in SQL for safe and reliable database schema migrations during application upgrades.
A guide to managing database changes in .NET using Database Projects for state versioning and DbUp for migration scripting.
SQL Server 2019's Master Data Services (MDS) finally replaces the Silverlight-based web interface with a modern, browser-agnostic HTML front-end.
How to use the Flyway baseline command to introduce database migrations into an existing, pre-populated database schema.
Summary of major database trends in Fall 2017, including SQL's resurgence, cloud pricing wars, IBM's renaming controversy, and new releases.
A summary of key SQL Server management takeaways from a TechEd Europe 2014 session, covering backups, TempDB, and indexing.
A developer shares their experience using MongoVUE, a free .NET-based GUI tool for managing MongoDB databases.
A review of the SSMS Tools Pack, a free productivity add-in for SQL Server Management Studio, highlighting its key features like snippets and connection coloring.
Overview of SQL Azure Project 'Houston', a browser-based Silverlight tool for managing SQL Azure databases, including its features and limitations.
Introducing SQL Azure Manager, a community tool for connecting to and managing SQL Azure databases, addressing usability issues with SQL Server Management Studio.
A guide to Debian-based control panels and tools for simplifying web hosting server administration and user management.
