SQL Server 2008 has a ton of new DBA features, but if you really want to make this thing go, just crank out a little code. SQL Server 2008 is mostly in the domain of system and database administrators ...

In-Depth Laying the Groundwork for Microsoft SQL Server 2008 Redmond's new database server is a complex product often running mission-critical apps. You can't afford to not get it right. By Josh Jones ...

Microsoft SQL Server 2008 is the most recent version of the Redmond, Wash., company's data management and business intelligence platform. According to Microsoft, the version provides new capabilities ...

SQL Server 2008, aka “Katmai,” gives SQL Server shops plenty of reasons to get excited. The best SQL Server release to date, it sports more nice new features than you can count, and the improvements ...

sQL Server 2008 offers new support for spatial data types that some analysts say should deliver a real boost to geospatial applications and data sharing. Microsoft's soon-to-be-released SQL Server ...

Unlock the full InfoQ experience by logging in! Stay updated with your favorite authors and topics, engage with content, and download exclusive resources. Dany Lepage discusses the architectural ...

Yes, SQL Server 2005 allowed us for the first time to encrypt individual sensitive columns without the use of third-party products. However, the implementation required application code changes using ...

This method is so discouraged that Microsoft is not including it in SQL Server 2008 and future versions of the product. I’ll include the syntax here to be thorough, but you should try to avoid using ...