.NETAgileAngularArchitectureASP.NETAzureBIBig DataBusinessC#Cloud ServiceDebuggingEncryptionFYIGoogleHardwareInternetInterviewsjQueryLeadershipManagementMicrosoftMobileMS SQLNetworkingNoSQLOOPProject ManagementSoftware DevelopmentSource ControlSSISSSRSTeamTestingTSQLUncategorizedVendor SoftwareVisual StudioWebWeb ServicesWindowsWordPress
Error: Column ‘xxxxx’ is partitioning column of the index ‘PK_xxxxxxxx’. Partition columns for a unique index must be a subset of the index key. Could not create constraint or index. Solution: Since both biTable01Id, dtStartDateTime columns are in the partition column, both must be in the Primary Key column as well.
Starting with SQL Server 2014 a new troubleshooting capability is to monitors real time query progress with the DMV sys.dm_exec_query_profiles which is the base for Live Query Statistics new functionality for SQL Server 2016, there are two ways to enable real time query monitoring: Session scope: By enabling SET STATISTICS XML ON; or SET STATISTICS PROFILE ON;... » read more
Execution Plan in SSMS Run Stored Procedure in SSMS with “Execution Plan” enabled. SSMS will recommend index to be created.
Model Browser My default, the Model Browser panel does not show up in Endity Model editor. To show the Model Browser panel… Open up .edmx file. Right click and select “Model Browser”.
Error: For some reason, when I launch this application in the debugger using the normal Start Debugging command in Visual Studio, it launches, but it also produces the following warning: Resolution: Disable this option under Debug->Options->Suppress JIT optimization on module load (Managed only). Sources: https://stackoverflow.com/questions/38601643/error-you-are-debugging-a-release-build-of-x-dll
https://www.time.gov/
Error in Visual Studio: The type or namespace name ‘Dymo’ could not be found (are you missing a using directive or an assembly reference?) Fix: Interop.Dymo.dll
https://www.atlassian.com/git/tutorials/comparing-workflows/gitflow-workflow