Microsoft Delivers SQL Server 2005 SP3

Microsoft ratcheted up its product support for SQL Server 2005 by releasing Service Pack 3 (SP3) on Monday, along with SP3 Cumulative Update 1. On the same day, the company also released Cumulative Update 11 for SQL Server 2005 Service Pack 2 (SP2).

If that weren't enough, the company offered incentives for Microsoft's partners and Microsoft Dynamics customers to jump to SQL Server 2008, which was released as a product last summer.

Microsoft is updating its price list on January 1, 2009 and will replace the runtime for SQL Server 2005 with that of Microsoft SQL Server 2008, according to a Microsoft Dynamics blog.

"Customers who have licensed Microsoft SQL 2008-Runtime and are current on the Business Ready Enhancement Plan as of January 1, 2009 will be entitled to an upgrade to Microsoft SQL Server 2008," the blog explained.

Features in SQL Server SP3 include "supportability enhancements," plus improvements in the database engine, notifications services, replication and reporting services, according to an MSDN library Web page. SP3 contains all previously released cumulative updates for SQL Server 2005.

KnowledgeBase articles for SP3 are available through the release notes here.

For SQL users not opting for SP3, Microsoft released Cumulative Update 11 for SQL Server 2005 SP2, which contains all of the hot fixes for SP2, without the new features in SP3.

However for those who are moving from SQL Server SP2 to SP3, Microsoft offers a caveat. Be sure to apply SP3 Cumulative Update 1.

"If you are upgrading from SQL Server 2005 SP2 Cumulative Update 10 or from SQL Server 2005 SP2 Cumulative Update 11, you must apply a post-SP3 cumulative update after you upgrade to SP3 to obtain all the fixes," according to Nick MacKechnie's blog.

For those wanting more than just blog advice, Microsoft's "Books Online" release for Microsoft SQL Server 2005 is available here. It provides primary documentation, including setup and upgrade instructions for SP3.

Microsoft also released a new Feature Pack for SQL Server 2008 on Monday that provides optional add-ons for the database solution. The December Feature Pack can be accessed here.

For more information and links to documentation, visit the Swiss IT Professional and TechNet Blog.

Feature Dell Simplifies Virtualization

Dell Inc. is not the most complex company in the world. Its PCs and laptops run industry-standard operating systems on industry-standard hardware and focus on overall value. It's the same story with servers.

While it may take a while to untangle the rich and complex virtualization strategies of Sun Microsystems Inc., IBM Corp. and Hewlett-Packard Co., Dell's approach is shockingly simple. Could it be that simple is better? Dell thinks so.

Not surprisingly, Dell's overall theme in all of this is to "Simplify IT," an initiative announced last year that focuses on easing the expansion of data center assets, taking more advantage of assets you already have and dealing with a mobile workforce. Virtualization plays a huge role in the Simplify IT plan. "We think there's an opportunity to move beyond just hypervisors and consolidation to more advanced end-to-end usages and benefits, like disaster recovery, high availability and dynamic provisioning. We think there's an opportunity to take the complexity out of the data center by simplifying lifecycle management," says Rick Becker, Dell's vice president of the Enterprise Software Group.

In fact, the first product set announced under the Simplify IT umbrella was all about virtualization. On-Demand Desktop Streaming is a Citrix-based thin client setup using PowerEdge servers on the back-end, standard as well as diskless PCs for application access, a PowerConnect Switch for networking, with storage handled by a PowerEdge 2900 storage server. Streaming is provided by the Citrix Provisioning Server for Desktops software. Dell claims that 100 desktops can be driven off a single Dell server.

Dell and Partners
While Sun, IBM, and even HP develop home-grown tools, Dell prefers to work with software partners and supports their tools. This still gives the server giant a full range of offerings. On the hypervisor or platform side, Dell has formal deals with VMware Inc., Microsoft and Citrix Systems Inc., plus Novell Inc. and Red Hat Inc. Dell also supports CommVault, Double-Take Software Inc., PlateSpin Ltd., Platform Computing Corp., Vizioncore Inc., Symantec Corp. and Altiris (recently acquired by Symantec), which has application virtualization and management.

While Dell focuses mostly on VMware on the server, and Citrix for desktop virtualization, the company also works with Sun. Under a deal struck last fall, Dell offers Sun's Solaris, which includes the Xen hypervisor, on Dell servers. Dell is also moving toward Microsoft. "As Hyper-V becomes available from Microsoft, we'll offer that," says Becker. And as for Sun's own hypervisor, xVM Server? "We're looking at Sun right now. We're certifying Solaris on select environments, and we're trying to figure out what the right virtualization strategy with Sun is," Becker explains. Meanwhile, Dell pushes Xen, especially in high-end environments where I/O performance is a big concern.

