Ryzora's Blog

SQL Server Failover Cluster Instance (FCI) On this guide, I will show you how to setup a SQL Server Failover Cluster Instance or mostly called SQL Server FCI. It is a bit different than SQL Server AlwaysOn Availability Group where we can have primary node (owner node) and secondary node but the SQL Server itself is actually treated as a single Instance using Shared Cluster Disk.  Notes: This guide will use VMWare on my local computer for testing purpose only The requirements for setting up SQL Server Failover Cluster Instance are these: - Primary node and Secondary node for hosting SQL FCI joined to Active Directory - Windows Server Failover Cluster (WSFC) configured for all nodes - Shared Cluster disk for the Cluster which will be used for SQL FCI - Network Name for the SQL Server name in Active Directory - An IP Address for SQL FCI For configuring and installing SQL Primary node and Secondary Node, also with configuring and installing WSFC you can follow the guide which I previously

  What is SQL Server Management Studio (SSMS)? SQL Server Management Studio (SSMS) is an integrated environment for managing any SQL infrastructure. Use SSMS to access, configure, administer, and develop all components of SQL Server,  Azure SQL Database ,  Azure SQL Managed Instance ,  SQL Server on Azure VM , and  Azure Synapse Analytics  . SQL Server Management Studio provides one comprehensive utility that combines an extensive group of graphical tools with many rich script editors to provide access to SQL Server for developers and database administrators of all skill levels. SSMS is a must have tool if you want to easily manage your SQL Server. You need a windows computer to use the tool, but it can connect to any SQL Server supported by Microsoft including SQL Server hosted in Linux OS. Almost all activities in SQL Server can be managed by using SSMS, and it provides GUI interface so it’s easier to get a good look on SQL Server. Download SQL Server Management Studio : Downlo

  Get started Editions and features : Review the supported features for the different editions and versions of SQL Server to determine which best suits your business needs. SQL Server 2022 (16.x) SQL Server 2019 (15.x) SQL Server 2017 (14.x) SQL Server 2016 (13.x) SQL Server 2014 (12.x) Requirements : Review hardware and software installation requirements for  SQL Server 2016 and SQL Server 2017 ,  SQL Server 2019 ,  SQL Server 2022 , or  SQL Server on Linux , as well as system configuration checks, and security considerations in  Planning a SQL Server Installation Installation media The download location for SQL Server depends on the edition: SQL Server Enterprise, Standard, and Express editions  are licensed for production use. For the Enterprise and Standard Editions, contact your software vendor for the installation media. You can find purchasing infor