How to Do Everything MacBook

August 11, 2010


MacBook

How to Do Everything MacBook

Authors: Noelle, Robin
ISBN-13: 978-0-07-174253-5
ISBN-10: 0071742530
©2011 | 1st Edition | 352 pages , Softcover
Pub Date: September 2010
Price: US$ 24.99
Learn More

Easy-to-follow coverage of portable Macs, including the MacBook, MacBook Pro, and MacBook Air

How to Do Everything: MacBook strongly emphasizes the portability and other unique features of the laptop versions of the Mac, examining ports and jacks, discussing user accounts and privacy, managing multiple network connections, using MobileMe to stay synched, etc. It also explores the activities laptop users most often perform, such as productivity, entertainment, and communication.

Tasks and activities are broken down into simple-to-follow directions and highlighted with clear graphics to make everything easy to understand. Tips and tricks for getting the most out of the latest versions of the built-in software, including the new versions of iLife and iWork are also included. As a travel writer, the author understands the needs of mobile computer users. She covers battery management and power, connectivity, working online, using VoIP, and maintaining and troubleshooting the MacBook.

How to Do Everything: MacBook

  • Draws on author’s personal experience as a writer who travels, providing tips and tricks for getting the best out of the MacBook on the road
  • Contains accurate and up-to-date product information on latest versions of Mac OS X and iWork/iLife applications
  • Explains the differences between the MacBook, MacBook Pro and MacBook Air


About the Author

Robin Noelle is a professional writer who has more than 12 years’ experience in marketing and public relations, with an emphasis on technology. Her ability to translate highly technical information into layman’s terms led to Noelle facilitating interviews between product managers and editors from PC Magazine, CNET, and PC World. She has written travel guides for Avalon Travel.



Related Title

9780071639989      How to Do Everything Mac
9780071630245     How to Do Everything iPod, iPhone & iTunes
9780072263794    How to Do Everything iPad
Read the rest of this entry »



Microsoft SQL Server 2008

June 18, 2010


Microsoft SQL 2008 titles by McGraw-Hill Professional:



SQL Server 2008 R2

Building Integrated Business Intelligence Solutions with SQL Server 2008 R2 & Office 2010

Author: Janus, Philo
ISBN-13: 978-0-07-171673-4
ISBN-10: 0071716734
©2011 | 1st Edition | 512 pages , Softcover
Pub Date: December 2010
Price: US$ 49.99
Learn More

Create integrated business intelligence solutions using the newest releases of the Microsoft BI stack

Building Integrated Business Intelligence Solutions with SQL Server 2008 R2 & Office 2010 explains how to use the entire Microsoft BI stack–SQL Server 2008 R2, SharePoint 2010, and Office 2010 components, including Excel/Gemini–to create integrated, practical, business intelligence solutions. An overview of SQL Server Analysis Services sets the stage for broad coverage of Excel as a front end for “self-service analysis,” using SharePoint features for collaboration and workgroup BI, and leveraging Reporting Services for enterprise dashboards and reports. This practical guide focuses on building end-to-end BI solutions that solve real business data dilemmas.


Building Integrated Business Intelligence Solutions with SQL Server 2008 R2 & Office 2010 features:

  1. Authoritative content written by a senior technology specialist at Microsoft who has presented to thousands of users and developers on Microsoft’s BI technologies
  2. A foreword by Thierry D’Hers, Business Intelligence Group Program Manager at Microsoft
  3. Real-world exercises that enable you to build practical solutions for your own business problems
  4. Detailed illustrations depicting sophisticated reporting results
  5. Tips on visually representing data, creating KPI’s, and business metrics


Complete coverage of Microsoft business intelligence solutions:

  1. What Is Business Intelligence
  2. Collaboration Meets Business Intelligence
  3. Excel & Excel Services
  4. Analysis Services & Cubes
  5. Introducing PowerPivot
  6. Getting Data In
  7. Reporting Services
  8. SharePoint
  9. Charts & Graphs
  10. Mapping; Data Mining
  11. Scorecards & Dashboards
  12. Master Data Services
  13. Publishing and Administration






Microsoft SQL Server 2008

