Browse by Tags

All Tags » SQL Server (RSS)
Wed, Dec 22 2010 8:27 AM

Getting rid of : WCF-Custom" raised an error message. Details "System.Data.SqlClient.SqlException: Timeout expired

I had a nice setup in my BizTalk environment. I had 4 receive locations polling for data (in the same table) and it all boiled down to execute a stored procedure with different parameters. I used the WCF adapter with SQL bindings for that. For some obscure...
Posted by Patrick Wellink | 4 comment(s)
Filed under: , , ,
Fri, Aug 15 2008 8:52 AM

Interesting stuff coming with the BizTalk Adaper Pack

I really can't wait for the BizTalk Adapter pack. Finally we get a good SQL adapter capable of almost everything. I had concurrency problems in the past cause the Adapter always has a transaction level Serializable. Now with the new SQL Adapter the...
Posted by Patrick Wellink | with no comments
Filed under: , ,
Mon, Jan 7 2008 9:34 AM

The truth about Dynamic SQL and Stored Procedures....

Well I am not going to say what's better or what I prefer, but I can only give my view of things. What everybody seems to forget is that an external person with very good understanding of SQL ( commonly know as a DBA ) can solve performance problems...
Posted by Patrick Wellink | 5 comment(s)
Filed under:
Fri, Apr 28 2006 4:00 PM

Inserts with guids have become faster... (in SQL2005 that is)

Ok, I am not a real fan of the GUID datatyoe in SQL server cause some people will create clustered indexes on them and then start to insert thousands of records, Next they will start complaining SQL isn't fast at all. (Wich is about the same as putting...
Posted by Patrick Wellink | 2 comment(s)
Filed under:
Fri, Dec 2 2005 10:11 AM

Things you should know about UpdateGrams and the SQL Adapter !!

For lotsa people this won't be too interesting but if you are a BizTalker and have regular interaction with a SQL Server keep on reading. First I wish to thank Richard Seroter who had an excellent post about the SQL adapter.(see here ). (Don't know why...
Posted by Patrick Wellink | 1 comment(s)
Filed under: ,
Tue, Apr 12 2005 1:39 PM

Why Mygeneration Beats the Competition when it comes to codegeneration

The main reason why MyGeneration is an excellent tool (Besides support of the dOOdad architecture) is the ability to add several templates to a project. Below is an example of this. In this project there are four templates needed. Adding a template is...
Posted by Patrick Wellink | 2 comment(s)
Filed under: , , ,
Wed, Feb 9 2005 3:26 PM

Holy Melony, There is a new SQL Worm active !!!!

Watch out everybody.... There is a new SQL worm out there........ It is infecting machines at a rate of 100 a second....... ( Click here for more Exiting New Details ) but wait..........It's a MySQL worm ....... ha haaaaaaa...... Too bad all those open...
Posted by Patrick Wellink | with no comments
Filed under:
Mon, Sep 27 2004 4:52 PM

Interesting Article : Introduction to DTS in SQL Server 2005

Have a look at this article and see how awesome the improvements in YUKON DTS are
Posted by Patrick Wellink | 2 comment(s)
Filed under:
Wed, Jun 30 2004 7:48 AM

Simple Walkthrough Reporting Services

Scared of Reporting Sevices....... Try this Hyperlink : http://www.sqlservercentral.com/columnists/bknight/designingyourfirstreportinreportingservices.asp
Posted by Patrick Wellink | 1 comment(s)
Filed under:
Mon, Mar 15 2004 11:36 AM

GUID is not Always GOOD !!!!!!! (a true RTFM story)

A collegue of mine asked me some questions about a clustered index. He was preparing for a SQL Exam and he had trouble understaning some concepts. He had trouble with the concepts not because they were too difficult for him, but they were completely opposite...
Posted by Patrick Wellink | 42 comment(s)
Filed under:
Tue, Mar 2 2004 9:05 AM

Database recovery met SQL Server / Biztalk

Voor wie het leuk vindt kwam ik hier iets tegen. http://www.sql-server-performance.com/disaster_recover_examples.asp Het Stukje gaat over database Recovery met SQL server. In principe is dit natuurlijk nooit nodig vandaar ook dat er zo weinig goed uitgewerkte...
Posted by Patrick Wellink | 3 comment(s)
Filed under: