Browse by Tags -

Browse by Tags

Moving the BizTalk databases (part 2)

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 entire article. 32 vs 64 bit Ever heard of that issue...

Posted to Mikael Sand - Trying to be different (Weblog) by Mikael Sand on Thu, Apr 4 2013
Moving the BizTalk databases (part 1)

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 answer is very simple: Because you have to. At some...

Posted to Mikael Sand - Trying to be different (Weblog) by Mikael Sand on Mon, Mar 11 2013
Minimal security requirements for using notifications with the BizTalk WCF SQL adapter

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 Seroter had a good article about it back in...

Posted to Mikael Sand - Trying to be different (Weblog) by Mikael Sand on Sun, May 27 2012
Ibmdadb2.1 provider is not registered on the local machine – the quick solution

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 correctly. The package is installed and every possible...

Posted to Mikael Sand - Trying to be different (Weblog) by Mikael Sand on Wed, Aug 24 2011
SQL Server Trace Flags - why and how to use them

Trace flags are very powerful settings that allow you to customize SQL Server behaviour. Most of the trace flags are undocumented in Books Online and there does not exist any official list of them. Some have been mentioned in Knowledge Base articles and presentation from Microsoft employees making them...

Posted to Johan Åhlén (Weblog) by jahlen on Sat, Dec 18 2010
SQLug.se challenge 2010 - the Swedish national championship for SQL Server developers

The Swedish national championship for SQL Server developers, SQLug.se challenge 2010 , is now finished. The competition has been running on the Swedish SQL Server User Group's website, but I publish the competition problem also on my blog in case you want to test your skills on it! The problem comes...

Posted to Johan Åhlén (Weblog) by jahlen on Mon, Dec 6 2010
SQL Azure - why use it and what makes it different from SQL Server?

I've so far not seen any article on why anyone should use SQL Azure so I thought it is time someone writes about that. This article is an introduction to why you might be interested in a cloud database and a summary of the differences compared to "ordinary" SQL Server. Finally I've...

Posted to Johan Åhlén (Weblog) by jahlen on Tue, Nov 23 2010
Search all SPs for a string

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/string%' Nice! So now you can search all the...

Posted to Mikael Sand - Trying to be different (Weblog) by Mikael Sand on Tue, Nov 16 2010
Minesweeper in T-SQL

Who said that coding T-SQL should not be fun? Minesweeper is a real old classic (that's still being shipped with Windows). Truly creative of Auke Teeninga to implement Minesweeper in T-SQL... Keep on playing!

Posted to Johan Åhlén (Weblog) by jahlen on Sun, Sep 5 2010
SQL Azure new user interface - Project Houston

"Project Houston" is the new user interface for SQL Azure. If you have tried SQL Azure you know that the user interface on the web portal is very brief. You can't do almost anything from there (except create new database and setup security). To do anything with your SQL Azure database you...

Posted to Johan Åhlén (Weblog) by jahlen on Thu, Sep 2 2010

Page 1 of 3 (23 items) 1 2 3 Next >