Author
SSMS IntelliSense Autofill Feature Not Working
Issue: SSMS IntelliSense autofill feature not working after Red Gate uninstall. Resolution: Enable IntelliSense: For all query windows, please go to Tools >> Options >> Text Editor >> Transact-SQL >> IntelliSense, and select Enable IntelliSense. For each opening query window, please go to Query >> Intellisense Enabled. Enable statement completion: please go to Tools >>... » read more
DLL Reference Not Found Error
Possible Fix 1: In solutions with multiple projects, if you get an error with DLL reference not found even though you have the reference project, check to make sure all projects in the solutions are using the same version of .NET. Go to the “properties” section of each project and make sure the “Targeted Framework”... » read more
Get Selected Rows in DataGrid
Sources: https://github.com/syncfusion/blazor-samples/issues/74
AlwaysOn Setup New User on Read Only Replica
All you need is to create the same login on the second server preserving it’s sid, and you can do this first by copying the login’s sid from sys.server_principals and then by creating the same login using with sid like this: Example: On Primary Database: On Read Only Replica Database: Sources: https://dba.stackexchange.com/questions/174946/creating-a-sql-login-and-user-on-an-alwayson-replica
Repair SQL Server Management Studio
Issue: D:\Program Files (x86)\Microsoft SQL Server Management Studio 18\Common7\IDE\Ssms.exe Ssms.exe is corrupted or missing. Fix: To repair Management Studio open Control Panel, go to Programs and Features, locate SQL Server Management Studio using the scroll bar and double click on it. You can also just upgrade to a newer version of SQL Server Management Studio.... » read more
Always On Error: The remote copy of database has not been rolled forward to a point in time that is encompassed in the local copy of the database log
Error: The remote copy of database x has not been rolled forward to a point in time that is encompassed in the local copy of the database log Fix: Make sure you disable existing log backup job that is automatically backing up the log file. Fix 2: The only thing that I can think of... » read more
Blazor Url Parameter
Install the following for NuGet… Microsoft.AspNetCore.WebUtilities Example: https://localhost/Page1?SupplierId=123 Sources: https://www.c-sharpcorner.com/article/working-with-query-string-or-query-parameter-in-blazor/
Unable to connect to SQL Server Remotely
Issue: Unable to connect to SQL Server remotely. Able to connect on the server. This is for a newly installed instance of SQL Server. Fix: Make sure “Named Pipes” and “TCP/IP” protocol is enabled. Go to SQL Server Configuration Manager -> SQL Server Network Configuration -> Protocols for MSSQLSERVER Make sure Named Pipes and TCP/IP... » read more