Microsoft Failover Cluster Manager (MSFCM)

You can access the Microsoft Failover Cluster Management in a couple of different ways: Go to Server Manager, Features, Failover Cluster Manager Go to Control Panel, Administrative Tools, Failover Cluster Manager Sources: https://www.mssqltips.com/sqlservertip/2672/managing-a-windows-and-sql-server-cluster-using-the-failover-cluster-manager-tool/

SQL Server 2008 High Availability Options

There are 4 High Availability options in SQL Server 2008 that we will cover; Failover Clustering, Database Mirroring, Log Shipping and Replication. Each one has its own features and benefits. The Failover Clustering supports server level high availability whereas Database Mirroring and Log Shipping are per database and Replication is object level.  Failover Clustering This... » read more

Upgrade from SQL Server 2008 (10.x) to SQL Server 2017 (14.x).

You can upgrade from SQL Server 2008, SQL Server 2008 R2, SQL Server 2012 (11.x), SQL Server 2014 (12.x), and SQL Server 2016 (13.x). Upgrades from Earlier Versions to SQL Server 2017 (14.x) SQL Server 2017 (14.x) supports upgrade from the following versions of SQL Server: SQL Server 2008 SP4 or later SQL Server 2008... » read more

Offline installation for Machine Learning Server for Windows

By default, installers connect to Microsoft download sites to get required and updated components for Machine Learning Server for Windows. If firewall constraints prevent the installer from reaching these sites, you can use an internet-connected device to download files, transfer files to an offline server, and then run setup. https://docs.microsoft.com/en-us/machine-learning-server/install/machine-learning-server-windows-offline Note: During SQL Server 2019... » read more

SQL Server Managmenet Studio 18 (SSMS)

Install https://docs.microsoft.com/en-us/sql/ssms/download-sql-server-management-studio-ssms?view=sql-server-ver15 SSMS 18.4 is the latest general availability (GA) version of SSMS. If you have a previous GA version of SSMS 18 installed, installing SSMS 18.4 upgrades it to 18.4. The SSMS 18.x installation doesn’t upgrade or replace SSMS versions 17.x or earlier. SSMS 18.x installs side by side with previous versions, so both... » read more

SQL Transparent Data Encryption (TDE)

SQL Transparent Data Encryption (TDE) Feature is a native feature of SQL Enterprise edition. Transparent Data Encryption is designed to protect data by encrypting the physical files of the database, rather than the data itself. Its main purpose is to prevent unauthorized access to the data by restoring the files to another server. With Transparent... » read more