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!
Samsung portable 1TB T3 drive
Epson WorkForce ET-4550
Everki ContemPRO Roll Top Laptop Backpack
Lexar® JumpDrive® S57 USB 3.0 flash drive
UE Boom 2 Bluetooth speaker
Microsoft L5V-00027 Sculpt Ergonomic Keyboard Desktop
Epson EcoTank Expression ET-2500
Linksys AC5400 MU-MIMO Gigabit router
Google Daydream VR headset
Epson WorkForce DS-360W
Lexar® JumpDrive® S45 USB 3.0 flash drive
Lexar® Portable SSD
Acer Swift 7
Belkin MIXIT Metallic Lightning to USB Cable
Logitech G403 Prodigy mouse
3SIXT Ultra HD Sports Action Camera
Huawei Mate 9
Lexar® JumpDrive® C20c USB Type-C flash drive
Blade 28 backpack by Arc’teryx
Audio-Technica ATH-ANC70 Noise Cancelling Headphones
Dell Inspiron 5000 series 2-in-1
HP Pavilion x360 13”
Lexar® Professional 1800x microSDHC™/microSDXC™ UHS-II cards
Garmin Fenix Chronos smartwatch
Dell XPS 13 laptop
Surface Pro 4
HD Pan/Tilt Wi-Fi Camera with Night Vision NC450
Most Popular Reviews
- 1 Huawei Mate 9 full in-depth smartphone review
- 2 ZTE Axon 7 review: Is ZTE dumping old stock on Australia?
- 3 Oppo R9s smartphone full review
- 4 Huawei Nova Plus smartphone review
- 5 Google Pixel XL full, in-depth smartphone review: Phones just got smarter
Latest News Articles
- Google promotes Keep note app to a G Suite core service, much to our relief
- Lenovo to integrate Amazon Alexa in Moto smartphones
- Google will start adding Assistant to Nougat and Marshmallow phones this week
- Google's new AI aims to end abusive online comments using 'Perspective'
- Village Roadshow aims to block 40 pirate sites
PCW Evaluation Team
A smarter way to print for busy small business owners, combining speedy printing with scanning and copying, making it easier to produce high quality documents and images at a touch of a button.
I've had a multifunction printer in the office going on 10 years now. It was a neat bit of kit back in the day -- print, copy, scan, fax -- when printing over WiFi felt a bit like magic. It’s seen better days though and an upgrade’s well overdue. This HP OfficeJet Pro 8730 looks like it ticks all the same boxes: print, copy, scan, and fax. (Really? Does anyone fax anything any more? I guess it's good to know the facility’s there, just in case.) Printing over WiFi is more-or- less standard these days.
As a freelance writer who is always on the go, I like my technology to be both efficient and effective so I can do my job well. The HP OfficeJet Pro 8730 Inkjet Printer ticks all the boxes in terms of form factor, performance and user interface.
I’d happily recommend this touchscreen laptop and Windows 10 as a great way to get serious work done at a desk or on the road.
Ultimately, I think the Windows 10 environment is excellent for me as it caters for so many different uses. The inclusion of the Xbox app is also great for when you need some downtime too!
For me, the Xbox Play Anywhere is a great new feature as it allows you to play your current Xbox games with higher resolutions and better graphics without forking out extra cash for another copy. Although available titles are still scarce, but I’m sure it will grow in time.
- Kogan curved 4K UHD 55-inch LED LCD TV review
- How to quit Pokemon Go (or to start enjoying it again)
- Huawei Mate 9 full in-depth smartphone review
- What's the difference between an Intel Core i3, i5 and i7?
- Laser vs. inkjet printers: which is better?
- FTConsultant Business AnalystQLD
- CCDesktop Engineer l WollongongNSW
- FTDrupal Developer - SeniorQLD
- CCFinance Analyst/ Project SpecialistVIC
- CCSenior .NET DeveloperNSW
- FTNodeJS DeveloperNSW
- FTSenior Business AnalystSA
- CCTest Automation EngineerVIC
- CCBusiness Analyst - AgileQLD
- FTBranch Practice Manager - SecurityQLD
- FTDeveloper - Java/J2EEQLD
- FT.net Developer (Front and Back end)QLD
- CCFront End Developer - Mid-LevelNSW
- CCDevOps/Senior Sys Admin - eCommerce - Contract - Sydney Northern BeachesNSW
- CCInfrastructure Test AnalystACT
- CCPega DeveloperNSW
- TPSenior Java Developer - ContractQLD
- FTIT Information Security AdvisorNSW
- TPBusiness Process Analyst (Newcaslte Based)NSW
- FTJunior / Entry Level IT role - Recent IT TAFE GraduateNSW
- CCTechnical Support AnalystACT
- FTDigital Strategist - Global Consulting FirmACT
- CCMicrostrategy DeveloperVIC
- CCSenior ASP .NET DeveloperNSW
- TPMicrosoft Analyst ProgrammerSA