Author: Anderson Mark
ISBN-13: 978-0-07-170064-1
ISBN-10:
©2011 | 1st Edition | 512 pages , Softcover
Pub Date: November 2010
Price: US$ 50.00

An expert guide to working with SQL Server in a mixed-database environment

Microsoft SQL Server Administration for Oracle DBAs is the ideal resource for experienced Oracle database professionals looking to expand their knowledge and skill set into the Microsoft database platform. The book compares and contrasts the platform architectures and shows how to perform everyday database administrator tasks. Screenshots, script examples, and step-by-step labs are included in this practical guide.

This book is not designed to be a “SQL Server is better than Oracle” or vice versa. It will enable experienced Oracle database administrators to get up to speed on the Microsoft SQL Server platform by building on existing relational database skills. The authors’ combination of expertise in both technologies ensures technical accuracy and real-world experiences. Interviews with members of the Oracle DBA community are included in this practical guide.


Microsoft SQL Server Administration for Oracle DBAs

  1. Is co-written by a data platform technical specialist at Microsoft, UK who works daily with large customers integrating SQL Server into Oracle
  2. Teaches dual skills using real-world examples based on authors’ vast experience
  3. Quickly explains how to perform everyday database admin tasks on SQL Server
  4. Focuses on making both platforms work together successfully
  5. Includes step-by-step labs and interviews with members of the Oracle DBA community


Leverage your Oracle DBA skills on SQL Server

  1. SQL Server Architecture
  2. Installing and Configuring SQL Server
  3. Database Objects
  4. Security
  5. Data Access and Transaction Control
  6. Backup and Recovery
  7. Performance Tuning and Optimization
  8. High Availability and Disaster Recovery Options
  9. Scheduling, Automation and Alerting
  10. Data Movement
  11. Upgrading and Migrating to SQL Server






SQL Server 2008

Practical SQL Queries for SQL Server 2008

Author: Tennick, Art
ISBN-13: 978-0-07-174687-8
ISBN-10: 0071746870
©2011 | 1st Edition | 512 pages , Softcover
Status: November 2010
Price: US$ 50.00
Learn More

Extract real, actionable business intelligence by utilizing the power of SQL queries

Featuring 300 ready-to-use SQL queries Practical SQL Queries for SQL Server 2008 shows how to write SQL queries within Microsoft’s BI stack, but well over 90% of the SQL queries will work with relational databases from other vendors. This solutions-based guide contains more than 300 SQL queries that can be immediately applied across a wide variety of BI-related problems. It begins with fundamental principles and simple queries and rapidly progresses to complex and sophisticated queries. The book is structured as follows:

  1. Query: Introduction and description of query and its use
  2. Syntax: Complete syntax
  3. Result: Screen shot showing the data returned from the SQL Server relational database by the query
  4. Analysis: Analysis of the results and tips for customization

Specific emphasis is placed on writing SQL for use within Microsoft SQL Server Management Studio (SSMS) connecting to SQL Server – however, the techniques and queries can also be utilized across Reporting Services (SSRS), Integration Services (SSIS), Winforms and Webforms, and in a large variety of third-party front-ends.

Practical SQL Queries for SQL Server 2008

  1. Includes 300+ ready-to-use, easily customizable SQL queries, all available for download
  2. Features a practical, hands-on approach with a minimum of difficult concepts and theory
  3. Explains how to visualize actionable BI
  4. Helps to dramatically improve analysis and decision-making skills


Complete coverage of SQL queries

  1. Select – single table
  2. Where; Order By
  3. Select – multiple tables
  4. Aggregates; Select – new tables
  5. Except/Intersect/Union
  6. Group By
  7. System functions
  8. Subqueries
  9. Delete/Insert/Update
  10. Views/User-defined functions
  11. Stored procedures/Programming
  12. DDL (data definition language)/DCL





Microsoft SQL Server 2008

Microsoft SQL Server 2008 R2 Analytics & Data Visualization

Authors: Harts, Doug; Dugan, Jim; Almas, Tricia
ISBN-13: 978-0-07-160143-6
ISBN-10: 0071601430
©2010 | 1st Edition | 504 pages , Softcover
Pub Date: September 2010
Price: US$ 49.99
Learn More

A practical guide to the next-generation Business Intelligence tools available in SQL Server 2008