Working with partners means that Dell has fewer of its own technologies, such as hypervisors and large management stacks. "We think our competition is driving to captive complexity, whereas ours is a simplified enablement strategy," argues Sally Stevens, director of Dell's PowerEdge Servers group. Stevens points to HP in particular, which promotes the HP Insight Manager. "They want to take all these different management tools that are out there and pull them into the suite of [HP] Insight Manager," she argues. Meanwhile, Dell "wants to partner with best of breed [providers] to give customers options and a simplified and best-of-class solution."

Analysts see this as a key difference for Dell. "Among HP, IBM, Dell and Sun, all except Dell have a strong software development focus. These three companies have been involved in virtualization technology and have products at every layer [of the virtualization model we use]. So there's a clear distinction between Dell-which takes advantage of the software that's written by Microsoft, Red Hat, Novell and others -- and the other three," says Dan Kusnetzky, president of the Kusnetzky Group.

There may also be a downside to this simplicity. "Dell has only one architecture that they play in and they don't necessarily have the ability to reach either as high in scalability, or as low- in the case of some embedded systems- as the other players can. So if you were looking for something that went from the desktop to the biggest of the big data centers, we're looking at HP, IBM and Sun. However, if we spoke to people in Japan, they would also bring up Hitachi and NEC and in Europe, there would be Siemens," Kusnetzky concludes.

Reference Architectures
To keep installations simple, Dell has Reference Architectures to make sure all this software runs properly and suits customer needs.

One of the most developed reference architectures, as one might imagine, involves VMware. Dell has VMware reference architectures and pre-test configurations that include servers, HBAs, NICs and storage component such as RAID arrays.

