.NETADO.NETAgileAngularArchitectureASP.NETAuthenticationAzureAzure FunctionBIBig DataBlazorBusinessC#Cloud ServiceCosmosDBCSSDebuggingDesignEncryptionEntity FrameworkFYIGoogleHardwareInternetInterviewsJavascriptjQueryLeadershipLINQManagementMicrosoftMobileMS OfficeMS SQLNetworkingNoSQLOOPProject ManagementSoftware DevelopmentSource ControlSSISSSRSSyncfusionTeamTestingTSQLUncategorizedVendor SoftwareVisual StudioWebWeb ServicesWindowsWordPress
Standard Edition only allows Always On setup in basic mode. Switch to Enterprise Edition for full Always On features. Always On Basic Mode (Standard Edition) Limitations Basic availability groups use a subset of features compared to advanced availability groups on SQL Server Enterprise Edition. Basic availability groups include the following limitations: Limit of two replicas... » read more
https://www.brentozar.com/first-aid/ https://github.com/BrentOzarULTD/SQL-Server-First-Responder-Kit#how-to-install-the-scripts Run Install-All-Scripts.sql in master database. Run sp_BlitzIndex.sql in individual database.
Issue: Hi I have a stored procedure and when i run it by using declare and set parameter it gives me result with in 30 seconds but if I use (exec sp_procedurename parametervalue1,parametervalue2) statement then it takes 5 minutes to execute. Resolution: If you’re running the same exact SQL as the stored procedure and the... » read more
Sources: https://learn.microsoft.com/en-us/sql/reporting-services/report-server/report-server-executionlog-and-the-executionlog3-view?view=sql-server-ver16
SQL Server is, by default, case insensitive; however, it is possible to create a case-sensitive SQL Server database and even to make specific table columns case sensitive. The way to determine if a database or database object is to check its “COLLATION” property and look for “CI” or “CS” in the result. CI = Case Insensitive... » read more
Note: If no errors seen on the database side, it could be some problem with the outgoing STMP email server. Sources: https://learn.microsoft.com/en-us/sql/relational-databases/database-mail/database-mail-general-troubleshooting?view=sql-server-ver16
Error: Resolution: Sources: https://www.sqlserver-dba.com/2012/12/sql-server-alter-index-failed-due-to-quoted-identifier-.html
Issue: http://localhost:7071 already in use by another running Azure app. Resolution: Change your current Azure Function app to run under another port. local.settings.json
1 One2 Two3 Three4 Before full backup <FULL BACKUP>5 After full backup6 Before LOG backup 1 <LOG BACKUP 1>7 After LOG backup 18 Before DIFF backup <DIFF BACKUP>9 After DIFF backup10 Before LOG backup 2 <LOG BACKUP 2>11 After LOG backup 212 Before LOG backup 3 <LOG BACKUP 3>13 After LOG backup 3 Restore Options... » read more
Issue: Database Connection String: Encrypt=True;TrustServerCertificate=False If you recently upgraded your SQL Server Native Client 11.0 (Provider=SQLNCLI11) application to use Microsoft OLE DB Driver 19 for SQL Server (Provider=MSOLEDBSQL19), you might receive error messages that resemble the following messages: [Microsoft OLE DB Driver 19 for SQL Server]: Client unable to establish connection [Microsoft OLE DB Driver... » read more