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

Upgrade availability group replicas

https://learn.microsoft.com/en-us/sql/database-engine/availability-groups/windows/upgrading-always-on-availability-group-replica-instances?view=sql-server-ver16 When upgrading a SQL Server instance that hosts an Always On availability group (AG) to a new SQL Server version, to a new SQL Server service pack or cumulative update, or when installing to a new Windows service pack or cumulative update, you can reduce downtime for the primary replica to only a single... » read more

0
Read
echiang
Check Current Windows Version

To find out which version of Windows your device is running, press the Windows logo key  key + R, type winver in the Open box, and then select OK. Select the Start  button > Settings  > System  > About .

0
Read
echiang
Things to Avoid in Your Query

LIKE ‘%xxxxxx%’ https://www.brentozar.com/archive/2010/06/sargable-why-string-is-slow/ Table Valued Functions https://www.brentozar.com/blitzcache/tvf-join/ Functions in from/below Implicit Conversions (convert to different data type) Comparing the contents of 2 columns on 1 table Table Variables Table variable does not have stats and serial for updates.

0
Read
echiang
CTE (Common Table Expression)

https://learn.microsoft.com/en-us/sql/t-sql/queries/with-common-table-expression-transact-sql?view=sql-server-ver16 Specifies a temporary named result set, known as a common table expression (CTE). This is derived from a simple query and defined within the execution scope of a single SELECT, INSERT, UPDATE, DELETE or MERGE statement.  A Common Table Expression, also called as CTE in short form, is a temporary named result set that... » read more

0
Read
echiang
SQL Server Windows Failover Cluster – Unable to start Roles

Status: Windows Failover Cluster fail to start any of the Roles All nodes in the Windows Failover Cluster are up. Identified several important event IDs that are common across all SQL nodes: 1069, 1205, 1254. Probable Causes: -SQL node names and AG name are not resolving or couldn’t register in the network. please look at the... » read more

0
Read
echiang
ONLINE = ON

ONLINE = ON for SQL Server Enterprise / Developer Edition ONLINE = OFF for SQL Server Standard Edition

0
Read
echiang
Updating SSL Certificate for Azure Web App

https://decoder.link/converter Input: mydomain.com.crt (cert folder) mydomain.com_key.txt (key folder) mydomain.com.ca-bundle (cert folder) Output: mydomain.pfx Upload the generated .pfx file to your Azure Web App “Certificates” and update your “Custom Domains” with the new certificate. Resources: https://www.ssls.com/

0
Read
echiang
UDF (User Defined Functions) and Serialization

Your queries could be going parallel, but because of limitations in SQL Server, they staying serial: single-threaded. A lot of different things can cause this, including running SQL Server Express Edition (which only uses 1 CPU core), but the most common are Scalar UDFs. Generally, there’s not a server-level fix for these: you’re stuck rewriting the... » read more

0
Read
echiang