The Smart Guide to Building World-Class Applications
Browse By: Author | Issue
See why MySpace, one of the largest websites in the world, chose SQL Server for its database platform. Three leaders of the company’s IT department discuss how they planned, implemented, extended, and maintain a massive deployment of SQL Server.
By Michael Otey
SQL Server 2008 R2 comes in some new flavors, from the Parallel Computing Edition on down to the three SQL Server Express editions.
By Caroline Marwitz
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.
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
By using table variables as parameters, you can make code maintenance easier.
By Gary Zaika
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.
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
MySpace executives give an inside look at how they implemented and scaled SQL Server to handle more than 400 databases.
By Itzik Ben-Gan
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 called V.
By Scott Klein
Find poor-performing queries early in the development process using this security and performance monitoring tool from Pyn Logic.
By Dejan Nakarada-Kordic
Prevent data loss and improve performance by using this method to reduce conversation management overhead.
advertisement