This book will help DBAs and business intelligence architects work with the latest 3-D visualization techniques that revolutionize data reporting, analysis, and measurement in SQL Server 2008. You will appreciate the complete end-to-end explanation of the real-time visual representation of metrics and trends.

Microsoft SQL Server 2008 Analytics and Data Visualization begins with an overview of how these new tools, acquired from Dundas, fit into the SQL Server 2008 BI stack. You will learn strategies for data mining and advanced analytics. The book explains the full range of cutting-edge data visualization tools, including several customizable charts, map solutions for geographic data, illustrative gauges, and detailed calendars. An eight-page full-color insert highlights dazzling examples of 3-D visuals that convey business metrics in innovative ways.


Benefit to the Customer

  1. Understand 3-D visualization techniques that can be used in reporting, analysis, and measurement.
  2. Examples of the newest ‘Dundas’ BI tools for 3-D data visualization
  3. Easily explore data relationships with a friendly front-end to statistical algorithms
  4. Examples that can be used by BI Architects and connected to every desktop








 Microsoft SQL Server 2008Hands-On Microsoft SQL Server 2008 Integration Services

Author: Nanda, Ashwani
ISBN-13: 978-0-07-173640-4
ISBN-10: 0071736409
©2011 | 2nd Edition | 608 pages , Softcover
Pub Date: September 2010
Price: US$ 59.99
Learn More


A practical guide to mastering Microsoft SQL Server 2008 Integration Services

Hands-On Microsoft SQL Server 2008 Integration Services makes learning SSIS easier through the use of extensive exercises structured around every component within the tool. The complex topics of embedding control flow tasks and containers in a data workflow and using data transformations in the data flow are covered with real-world examples and step-by-step methods.

Hands-On Microsoft SQL Server 2008 Integration Services features:

  1. Details on installation, control flow, data flow transformations, administration, security, and troubleshooting
  2. Two new chapters on extending SSIS through scripting/programming and standard methods for developing a data warehouse architecture
  3. New advanced examples throughout each chapter
  4. Hands-on exercises that are broken down into objectives, solution methodologies, numbered steps, and review for reinforcing techniques
  5. A focus on real-world data warehousing solutions that can be easily applied to your own business challenges


Comprehensive coverage of SSIS:

  1. Introducing SSIS
  2. Import and Export Wizard
  3. SSIS Workflow Nuts and Bolts
  4. Control Flow Containers
  5. Control Flow Tasks
  6. Administration
  7. Securing Packages
  8. Advanced Features
  9. Data Flow Components
  10. Data Flow Transformations
  11. Deploying Packages
  12. Migrating
  13. Troubleshooting and Performance Enhancements
  14. Extending SSIS
  15. Star Schema Data Warehouse Architecture






Microsoft SQL Server Analysis Services 2008

Practical DMX Queries for Microsoft SQL Server Analysis Services 2008

Author: Tennick, Art
ISBN-13: 978-0-07-174866-7
ISBN-10: 0071748660
©2011 | 1st Edition | 512 pages , Softcover
Pub Date: September 2010
Price: US$ 50.00
Learn More


Extract real, actionable business intelligence using DMX

Practical DMX Queries for SQL Server Analysis Services shows how to write DMX queries within Microsoft’s BI stack. This solutions-based guide contains more than 240 DMX queries that can be immediately applied across a wide variety of BI-related problems. It begins with fundamental principles and simple queries and rapidly progresses to complex and sophisticated queries. The book is structured as follows:

  1. Query: Introduction and description of query and its use
  2. Syntax: Complete syntax
  3. Result: Screen shot showing the data returned from the Analysis Services data mining model by the query
  4. Analysis: Analysis of the results and tips for customization

Specific emphasis is placed on writing DMX for use within Microsoft SQL Server Management Studio (SSMS) connected to Microsoft SQL Server Analysis Services (SSAS) – however, the techniques and queries can also be utilized across Reporting Services (SSRS), Integration Services (SSIS), WinForms and WebForms, and in a large variety of third-party front-ends.


