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!
WD MY PASSPORT™ Gaming Storage
Panasonic OLED 4K Ultra HD TV - TH-55EZ950U
Breitling Superocean Heritage Chronographe 44
SanDisk MicroSDXC™ for Nintendo® Switch™
Bang and Olufsen BeoVision 14
Nespresso Creatista Coffee Machine
Apple iPhone X
Panasonic OLED 4K Ultra HD TV - TH-77EZ1000U
cloudandco Smart Cane
WD MY PASSPORT™ X Gaming Storage
Toys for Boys
Onyx Smart Walkie Talkie
Lego Mindstorms EV3
UBTech First Order Stormtrooper Robot
Propel Star Wars T-65 X-Wing Drone
Google Daydream View VR Headset
Ubiquiti Network’s Front Row Camera
Bose SoundLink Micro
LaCie Rugged USB-C Portable Hard Drive
Leica M10 Digital Rangefinder Camera
WD MY CLOUD™ HOME Personal Cloud Storage
Belkin Pocket Power 10,000mAh
Amazon Echo Bluetooth Speaker
Dearear Endear In-ear Wireless Earphones
iRobot Roomba 980 Vaccum Cleaning Robot
Panasonic Hi-Fi - SC-UA7GS-K
Xbox One X
Nest Protect Smart Smoke Alarm
Panasonic 4K UHD Blu-Ray Player and Full HD Recorder with Netflix - UBT1GL-K
PETKIG Go Smart Dog Leash
Toffee Bags Commuter Satchel
Raspberry Pi Starter Kit
Ikea NORDMÄRKE Wireless Charging Pad
Panasonic Portable Splashproof Fun - RF-D20U
Kogan Bluetooth Soundbar
Logitech Doodle Collection Wireless Mouse
Razer DeathAdder Expert Ergonomic Gaming Mouse
Lexon Flip Alarm Clock
Fallout Geeki Tikis
3SIXT 3-in-1 Smartphone Lens Kit
Tile Pro Bluetooth Tracker
Urbanworx Full HD Action Camera
Most Popular Reviews
- 1 Fitbit Ionic review: Impressive but not quite iconic
- 2 Acer Spin 5 review: Value for money but conditions apply
- 3 Huawei Mate 10 Pro Review: A solid winter flagship that cribs from the best
- 4 Sony LF-S50G review: Google Assistant and then some
- 5 Google Pixel 2 review: not quite 'pixel perfect' but damn close
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
- CES 2018: Belkin go big on wearables accessories
- CES 2018: Alcatel Embrace 18:9 Aspect Ratio In 2018
- OPPO Load Up A73 Smartphone With Flagship Features
- What's the difference between an Intel Core i3, i5 and i7?
- Laser vs. inkjet printers: which is better?
Product Launch Showcase
- CCDesktop EngineerQLD
- FTProgram ManagerSA
- FTCRM DeveloperACT
- FTUX Design LeadOther
- CCIBM FileNet ConsultantsSA
- FTImplementation Project ManagerOther
- CCTechnical Business Analyst - Government - 12 Month Contract - SydneyNSW
- CCAIX System Administration ? UNIXVIC
- CCNetwork Engineer (Juniper)VIC
- FTBusiness Analyst - CMS / DMSOther
- CCMiddleware SpecialistNSW
- CCSystem Access Administrator - TelcoVIC
- FTCyber Security ArchitectOther
- FTSenior Change Analyst / Change Manager ( Banking background)Other
- FTiOS DeveloperOther
- FTNetwork EngineerSA
- TPICT Service Assurance Manager - ServiceNowQLD
- FTEmbedded Software EngineerWA
- FTDevOps EngineerOther
- FTSenior Insights AnalystNSW
- FT.NET DeveloperNSW
- TPSenior Business Analyst - TechnicalNSW
- TPTechnical WriterQLD
- CCIT Service Desk Specialist - BrisbaneVIC
- FTNatural/ADABAS ProgrammerOther