Microsoft SQL Server 2008
Microsoft SQL Server 2008, aka "Katmai", gives SQL Server shops plenty of reasons to get excited.
It's not without its faults, but Microsoft SQL Server 2008 easily passes our own five-point test for upgrades by bringing at least five significant improvements to a data environment. It's a winner.
Microsoft 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 extend to both performance and manageability.
In a few cases, such as the Resource Governor, you'll wish Microsoft had taken the functionality a little further. But whether you manage an OLTP environment, or an OLAP environment, or both, you will most likely find Katmai compelling. SQL Server 2008 easily passes our own five-point test for upgrades.
Our five-point test requires a new release to bring at least five significant improvements to our data environment — a large data warehouse — or it's not worth upgrading. Each improvement has to change our life in a significant way, either by dramatically shortening the time to do common tasks or by allowing us to do something we couldn't do before.
These five Katmai features easily pass the test: Change Data Capture, Lookup Cache, Data Compression, PowerShell integration, and Policy-Based Management. And with Microsoft SQL Server 2008, we could easily keep counting.
Change Data Capture and Lookup Cache will be popular with DBAs who want to speed up ETL (Extract, Transformation, and Load) processes, as will the pipeline improvements in Integration Services, enabling Microsoft SQL Server 2008 to push data much faster.
Microsoft SQL Server 2008: faster, sleeker
Data Compression, PowerShell integration, and Policy-Based Management, not to mention Server Groups, should make a big splash in almost any environment. Just keep in mind that the benefits you get from Data Compression (which works at the page level, replacing repeating data with lookup pointers) will depend on the nature of the data in your table and how it's ordered.
Backup Compression is also new in Microsoft SQL Server 2008. Although the compression itself works well, the feature has too many limitations (including supporting only Enterprise Edition) to be effective in an enterprise setting.
Another compression feature, called Sparse Columns, allows you to store nulls without taking up physical space. Sparse Columns will come in handy for large tables containing many null values. It's just too bad you can't use Sparse Columns and Data Compression on the same table.
Policy-Based Management allows you to define almost any configuration or administration policy you might think of for any number of servers, and be alerted whenever those policies are violated. Although spanking new in Katmai, Policy-Based Management already seems mature.
The inclusion of PowerShell will reinvent the way DBAs manage their environments by taking complicated cursors out of management scenarios. This is the debut of PowerShell in SQL Server, and there are some rough spots. But we expect they'll be ironed out soon enough. We've even heard rumours that PowerShell will eventually replace sqlcmd as the command line interface.
Policy-Based Management and PowerShell integration are the biggies, but Management Studio has added some other nice features, such as Server Groups, which allows you to run queries against multiple servers at once. However, we're not fond of the new Activity Monitor. It may be a step in the right direction, but it just isn't useful in its current state.
Another new feature that isn't quite there yet is the ballyhooed Resource Governor. The Resource Governor lets you define limits on CPU and memory usage for certain workloads. This is good enough to prevent some traffic jams — like query processes consuming too many resources on an OLTP server, for example — but it's a far cry from what's needed to define and isolate rogue queries.
In short, Microsoft SQL Server 2008 is a solid release packed with significant improvements. Not all of the new features are fully fleshed out, but some are surprisingly mature and many are extraordinarily useful.
A few will allow DBAs to manage multiple servers as easily as one, and perform certain tasks and operations in a fraction of the time they take today.
Read on for more detail on SQL Server Management Studio and management improvements, Resource Governor, Change Data Capture and non-logged inserts, Data Compression, Backup Compression, index improvements, SQL Server Reporting Services, and SQL Server Integration Services.
Join the PC World newsletter!
Most Popular Reviews
- 1 Sony Xperia Z5 Premium review: Is the world ready for a 4K phone?
- 2 D-Link Taipan AC3200 Ultra tri-band modem-router review
- 3 Dell XPS 13 (2016) review: Making the very best Ultrabook
- 4 Microsoft Surface Book review: The verdict on Microsoft's first notebook
- 5 Telstra Wi-Fi 4GX Advanced III review: Testing the world's first 600Mbps wireless hotspot
Best Deals on PC World
Latest News Articles
- Google's Accelerated Mobile Pages (AMP) speed up web browsing for users
- NBN Co's poor document security enabled document leaks that could have been avoided
- Microsoft breaks own design rules in dupe-the-user Windows 10 upgrade tactic
- Top 30 AWS cloud services
- Update to Google Docs, Sheets, Slides lets them automatically save recent files offline
GGG Evaluation Team
First impression on unpacking the Q702 test unit was the solid feel and clean, minimalist styling.
For work use, Microsoft Word and Excel programs pre-installed on the device are adequate for preparing short documents.
The Fujitsu LifeBook UH574 allowed for great mobility without being obnoxiously heavy or clunky. Its twelve hours of battery life did not disappoint.
The screen was particularly good. It is bright and visible from most angles, however heat is an issue, particularly around the Windows button on the front, and on the back where the battery housing is located.
My first impression after unboxing the Q702 is that it is a nice looking unit. Styling is somewhat minimalist but very effective. The tablet part, once detached, has a nice weight, and no buttons or switches are located in awkward or intrusive positions.
- CCFront end and Full Stack DevelopersNSW
- CCMessaging Engineer - BAU SupportNSW
- CCIT Program ManagerACT
- CCInfrastructure Business AnalystNSW
- CCData Engineer | Real Time StreamingNSW
- FTBI / Business Intelligence Designer / ArchitectNSW
- CCSenior Service Desk ManagerNSW
- CCBusiness Analyst, LifeNSW
- FTNV2 Defence Project Manager | Major exciting White Paper projectsACT
- CC12 months + 2x12 months | $80/hr | NV1 Project Manager | Large govt departmentACT
- FTMid-Level Full-Stack Java DeveloperVIC
- FTData Feeds Developer | Financial Services | C# & SQLNSW
- CCSenior Network Engineer - NV1ACT
- CCSenior DevOps EngineerACT
- FTPerformance Test AnalystNSW
- CCTechnical Digital Producer / Requirements EngineerNSW
- FTTechnical WriterACT
- CCTechnical Specialist - IP Network Design - Juniper MXNSW
- CCProgram Business AnalystVIC
- CCOracle Siebel Administrator - JULY STARTACT
- CCSr Service ManagementACT
- FTWeb DeveloperSA
- CCSolutions Architect - SAP HANAQLD
- CCSecurity Clearances Vetting Services OfficerACT
- CCService Desk analystSA