Great minds discuss ideas!
In-Place Upgradation vs Side-by-Side Migration in SQL Server Upgrading SQL Server is a critical process for organizations that need better performance, security, and modern features. Two main approaches are commonly used: In-Place Upgradation and Side-by-Side Migration. Understanding the differences, challenges,…
Changing the collation of an SQL Server instance after installation is a significant task that requires careful planning and execution. Collation affects how data is sorted and compared, so it’s crucial to approach this change methodically to ensure data integrity…
In the realm of database administration, understanding and managing network configurations is paramount. SQL Server, like many database systems, relies on TCP/IP for network communications. Consequently, knowing which TCP ports are in use by your SQL Server instance can be…
In the realm of SQL Server management, keeping up with service packs and cumulative updates is not just a recommendation—it’s a necessity. Understanding these updates and their importance can make a significant difference in the performance, security, and reliability of…
Introduction Keeping your SQL Server instances updated is crucial for security, performance, and stability. In this blog, we will go through the process of applying SQL Server patches or cumulative updates (CUs) to a SQL Server Always On Availability Group.…
What is SQL Server UPGRADATION? Upgrading means, migrating sql server old version to sql server 2012. Before upgradation we need to run upgrade advisor tool. Microsoft sql server 2012 upgrade advisor Under installation menu → in planning → click upgrade…
Migration means moving one (or) set of databases from one server to another server. SQL Server Migration Scenarios Scenario 1: As a part of launch, deployment in the production server and go live In all these 3 types we are…
Installation Whenever we want to start the installation of the SQL server we need to gather details of installation. SQL Server Versions Version (Name) RTM SP1 SP2 SP3 SP4 Sql server 2014 (Heteko) Trail version released Sql server 2012 (Denali)…