By Caroline Marwitz, 12/18/2009
Is SQL Azure a possible alternative to on-premise SQL Server? Whether you're a developer or a DBA, you need to keep tabs on this technology.
By Michael Otey, 12/18/2009
SQL Server 2008 R2 comes in some new flavors, from the Parallel Computing Edition on down to the three SQL Server Express editions.
By Michael Otey, 12/18/2009
Can the PowerPivot for Excel 2010 feature for SQL Server 2008 R2 bring harmony to business and IT teams within the organization?
By Matthew Clingan, 12/17/2009
By using table variables as parameters, you can make code maintenance easier.
By Gary Zaika, 12/17/2009
Deal with the limitations of SQL Server 2008’s built-in policies by creating a table-driven solution that lets you insert policy exceptions and regulate policy execution.
By Michael Otey, 12/15/2009
SQL Azure Database supports many—but not all—SQL Server features. Here are some commonly used features that SQL Azure doesn't support.
By Sheila Molnar, 12/15/2009
MySpace executives give an inside look at how they implemented and scaled SQL Server to handle more than 400 databases.
By Itzik Ben-Gan, 12/15/2009
The author discusses a fundamental topic in mathematical set theory to determine the properties of a relation represented by a table called R on a set represented by a table ...
By Scott Klein, 12/09/2009
Find poor-performing queries early in the development process using this security and performance monitoring tool from Pyn Logic.
By Dejan Nakarada-Kordic, 12/08/2009
Prevent data loss and improve performance by using this method to reduce conversation management overhead.