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:

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

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. Note: During SQL Server 2019... » read more

SQL Server Managmenet Studio 18 (SSMS)

Install 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 versions are available for use. However, if you have a preview version of SSMS 18.x installed, you must uninstall it before installing SSMS 18.4. You can see if you have the Preview version by going... » 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