EugeneChiang.com

Knowledge is Power. Never Stop Learning. Seek the Truth.

.NETADO.NETAgileAngularArchitectureASP.NETAuthenticationAzureAzure FunctionBIBig DataBlazorBusinessC#Cloud ServiceCosmosDBCSSDebuggingDesignEncryptionEntity FrameworkFYIGoogleHardwareInternetInterviewsJavascriptjQueryLeadershipLINQManagementMicrosoftMobileMS OfficeMS SQLNetworkingNoSQLOOPProject ManagementSoftware DevelopmentSource ControlSSISSSRSSyncfusionTeamTestingTSQLUncategorizedVendor SoftwareVisual StudioWebWeb ServicesWindowsWordPress

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

0
Read
echiang
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 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

0
Read
echiang
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

0
Read
echiang
ISO File

Using .iso file. Right click on the file .iso and select the option to Mount, this will create a virtual DVD drive (Usually the E: drive). After the virtual drive has been created (mounted), you can use the drive to access the content.

0
Read
echiang
How to Grant Permissions to run SQL Server Profiler for a non System Admin User

In order to run a trace against SQL Server you must be a member of sysadmin fixed server role or have the ALTER TRACE permission. Sources: https://www.mssqltips.com/sqlservertip/3559/how-to-grant-permissions-to-run-sql-server-profiler-for-a-non-system-admin-user/ https://learn.microsoft.com/en-us/sql/tools/sql-server-profiler/permissions-required-to-run-sql-server-profiler?view=sql-server-ver16

0
Read
echiang
Always On Availability Group – Select Data Synchronization

Select “Automatic seeding” (default) if you have not created the database on the secondary replica and would like this wizard to create the database on the secondary replica based on the same setting as the primary replica. Use this option, if this is a small database. Select “Join only” if you already have already created... » read more

0
Read
echiang
Upgrading SQL Server 2014 via Uninstall/Re-install

Process Detach databases. Uninstall SQL Server 2014 Install SQL Server 2016/2019 Reattach databases. Uninstall SQL Server 2014 (v12) To uninstall SQL Server instance, go to Control Panel and then Programs and Features. Select and right-click on Microsoft SQL Server 2014 and select Uninstall/remove. Upgrade to SQL Server 2016 (v13) SSMS Tool https://docs.microsoft.com/en-us/sql/ssms/download-sql-server-management-studio-ssms?view=sql-server-ver15 Upgrade to SQL... » read more

0
Read
echiang