adsense

Sunday, November 28, 2010

An example of Test-Driven Development in SQL Server 2005

This article demonstrates principles of test-driven database development (TD3) along with Try/Catch and SqlCmd functionality. Make sure u read all 5 parts...!!!

http://www.sqlservercentral.com/articles/Testing/66553/

Cheers
samitha

Tuesday, November 9, 2010

centralize your SQL Server Event Logs.

Learn how you can centralize the Event log data for your servers.

http://www.sqlservercentral.com/articles/Monitoring/71390/


Cheers
Happy coding
Samitha

Wednesday, November 3, 2010

MySQL Connector/NET 6.3.4 was released

New features include:
  • Ability to dynamically enable/disable query analysis at runtime
  • Visual Studio 2010 compatibility
  • Improved compatibility with Visual Studio wizards using the new SQL Server mode
  • Support for Model-First development using Entity Framework
  • Nested transaction scopes
  • Additional improvements and bug fixes
download at http://dev.mysql.com/downloads/connector/net/

Cheers
Happy coding
samitha

A Faster BETWEEN Dates

Finding records that exist between two dates can sometimes be slow. This is especially true if temporary tables and table variables are used. This article shows different ways that you can get the same records but with faster results.
http://www.sqlservercentral.com/articles/BETWEEN/71395/

Cheers
Happy coding
samitha

Using SqlMethods.Like method

The System.Data.Linq.SqlClient namespace includes a helper class called SqlMethods, which can includes a method called Like, that can be used in a Linq to SQL query:

var query = from c in ctx.Customers
            where SqlMethods.Like(c.City, "L_n%")
            select c;

This method gets the string expression to check (the customer's city in this example) and the patterns to test against which is provided in the same way you'd write a LIKE clause in SQL.

Using the above query generated the required SQL statement:

SELECT CustomerID, CompanyName, ...
FROM    dbo.Customers
WHERE  City LIKE [L_n%]

Cheers,
Happy Coding
Samitha