.NETADO.NETAgileAngularArchitectureASP.NETAuthenticationAzureAzure FunctionBIBig DataBlazorBusinessC#Cloud ServiceCosmosDBCSSDebuggingDesignEncryptionEntity FrameworkFYIGoogleHardwareInternetInterviewsJavascriptjQueryLeadershipLINQManagementMicrosoftMobileMS OfficeMS SQLNetworkingNoSQLOOPProject ManagementSoftware DevelopmentSource ControlSSISSSRSSyncfusionTeamTestingTSQLUncategorizedVendor SoftwareVisual StudioWebWeb ServicesWindowsWordPress
Error: Error in Visual Studio when trying to publish project. Event name should have at least 3 parts separated by slash Fix: This specific error happens when you are not logged in to the Azure account in VS (the account that contains the Function app). To work-around this issue: You can go to File ->... » read more
Things to remember when deleting a large number of records from a database table. Consider using TRUNCATE instead of DELETE if truncating the table (removing all records from the table) is ok. Remove records in batches. Make sure there is enough space for the log files. If database is simple, truncate log after every run.... » read more
Create a macro and open the following application… C:\Windows\explorer.exe and set the parameter to the folder location C:\\folder01 Sources:
For Existing Table For New Table Definition
Using GOTO instead sql query statement.
Simple restore database to same server on same disk configuration.
Key Action F5 Execute Ctrl + F Find Ctrl + H Find and Replace Ctrl + F4 Close Query Crtl + K + C Comment Crtl + K + U Uncomment Crtl + Shift + V Cycle Through Clipboard
Key Action F11 Full Screen F12 Console Ctrl + F5 Clear Cache and Reload Page Ctrl + Shift + T Reopen Last Closed Tab Ctrl + Shift + Delete Clear Browsing Data Ctrl and + Zoom In Ctrl and – Zoom Out Ctrl + D Bookmark Current Page Sources: https://www.google.com/chrome/tips/
Key Action F5 Build Crtl + K + C Comment Line Crtl + K + U Uncomment Line Crtl + M + O Collapse All Crtl + Scroll Up Zoom In Ctrl + Scroll Down Zoom Out Printable Sheet Click to get our printable keyboard shortcut cheatsheet for Visual Studio Sources: https://docs.microsoft.com/en-us/visualstudio/ide/default-keyboard-shortcuts-in-visual-studio?view=vs-2019
Open up the new SQL Server installation -> Maintenance -> Edition Upgrade SQL Server 2019 Standard Edition -> SQL Server 2019 Developer Edition Not supported. Have to uninstall SQL Server 2019 Standard Edition and then reinstall SQL Server Developer Edition. Rule “SQL Server 2019 edition upgrade” failed. The selected SQL Server instance does not meet... » read more