The latest techniques for securing wireless networks using the proven Hacking Exposed methodology
Filled with tactical security information, Hacking Exposed Wireless, Second Edition sheds light on how hackers zero in on susceptible networks and peripherals, gain access, and execute debilitating attacks. The book includes vital details on new, previously unpublished attacks alongside real-world, proven countermeasures. Seven new chapters discuss in depth how to conduct an assessment from start to finish, secure Bluetooth networks, write custom wireless security tools, and ensure compliance with the latest wireless laws and regulations.
Hacking Exposed Wireless, Second Edition features:
Thorough updates for the latest wireless threats and techniques
Information on wireless laws and regulations including how to meet PCI wireless security requirements
Content written by world-renowned wireless security experts
Global examples throughout
About the Author
Vincent Liu, CISSP, is the Managing Director at Stach & Liu, a security consulting firm providing IT security services to the Fortune 500 and global financial institutions as well as U.S. and foreign governments. Before founding Stach & Liu, Vincent led the Attack & Penetration and Reverse Engineering teams for the Global Security unit at Honeywell International. Prior to that, he was a consultant with the Ernst & Young Advanced Security Centers and an analyst at the National Security Agency. In these roles, he gained extensive experience conducting risk assessments, performing application code reviews, and supporting incident response situations. Vincent is a contributor for the Metasploit Project and a respected member of the security community. He is an experienced speaker and has presented his research at conferences including BlackHat, ToorCon, and Microsoft BlueHat.
Vincent has been published in interviews, journals, and books with highlights including: Penetration Tester’s Open Source Toolkit; Writing Security Tools and Exploits; Sockets, Shellcode, Porting, and Coding; and Hacking Exposed: Wireless. Most recently, he led the technical editing of the critically-acclaimed Ajax Security, published by Addison-Wesley.
Vincent holds a Bachelor of Science and Engineering from the University of Pennsylvania with a major in Computer Science and Engineering and a minor in Psychology. Johnny Cache received his Masters in Computer Science from the Naval Postgraduate School in 2006. His thesis work, which focused on fingerprinting 802.11 device drivers, won the Gary Kildall award for the most innovative computer science thesis. Johnny wrote his first program on a Tandy 128K color computer sometime in 1988. Since then he has spoken at several security conferences including BlackHat, BlueHat, and ToorCon. He has also released a number of papers related to 802.11 security, and is the author of many wireless tools. Most of his wireless utilities are included in the Airbase suite, available at 802.11mercenary.net.
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:
Authoritative content written by a senior technology specialist at Microsoft who has presented to thousands of users and developers on Microsoft’s BI technologies
A foreword by Thierry D’Hers, Business Intelligence Group Program Manager at Microsoft
Real-world exercises that enable you to build practical solutions for your own business problems
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
Is co-written by a data platform technical specialist at Microsoft, UK who works daily with large customers integrating SQL Server into Oracle
Teaches dual skills using real-world examples based on authors’ vast experience
Quickly explains how to perform everyday database admin tasks on SQL Server
Focuses on making both platforms work together successfully
Includes step-by-step labs and interviews with members of the Oracle DBA community
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:
Query: Introduction and description of query and its use
Syntax: Complete syntax
Result: Screen shot showing the data returned from the SQL Server relational database by the query
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
Includes 300+ ready-to-use, easily customizable SQL queries, all available for download
Features a practical, hands-on approach with a minimum of difficult concepts and theory
Explains how to visualize actionable BI
Helps to dramatically improve analysis and decision-making skills
Complete coverage of SQL queries
Select – single table
Where; Order By
Select – multiple tables
Aggregates; Select – new tables
Except/Intersect/Union
Group By
System functions
Subqueries
Delete/Insert/Update
Views/User-defined functions
Stored procedures/Programming
DDL (data definition language)/DCL
Microsoft SQL Server 2008 R2 Analytics & Data Visualization
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
Understand 3-D visualization techniques that can be used in reporting, analysis, and measurement.
Examples of the newest ‘Dundas’ BI tools for 3-D data visualization
Easily explore data relationships with a friendly front-end to statistical algorithms
Examples that can be used by BI Architects and connected to every desktop
Hands-On Microsoft SQL Server 2008 Integration Services
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:
Details on installation, control flow, data flow transformations, administration, security, and troubleshooting
Two new chapters on extending SSIS through scripting/programming and standard methods for developing a data warehouse architecture
New advanced examples throughout each chapter
Hands-on exercises that are broken down into objectives, solution methodologies, numbered steps, and review for reinforcing techniques
A focus on real-world data warehousing solutions that can be easily applied to your own business challenges
Comprehensive coverage of SSIS:
Introducing SSIS
Import and Export Wizard
SSIS Workflow Nuts and Bolts
Control Flow Containers
Control Flow Tasks
Administration
Securing Packages
Advanced Features
Data Flow Components
Data Flow Transformations
Deploying Packages
Migrating
Troubleshooting and Performance Enhancements
Extending SSIS
Star Schema Data Warehouse Architecture
Practical DMX Queries for Microsoft SQL Server Analysis Services 2008
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:
Query: Introduction and description of query and its use
Syntax: Complete syntax
Result: Screen shot showing the data returned from the Analysis Services data mining model by the query
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:
Includes 240+ ready-to-use, easily customizable DMX queries, all available for download
Features a practical, hands-on approach with a minimum of difficult concepts and theory
Explains how to visualize actionable BI
Shows how to surface knowledge discovery and make informed predictions quickly
Helps to dramatically improve analysis and decision-making skills
Complete coverage of DMX queries
Cases Queries
Content Queries
Prediction Queries with Decision Trees
Prediction Queries with Time Series
Prediction and Cluster Queries with Clustering
Prediction Queries with Association and Sequence Clustering
DDL (data definition language) Queries
Schema and Column Queries
Practical MDX Queries: For Microsoft SQL Server Analysis Services 2008
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:
Query Overview: Introduction and description of query and its use
Syntax: Complete syntax
Result: Illustrates the data returned from the Analysis Services cube by the query
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
Practical and hands-on with a minimum of difficult concepts and theory
Over 300 MDX queries – all downloadable from www.mhprofessional.com
Clear and simple layout
Refer to any query within the book and become immediately productive
Learn how to visualize actionable Business Intelligence
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.
Configure Windows Failover Clustering
Set up the Microsoft Distributed Transaction Coordinator on a two node failover cluster
Install SQL Server 2008 on your cluster
Handle cluster management and backup
Configure and manage database mirroring for high availability
Implement Hyper-V virtualization and Live Migration
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:
The new Transparent Data Encryption, Extended Events, filtered indexes, and auditing features
The new Resource Governor, policy-based management framework, T-SQL IntelliSense and debugging, and PowerShell integration
Availability enhancements-Failover Clustering, Database Mirroring, peer-to-peer replication, backup compression, and the new table lock escalation
The new ADO.NET Entity Framework
LINQ (Language Integrated Query)
The new native DATE, TIME, FILESTREAM, and Geospatial data types
T-SQL enhancements, such as the new DECLARE, MERGE, and GROUPING SETS statements
The more powerful BI toolset, including Integration Services Data Profiling, Analysis Services new Cube Designer, and Reporting Services new tablix controls
Improved Microsoft Office integration capabilities
Delivering Business Intelligence with Microsoft SQL Server 2008
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
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.
Install, configure, and customize SQL Server 2008 Reporting Services
Create SELECT queries to extract data
Generate reports from the Report Wizard and from scratch
Add charts, images, and gauges
Build reusable report templates
Use the new Tablix data format to create reports with any structure
Export reports to Word, Excel, PDF, HTML, XML, and other formats
Enable end-user access to reports via the Report Server and its Report Manager web interface
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.
Set up, configure, and maintain SQL Server 2008
Build and manage database objects using Transact-SQL statements
Create stored procedures and user-defined functions
Optimize database performance, availability, and reliability
Implement solid security using authentication, encryption, and authorization
Automate tasks using SQL Server Agent
Create reliable data backups and perform flawless system restores
Use all-new SQL Server 2008 Business Intelligence, development, and administration tools
Learn in detail the SQL Server XML technology (SQLXML)
Implement an effective security metrics project or program
IT Security Metrics: A Practical Framework for Measuring Security & Protecting Data proposes new ways of examining security activities that focus on observation, measurement, and a more structured way of looking at security problems. These methods encourage empirical inquiry and scientific analysis over subjective judgment and opinion when driving security decision-making. The book offers concrete strategies for putting a variety of research tools and metrics into active use on everyday projects.
This definitive guide first describes the history and theory behind empirical analysis and scientific methods, and shows how traditional security practices often do not stand up to rigorous standards of research and analysis. The book then presents new security methods that improve decisions, increase security, and save time and money. The book advises how to choose effective methods and metrics for security projects and provide better information to security stakeholders, reducing uncertainty about the effectiveness of their programs.
Define security metrics as a manageable amount of usable data
Design effective security metrics
Understand quantitative and qualitative data, data sources, and collection and normalization methods
Implement a programmatic approach to security using the Security Process Management Framework.
Analyze security metrics data using quantitative and qualitative methods
Design a security measurement project for operational analysis of security metrics
Measure security operations, compliance, cost and value, and people, organizations, and culture
Manage groups of security measurement projects using the Security Improvement Program
Apply organizational learning methods to security metrics
Endorsement
“Disperses myths while illuminating truths, pointing towards better ways for IT to conceptualize, implement, and articulate the value proposition of security activities and investments….Clearly grounded in foundational concepts of risk management, decision support, and basic economics….Abounds with practical examples, anecdotes, metaphors, crisp descriptions of difficult concepts, comparisons with other industries, and a just plain entertaining writing style that won’t strain your attention span….The relevance, information density, and readability of this book is top-notch….I strongly recommend it to anyone who is passionate and serious about protecting digital assets with better precision and effectiveness.”
–Joel Scambray, Co-Author, Hacking Exposed, and CEO of Consciere
About the Author
Lance Hayden, Ph.D. (Austin, TX) works for Cisco Systems, developing and managing security consulting services and contributing to new security product initiatives. He previously worked for the CIA where he conducted sensitive intelligence operations on behalf of the U.S. government. Lance has spoken at technology and security conferences such as RSA, FIRST, ToorCon, and Cisco Live.
New in the bestselling QuickSteps series, this full-color guide is the fastest, easiest way to get up and running on the latest release of Microsoft’s powerful database application for home and professional users.
Using lots of full-color graphics while keeping text to a minimum, Microsoft Office Access 14 QuickSteps makes it easy for readers to learn how to use Microsoft’s powerful database program. Readers can easily find exactly the answers they are looking for without having to read the whole book. The essential features of the program are covered, including the Ribbon interface and enhanced collaborative features, and the book shows how to make the most of Access’s improved interoperability with other applications. Readers will learn how to create great-looking reports that incorporate charts, graphics, and other material from programs in the Office suite. Timesaving, troubleshooting, and analysis techniques are also included.
Features
The book combines simplified tutorials with ready reference materials, making it like a recipe book for Access users
Expository text is kept to a minimum so readers can focus on learning just the steps they need to know to accomplish their goals
Full-color graphics and headings throughout keep the materials lively and visually interesting for the reader
Graphical icons guide readers to useful tips and reminders, bonus information related to the topic being covered, and warnings about common errors and pitfalls
The oversize, oblong trim makes it possible to show graphics and text side by side, and the book lies open so readers can follow along as they type
With its colorful graphics and easy-to-follow instructions, QuickSteps empowers any computer user to learn the key features of the new operating system
Sidebars provide valuable information above-and-beyond the task at hand without breaking the flow of the main text
High production values, loads of information, and an ultra-low price make this the best value on the market
Easy-to-follow coverage of Access 2010:
Creating a Database
Modifying Tables and Fields
Working in the Datasheet
Retrieving Information
Creating Forms and Using Controls
Working with Reports
Preparing Your Data for Presentation
Securing and Administering Access Extending Access
About the Author
John Cronan (Everett, WA) has worked with computers for more than 25 years and has written about them for more than a dozen years. In addition to authoring the present work, he has contributed to more than 25 other titles, including Microsoft Office Excel 2007 QuickSteps, Microsoft Office Access 2007 QuickSteps, eBay QuickSteps, Second Edition, and Build an eBay Business QuickSteps, Second Edition
Robin 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.
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.
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).