.NETADO.NETAgileAngularArchitectureASP.NETAuthenticationAzureAzure FunctionBIBig DataBlazorBusinessC#Cloud ServiceCosmosDBCSSDebuggingDesignEncryptionEntity FrameworkFYIGoogleHardwareInternetInterviewsJavascriptjQueryLeadershipLINQManagementMicrosoftMobileMS OfficeMS SQLNetworkingNoSQLOOPProject ManagementSoftware DevelopmentSource ControlSSISSSRSSyncfusionTeamTestingTSQLUncategorizedVendor SoftwareVisual StudioWebWeb ServicesWindowsWordPress
Issue: Log has grown to be very large and unable to trunk log file even after database and transaction log backup. Get the following error message when trying to truncate log. The log was not truncated because records at the beginning of the log are pending replication or Change Data Capture. Ensure the Log Reader... » read more
Copy .ISPAC file to the server. Click on the .ISPAC file on the server, this should bring up the Integration Services Deployment Wizard. Select packages and deployment server to deploy SSIS packages. Note .ISPAC file is generated in the bin\Development folder of Visual Studio project. SSIS Package deployment using .ISPAC file seems to be the... » read more
Linked Server Error: Could not execute procedure on remote server ‘XXXX’ because SQL Server is not configured for remote access. Ask your system administrator to reconfigure SQL Server to allow remote access. Fix: Make sure remote access is enabled on the database server and that the server has been restarted if the configuration changed. Also... » read more
https://visualstudio.microsoft.com/launch/
Convert vs Cast CAST and CONVERT are two SQL functions used by programmers to convert one data type to another. The CAST function is ANSI standard and is compatible to use in other databases while the CONVERT function is a specific function of the SQL server. Since the CAST function is compatible with other databases,... » read more
Open up “Login Properties” of the user. Go to “User Mapping” page and select “msdb” database. Add the following membership… SQLAgentUserRole SQLAgentReaderRole SQLAgentOperatorRole SQL Agent User Role: SQLAgentUserRole is the least privileged of the SQL Server Agent fixed database roles. It has permissions on only operators, local jobs, and job schedules. Members of SQLAgentUserRole have... » read more
Microsoft Report Viewer 2015 Runtime https://www.microsoft.com/en-us/download/details.aspx?id=45496 Install Errors Microsoft System CLR Types for SQL Server 2014 is missing. Download Microsoft SQLSysCLRTypes from Official Microsoft Download Center
Linked Server The bottom line is that linked servers are always slow. Try to run queries on the remote server or try to push data from the remote server. Also look for ways to replicate data from the remote server locally. Remote Join When you use the INNER REMOTE JOIN hint you are forcing the tables... » read more
Issues: Long Running Queries https://www.brentozar.com/blitzcache/long-running-queries/ Check for missing index – Check “Execution Plan” for missing index. Expensive Key Lookups https://www.brentozar.com/blitzcache/expensive-key-lookups/ Check “Execution Plan” for Key Lookup. A key lookup occurs when SQL uses a nonclustered index to satisfy all or some of a query’s predicates, but it doesn’t contain all the information needed to cover... » read more
Issue: Edit and Deleting records from Syncfusion list not not close form. Resolution: Make sure there is a Primary Key column define in the list columns.