database,Development - Riaan's Blog

Browse by Tags

All Tags » database » Development (RSS)
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: , , ,
SQL 2005 Driver for PHP
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!
Posted 07 August 2008 02:48 AM by riaan | 2 comment(s)
Filed under: , , , ,
Entity Framework and Data Modeling
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!
Posted 08 July 2008 03:18 AM by riaan
Filed under: , , , , , ,
Stored procedure generator
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!
Posted 27 May 2008 02:18 AM by riaan
Filed under: , , , , , ,
Flexible Data Transformation Architecture
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!
Posted 20 May 2008 02:17 AM by riaan
Filed under: , , , , , , ,
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
Filed under: , , , , ,

Search

Go

This Blog

2point-zero

Syndication