Subscribe to SQL Server Magazine: http://lists.sqlmag.com/t?ctl=27C8F:610454 =================================
Our email address has changed! To ensure that future email messages you receive from SQL Server Magazine UPDATE aren't mistakenly blocked by antispam software, be sure to add SQLServerMag_UPDATE@lists.sqlmag.com to your list of allowed senders and contacts.
==== This Issue Sponsored By ==== This email newsletter comes to you free and is supported by the following advertisers, who offer products and services that might interest you. Please take a moment to visit these advertisers' Web sites and show your support for SQL Server Magazine UPDATE.
Double-Take Software http://lists.sqlmag.com/t?ctl=27C74:610454
Hewlett-Packard http://lists.sqlmag.com/t?ctl=27C78:610454
=================================
April 21, 2006
1. Commentary - Microsoft Business Intelligence, Part 2: The 2007 Office System
2. Events Central - Are you a SQL Server Superhero? Take our free pop quiz to prove that you are, and you'll be entered to win a PSP! - Industry guru Randy Franklin Smith helps you identify what you should do to leverage your mobile and wireless infrastructure, how to pick devices that are right for you, and more! - Learn about the advantages of each alternative to traditional file servers and tape storage solutions, and make the best choice for your enterprise needs. - Gain control of your messaging data with step-by-step instructions for complying with the law, ensuring your systems are working properly, and ultimately making your job easier.
3. Featured White Paper - Secure Your Online Data Transfer with SSL
4. What's New in this Issue: - Focus: Integrating SQL Server & Office 2003 - Editorial: Riding the x64 Wave - Products
5. Announcements - Exclusive Spring Savings - Save 44% off the Windows IT Security Newsletter 6. Subscribers Only - Development Section - Administration Section - Business Intelligence Section - Departments
==== Double-Take Software ====
Start your disaster recovery program before it's too late--including defining the right plan for you, and mistakes to avoid when planning. http://lists.sqlmag.com/t?ctl=27C74:610454
1. ==== Commentary ==== Microsoft Business Intelligence, Part 2: The 2007 Office System by Douglas McDowell, douglas@SolidQualityLearning.com
Last month, I commented on the expanding definition of Microsoft Business Intelligence (BI-- http://lists.sqlmag.com/t?ctl=27C89:610454 ), foreshadowed a forthcoming financial-planning application, and promised to soon focus on the 2007 Office System. Remember when it was just Office? It's gone from just a desktop productivity suite to a never-ending product line that spans the client desktop, server infrastructure, and the Internet. They had to call it something different <g>. The 2007 Office System includes old Microsoft favorites such as Word, PowerPoint, Excel, Access, Outlook, and FrontPage, plus OneNote, InfoPath, Project, Live Meeting, Publisher, Visio, and MapPoint. Microsoft also piled on server products such as SharePoint Portal Server, Windows SharePoint Services, Business Scorecard Manager (BSM), Exchange Server, Live Communications Server, Project Server, and new additions including Forms Server and Groove Server. (If any of these products are new to you, see the 2007 Microsoft Office System preview Web site at http://lists.sqlmag.com/t?ctl=27C8B:610454 .) Because the system is too expansive to cover in one commentary, I'm going to look at components that extend SQL Server, especially BI. To get my facts (and the product names) straight, I talked to Alex Payne from the Office Business Applications (OBA) team. Alex is The Man when it comes to Microsoft's BI plans; he's always in the middle of everything figuring out what customers need and how Microsoft ranks. Alex explained Microsoft's acquisition of ProClarity ( http://lists.sqlmag.com/t?ctl=27C79:610454 ). He underscored with indelible ink that ProClarity is NOT Excel's replacement as *the* Microsoft Analysis Client, but we should expect to see ProClarity's ingenuity shine through Excel in future releases. The Microsoft-ProClarity deal should wrap up in May; then, folks like Alex can reveal Microsoft's plans for integrating ProClarity into their product road map. Excel 2007 offers exciting data-visualization improvements; and its PivotTables are more robust and flexible. You don't have to feel your way around with drag-and-drop but instead can use a placement pane to move measures and dimensions. You can even build calculations and use conditional formatting inside PivotTables. Excel 2007's new data-visualization features, such as data bars (each cell has a degree of background-fill correlating to its value) and the ability to create heat maps (rectangles of different sizes and colors based on data represented), are really catchy. Excel 2007 has a strong Analysis Services 2005 integration, displays rich metadata (i.e., member properties), and has native support for Analysis Services Key Performance Indicators (KPIs). Office SharePoint Server 2007 will be a hub for BI in organizations of all sizes. Almost completely rewritten, Microsoft's portal server has truly matured and expanded, incorporating excellent BI features including Excel Services and robust reporting and KPI support. Excel Services enables enterprise deployment of Excel content through SharePoint in a pure-HTML format. SharePoint will offer support for Reporting Services administration, a new Report Center, and the ability to publish directly to the Report Center or Report libraries--similar to document libraries but "smart" to Reporting Services and Office report content. Basic dashboard functionality will be accessible with the new SharePoint KPI List feature. Often running under the waterline in the BI arena are Visio, MapPoint, and Project. Visio's data-driven diagrams rock, and MapPoint is fully programmable for rich spatial and geographical reporting. Project is a little different from Visio and MapPoint; it represents a client and server solution for a Project Management Office (PMO), which includes notable BI functionality. Look for 2007 Office public betas later this year and its near-end-of-year release. Alex and I didn't have time to delve into BSM, but the OBA team is hard at work on the next release. =========================
==== Hewlett-Packard ====
Your Guide to Exchange 2003 High Availability Many things can affect your messaging system's availability, including component failure, power outages, operator errors, and natural disasters. This FREE white paper will help you plan and implement reliable strategies to maintain highly available Exchange Server 2003 messaging systems. Download it today! http://lists.sqlmag.com/t?ctl=27C78:610454
2. ==== Events Central ====
Are you a SQL Server Superhero? Take our free pop quiz to prove that you are, and you'll be entered to win a PSP! http://lists.sqlmag.com/t?ctl=27C90:610454
Industry guru Randy Franklin Smith helps you identify what you should do to leverage your mobile and wireless infrastructure, how to pick devices that are right for you, and more! http://lists.sqlmag.com/t?ctl=27C76:610454
Learn about the advantages of each alternative to traditional file servers and tape storage solutions, and make the best choice for your enterprise needs. http://lists.sqlmag.com/t?ctl=27C75:610454
Gain control of your messaging data with step-by-step instructions for complying with the law, ensuring your systems are working properly, and ultimately making your job easier. http://lists.sqlmag.com/t?ctl=27C7A:610454
3. ==== Featured White Paper ====
Secure Your Online Data Transfer with SSL Increase your customers' confidence and your business by securely collecting sensitive information online. In this free white paper you'll learn about the various applications of SSL certificates and how to deploy them appropriately, along with details of how to test SSL on your Web server. http://lists.sqlmag.com/t?ctl=27C7B:610454
==== Hot Release ===
Explore how the standardization of storage hardware will change market dynamics, focusing on the growth of iSCSI SANs and "glue software." http://lists.sqlmag.com/t?ctl=27C77:610454 ==================== SQL Server Magazine is the #1 SQL Server resource dedicated to everything SQL Server. Each issue is loaded with performance tips, how- to articles, coding techniques, troubleshooting tricks, development strategies, product reviews, and much more. Not only do SUBSCRIBERS get each new issue delivered to their doorstep or desktop each month (1 year/12 issues), but they also get exclusive online access to every article ever published in SQL Server Magazine, including the most recent issue ( http://lists.sqlmag.com/t?ctl=27C8C:610454 ). If your job depends on getting the most out of SQL Server, then you need SQL Server Magazine. Subscribe today: http://lists.sqlmag.com/t?ctl=27C8F:610454 =========================
4. ==== What's New in this Issue: ====
Focus: Integrating SQL Server & Office 2003 All the major Microsoft Office 2003 applications include tools that let you incorporate and use data from a SQL Server database. These instructions for importing data into Word, Access, and Excel will get you started. --Michael Otey http://lists.sqlmag.com/t?ctl=27C86:610454
Editorial: Riding the x64 Wave The x64 architecture is accelerating the move to 64-bit computing in the Windows Server space and database world. Both existing 32-bit executable programs and native 64-bit programs are benefiting with enhanced performance. --Michael Otey http://lists.sqlmag.com/t?ctl=27C7D:610454
PRODUCTS
Shrink-Wrapped DBAs Check out this comparative review of two hefty database-adminstration products, in which we examine how well Embarcadero Technologies' DBArtisan and Quest Software's Quest Central for SQL Server provide value to both experienced and less-skilled DBAs. --Michael K. Campbell http://lists.sqlmag.com/t?ctl=27C84:610454
Neverfail Definitely worth a look, Neverfail for SQL Server might be the high availability solution you've been seeking. --Michael Otey http://lists.sqlmag.com/t?ctl=27C81:610454
New Products Check out new and improved SQL Server-related products. --Blake Eno, beno@sqlmag.com http://lists.sqlmag.com/t?ctl=27C83:610454
5. ==== Announcements ====
Exclusive Spring Savings Subscribe to Windows IT Pro and SAVE 58%! Along with your 12 issues, you'll get FREE access to the entire Windows IT Pro online article archive, which houses more than 9,000 helpful articles. This is a limited-time offer, so order now: http://lists.sqlmag.com/t?ctl=27C87:610454
Save 44% off the Windows IT Security Newsletter For a limited time, order the Windows IT Security newsletter and SAVE up to $80! You'll get 12 helpful issues loaded with endless fundamentals on building and maintaining a secure enterprise, in-depth product coverage of the best security tools available, and expert advice on the best way to implement various security components. Subscribe now: http://lists.sqlmag.com/t?ctl=27C88:610454
6. Subscribers Only
* The following in-depth articles are included in the latest issue of SQL Server Magazine--available only to current subscribers. If you aren't already a subscriber, now is the time to sign up to gain access to the entire SQL Server Magazine article database (over 2500 articles)! Click below to subscribe and get access to the May issue! http://lists.sqlmag.com/t?ctl=27C8D:610454
DEVELOPMENT
SQL Injection: The Hacker's Gold Mine Learn what SQL injection is, how it happens, and how to protect your organization from it. --Dan Hurst http://lists.sqlmag.com/t?ctl=27C80:610454
T-SQL Black Belt: Custom Aggregations: The Pivoting Technique In this second part of a four-part series about custom aggregations, we look at a class of solutions that relies on pivoting techniques. --Itzik Ben-Gan http://lists.sqlmag.com/t?ctl=27C7E:610454
ADMINISTRATION
Inside SQL Server: Special Snapshots The database snapshot feature in SQL Server 2005 lets you query your databases and run system health reports without blocking end users. --Kalen Delaney http://lists.sqlmag.com/t?ctl=27C85:610454
Solutions by Design: Designing for Performance: NULL or NOT NULL? The useful NULL condition lets you represent unknown values in a database, but you might worry about its effect on database performance. Never fear: You can use NULL sensibly. --Michelle A. Poolet http://lists.sqlmag.com/t?ctl=27C7F:610454
BUSINESS INTELLIGENCE
Custom Data Processing Extensions for Reporting Services Good news: You no longer need to write the same code in multiple places in Reporting Services. You'll be pleased to see how easily you can use custom data processing extensions to share data sets across multiple reports. --Andrew Potter http://lists.sqlmag.com/t?ctl=27C7C:610454
DEPARTMENTS
SELECT TOP(X): Setting Up an Oracle Linked Server Access Oracle data from SQL Server using these basic steps. --Michael Otey http://lists.sqlmag.com/t?ctl=27C82:610454
==== Contact Us ====
About the newsletter--letters@sqlmag.com About technical questions--http://lists.sqlmag.com/t?ctl=27C91:610454 About product news--products@sqlmag.com About your subscription--sqlupdate@sqlmag.com About sponsoring SQL Server Magazine UPDATE--Richard Resnick, rresnick@sqlmag.com or Lisa Kling, lkling@sqlmag.com
SQL Server Magazine UPDATE is brought to you by SQL Server Magazine, the only magazine devoted to helping developers and DBAs master new and emerging SQL Server technologies and issues. Subscribe today. http://lists.sqlmag.com/t?ctl=27C8E:610454
Manage Your Account You are subscribed as news-and-stuff@arconati.us. To unsubscribe from this email newsletter, click here http://lists.sqlmag.com/u?id=28351AE7DCFB1F6C28A3C14B9A02459D
To manage your email account, simply log on to our Email Preference Center. http://lists.sqlmag.com/t?ctl=27C92:610454
View the SQL Server Magazine Privacy Policy. http://lists.sqlmag.com/t?ctl=27C8A:610454
SQL Server Magazine is a division of Penton Media, Inc., 221 East 29th Street, Loveland, CO 80538, Attention: Customer Service Department
Copyright 2006, Penton Media, Inc. All Rights Reserved.
No comments:
Post a Comment
Keep a civil tongue.