Practical DMX Queries for SQL Server Analysis Services:

  1. Includes 240+ ready-to-use, easily customizable DMX queries, all available for download
  2. Features a practical, hands-on approach with a minimum of difficult concepts and theory
  3. Explains how to visualize actionable BI
  4. Shows how to surface knowledge discovery and make informed predictions quickly
  5. Helps to dramatically improve analysis and decision-making skills


Complete coverage of DMX queries

  1. Cases Queries
  2. Content Queries
  3. Prediction Queries with Decision Trees
  4. Prediction Queries with Time Series
  5. Prediction and Cluster Queries with Clustering
  6. Prediction Queries with Association and Sequence Clustering
  7. DDL (data definition language) Queries
  8. Schema and Column Queries





MDX Queries: For Microsoft SQL Server Analysis Services 2008

Practical MDX Queries: For Microsoft SQL Server Analysis Services 2008

Author: Tennick, Art
ISBN-13: 978-0-07-171336-8
ISBN-10: 0071713360
©2010 | 1st Edition | 304 pages , Softcover
Pub Date: May 2010
Price: US$ 49.99
Learn More

The Business Intelligence market continues to grow, despite the ongoing global recession. In fact, Gartner published (in June 2009) its annual analysis of the Business Intelligence market, citing that worldwide sales of Business Intelligence software grew 22% in 2008 (versus 13% year prior). Total revenue for the market came in at $8.8B. The BI category continues to be an area of focus and expansion for McGraw-Hill Professional.

MDX (Multi-Dimensional Expressions) is a standard language for extracting business intelligence from multi-dimensional cubes within data warehouses and is supported by multiple database vendors. This book is a guide to writing MDX queries within Microsoft’s Business Intelligence stack. The book’s approach is solutions-based, and hands-on, containing more than 300 MDX queries that can be immediately applied across a wide variety of Business Intelligence-related problems. It begins with fundamental principles and simple queries and rapidly progresses to complex and sophisticated queries. The book is structured as follows:

  1. Query Overview: Introduction and description of query and its use
  2. Syntax: Complete syntax
  3. Result: Illustrates the data returned from the Analysis Services cube by the query
  4. Analysis: Analysis of the results and tips for customization

Specific emphasis is placed on writing MDX for use within Microsoft SQL Server Analysis Services (SSAS)—however, the techniques and queries can also be utilized across Excel, Excel Services in Sharepoint, Reporting Services (SSRS), Integration Services (SSIS), Performance Point Server dashboards, Winforms and Webforms, and in a large variety of third-party front-ends.


Features

  1. Practical and hands-on with a minimum of difficult concepts and theory
  2. Over 300 MDX queries – all downloadable from www.mhprofessional.com
  3. Clear and simple layout
  4. Refer to any query within the book and become immediately productive
  5. Learn how to visualize actionable Business Intelligence
  6. Surface corporate KPIs (key-performance indicators) quickly
  7. The MDX queries can be used immediately in a corporate business intelligence environment and/or easily customized for a specific business need.
  8. Serves as both a comprehensive tutorial and a reference guide
  9. Dramatically improve analysis and decision-making skills





Microsoft SQL Server 2008

Microsoft SQL Server 2008 High Availability with Clustering & Database Mirroring

Authors: Otey, Michael
ISBN-13: 978-0-07-149813-5
ISBN-10: 0071498133
©2010 | 1st Edition | 304 pages , Softcover
Pub Date: December 2009
Price: US$ 39.99
Learn More

Create a Highly Available Microsoft SQL Server 2008 Environment

Written by the technical director for SQL Server Magazine, this expert guide shows you how to implement clustering and database mirroring in SQL Server 2008. Learn proven techniques for ensuring zero database loss, avoiding system downtime, and providing instant data backups. Filled with detailed instructions, Microsoft SQL Server 2008 High Availability with Clustering & Database Mirroring takes you from planning to management of a robust high availability solution.

  1. Configure Windows Failover Clustering
  2. Set up the Microsoft Distributed Transaction Coordinator on a two node failover cluster
  3. Install SQL Server 2008 on your cluster
  4. Handle cluster management and backup
  5. Configure and manage database mirroring for high availability
  6. Implement Hyper-V virtualization and Live Migration
  7. Manage a SQL Server virtual machine





Microsoft SQL Server 2008Microsoft SQL Server 2008 New Features

