SQL Server,Development - Riaan's Blog

Sharepoint support for SQL 2008

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! | digg it! | reddit! | kick it! | live it!

Posted 27 August 2008 02:32 AM by riaan | 1 comment(s)

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

SQL And Case Sensitive queries

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 Subscribe in a reader Join my blog network on Facebook Blog Networks Share this post: email it! | bookmark it! | digg it! | reddit...

Posted 13 August 2008 06:05 AM by riaan | 1 comment(s)

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

BizTalk EDI

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!

Posted 04 August 2008 03:07 AM by riaan | with no comments

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

WCF and SSB

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!

Posted 01 July 2008 01:48 AM by riaan | with no comments

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

Stored procedure generator

Posted 27 May 2008 02:18 AM by riaan | with no comments

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

Looping VS LINQ

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 it! | live it!

Posted 04 April 2008 02:59 AM by riaan | with no comments

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

Microsoft SQL Data Services

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 like a very cool concept. For more information go read here: http://www.microsoft.com/sql/dataservices/default.mspx Share this post: email...

Posted 12 March 2008 02:23 AM by riaan | with no comments

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

Riaan's Blog

Browse by Tags

Search

This Blog

Tags

Navigation

Archives

2point-zero

Syndication