Category: Database
Exploring AWS RDS for SQL Server vs Azure SQL
I’m looking at moving to AWS RDS for SQL from Azure SQL. The biggest downside is the licensing. Currently, I’m using…
Read MoreFix 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:…
Read MoreFind Orphaned DTA Service Instances with SQL Query
I was trying to find what messages were being orphaned, so I started doing a little digging to figure out how…
Read MoreEnable User without Login
This is a little tricky in the syntax. ?If you have a SQL User without Login that is showing disabled, you…
Read MoreDisable/Enable all triggers in SQL Server Database
This script will create a script to disable and enable all the trigger within a SQL Server Database. You will want…
Read MoreMonitor BizTalk Server (BizTalkMgmtDb) SQL Job Fails
A client was experiencing failures with the BizTalk job Monitor BizTalk Server (BizTalkMgmtDb), which calls stored procedure [dbo].[btsmon_Inconsistent]. This proc calls…
Read More