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

Download Large File with BitTorrent Client

BitTorrent BitTorrent is a proprietary adware BitTorrent client developed by Bram Cohen and Rainberry, Inc. used for uploading and downloading files via the BitTorrent protocol. BitTorrent was the first client written for the protocol. It is often nicknamed Mainline by developers denoting its official origins.  https://www.bittorrent.com/products/win/bittorrent-classic-compare/ Beware: Installing the free edition of BitTorrent application on... » read more

0
Read
echiang
Screen Capture on Windows

Press Windows logo key  + Shift + S for a static image snip. https://support.microsoft.com/en-us/windows/use-snipping-tool-to-capture-screenshots-00246869-1843-655f-f220-97299b865f6b

0
Read
echiang
Truncate table for system versioned table

Error: Msg 13545, Level 16, State 1, Line 14Truncate failed on table ‘tbXXXXX’ because it is not a supported operation on system-versioned tables. Resolution: Links: https://rajeevdotnet.blogspot.com/2019/05/truncate-system-version-table-temporal.html

0
Read
echiang
Unable to Install SSRS 2022

Issue Unable to install SSRS 2022. Setup failed UnexpectedError: Bundle action failed: The system cannot locate the resource specified (0x800C0005) Setup: Install Completed for package Installing Microsoft .NET 4.8 Resolution Server does not have internet access. Unable to download and install supporting component Microsoft .NET 4.8. Download offline installer for “Microsoft .NET Framework 4.8 offline... » read more

0
Read
echiang
SQL Server Database AlwaysOn without Clustering

It is possible to setup SQL Server AlwaysOn without Windows Failover Clustering. The feature “Windows Failover Cluster” does not need to be installed on the server. There will still be Primary and Secondary AlwaysOn servers. This setup is useful when you do not need failover, but simply to setup for a read-only secondary server. Note:... » read more

0
Read
echiang
Unable to uninstall or reinstall SSRS

Error: SSRS service will not start. Ended up un-install and re-install SSRS to get SSRS working again. Ran into error with un-install SSRS. Ran into the same error with re-install SSRS. Resolution: Remove the following directory… and then run install SSRS. C:\Program Files\Microsoft SQL Server Reporting Services

0
Read
echiang
Blitz Result: Slow Storage Reads or Writes

https://www.brentozar.com/blitz/slow-storage-reads-writes/ SQL Server feels the need – the need for speed.  Storage speed, to be more specific.  One of the most common bottlenecks is underperforming storage subsystems. SQL Server tracks read and write speeds for each database file – both data and log files.  This part of our SQL Server sp_Blitz script checks sys.dm_io_virtual_file_stats looking for average... » read more

0
Read
echiang
DBCC CHECKDB Not Run Recently

https://www.brentozar.com/blitz/dbcc-checkdb-not-run-recently/ When SQL Server writes data to your drives, it just assumes everything’s okay until it needs to read the data back again. Unfortunately, in the event of storage corruption, the storage isn’t so kind as to alert SQL Server.  And sometimes, SQL Server has even been known to corrupt itself. We need to periodically check... » read more

0
Read
echiang