Bulk Insert from File
Insert the content of files into a database table.
.NETADO.NETAgileAngularArchitectureASP.NETAuthenticationAzureAzure FunctionBIBig DataBlazorBusinessC#Cloud ServiceCosmosDBCSSDebuggingDesignEncryptionEntity FrameworkFYIGoogleHardwareInternetInterviewsJavascriptjQueryLeadershipLINQManagementMicrosoftMobileMS OfficeMS SQLNetworkingNoSQLOOPProject ManagementSoftware DevelopmentSource ControlSSISSSRSSyncfusionTeamTestingTSQLUncategorizedVendor SoftwareVisual StudioWebWeb ServicesWindowsWordPress
Azure Cosmos DB
Azure Cosmos DB is Microsoft’s proprietary globally-distributed, multi-model database service “for managing data at planet-scale” launched in May 2017. It is schema-agnostic, horizontally scalable, and generally classified as a NoSQL database. Azure Cosmos DB is a fully managed NoSQL database service for modern app development. Get guaranteed single-digit millisecond response times and 99.999-percent availability, backed... » read more
SQL vs NoSQL
What is NoSQL? NoSQL is a non-relational DMS, that does not require a fixed schema, avoids joins, and is easy to scale. NoSQL database is used for distributed data stores with humongous data storage needs. NoSQL is used for Big data and real-time web apps. For example companies like Twitter, Facebook, Google that collect terabytes of... » read more
Enable Anonymous Access for Confluence Site
https://support.atlassian.com/confluence-cloud/docs/set-up-public-access/ To enable anonymous access: Select (Settings) in the Confluence navigation Choose Global Permissions in the left-hand panel Click Edit Permissions In the Anonymous Access section, check the box under Use Confluence Click Save all To allow anonymous users to see user profiles, check the checkbox in the View User Profiles section. You need to grant the Use Confluence permission to grant the View User... » read more
Set Azure Function Time Zone for Timer Trigger
Azure Function based on Web app sandbox. Web app need you to set the timezone in env settings first. The timetrigger attribute is the declaration part of the function. The environment variables will be checked here. If you do not set the environment variables about the time zone in advance, it will be processed according... » read more
Copy Database Login User Account After Database Restore
Note: Run the following on the source server and run the output on the destination server. Run after database has been restored. Apply to restored databases from PROD backup. Apply to AlwaysOn databases.
C# Get Time By Time Zone
Note: Different OS will have different Time Zone Id. On Windows systems, FindSystemTimeZoneById tries to match id to the subkey names of the HKEY_LOCAL_MACHINE\Software\Microsoft\Windows NT\CurrentVersion\Time Zones branch of the registry. On Linux and macOS, it uses time zone information available in the ICU Library Windows OS Pacific Standard Time Non Windows OS America/Los_Angeles Time Zone List https://en.wikipedia.org/wiki/List_of_tz_database_time_zones Code UTC... » read more
Secret Manager Tool for .NET App
This document explains how to manage sensitive data for an ASP.NET Core app on a development machine. Never store passwords or other sensitive data in source code. Production secrets shouldn’t be used for development or test. Secrets shouldn’t be deployed with the app. Instead, production secrets should be accessed through a controlled means like environment... » read more
SendGrid Setup
Create SendGrid Account https://sendgrid.com/ Install the package The recommended installation uses the NuGet package manager. Run the following: Alternatively, you can download the SendGrid C# .NET library directly from our Github repository. Send your first email The following is the minimum needed code to send an email:
Moving Large Number of Records between Databases Involved in AlwaysOn.
Moving data from Transaction database to Archive/Reporting database. After the records has been moved, delete the records to avoid duplicates. Note: If your database is involved in AlwaysOn or in Full Recovery mode, make sure you backup the database and log file to clear out the log files on the database before preceding. After you... » read more