.NETADO.NETAgileAngularArchitectureASP.NETAuthenticationAzureAzure FunctionBIBig DataBlazorBusinessC#Cloud ServiceCosmosDBCSSDebuggingDesignEncryptionEntity FrameworkFYIGoogleHardwareInternetInterviewsJavascriptjQueryLeadershipLINQManagementMicrosoftMobileMS OfficeMS SQLNetworkingNoSQLOOPProject ManagementSoftware DevelopmentSource ControlSSISSSRSSyncfusionTeamTestingTSQLUncategorizedVendor SoftwareVisual StudioWebWeb ServicesWindowsWordPress
Query to return long running transactions and cumulative CPU time in MS for open transactions in a SQL Server Database A long running transaction keeps the transaction log active from the virtual log file containing the first log record of the transaction. Truncation cannot occur from that virtual log file onward. It may leads to... » read more
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