Authors: Otey, Michael
ISBN-13: 978-0-07-154640-9
ISBN-10: 0071546405
©2009 | 2nd Edition | 272 pages , Softcover
Status: December 2008
Price: US$ 39.99
Learn More

Maximize the New Capabilities of Microsoft SQL Server 2008

Take immediate advantage of all the innovative features and benefits available in SQL Server 2008 with help from this expert guide. Written by the technical director for SQL Server Magazine, this book offers a concise yet in-depth look at the new and improved enterprise data management capabilities, developer functions, Business Intelligence tools, and security enhancements of SQL Server 2008. This is the perfect resource for decision-makers, developers, and DBAs preparing for upgrades or migration. Get details on:

  1. The new Transparent Data Encryption, Extended Events, filtered indexes, and auditing features
  2. The new Resource Governor, policy-based management framework, T-SQL IntelliSense and debugging, and PowerShell integration
  3. Availability enhancements-Failover Clustering, Database Mirroring, peer-to-peer replication, backup compression, and the new table lock escalation
  4. The new ADO.NET Entity Framework
  5. LINQ (Language Integrated Query)
  6. The new native DATE, TIME, FILESTREAM, and Geospatial data types
  7. T-SQL enhancements, such as the new DECLARE, MERGE, and GROUPING SETS statements
  8. The more powerful BI toolset, including Integration Services Data Profiling, Analysis Services new Cube Designer, and Reporting Services new tablix controls
  9. Improved Microsoft Office integration capabilities






Business Intelligence with Microsoft SQL Server 2008

Delivering Business Intelligence with Microsoft SQL Server 2008

Authors: Larson, Brian
ISBN-13: 978-0-07-154944-8
ISBN-10: 0071549447
©2009 | 2nd Edition | 792 pages , Softcover
Pub Date:November 2008
Price: US$ 49.99
Learn More

Maximize the Business Intelligence Tools in Microsoft SQL Server 2008

Manage, analyze, and distribute enterprise data with help from this expert resource. Delivering Business Intelligence with Microsoft SQL Server 2008 covers the entire BI lifecycle and explains how to build robust data integration, reporting, and analysis solutions. Real-world examples illustrate all of the powerful BI capabilities of SQL Server 2008. This is your one-stop guide for transforming disparate data into actionable insight for users throughout your organization.

  • Understand the goals and benefits of business intelligence
  • Design and create relational data marts and OLAP cubes
  • Manage Analysis Services databases using BI Development Studio
  • Cleanse data and populate data marts with SQL Server Integration Services
  • Take advantage of the flexibility of the Unified Dimensional Model
  • Manipulate and analyze data using MDX scripts and queries
  • Use data mining to identify data patterns, correlations, and clustering
  • Develop and distribute interactive reports with SQL Server 2008 Reporting Services
  • Integrate business intelligence into enterprise applications using ADOMD.NET and the Report Viewer Control





Microsoft SQL Server 2008 Reporting Services

Microsoft SQL Server 2008 Reporting Services

Authors: Larson, Brian
ISBN-13: 978-0-07-154808-3
ISBN-10: 0071548084
©2009 | 3rd Edition | 866 pages , Softcover
Pub Date: August 2008
Price: US$ 49.99
Learn More

The Definitive Guide to Microsoft SQL Server 2008 Reporting Services

Create and deliver data-rich reports across the enterprise using this complete server-based reporting solution. Written by a member of the original Reporting Services development team, Microsoft SQL Server 2008 Reporting Services covers the entire report-building and distribution process, including data extraction, integration with desktop and Web applications, and end-user access. The book explains how to maximize all of the powerful features, including the new Tablix data format, as well as enhanced performance, scalability, and visualization capabilities.

  1. Install, configure, and customize SQL Server 2008 Reporting Services
  2. Create SELECT queries to extract data
  3. Generate reports from the Report Wizard and from scratch
  4. Add charts, images, and gauges
  5. Build reusable report templates
  6. Use the new Tablix data format to create reports with any structure
  7. Export reports to Word, Excel, PDF, HTML, XML, and other formats
  8. Enable end-user access to reports via the Report Server and its Report Manager web interface





