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!
Most Popular Reviews
- 1 Oppo A73 review: The budget smartphone that sets the bar for 2018
- 2 Oppo R11s review: The iClone you know and love, but not quite the one you deserve
- 3 Blackberry KEYone Black Edition review: What the original KEYone should have been
- 4 Zolo Liberty+ review: The true wireless earbuds you've been waiting for
- 5 Samsung Gear IconX 2018 review: The path of least resistance makes for an easy upgrade
Latest News Articles
- Sonos say Aussie Alexa support for One smart speaker won't arrive until Autumn 2018
- Transport for NSW boosts digital experience with Amazon Alexa
- Irdeto Acquires Denuvo
- Businesses jump on Amazon’s Alexa after Australian launch date revealed
- Officeworks hops on voice interface bandwagon with Google Assistant integration
PCW Evaluation Team
The printer was convenient, produced clear and vibrant images and was very easy to use
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.
- Interview - Netgear CEO Patrick Lo talks eSports, the NBN and why mesh is the smartphone of home Wi-Fi
- Everything You Can Do, I Can Do Better: Comparing The Google Home’s Assistant To Amazon Echo’s Alexa
- Samsung Galaxy S9+ review: A predictably-exellent flagship uplifted by a standout camera
- What's the difference between an Intel Core i3, i5 and i7?
- Laser vs. inkjet printers: which is better?
Product Launch Showcase
- FTJava Developer (API)Other
- CCSenior Project CoordinatorNSW
- FTBusiness AnalystSA
- FTProject Manager - DatawarehouseACT
- FTBusiness AnalystNSW
- FTTest AnalystQLD
- FTIT SpecialistSA
- FTSoftware EngineerOther
- FTProject Manager - SAP Asset ManagementOther
- FTSenior Project Coordinator, Project DeliveryOther
- FTWireless Consulting EngineerNSW
- FTJava DeveloperWA
- FTOracle SOA Integration ConsultantOther
- FTJava DeveloperOther
- TPMessaging EngineerQLD
- FTApplication Delivery Manager - HealthcareQLD
- FTBusiness Intelligence DeveloperNSW
- FTInformation Management OfficerVIC
- FTSenior Business AnalystOther
- FTHelp desk Support AnalystOther
- TPChange and Communication ManagerVIC
- FTOrganisational Change ManagerOther
- FTOracle SOA DeveloperOther
- TPSenior Java Developer / IntegratorACT
- FTSoftware Media Applications SpecialistOther