Posts by Chris Straw:
Fix Ssms.exe 2014 on 4K monitors
I was having problems with Sql Management Studio 2014 running on 4K monitors.
This post tells you have to fix the issue:
SSMS in High-DPI Displays: How to Stop the Madness
Find missing SQL Server Indexes
Tweet The original post is here: Find missing indexes using SQL Servers index related DMVs
Angular isNumeric
Tweet For Angular, you can utilize the isNumeric from rxjs.
Install .Net windows services without using installutil.exe
Tweet When writing a windows service using c# (or vb.net), you can install the service locally using installutil.exe. You can simply just install the service by using a few lines of c# code within your program’s startup. By doing this, you will not be able to use Client Profile of the framework. By changing the Program.cs (main […]
Find Orphaned DTA Service Instances with SQL Query
Tweet I was trying to find what messages were being orphaned, so I started doing a little digging to figure out how I could get more detail. With that being said, I still use the Terminator to fix the issue. I do NOT recommend updating or changing any messages in the messagebox without consent from […]
SQL Query to list BizTalk Hosts
Tweet This query will give you a list of the BizTalk Hosts:
Disable WCF Certificate Check for Self-Assigned Certificates
Tweet To “turn off” the trusted certificate check for self-assigned certificates, just add this to the web.config
Enable User without Login
Tweet This is a little tricky in the syntax. If you have a SQL User without Login that is showing disabled, you have to grant it connect access, since there isn’t a SQL login.