MICROSOFT SQL SERVER 2008MICROSOFT SQL SERVER 2008 A BEGINNER’S GUIDE

Authors: Petkovic, Dusan
ISBN-13: 978-0-07-154638-6
ISBN-10: 0071546383
©2009 | 4th Edition | 709 pages , Softcover
Pub Date: July 2008
Price: US$ 39.99
Learn More



Get Started on Microsoft SQL Server 2008 in No Time

Learn to use all of the powerful features available in SQL Server 2008 quickly and easily. Microsoft SQL Server 2008: A Beginner’s Guide explains the fundamentals of each topic alongside examples and tutorials that walk you through real-world database tasks. Install SQL Server 2008, construct high-performance databases, use powerful Transact-SQL statements, create stored procedures and triggers, and execute simple and complex database queries. Performance tuning, Database Engine security, Business Intelligence, and XML are also covered.

  1. Set up, configure, and maintain SQL Server 2008
  2. Build and manage database objects using Transact-SQL statements
  3. Create stored procedures and user-defined functions
  4. Optimize database performance, availability, and reliability
  5. Implement solid security using authentication, encryption, and authorization
  6. Automate tasks using SQL Server Agent
  7. Create reliable data backups and perform flawless system restores
  8. Use all-new SQL Server 2008 Business Intelligence, development, and administration tools
  9. Learn in detail the SQL Server XML technology (SQLXML)

The Technical Author – Robin Nixon

April 7, 2010

  

Robin NixonRobin Nixon has worked with and written about computers since the early 1980s (his first computer was a Tandy TRS 80 Model 1 with a massive 4KB of RAM!). During this time he has written in excess of 500 articles for many of the U.K.’s top computer magazines.

Robin started his computing career in the Cheshire homes for disabled people, where he was responsible for setting up computer rooms in a number of residential homes, and for evaluating and tailoring hardware and software so that disabled people could use the new technology – sometimes by means of only a single switch operated by mouth or finger.

After writing articles for computer magazines about his work with disabled people, he eventually worked full time for one of the country’s main IT magazine publishers, where he held several roles including editorial, promotions, and cover disc editing.

With the dawn of the Internet in the 1990s, Robin branched out into developing websites. One of these presented the world’s first radio station licensed by the music copyright holders, and was featured in several news reports on TV and radio networks in the United Kingdom. In order to enable people to continue to surf while listening, Robin also developed the first known pop-up windows.

Robin lives on the southeast coast of England with his wife Julie, a trained nurse, and five children, where he also finds time to foster three disabled children, as well as working full time from home as a technical author.

 

Robin has contributed an article to “The Daily Tip” section on “IT World,” and Plug-In PHP is one of the featured books on the company’s web site. For a look at the article, please click HERE.

Read the rest of this entry »


Plug-In PHP: 100 Power Solutions

March 8, 2010

 

Plug-In PHP

Plug-In PHP: 100 Power Solutions

Authors: Nixon, Robin
ISBN-13: 978-0-07-166659-6
ISBN-10: 0071666591
©2010 | 1st Edition | 384 pages , Softcover
Pub Date: March 2010
Price: US$ 39.99

   

100 PHP power solutions in one handy guide

This practical resource contains 100 ready-to-run PHP plug-ins you can use to create dynamic Web content. The book begins by showing you how to install, configure, and use a powerful web development environment. Then, each chapter in Plug-In PHP offers complete, working examples for specific end results you can achieve right away. In this time-saving tool, all of the code is extensively documented along with tips for adapting it for your own requirements.

Get ready-made PHP plug-ins for:

  • Text processing
  • Image handling
  • Content management
  • Forms and user input
  • Internet integration
  • Chat and messaging
  • MySQL, sessions, and cookies
  • APIs, RSS, and XML
  • JavaScript and Ajax
  • Geo-location
  • Spelling and language translation
  • And much more

Download all of the book’s plug-ins at www.pluginphp.com

   

About the Author

Robin Nixon (UK) is a developer and freelance technical writer who has published more than 500 articles in magazines such as PC Plus, PCW, Web User, .net, PC Advisor, and PC Answers. He is the author of 3 computing books, including the upcoming Learning PHP, MySQL & JavaScript (O’Reilly).

Learn More