Home » Posts tagged 'SQL Server'
Tag Archives: SQL Server
Azure Arc in Action: Hybrid Cloud Management Made Easy
In today’s hybrid and multi-cloud world, managing SQL Server instances across diverse environments can be a daunting task. Enter Azure Arc—Microsoft’s game-changing solution that brings the power of Azure to your on-premises, edge, and multi-cloud SQL Server deployments. Azure Arc is a hybrid and multi-cloud management platform developed by Microsoft that extends Azure’s capabilities to infrastructure and … Continue reading
Database Concurrency: MVCC in PostgreSQL vs Row Versioning in SQL Server
What is Concurrency in Databases? Concurrency control ensures that multiple transactions can occur simultaneously without leading to data inconsistency. Two popular concurrency control mechanisms are: MVCC in PostgreSQL PostgreSQL uses MVCC to handle concurrent transactions without locking rows for reads. Instead of overwriting data, it creates a new version of a row for every update. … Continue reading
Query Store – Useful Tool for DBAs
SQL Server is a robust and flexible database management system that offers a variety of features and capabilities to help organizations effectively manage their data. One of the key features of SQL Server is its ability to provide insights into query performance, enabling database administrators and developers to identify and resolve performance issues. The Query … Continue reading
Step By Step Installation of SQL Server 2019 with all features
[MSSQLFUN & Decode ITeS becomes a family of 1500 individuals across the globe. Please join us on Facebook & YouTube.] Today, I will take you to step by step installation of SQL Server 2019 with all features. You can go through my previous post for downloading Download SQL Server Developer / Evaluation / Express Editions, YouTube Link. … Continue reading
SQL Server Cluster LooksAlive and IsAlive Check
Windows Cluster Service use the “heartbeat” process to check whether each node is alive at both the OS level and SQL Server level. Heartbeat signals works on UDP. Microsoft Windows Cluster service perform 2 health checks to perform node & resource availability check. LooksAlive Health Check 1) LooksAlive is a quick lightweight health check 2) … Continue reading