Skip to content

Chris Straw

Software Architect

Tags

.net framework (6) Angular (1) ASP.Net (1) c# (9) DDL Script (1) EF6 (1) Firefox (1) Foreign?Key (2) Microsoft BizTalk (9) Nuget (2) REST (1) RESTful (1) Shoeboxed (1) SQL Server (15) vb.net (2) Visual Studio (3) WCF (3) Windows 10 (1) Windows Service (1) XML (2) XSD (1)

Recent Posts

  • Add Collapse to Definitions button to Visual Studio
  • Bootstrap 4: CardHeader with buttons on the right
  • EF Stored Proc Timeout
  • Reorder Firefox containers
  • Bootstrap 4 Equal Height Cards using Grid and Flexbox Utilities

Posts

  • October 2020 (1)
  • September 2020 (1)
  • July 2020 (1)
  • June 2020 (1)
  • May 2020 (4)
  • April 2020 (2)
  • November 2019 (1)
  • August 2019 (1)
  • May 2019 (1)
  • August 2018 (2)
  • May 2018 (1)
  • April 2018 (1)
  • December 2017 (1)
  • November 2013 (1)
  • October 2013 (2)
  • August 2013 (1)
  • April 2013 (1)
  • May 2012 (2)
  • April 2012 (2)
  • February 2012 (1)
  • January 2012 (2)
  • November 2011 (5)
  • October 2011 (6)
  • September 2011 (1)
  • June 2011 (4)
  • April 2011 (4)
Blogger WordPress Theme by Blaze Themes
  • BizTalk
  • SQL Server
SHARE:

SQL Query to list BizTalk Hosts

October 26, 2013 by Chris Straw

This query will give you a list of the BizTalk Hosts:

Read More
  • c#
  • WCF
SHARE:

Disable WCF Certificate Check for Self-Assigned Certificates

August 28, 2013 by Chris Straw

To “turn off” the trusted certificate check for self-assigned certificates, just add this to the web.config

Read More
  • Database
  • SQL Server
SHARE:

Enable User without Login

April 25, 2013 by Chris Straw

This is a little tricky in the syntax. ?If you have a SQL User without Login that is showing disabled, you…

Read More
  • SQL Server
SHARE:

Disable/Enable all triggers in SQL Server Database

May 12, 2012 by Chris Straw

This script will create a script to disable and enable all the trigger within a SQL Server Database. You will want…

Read More
  • BizTalk
  • SQL Server
SHARE:

Monitor BizTalk Server (BizTalkMgmtDb) SQL Job Fails

May 1, 2012 by Chris Straw

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
  • SQL Server
SHARE:

SQL Server Trace (aka SQL Profiler) Priveliges without giving sysadmin

April 7, 2012 by Chris Straw

I’m a big proponet of using SQL Server Profiler for monitoring DB activity from applications. When a client has a SQL…

Read More
  • BizTalk
  • SQL Server
SHARE:

How to Clear or Purge the Biztalk Tracking Database

April 7, 2012 by Chris Straw

Stop all running Biztalk services, load up SQL Management Studio, on the BiztalkDTADb database run the following script. Note that this…

Read More
  • SQL Server
SHARE:

Script to delete all objects from SQL Server

February 2, 2012 by Chris Straw

Today I accidentally?ran a script on master instead of the DB desired. ?So, I created a script that would create the…

Read More
  • ASP.net
  • c#
SHARE:

Disable button on click ASP.Net 2.0 or higher (prevent double click)

January 20, 2012 by Chris Straw

There is a need, at times, to prevent the user from clicking a button?multiple?times. ?Since ASP.Net already wraps something into the…

Read More
  • Database
  • SQL Server
SHARE:

Find missing Foreign Keys in SQL Server

January 13, 2012 by Chris Straw

I was looking working on a script to find possibly missing foreign keys, when I stumbled upon Michael J Swart’s blog…

Read More
    « Previous 1 2 3 4 5 Next »
  • Home
  • About Me

Chris Straw

Software Architect

This website uses cookies to improve your experience. We'll assume you're ok with this, but you can opt-out if you wish. Cookie settingsACCEPT
Privacy & Cookies Policy

Privacy Overview

This website uses cookies to improve your experience while you navigate through the website. Out of these cookies, the cookies that are categorized as necessary are stored on your browser as they are essential for the working of basic functionalities of the website. We also use third-party cookies that help us analyze and understand how you use this website. These cookies will be stored in your browser only with your consent. You also have the option to opt-out of these cookies. But opting out of some of these cookies may have an effect on your browsing experience.
Necessary
Always Enabled
Necessary cookies are absolutely essential for the website to function properly. This category only includes cookies that ensures basic functionalities and security features of the website. These cookies do not store any personal information.
Non-necessary
Any cookies that may not be particularly necessary for the website to function and is used specifically to collect user personal data via analytics, ads, other embedded contents are termed as non-necessary cookies. It is mandatory to procure user consent prior to running these cookies on your website.
SAVE & ACCEPT