Create Linked Server Error, Cannot generate SSPI context
Error: Possible Fixes: In the Security section of the linked server, switch to “Be made using this security context” and provide a login SQL account.
.NETADO.NETAgileAngularArchitectureASP.NETAuthenticationAzureAzure FunctionBIBig DataBlazorBusinessC#Cloud ServiceCosmosDBCSSDebuggingDesignEncryptionEntity FrameworkFYIGoogleHardwareInternetInterviewsJavascriptjQueryLeadershipLINQManagementMicrosoftMobileMS OfficeMS SQLNetworkingNoSQLOOPProject ManagementSoftware DevelopmentSource ControlSSISSSRSSyncfusionTeamTestingTSQLUncategorizedVendor SoftwareVisual StudioWebWeb ServicesWindowsWordPress
Installing SQL Server Checklist
What Version and Edition to install? Developer, Standard, or Enterprise Edition If not Developer, need license key Account to use for install? Local Account or Network Account Collation, default set to “SQL_Latin1_General_CP1_CI_AS” Drives? Data, Log, Index, Backup Space Requirements Features to install? Analysis Services, Machine Learning Services, PolyBase Query Service, Integration Service, Reporting Service Example... » read more
SQL Profiler for Specific Stored Procedure
Create a new Trace In the “Events Selection” tab, click on “Show all events” and select these… Stored Procedures -> RPC:Starting Stored Procedures -> RPC:Completed TSQL -> SQL:BatchStarting TSQL -> SQL:BatchCompleted In the “Events Selection” tab, make sure the “TextData” is selected and click on “Column Filters” In the TextData column add a filter: Like %uspMySP01%... » read more
Bring Offline and Online Database
Note: Bring database OFFLINE / ONLINE should be a fast process, even for a large database. Users must be disconnected from database before setting the database to offline. Else, use ROLLBACK IMMEDIATE clause. If you run into problem with bring the database back ONLINE, try restarting SQL Server service. If part of Availability Group, need... » read more
Cannot drop database “xxxxx” because it is currently in use.
Problem: Solution: When you have tried everything to drop the database but nothing works. Stop the SQL Server service. Manually remove the data files from drive. Restart the SQL Server service. Delete database.
TeamCity
TeamCity is a build management and continuous integration server from JetBrains. It was first released on October 2, 2006 and is commercial software and licensed under a proprietary license: a freemium license for up to 100 build configurations and three free Build Agent licenses are available. https://www.jetbrains.com/teamcity/
Custom CommandExecute Script
https://ola.hallengren.com
Custom Index Optimizer Script
Source: https://ola.hallengren.com User Database IndexOptimize Script