Microsoft SQL Server 2012 High-Performance T-SQL Using Window Functions
Go beyond traditional query approaches to express set calculations more efficiently
Delve into ordered set functions such as rank, distribution, and offset
Implement hypothetical set and inverse distribution functions in standard SQL
Use strategies for improving sequencing, paging, filtering, and pivoting
Increase query speed using partitioning, ordering, and coverage indexing
Apply new optimization iterators such as Window Spool
Handle common issues such as running totals, intervals, medians, and gaps
Apply powerful window functions in T-SQL and increase the performance and speed of your queries
Optimize your queries and obtain simple and elegant solutions to a variety of problems using window functions in Transact-SQL. Led by T-SQL expert Itzik Ben-Gan, you’ll learn how to apply calculations against sets of rows in a flexible, clear, and efficient manner. Ideal whether you’re a database administrator or developer, this practical guide demonstrates ways to use more than a dozen T-SQL querying solutions to address common business tasks. Download eBook Free »
Inside Windows Debugging: A Practical Guide to Debugging and Tracing Strategies in Windows
Go behind the scenes to examine how powerful Windows debuggers work
Catch bugs early in the development cycle with static and runtime analysis tools
Gain practical strategies to tackle the most common code defects
Apply expert tricks to handle user-mode and kernel-mode debugging tasks
Implement postmortem techniques such as JIT and dump debugging
Debug the concurrency and security aspects of your software
Use debuggers to analyze interactions between your code and the operating system
Analyze software behavior with Xperf and the Event Tracing for Windows (ETW) framework
Use Windows debuggers throughout the development cycle and build better software
Rethink your use of Windows debugging and tracing tools and learn how to make them a key part of test-driven software development. Led by a member of the Windows Fundamentals Team at Microsoft, you’ll apply expert debugging and tracing techniques and sharpen your C++ and C# code analysis skills through practical examples and common scenarios. Learn why experienced developers use debuggers in every step of the development process, and not just when bugs appear. Download eBook Free »
Publisher: Microsoft Press; Original edition (May 16, 2012)
Language: English
ISBN-10: 0735658994
ISBN-13: 978-0735658998
eBook Description:
Working with Microsoft Office 365: Running Your Small Business in the Cloud
Take control of your small business communication and increase your productivity with Microsoft Office 365 cloud services. Through extensive walkthroughs, easy-to-follow procedures, and real-world tips, you’ll learn how to implement Office 365 for professionals and small businesses without having to be an IT expert. You’ll also gain valuable knowledge on configuring, deploying, and maintaining Office 365 no matter which plan you choose.
Deploy and manage Office 365 cloud services quickly and easily
Improve your business image with a custom website and email domain name
Set up Office 365 on individual business PCs and simply migrate your email
Share lists, calendars, and contacts with Microsoft Outlook® and Exchange Online
Stay connected to your business almost anywhere through mobile devices
Optimize team collaboration and file sharing using Microsoft SharePoint® Online
Keep in touch with important contacts using instant messaging, conferencing, and video
Use Microsoft Lync® Online to chat in real-time, or augment phone calls with text
Take control of your small business communication and increase your productivity with Microsoft Office 365 cloud services. Through extensive walkthroughs, easy-to-follow procedures, and real-world tips, you’ll learn how to implement Office 365 for professionals and small businesses without having to be an IT expert. You’ll also gain valuable knowledge on configuring, deploying, and maintaining Office 365 no matter which plan you choose. Download eBook Free »
Arduino and Kinect Projects: Design, Build, Blow Their Minds
If you’ve done some Arduino tinkering and wondered how you could incorporate the Kinect or the other way around then this book is for you. The authors of Arduino and Kinect Projects: Design, Build, Blow Their Minds will show you how to create 10 amazing, creative projects, from simple to complex. You’ll also find out how to incorporate Processing in your project design a language very similar to the Arduino language.
The ten projects are carefully designed to build on your skills at every step. Starting with the Arduino and Kinect equivalent of “Hello, World,” the authors will take you through a diverse range of projects that showcase the huge range of possibilities that open up when Kinect and Arduino are combined.
If you’ve done some Arduino tinkering and wondered how you could incorporate the Kinect or the other way around then this book is for you. The authors of Arduino and Kinect Projects: Design, Build, Blow Their Minds will show you how to create 10 amazing, creative projects, from simple to complex. You’ll also find out how to incorporate Processing in your project design a language very similar to the Arduino language. Download eBook Free »
Ubuntu Unleashed 2012 Edition: Covering 11.10 and 12.04, 7th Edition
Ubuntu Unleashed 2012 Edition: Covering 11.10 and 12.04, 7th Edition is filled with unique and advanced information for everyone who wants to make the most of the Ubuntu Linux operating system. This new edition has been thoroughly revised and updated by a long-time Ubuntu community leader to reflect the exciting new Ubuntu 11.10 (“Oneiric Ocelot”) and the forthcoming Ubuntu 12.04.
Ubuntu Unleashed 2012 Edition: Covering 11.10 and 12.04, 7th Edition is filled with unique and advanced information for everyone who wants to make the most of the Ubuntu Linux operating system. This new edition has been thoroughly revised and updated by a long-time Ubuntu community leader to reflect the exciting new Ubuntu 11.10 (“Oneiric Ocelot”) and the forthcoming Ubuntu 12.04.
Helmke presents up-to-the-minute introductions to Ubuntu’s key productivity and Web development tools, programming languages, hardware support, and more. You’ll find brand-new coverage of the new Unity desktop, new NoSQL database support and Android mobile development tools, and many other Ubuntu 11.10/12.04 innovations. Whether you’re new to Ubuntu or already a power user, you’ll turn to this book constantly: for new techniques, new solutions, and new ways to do even more with Ubuntu! Download eBook Free »
Sams Teach Yourself Microsoft Dynamics CRM 2011 in 24 Hours
In just 24 sessions of one hour or less, you’ll learn how to drive powerful business results with Microsoft Dynamics CRM 2011! Using this book’s straightforward, step-by-step approach, you’ll learn how to orchestrate successful CRM projects, automate processes, create more efficient workflows, optimize sales and marketing campaigns, and integrate with your other systems to do even more. One step at a time, you’ll master new features ranging from the new Ribbon interface to SharePoint integration. Each lesson builds on what you’ve already learned, helping you get the job done fast-and get it done right!
Now, there’s a practical, hands-on guide to mastering customer relationship management with Microsoft Dynamics CRM 2011. Authored by top CRM expert and blogger Anne Stanton (“The CRM Lady”), this book explains how the core Dynamics CRM 2011 fits in today’s organizations, and explains everything users and managers need to make the most of it. Stanton begins with the absolute basics, including Microsoft Dynamics CRM’s uses, components, and functionality; business roadmaps; and infrastructure choices. Then, step-by-step, you learn how to orchestrate successful CRM projects; automate processes; create and manage business units and users; define security roles; import contacts; distribute leads; create and track marketing campaigns; convert leads to accounts and contacts; integrate with email, Excel, and other applications; and create workflows. Download eBook Free »
The iOS 5 Developer’s Cookbook: Core Concepts and Essential Recipes for iOS Programmers, Third Editionis packed with ready-made code solutions for the iOS 5 development challenges you’re most likely to face, eliminating trial-and-error and helping you build reliable apps from the very beginning. Sadun teaches each new concept and technique through robust code that is easy to reuse and extend. This isn’t just cut-and-paste: Using her examples, Sadun fully explains both the “how” and “why” of effective iOS 5 development.
In this book, bestselling author and iOS development guru Erica Sadun brings together all the information you need to quickly start building successful iOS apps for iPhone, iPad, and iPod touch. Sadun has thoroughly revised this book to focus on powerful new iOS 5 features, the latest version of Objective-C, and the Xcode 4 development tools.
The iOS 5 Developer’s Cookbook: Core Concepts and Essential Recipes for iOS Programmers, 3rd Editionis packed with ready-made code solutions for the iOS 5 development challenges you’re most likely to face, eliminating trial-and-error and helping you build reliable apps from the very beginning. Sadun teaches each new concept and technique through robust code that is easy to reuse and extend. This isn’t just cut-and-paste: Using her examples, Sadun fully explains both the “how” and “why” of effective iOS 5 development. Download eBook Free »
Data Structures and Algorithms in Java, 5th Edition
Now revised to reflect the innovations of Java 5.0, Goodrich and Tamassia’s Fifth Edition of Data Structures and Algo-rithms in Java 5.0 continues to offer accessible coverage of fundamental data structures, using a consistent object-oriented framework. The authors provide intuition, description, and analysis of fundamental data structures and algorithms. Numerous illustrations, web-based animations, and simplified mathematical analyses justify important analytical concepts.
Additional Figures: Topics and their mathematical analysis are presented as visually as possible without sacrificing the rigor or content.
Increased and Updated Examples: Student-motivating topics such as Internet, Biology, Medicine, Science and Engineering, Business and Finance, Sports, Entertainment and Community Service are used as examples to draw students into the material.
Additional Exercises: The existing exercises have been throughly updated and new exercises added to this edition.
New Powerpoint Slides: Updated Powerpoint slides are provided to instructors free upon adoption.
Now revised to reflect the innovations of Java 5.0, Goodrich and Tamassia’s Fifth Edition of Data Structures and Algo-rithms in Java 5.0 continues to offer accessible coverage of fundamental data structures, using a consistent object-oriented framework. The authors provide intuition, description, and analysis of fundamental data structures and algorithms. Numerous illustrations, web-based animations, and simplified mathematical analyses justify important analytical concepts. Download eBook Free »