By Kalen Delaney, 01/19/2012
Learn how you can replace a scalar-valued user-defined functions (UDFs) call with actual code to greatly improve SQL Server performance.
By Michael Otey, 01/19/2012
SQL Server Data Tools in SQL Server 2012 offers more than declarative schema-based database design and T-SQL debugging--here's what to look for in this super tool.
By Kevin Kline, 01/13/2012
The Scripted PowerShell Automated Deployment Engine is a free, remote install and configuration tool for SQL Server that streamlines remote deployment and simplifies complex ...
By Kalen Delaney, 12/29/2011
Kalen discusses two reasons she finds SQL Server query hints to be fascinating.
By Brian Moran, 12/22/2011
The SQL Server community is known for banding together to help those in need, whether they have a SQL Server-related question or a charity they want to support. Here's two acts of ...
By William Sheldon, 12/15/2011
If you're looking for ASP.NET rapid application development (RAD) controls, Telerik's RadControls suite is an excellent choice.
By Michael K. Campbell, 12/14/2011
Although the ADO.NET Entity Framework makes application developers' jobs easier, the code it generates can lead to poorly performing applications. Here is what you need to know ...