Browse by Tags
All Tags »
SQL Server (
RSS)
Skipping ahead a bit After some feedback about the last article (thanks everyone) you all seem to know how to follow instructions from Microsoft. You all told me to skip to the part about the instructions being wrong. So I will. Make sure to read the...
The correct title might be: “Moving the BizTalk databases – The right way”. Because the way outlined in the BizTalk help, is not much help. Scared yet? Well not after reading thru my articles. Why move databases? This is a very natural question and the...
Using notifications (or rather the SQL Broker engine) in BizTalk is a great way to utilize Microsoft technology and platform uniformity. There is a great article about it in the Microsoft BizTalk 2010: Line of business Systems Integration book, and Richard...
The last couple of days I have been working with IBM connectivity. We use standard IBM components to bridge SQL Server SSIS and DB2. The component has been working 100% in all but one environment. So, everything is installed and seems to be configured...
Ever asked this question: “I wonder if we access this table from any stored procedures?”. Well here is how to find out: SELECT distinct so.name, so.xtype FROM syscomments sc INNER JOIN sysobjects so ON sc.id=so.id WHERE sc.TEXT LIKE '%TABLE/COLUMN...
SQL-Server and I has had a bit of a fallout. I don't talk to it and it doesn't talk to me. A shame really since we used to be very close back in 2001. Today we once again stood face to face. I said: "Oh, you look good. You have changed, and...