The architectures address three3 levels of IT:.

  • Small is aimed at small shops with one or two servers, direct-attached storage, with no ability to move virtual machines (VMs) around. Here Dell promotes VMware or XenServer with Dell PowerVault storage.

  • Medium addresses shops with eight to 16 servers, uses network-attached storage, exploits VMotion to move VMs around, and uses VMware Virtual Center for management. Here Dell suggests EqualLogic storage and VMware plus Site Recovery Manager to maximize uptime.

  • Large is for shops with more than 16 servers, using Fibre Channel storage-area network or iSCSI network-attached storage, as well as VMotion and Virtual Center.

    On the high end, Dell also has a partnership with Egenera -- its software is designed to automate the entire data center, creating large virtual pools of processing called a Processor Area Network, or PAN. Dell is bundling together EMC storage, XenServer, and PowerEdge servers equipped with Egnera software as the Dell PAN System.

    "We're finding out that for a small business customer, they're looking for an ease of application deployment. Our midrange business customers are looking at how they can move their hard drives out of their servers and onto their networks, and how they can manage their physical/virtual environments more simply. Our biggest enterprise customers are looking at how they can virtualize and automate their entire environment," says Becker.

    Analysts applaud the Dell PAN System move. "Licensing the Egenera technology was a very good move for Dell," says Judith Hurwitz, President, Hurwitz and Associates.

    Dell Services
    Dell has servers, bundles and deals with the major hypervisor makers. So what else does Dell bring to the party? Expertise. Its Services group offers assessment, planning, installation and training.

    And despite support for Microsoft, Citrix/Xen and others, Dell consultants today focus almost 100 percent on VMware, offering what Dell calls "a direct, uncomplicated approach that simplifies, speeding time to productivity" and a "standards-based virtualization strategy." Dell claims that its virtualization installations, on average, lower TCO by about 25 percent.

    While Dell remains a huge VMware fan, its services plan is to be hypervisor-agnostic. "We've been providing VMware services for some time. We're expanding those services. We will also be providing a complete set of services around the XenServer set of products. And we are already working with Microsoft on their upcoming release of Hyper-V and will have complete end-to-end services for that product as well," says Tim Webb, Dell's director of Services.

    Besides building new virtual environments, Dell Services can optimize existing shops. Dell's Assessment services include tools that discover the servers and levels of utilization. This helps guide which servers and apps are ripe for consolidation.

    Next Dell can design a plan, which typically calls for Dell servers, VMware ESX, VMware's Virtual Center, VMotion, and a combination of Dell and EMC SAN storage.

    What that plan won't typically entail is a raft of Dell management tools that could lock the customer in. "As virtualization takes hold we have an opportunity to break the proprietary lock holds of systems management. We have OpenManage, which is integrated with VMware and Citrix and it's a great solution for our customers that want to do a one-to-one or one-to-many. But it shouldn't be about what the vendor wants, it should be about what the customer wants," says Webb.

    Storage: EMC vs. EqualLogic
    Dell's storage strategy is two-pronged. The company has a long-standing relationship with EMC Corp., where Dell sells and even manufactures EMC gear. The EMC line has an array of virtual features, and Dell sells these AX and CX boxes to a largely high-end audience.

    This February, Dell bought EqualLogic for $1.4 billion, and in the process gained a line of iSCSI SAN storage devices that boast some virtualization features such as thin provisioning.

  • "Dell, with its acquisition of EqualLogic, now has a storage virtualization strategy. EqualLogic's arrays are consolidated under a single management system. The acquisition is a great boon for small and midsize businesses and departments within larger enterprises who want to embrace virtualization," explains Deni Connor, principal analyst for Storage Strategies Now, a storage-focused research and consulting firm.

    Many thought the EqualLogic acquisition would spell the end of the EMC deal, which runs through at least 2011. Instead, Dell aims the EqualLogic gear at small to midsize businesses and EMC at larger enterprises.

    Maybe a bigger issue is protocols. EqualLogic is iSCSI only, while EMC talks both Fibre Channel and iSCSI. As a storage veteran, EMC also has a broader selection of tools than EqualLogic, which was still a startup when Dell bought it.

    In a recent white paper, Dell argues that when it comes to storage virtualization, iSCSI tools such as EqualLogic are far superior to Fibre Channel, which is largely what EMC offers. That's because Fibre Channel SANs are hard-coded as each port has its own World Wide Name embedded in the physical device.

    Because it's based on TCP/IP, iSCSI SANs use DNS and therefore the addresses themselves are virtual.

    Dell argues that the EqualLogic tools have several advantages, including fast setup time. Praveen Asthana, director of Storage for Dell, argues that an EqualLogic SAN can be set up in as little as 20 minutes, far faster than Fibre Channel SAN.

    Asthana also argues the iSCSI-based EqualLogic boxes are more flexible. "When you implement a virtualized environment, you're talking about a lot of unpredictable movement of virtual machines, which has unpredictable demands on storage. To actually move VMs around you'll need to dynamically reallocate your storage. With all of the current arrays, it's very difficult to do."

    EqualLogic PS Series array storage virtualization features include:

    • Can virtualize volumes across disks and controllers
    • Virtualizes storage I/O
    • Thin provisioning

    Dell also claims that its storage line works with virtual environments, backing up applications and handling file-level backup and restore on VMs. The strategy of working with virtualization has a decided VMware bent. Dell can back up and restore VMware files, known as .VMDKs which helps restore an existing virtual machine. Dell storage also works with VMware Consolidated Backup.

    Dell and the Virtual Appliance
    While a server equipped with VMware or Microsoft Virtual Server seems pretty simple, an appliance is even more basic. And Dell has a ton of them, including software-only appliances or VMs and hardware appliances pre-loaded with specific applications.

    Software appliances, which are often designed for easy evaluation rather than deployment, include:

    • Symantec Mail Security
    • Red Hat Appliance Stack
    • SuSE Linux Enterprise Server
    • Ubuntu 7.10 JeOS with VMware Tools
    • BlueLane VirtualShield
    • Enterasys Secure Networks Dragon Enterprise Security Suite

    You can even download Windows Server 2008 or Exchange as a VM to give it a whirl.

    The Buying Process
    Dell is also trying to make it simpler to buy servers and virtualization software. Under the new Web site, www.dell.com/VMwareNow, customers can buy everything online. "It will streamline the path for customers to upgrade to full VI 3 enterprise licensing," explains Sally Stevens, director of PowerEdge Servers. Two of Dell's newest servers, the PowerEdge R805 and R905, come with either VMware ESX 3.5 or XenServer Express. These machines can handle up to 60 VMs each, Dell claims.

    The Customer View
    One customer is looking forward to exploiting what Dell has to offer in hardware and software, but probably won't need Dell Services. "As far as what Dell and others are doing, my opinion is they're beating a much bigger drum than we need or can dance to. Not saying what they're doing isn't good, because it is. I just feel like we've got the know-how to get it done in-house and on our own terms. I do use their online resources to help/advise me on what our next move should be," says Nick Clark, an MCSE and IT pro with Kerber, Eck & Braeckel LLP in Springfield, Ill. "We've got a couple Dell PowerEdge servers right now that we plan to roll into virtual servers. I'd like to set up as many as three virtual servers to each of these two servers, which would likely drop our total existing system by 50 percent. The scary part is that a couple of these servers will be servicing public extranet information and I don't know if I'm going to jump off that cliff yet."


  • What is Green Data Center?

    Issues and opportunities around energy, the environment, and sustainability impact every individual and every business, worldwide. Energy usage is becoming the largest single data center operating cost — at 30-40% of the operational budget today. Within the next few years, it is estimated the cost to power a server will equal the acquistion cost of the server. These critical energy and power costs should be solve through an optimized IT infrastructure. By combining hardware, software and services offerings, we can meet all of our business goals — performance, availability, simplicity — while addressing energy and cooling concerns.

    Green Data Center means simplify, less power, and manageable system that can bring business continuity and save the world from critical energy resources.

    What is Business Continuity?

    Today's senior management, with ever increasing time to market and resource constraint pressures, will need the answers to two major questions when considering the value of any proposed investment in improving business continuity IT Infrastructure. These questions are:

    What is the overall value proposition of Business Continuity to the business itself and what functions of Business Continuity do for our daily competitiveness, responsiveness, expense posture, and profit?

    What is the relationship between these business benefits and associated IT Infrastructure and IT operations requirements?

    The Answer is:
    The ability to adapt and respond to risks, as well as opportunities, in order to maintain continuous business operations, be more trusted partner, and enable growth.

    Laser Printers: An Overview


    Laser printers offer great speed and reliability for demanding business and home users. At their best when put to work in a network setting, laser printers allow multiple users to take advantage of the high speeds and duplexing capabilities of the printer.

    But how to weigh those advantages? We've got some tips on shopping for a laser printer if you're in the market for one this holiday season. And we've got a trio of recommendations for models that passed muster in our tests.

    Two sides are better than one Printers that offer duplexing can print on both sides of the page--a useful feature for users who want to maximize speed and efficiency. And printing on both sides of a page ultimately saves you money on paper.

    On a related note, laser printers cost less per page to print than their inkjet counterparts; they're also more environmentally friendly.

    What to look for When judging a laser printer, there are two key factors you should focus on--speed and text quality. Macworld Lab includes both time trials and jury ratings in our laser printer reviews--make sure to look at both when deciding which model to buy.

    A quality laser printer typically prints 10 pages in around 30 to 45 seconds. As for our jury tests of printing quality--which also include ratings on the quality of image and graphics output--a quality laser printer score a rating of "very good" or better in our text-quality test.

    Ponder Postscript Postscript capability or emulation is an important ability to consider. Postscript is a print description language that enables laser printers to handle high-quality graphics alongside text. No longer an absolute necessity, Postscript printing is still important as it takes the load off your computer's CPU and allows the use of certain types of fonts.


    InfoPrint 4247-X03 multiform printer


    Reliable high-speed printing for demanding business environments.

    Quick Tech Summary

    • Print speeds (up to) 800 cps¹

    • Multilingual 2x24 LCD display

    • Remote management with virtual operator panel.

    Our InfoPrint® 4247-X03 was made for demanding print environments. From the office to the warehouse, its industrial strength design puts professional reliability into every single print job. With a long lifecycle, low per-page costs, and worry-free operation, it gives you peace of mind laser printers can’t match.

    Highlights

    • Automatic forms loading and thickness adjustment

    • Supports printing on a wide range of media types.

    • Remote Printer Management Utility, included with the optional Ethernet controller, gives users visibility to real-time printer status for every printer on the network.

    • All-points-addressable graphics capability enables quality printing of bar codes, logos, overlays and more.

    • Optional Ethernet card supports IPDS and SNMP for the migration of legacy attachments

    • Pedestal, cabinet or desktop configurations are available.

    • Optional dual front paper paths and heavy-duty 6-pin tractors for easy forms loading


    IBM Infoprint Color 1634


    IBM Infoprint Color 1634

    First-page-out-times as fast as 10.5 seconds for monochrome and 11 seconds for color, giving small and medium workgroups the ability to produce high quality output whenever it is needed. The Infoprint Color 1634 Series includes tools to help you control color print access, produce consistent print quality, and help keep confidential jobs secure. Add wireless networking support or an additional paper tray when you're ready to boost the performance of your investment. An optional duplex model, high yield use and return cartridges and an intuitive operator panel are all designed to improve user productivity while reducing the number of user interventions.

    Description: Model ID 39V1776 / IBM Infoprint Color 1634 - Printer - colour - duplex - laser - Legal, A4 - 1200 dpi x 1200 dpi - up to 22 ppm (mono) / up to 20 ppm (colour) - capacity: 350 sheets - USB, 10/100Base-TX - Express / A powerful processor and 128 MB of memory produce.