.NETADO.NETAgileAngularArchitectureASP.NETAuthenticationAzureAzure FunctionBIBig DataBlazorBusinessC#Cloud ServiceCosmosDBCSSDebuggingDesignEncryptionEntity FrameworkFYIGoogleHardwareInternetInterviewsJavascriptjQueryLeadershipLINQManagementMicrosoftMobileMS OfficeMS SQLNetworkingNoSQLOOPProject ManagementSoftware DevelopmentSource ControlSSISSSRSSyncfusionTeamTestingTSQLUncategorizedVendor SoftwareVisual StudioWebWeb ServicesWindowsWordPress
https://www.w3schools.com/sql/sql_join_full.asp The FULL OUTER JOIN keyword returns all matching records from both tables whether the other table matches or not. So, if there are rows in “Customers” that do not have matches in “Orders”, or if there are rows in “Orders” that do not have matches in “Customers”, those rows will be listed as well.
Increasing the Failover Maximum failures in a specified period will enhance the cluster service for making more attempts in keeping the role up and working. You can increase Maximum failures in a specified time period to 5 or more. Default is 2 in 6 hours. Failover Cluster Manager -> Roles -> click on resource ->... » read more
Error: No Global Profile Is Configured Resolution: 1. Open database mail configuration by logging into SQL Server Management studio and expanding Management and right clicking on DatabaseMail, then choosing configure: 2. Choose Manage Profile Security. 3. Configure your profile to be the default profile: There’s no need to restart anything, your maintenance plan should now send... » read more
Resolution: Find Constraints Drop Constraints TRUNCATE Table Data Recreate Constraints Sources:
Example: -1253826760 = Desktop -1592396055 = Express -1534726760 = Standard 1333529388 = Workgroup 1804890536 = Enterprise -323382091 = Personal -2117995310 = Developer 610778273 = Enterprise Evaluation 1044790755 = Windows Embedded SQL 4161255391 = Express with Advanced Services
Install the following packages from Nuget Package Manager… Microsoft.EntityFrameworkCore Microsoft.EntityFrameworkCore.Design Microsoft.EntityFrameworkCore.SqlServer Install Entity Framework.. Check to see if Entity Framework is installed You will get the following if EF is not installed… dotnet : Could not execute because the specified command or file was not found. At line:1 char:1 + dotnet ef + ~~~~~~~~~ +... » read more
Create New Project Template: ASP.NET Core Web API Framework: .NET 6.0 Check “Configure for HTTPS“ Check “Use controllers (uncheck to use minimal API)” for controller vs minimal API Check “Enable OpenAPI support” for Swagger OpenAPI support Book Class Book Controller or … For Delete, pass in object instead of id. BookController using Entity Framework Example:
Visual Studio 2022 New Project Template: ASP.NET Core Web API Framework: .NET 6.0 Check “Configure for HTTPS“ Check “Use controllers (uncheck to use minimal API)” for controller vs minimal API Check “Enable OpenAPI support” for Swagger OpenAPI support Entity Framework Install the following from Nuget Package Manager… Microsoft.EntityFrameworkCore Microsoft.EntityFrameworkCore.Design Microsoft.EntityFrameworkCore.SqlServer PM> dotnet tool install –global... » read more
Error: Login failed for login <Login Name> due to trigger execution. Changed database context to ‘master’. Changed language setting to us_english. (Microsoft SQL Server, Error: 17892) Resolution: Search for the trigger via: If you see a server level trigger that might be responsible for the login issues, then you can drop it with: Instead of... » read more