Browse by Tags

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

ADO.Net Data Services Framework
Tuesday, August 12, 2008 3:08 AM

Good introduction article from MSDN around the ADO.Net Data Services Framework. This article also touch base on EDM (Entity Data Model) which is a base for the Data Services Framework. http://msdn.microsoft.com/en-us/magazine/cc748663.aspx Subscribe in a reader Join my blog network on Facebook Blog Networks Share this post: email it! | bookmark it! | digg it... Read More...

by riaan | 2 comment(s)

Filed under: C#, Integration, database, SaaS, .net, ADO.Net, Services, EDM

SQL 2005 Driver for PHP
Thursday, August 07, 2008 2:48 AM

Microsoft has released the Sql 2005 driver for PHP. Download from here: http://www.microsoft.com/downloads/details.aspx?FamilyID=61bf87e0-d031-466b-b09a-6597c21a2e2a&DisplayLang=en 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 | 2 comment(s)

Filed under: Development, programming, database, Open Source, Web 2.0

Entity Framework and Data Modeling
Tuesday, July 08, 2008 3:18 AM

In this MSDN Magazine article the author answers questions regarding the Entity Framework and provides an understanding of how and why it was developed. http://msdn.microsoft.com/en-us/magazine/cc700331.aspx 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, programming, database, Design, patterns, ADO.Net

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

Flexible Data Transformation Architecture
Tuesday, May 20, 2008 2:17 AM

Article found on MSDN. Some cool concepts used: http://msdn.microsoft.com/en-us/vcsharp/cc533518.aspx Share this post: email it! | bookmark it! | digg it! | reddit! | kick it! | live it! Read More...

by riaan | with no comments

Filed under: Code, C#, Development, programming, database, Design, Architecture, .net

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

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