Biztalk nuggets and other related findings
Translate This Page
Translate this page
BizTalk 2006 R2
BizTalk 2013 R2
BizTalk Server 2009
Microsoft BizTalk Server
Microsoft BizTalk Server 2013
SQL Server 2005
SQL Server 2008
SQL Server 2014
SQL Server Analysis Services
SQL Server Reporting Services 2008
Windows Failover Clustering
Windows Server 2008
Windows Storage Server 2008
Browse by Tags
sql server 2008
Tagged Content List
Exporting XML columns from SQL to file in SSIS
I had a requirement to facilitate some testing with an internal customer which involves periodically exporting XML which we store in SQL Server as XML data types. One requirement was to use some column data (e.g. a sequence number, dateTime and identifier) being returned in the query as part of the file...
1 Jun 2012
Setting the SQL TcpPort value via PowerShell and WMI
My customer has a requirement that all SQL instances use a non-standard port, and I wanted to set this during install as part of the basic script, because we'll be doing a lot of SQL installs and we want to eliminate manual effort where possible. I looked around and the few samples I found were using...
13 Mar 2012
Error on adding a SQL cluster node (or more simply "Ooops")
I was installing a new clustered SQL (2008) instance via command line scripts, something that I've done now somewhere between 500 and a bajillion times. The first node of the cluster went fine, but when trying to add additional nodes, I ran into an error I'd never seen before. "The edition of the...
17 Sep 2011
The saga of SSRS 2008 and the FipsAlgorithmPolicy
I'm in the process of rolling out a new environment at the customer site and as part of this environment we're using a Windows Server 2008 image developed by the customer that has a fairly rigid security policy. I was rolling out the SQL side of the environment, which includes SQL Reporting Services...
29 Aug 2011
Using SQL instance name when using a static port
Did you know that if you have a named instance of SQL, and that SQL instance is setup to use a static port (e.g. 2375 for something random), that you do not need to use the instance name when connecting to the SQL instance? For example, if I setup a server, called Server1, and I setup a named instance...
7 Apr 2010
An update to BAM SSIS pre-requisites
I got a call today from a client who was doing his initial install of BizTalk 2009 and had a similar issue as described in my post Do I need to install SSIS on my BizTalk server to configure and use BAM? NO! The difference was that he was using SQL Server 2008 and the installation options are a tad different...
4 Aug 2009
Page 1 of 1 (6 items)
© 2015 Microsoft Corporation.
Privacy & Cookies