.NETADO.NETAgileAngularArchitectureASP.NETAuthenticationAzureAzure FunctionBIBig DataBlazorBusinessC#Cloud ServiceCosmosDBCSSDebuggingDesignEncryptionEntity FrameworkFYIGoogleHardwareInternetInterviewsJavascriptjQueryLeadershipLINQManagementMicrosoftMobileMS OfficeMS SQLNetworkingNoSQLOOPProject ManagementSoftware DevelopmentSource ControlSSISSSRSSyncfusionTeamTestingTSQLUncategorizedVendor SoftwareVisual StudioWebWeb ServicesWindowsWordPress
Converts an inputdate to the corresponding datetimeoffset value in the target time zone. When inputdate is provided without offset information, the function applies the offset of the time zone assuming that inputdate is in the target time zone. If inputdate is provided as a datetimeoffset value, then AT TIME ZONE clause converts it into the target time zone using the time zone conversion rules. AT TIME ZONE implementation relies on... » read more
Error: An internal error occurred on the report server. See the error log for more details. (rsInternalError) Get Online Help For more information about this error navigate to the report server on the local server machine, or enable remote errors Fix: To determine the specific cause for this message, review the report server log files,... » read more
Azure Data Studio is a cross-platform database tool for data professionals using on-premises and cloud data platforms on Windows, macOS, and Linux. Azure Data Studio offers a modern editor experience with IntelliSense, code snippets, source control integration, and an integrated terminal. It’s engineered with the data platform user in mind, with built-in charting of query... » read more
Error: Getting the following error when trying to create linked servers (from an old script) on SQL Server 2019. The requested OLE DB provider SQLNCLI10.1 is not registered. Fix: In the linked server script, replace @provider=N’SQLNCLI10‘ with @provider=N’SQLNCLI‘
Error: While trying to setup a couple of SQL Enterprise servers in an Availability Group I kept getting the message “The local node is not part of quorum and is therefore unable to process this operation” Fix: I had done things in the wrong order. I had ticked “Enable AlwaysoOn Availability Groups” in SQL Server Configuration Manager... » read more
appsettings.json MyController.cs
Windows Azure Storage SDK Need to download and install the Windows Azure Storage SDK first. Go to NuGet Package Manager and search for “WindowsAzure.Storage” Note: There is a new version of SDK “Azure.Storage.Blobs” but not all functions has been migrated over to the newer version. Example: Index.razor Note: The ID field must be “UploadFiles” to... » read more
Get started with the Azure Blob Storage client library v12 for .NET. Azure Blob Storage is Microsoft’s object storage solution for the cloud. Follow steps to install the package and try out example code for basic tasks. Blob storage is optimized for storing massive amounts of unstructured data. Use the Azure Blob Storage client library... » read more
Error: When trying to add server to Availability Replicas, you get the following error… Failed to obtain cluster information. Either the specified instance of SQL Server is not running on a Windows Server Failover Cluster (WSFC)node, or the user lacks sysadmin permissions on the SQL Server instance to obtain the cluster information. Fix: 1) check... » read more
Error: Error when trying to create a database backup. Fix: Look for the service SQL Server (MSSQLServer) and see the username under ‘Log On As’. Add this user to have full control of permissions on the directory of back up by navigating to the folder / properties/ under secirity tab / Edit and give the... » read more