Mark Harris
Currently viewing the category:
"SQL Server"
This post has been sitting in my drafts for a while. After my day today i felt that it was best that i put my thoughts about service broker down.
In a project that i worked on about 2 years ago Service Broker was used as part of the system to [...]
Service Broker has a really good C# wrapper interface that comes part of the samples on Codeplex. If you need to work with service broker objects in the managed world then I would recommend using the interface from the Codeplex Service Broker Samples.
Most samples I have seen demonstrate [...]
First up Proper Case is really Title Case. And if you ever need to convert text to Title Case in SQL you can use Vyas Kondreddi’s PROPERCASE SQL script or David Wiesman’s PROPERCASE SQL script
My only change to their scripts would be to use NVARCHAR(MAX) or VARCHAR(MAX) [...]
For most people using SQL Server CLR is not an issue however when you have more that 4GB or more of memory, the CLR does not just work.
Enter the –g startup switch, You can read more about the SQL Server 2005 startup options to get the fine detail. In order to make the [...]
How do you deploy SQL Server Management Objects (SMO) runtime? Follow this 3 step process for success.
STEP 1: Download and Install Microsoft Core XML Services (MSXML) 6.0
STEP 2: Download and Install Microsoft SQL Server Native Client
STEP [...]
February 2012 M T W T F S S « Sep 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29
Tags
.net .net4 Addins apple Biztalk BizTalk Express C# Caching cch harmony launch party Comic Development Dilbert distributed entity framework extensions firefox 3 flickr flickrlight General Go Live Rituals in memory iphone2 iphone 3g Linq To Sql MAF Managed Addin Framework Mapped Drive to UNC NServiceBus Oslo Plugins point case estimation project estimation Run As Administrator silverlight sky diving soa SQL Server Training UAC Velocity Vista Visual Studio wcf wf wwdc 2008
