Browse by Tags

Sharepoint support for SQL 2008
Wednesday, August 27, 2008 2:32 AM

Office SharePoint Server 2007 SP1 & Windows SharePoint Services 3.0 SP1 now support SQL Server 2008. For more info go here: http://blogs.msdn.com/sharepoint/archive/2008/08/15/sql-server-2008-support-for-sharepoint-products-and-technologies.aspx Subscribe in a reader Join my blog network on Facebook Blog Networks Share this post: email it! | bookmark it!... Read More...

by riaan | with no comments

Filed under: Development, SharePoint, programming, SQL Server, MOSS 2007

SQL And Case Sensitive queries
Wednesday, August 13, 2008 6:05 AM

Ever wondered how to do a Sql query on case sensitive data, for example passwords? The answer is basically in the collation type. By changing the collation type on the column to SQL_Latin1_General_CP1_CS_AS (Case Sensitive) queries as below will shown will give the required results. Select * from table 1 where password = @password COLLATE SQL_Latin1_General_CP1_CS_AS... Read More...

by riaan | 1 comment(s)

Filed under: Development, database, SQL Server, T-SQL

BizTalk EDI
Monday, August 04, 2008 3:07 AM

What is EDI and how do you implement it with BizTalk 2006 R2? This article answers these questions: http://msdn.microsoft.com/en-us/magazine/cc748658.aspx Subscribe in a reader Join my blog network on Facebook Blog Networks Share this post: email it! | bookmark it! | digg it! | reddit! | kick it! | live it! Read More...

by riaan | with no comments

Filed under: BizTalk, Integration, Development, programming, SQL Server, patterns

WCF and SSB
Tuesday, July 01, 2008 1:48 AM

Good article on using the WCF SQL Adapter to extract messages from SSB. Read more here: http://blogs.msdn.com/adapters/archive/2008/06/30/using-the-wcf-sql-adapter-to-read-messages-from-ssb-queues-and-submit-them-to-biztalk.aspx Share this post: email it! | bookmark it! | digg it! | reddit! | kick it! | live it! Read More...

by riaan | with no comments

Filed under: BizTalk, Integration, Development, programming, SQL Server, patterns

Stored procedure generator
Tuesday, May 27, 2008 2:18 AM

A tool to create the basic insert,update,select statements to your SQL tables. http://www.codeplex.com/spgen Share this post: email it! | bookmark it! | digg it! | reddit! | kick it! | live it! Read More...

by riaan | with no comments

Filed under: C#, Development, query, programming, database, SQL Server, Design

VLINQ and LINQPad
Friday, April 18, 2008 3:26 AM

This article describes 2 cool LINQ tools. These tools help make the LINQ learning curve a bit better: http://www.infoq.com/news/2008/04/linq-tooling Share this post: email it! | bookmark it! | digg it! | reddit! | kick it! | live it! Read More...

by riaan | 2 comment(s)

Filed under: C#, query, programming, LINQ, database, SQL Server

Looping VS LINQ
Friday, April 04, 2008 2:59 AM

This is a very nice article by Chuck Jazdzewski on using traditional c# loops vs using LINQ. This article is making me think twice now before applying traditional loops in my logic. Read the full article here: http://www.removingalldoubt.com/permalink.aspx/6080a8a8-bb63-4492-acd2-1398f086fca0 Share this post: email it! | bookmark it! | digg it! | reddit! | kick... Read More...

by riaan | with no comments

Filed under: CodeSnippets, Code, C#, Development, LINQ, SQL Server, Loops, logic

Microsoft SQL Data Services
Wednesday, March 12, 2008 2:23 AM

From the official site: "SQL Server Data Services (SSDS) are highly scalable, on-demand data storage and query processing utility services. Built on robust SQL Server database and Windows Server technologies, these services provide high availability, security and support standards-based web interfaces for easy programming and quick provisioning." Seems... Read More...

by riaan | with no comments

Filed under: C#, Development, web development, database, asp.net, SQL Server