Thursday, August 11, 2011

25 Useful SQL Server Tutorials For .NET Developers

As a developer who has been developing data oriented .NET applications for over a decade now, I have become a strong believer of the fact that a developer’s knowledge is incomplete, without having knowledge of the database and network he/she is interacting with. A couple of my colleagues and I run a site called where we record our experiences with the databases, and share it with fellow devs in the form of blog posts. In this article, I will be sharing 25 T-SQL Scripts and Tutorials from our blog that I feel would be useful if you are developing .NET Centric Database Solutions.

Please retweet and share this list with other fellow developers. Thanks!

Here’s the list for your reference:

SQL Server Tutorials on Date Time - One of the most frequently asked question by SQL developers, is on handing Date, Time and other related datetime values in SQL Server. Developers are always looking out for solutions which demand either converting Date Time Values or finding date time ranges and so on. Madhivanan and I have already written a couple of articles on handling DateTime in SQL Server. In this post I will share some of the links with you.

Troubleshoot Deadlocks using SQL Server Profiler 2005/2008 - In this article, we will see how to capture deadlocks while modifying data using SQL Server Profiler in SQL Server 2005/2008

SQL Queries – beyond TRUE and FALSE - Most of the SQL novices are more accustomed to thinking in terms of two-valued logic (TRUE, FALSE) in SQL. But SQL uses three-valued logic – TRUE, FALSE and UNKNOWN. It means that the value of an expression may be TRUE, FALSE or UNKNOWN. Confused?

SQL Server: Search Similar String in a Table - There are may ways to look for similar strings in a SQL Server column. The most common method is to make use of LIKE operator. Let us see the different ways to look for similar string in a table.

SQL Server: Calculate Summary and Column Summary - This post shows how to show a summary of similar rows as well as column summary for SQL Server table data. Suppose you want to generate the total of a column and display it at the end of the result set.

SQL Server: Common mistake while Calculating Quarter Sales - When it comes to calculating quarter sales, I have always seen developers grouping only by quarter which is incorrect.

Read more: Beyond relational
QR: ShowArticle.aspx?ID=749

Posted via email from Jasper-Net