Fix Ssms.exe 2014 on 4K monitors
Tweet 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
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:
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.
Disable/Enable all triggers in SQL Server Database
Tweet This script will create a script to disable and enable all the trigger within a SQL Server Database. You will want to change your results to TEXT instead of GRID to get the line breaks for the “go”
Monitor BizTalk Server (BizTalkMgmtDb) SQL Job Fails
Tweet A client was experiencing failures with the BizTalk job Monitor BizTalk Server (BizTalkMgmtDb), which calls stored procedure [dbo].[btsmon_Inconsistent]. This proc calls several other stored procedures to cleanup the messagebox and other meta-tables within BizTalk. These procs generate dynamic SQL scripts and to run against the tables within the BizTalk databases. Depending on your configuration, […]
SQL Server Trace (aka SQL Profiler) Priveliges without giving sysadmin
Tweet I’m a big proponet of using SQL Server Profiler for monitoring DB activity from applications. When a client has a SQL Server DBA on staff, they continuously tell me they can’t grant me Trace privileges without giving me sysadmin privileges. Oh yes they can! Below is the simple script to grant a particular user […]
How to Clear or Purge the Biztalk Tracking Database
Tweet Stop all running Biztalk services, load up SQL Management Studio, on the BiztalkDTADb database run the following script. Note that this script does not archive data. The last part shrinks the database and log files.