The Smart Guide to Building World-Class Applications
Browse By: Author | Issue
SQL Server 2008's Resource Governor lets you allocate CPU and memory where it's needed. Learn how to create resource pools, create workload groups, view your configuration, classify applications, and some of the caveats of Resource Governor.
By Michael K. Campbell
If SQL Server’s performance is suffering, you may be considering new equipment. These techniques can improve performance without that expense.
By Michael Otey
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.
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 Michelle A. Poolet
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 build a data warehouse and act as their own PM.
By Lori Brown
Learn how to use the FixForwardedRecs stored procedure to find and remove forwarded records from heap tables.
By Itzik Ben-Gan
Itzik discusses four enhancements, including composable DML, the ability to declare and initialize variables in the same statement, compound assignment operators, and more reliable object dependency information.
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 some of the best ways to cuts costs for a SQL Server installation?
By Jeff James
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 environment.
By Michele Crockett
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, videos, blogs, and forums. We're reinventing the way we deliver content.
By
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 data in a results grid, whereas the other provides the data in a report.
By Bill McEvoy
Using T-SQL's CASE function, you can quickly transform numerical codes and other hard-to-decipher data into meaningful information.
advertisement