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: improved management
If there's any one new feature in Microsoft SQL Server 2008 that will change the way DBAs manage their environments, it's probably Server Groups.
Server groups let you run any query you like against an entire group of servers simultaneously. So instead of having to cycle through all of your servers to check job status, deploy stored procedures, and so on, you can manage or push code to any number of servers with a single query.
On top of that, Server Groups can be further extended and enhanced to do some great things. It does take a paradigm shift, however. DBAs will have to start thinking in terms of groups instead of single servers.
SSMS (SQL Server Management Studio) also has much better object-level stats than ever before. This is a perfectly executed feature, and we love it. In the object details pane, you can now click on an object folder and get info for all objects in that folder. For example, click the Databases folder to immediately see the key info on all the databases on the server, including size, space used, owner, index space used, and many more.
This is an incredibly useful list because you can sort it and reorder the columns and your customisations persist. You can get detailed info on all of your tables too. In this new detail view, you can see row count, data and index usage, schema, and so on. Not only is it very easy to view object-level stats, but this level of info is available for all folders, not just databases and tables. This is one feature that we wouldn't change in any way.
One of the most important features included in this release is PowerShell. PowerShell is going to change how DBAs manage their environment, because it allows you to do complicated things so much easier than in Visual Basic or T-SQL.
Let's take an example of scripting databases. You can script a database pretty easily in SSMS, but you can't schedule it. Until now, if you want to schedule a script or code the scripting process to perform the exact same options every time without having to click through the wizard or worry about making mistakes, all you could do was code a solution in VB and compile it. But not everyone has VB skills, and writing SMO (SQL Server Management Objects) is neither easy nor intuitive.
PowerShell allows you to script a database in just 21 characters of code and schedule it inside an agent job. You don't have to compile it, so you don't have to keep up with separate source code. PowerShell also makes it a lot easier to work with multiple objects — and multiple servers — in SQL Server.
Another good example is adding user permissions to all the schemas in a database. You can code this in T-SQL, but T-SQL requires the inclusion of unsafe dynamic SQL code inside a cursor. You can accomplish the same thing in PowerShell with just a couple of lines of code, and without introducing any unsafe constructs into your environment.
Join the newsletter!
Cartier Calibre de Cartier Diver Watch
Samsung QLED 8K TV
Bang and Olufsen Beoplay A9 Speaker
Ballistix Sport AT
Ballistix Tactical Tracer RGB 3000
Toys for Boys
Tivoli PAL BT
ESET Cyber Security Pro for Mac
Osmo Coding Awbie Game
Nix Pro Colour Sensor
ESET Smart Security Premium
ESET Internet Security
Oregon Pro WMR500 Weather Station
Little Bits DROID Inventor Kit
Naztech Xtra Drive Mini + 256GB microSD Card
Ultimate Ears Wonderboom Bluetooth Speaker
TimeFlip Magnet Simple Time Tracking Device
SmartLens - Clip on Phone Camera Lens Set of 3
Ikea RIGGAD work lamp with wireless charging
There are countless trends competing for attention in the gaming notebook and laptop space but not all of them are either useful or benefit the core gaming experience.
Most Popular Reviews
- 1 Oppo R17 Pro review: Oppo's thriftiest flagship yet drives a hard bargain
- 2 Google Home Hub review: A different kind of smart TV
- 3 Nokia 7.1 review: A modest and modern mid-tier option
- 4 Tenda Nova MW6 review: A gateway drug for mesh Wi-Fi
- 5 Huawei Mate 20 Pro review: Expensive, but probably the best phone you can buy right now
Latest News Articles
- CBA capitulates, will support Apple Pay next year
- Intel unveils the Intel Neural Compute Stick 2
- Fetch TV expands with Aussie Broadband
- Adobe announces next generation of Creative Cloud
- Logitech announces Logitech Rally
PCW Evaluation Team
Microsoft Office continues to make a student’s life that little bit easier by offering reliable, easy to use, time-saving functionality, while continuing to develop new features that further enhance what is already a formidable collection of applications
I’d recommend a Dell XPS 15 2-in-1 and the new Windows 10 to anyone who needs to get serious work done (before you kick back on your couch with your favourite Netflix show.)
It’s useful for office tasks as well as pragmatic labelling of equipment and storage – just don’t get too excited and label everything in sight!
The Brother MFC-L8900CDW is an absolute stand out. I struggle to fault it.
I need power and lots of it. As a Front End Web developer anything less just won’t cut it which is why the MSI GT75 is an outstanding laptop for me. It’s a sleek and futuristic looking, high quality, beast that has a touch of sci-fi flare about it.
If you’re looking to invest in your next work horse laptop for work or home use, you can’t go wrong with the MSI GE63.
- PC World 2018 Editor's Choice Awards
- Huawei Mate 20 Pro review: Full, in-depth, Australian review
- Razer Phone 2 review: One for the fans
- Everything you need to know about Smart TVs
- What's the difference between an Intel Core i3, i5 and i7?
- Laser vs. inkjet printers: which is better?