By Michael K. Campbell, 03/25/2009
If SQL Server’s performance is suffering, you may be considering new equipment. These techniques can improve performance without that expense.
By Michael Otey, 03/24/2009
New data-access options in VS 2008 and the .Net Framework 3.5 SP1 include LINQ to DataSet, ADO.Net Data Services, and SQL Server Data Services.
By Lori Brown, 03/23/2009
Learn how to use the FixForwardedRecs stored procedure to find and remove forwarded records from heap tables.
By Michelle A. Poolet, 03/23/2009
Poolet shares the approach she uses when planning and managing a database project. This is project management for non-PMs: admins and developers without a PM, or IT pros who must ...
By Michael K. Campbell, 03/23/2009
Store BLOB data as files managed by the OS and reap the performance benefits now—with this walk-through of how to set up and configure SQL Server 2008’s FILESTREAM storage feature.
By Itzik Ben-Gan, 03/18/2009
Itzik discusses four enhancements, including composable DML, the ability to declare and initialize variables in the same statement, compound assignment operators, and more ...
By Michael Otey, 03/16/2009
SQL Server shops are looking for ways to save money without cutting back on existing services or ongoing projects. They just want it all to happen with less money. So what are ...
By Jeff James, 02/26/2009
SQL Server and virtualization gurus from Quest Software, Microsoft, VMware, and Rochester General Health Systems offer their suggestions for running SQL Server in a virtual ...
By Michele Crockett, 02/24/2009
In this down economy, we’re looking at better ways to bring DBAs content and analysis in multiple formats—magazines, web seminars, live events, conferences, virtual events, ...
By Readers, 01/22/2009
SQL Server Management Studio (SSMS) lacks an easy-to-use tool to get detailed data about partitioned tables. To fill this gap, a reader has created two tools. One provides the ...
By Bill McEvoy, 08/29/2008
Using T-SQL's CASE function, you can quickly transform numerical codes and other hard-to-decipher data into meaningful information.