Database Development Articles

T-SQL Best Practices, Part 2

Itzik Ben-Gan — Tue, 22 May 2012 10:07:00 GMT

By Itzik Ben-Gan
Itzik continues his discussion of T-SQL best practices; he discusses cloud compatibility, date and time best practices, the importance of writing in a standard way, and performance-related best practices.

T-SQL Best Practices, Part 1

Itzik Ben-Gan — Fri, 20 Apr 2012 10:05:00 GMT

By Itzik Ben-Gan
Some T-SQL best practices include thinking in a relational way, always remembering NULLs and the three-valued-logic, realizing the full implications of using the NOLOCK hint and therefore avoiding it, and adopting good coding practices.

Understanding Query Plans

Itzik Ben-Gan — Mon, 19 Mar 2012 05:00:00 GMT

By Itzik Ben-Gan
A key element in query tuning is using the execution plan to determine the reasons for poor query performance. SQL Server provides rich information about query plans in the graphical as well as XML forms of plans.

Microsoft SQL Server in the Private Cloud: Is it Possible?

Michael Otey — Fri, 16 Mar 2012 13:05:00 GMT

By Michael Otey
Find out how SQL Server can leverage the benefits of a private cloud environment in several ways.

Microsoft Announces SQL Server 2012 Release to Manufacturing

Megan Keller — Tue, 06 Mar 2012 21:57:41 GMT

By Megan Keller
Microsoft announces the date SQL Server 2012 will be generally available and the upcoming Developer Preview of the Apache Hadoop-based Services for Windows Azure.