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 newsletter!
cloudandco Smart Cane
WD MY PASSPORT™ Gaming Storage
WD MY PASSPORT™ X Gaming Storage
Apple iPhone X
Bang and Olufsen BeoVision 14
Panasonic OLED 4K Ultra HD TV - TH-77EZ1000U
Dyson Supersonic™ Hair Dryer Fuchsia/Iron
Nespresso Creatista Coffee Machine
Panasonic OLED 4K Ultra HD TV - TH-55EZ950U
Breitling Superocean Heritage Chronographe 44
Toys for Boys
Propel Star Wars T-65 X-Wing Drone
Lego Mindstorms EV3
Onyx Smart Walkie Talkie
UBTech First Order Stormtrooper Robot
Leica M10 Digital Rangefinder Camera
Google Daydream View VR Headset
Ubiquiti Network’s Front Row Camera
Bose SoundLink Micro
LaCie Rugged USB-C Portable Hard Drive
Amazon Echo Bluetooth Speaker
PETKIG Go Smart Dog Leash
Nest Protect Smart Smoke Alarm
Belkin Pocket Power 10,000mAh
iRobot Roomba 980 Vaccum Cleaning Robot
Toffee Bags Commuter Satchel
Panasonic Hi-Fi - SC-UA7GS-K
WD MY CLOUD™ HOME Personal Cloud Storage
Xbox One X
Dearear Endear In-ear Wireless Earphones
Panasonic 4K UHD Blu-Ray Player and Full HD Recorder with Netflix - UBT1GL-K
3SIXT 3-in-1 Smartphone Lens Kit
Logitech Doodle Collection Wireless Mouse
Panasonic Portable Splashproof Fun - RF-D20U
Urbanworx Full HD Action Camera
Fallout Geeki Tikis
Ikea NORDMÄRKE Wireless Charging Pad
Razer DeathAdder Expert Ergonomic Gaming Mouse
Raspberry Pi Starter Kit
Tile Pro Bluetooth Tracker
Kogan Bluetooth Soundbar
Lexon Flip Alarm Clock
Most Popular Reviews
- 1 Huawei Mate 10 Pro Review: A solid winter flagship that cribs from the best
- 2 Google Pixel 2 review: not quite 'pixel perfect' but damn close
- 3 Google Home Mini review: a welcome addition to the smart speaker family.
- 4 Huawei Nova 2i review: Flagship features get smuggled into the mid-tier
- 5 Moto X4 review: This is what a world without MotoMods looks like
Latest News Articles
- Officeworks hops on voice interface bandwagon with Google Assistant integration
- Amazon confirms early 2018 Australian launch for Alexa and Echo
- JBL join smart speaker arena with the portable, waterproof and (Google-powered) JBL Link range
- University of Sydney Signs World-First Agreement with Dropbox
- Microsoft delves deeper into AI with new kit bag of tools
PCW Evaluation Team
I would recommend this device for families and small businesses who want one safe place to store all their important digital content and a way to easily share it with friends, family, business partners, or customers.
It’s easy to set up, it’s compact and quiet when printing and to top if off, the print quality is excellent. This is hands down the best printer I’ve used for printing labels.
Brainstorming, innovation, problem solving, and negotiation have all become much more productive and valuable if people can easily collaborate in real time with minimal friction.
The print quality also does not disappoint, it’s clear, bold, doesn’t smudge and the text is perfectly sized.
The Huddle Board’s built in program; Sharp Touch Viewing software allows us to easily manipulate and edit our documents (jpegs and PDFs) all at the same time on the dashboard.
The biggest perks for me would be that it comes with easy to use and comprehensive programs that make the collaboration process a whole lot more intuitive and organic
- LG V30+ review: The videographer's smartphone arrives
- Fitbit Ionic review: Impressive but not quite iconic
- Xbox One X review: Brave new world
- What's the difference between an Intel Core i3, i5 and i7?
- Laser vs. inkjet printers: which is better?
Product Launch Showcase
- FTSolution ArchitectOther
- FTSystem TesterOther
- FTPersonal AssistantSA
- TPTechnical Consultant - SOE, SCCMNSW
- CCLevel 1 Helpdesk TechnicianNSW
- CCLinux Platform/Development SpecialistACT
- FTAutomation TesterOther
- FTICT Cloud Transformation Program Coordinator - SAPOther
- FTApplication Support AnalystOther
- FTMicrofocus Cobol DeveloperOther
- FTData Centre Support Engineer -| 6mth ContractOther
- FTSecurity Leads - $800 per dayOther
- FTIntegeration ArchitectOther
- FTLevel 2/Level 3 Application Support AnalystVIC
- FTGraduate C# DeveloperNSW
- FTWeb Writers/EditorsOther
- FTJava DeveloperOther
- CCNetwork Data AdministratorWA
- CCFront-End DeveloperNSW
- FTDevOps EngineerOther
- TPIT Technical WriterNSW
- TPTechnical WriterNSW
- FTBusiness Analyst - TableauOther
- FTNetwork and Telecommunications ArchitectOther
- TPResource ManagerNSW