May 18, 2012 |
3,361 views |

Book Description
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.
Discover how to:
- 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
Download Now »
May 18, 2012 |
3,510 views |

Book Description
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.
Discover how to:
- 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
Download Now »
May 18, 2012 |
1,942 views |

Book Description
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.
Discover how to:
- 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
Table of Contents
Chapter 1. Office 365: A Big Deal for Small Business
Chapter 2. Choosing an Office 365 Plan
Chapter 3. Signing Up for the Office 365 P1 Plan Download Now »
May 17, 2012 |
3,235 views |

Book Description
With this digital Early Release edition of Getting Started with Metro Apps, you get the entire book bundle in its earliest form – the author’s raw and unedited content – so you can take advantage of this content long before the book’s official release. You’ll also receive updates when significant changes are made, as well as the final ebook version.
Get a head start on creating “Metro”-style apps for the approaching release of Windows 8. If you’re new to .NET programming, this introductory guide will quickly get you up to speed on the tools you need to build user interfaces with Microsoft’s new design language, code-named Metro. Learn how to use WinRT and the preview version of the upcoming Visual Studio release, and get tips and tricks for having your app published in the Windows Store.
Windows 8 brings some dramatic changes to the way users interact with computers and devices, and the Metro design language plays a key role. Whether you’re an experienced .NET developer, or build apps with HTML and Javascript, this book gets you in on the ground floor.
Table of Contents
Chapter 1. Windows 8: A Quick Tour
Chapter 2. Getting Started
Chapter 3. Application Architecture
Download Now »
May 17, 2012 |
1,850 views |

Book Description
With this digital Early Release edition of HLSL and Pixel Shaders for XAML Developers, you get the entire book bundle in its earliest form – the author’s raw and unedited content – so you can take advantage of this content long before the book’s official release. You’ll also receive updates when significant changes are made, as well as the final ebook version.
Graphic Shaders are used throughout the game and movie industry to improve onscreen graphics. They are versatile, doing important tasks like making computer rendered aliens look realistic, providing the ripples on a background lake or growing fur on the latest Pixar monster. In the PC world, programmers are often delighted to find that shaders are nothing more than a miniature program that is optimized to run on the computers GPU. This happiness fades when they start exploring the strange programming model underlying shaders however. Because shaders are strung together in an unusual fashion and run on a massive parallel processer developers shouldn’t use their traditional OO or procedural approach to writing code. Writing effective shaders requires a mind shift regarding how to craft a useful algorithm. To top it off, shaders are written in a unfamiliar C-like language. In the Microsoft DirectX world the dominant language is High Level Shader Language or HLSL.
Table of Contents
Chapter 1. Shader 101
Chapter 2. Getting Started Download Now »
May 16, 2012 |
5,731 views |

Book Description
Appropriate for all basic-to-intermediate level courses in Visual C# 2010 programming.
Created by world-renowned programming instructors Paul and Harvey Deitel, Visual C# 2010 How to Program, Fourth Edition introduces all facets of the C# 2010 language hands-on, through hundreds of working programs. This book has been thoroughly updated to reflect the major innovations Microsoft has incorporated in Visual C# 2010 and .NET 4; all discussions and sample code have been carefully audited against the newest Visual C# language specification.
Students begin by getting comfortable with the C# Express 2010 IDE and basic Visual C# syntax. Next, they build their skills one step at a time, mastering control structures, classes, objects, methods, variables, arrays, and the core techniques of object-oriented programming. With this strong foundation in place, the Deitels introduce more sophisticated techniques, including searching, sorting, data structures, generics, and collections. Throughout, the authors show students how to make the most of Microsoft’s Visual Studio tools. A series of appendices provide essential programming reference material on topics ranging from number systems to the Visual Studio Debugger, UML 2 to Unicode and ASCII.
Table of Contents
Chapter 1. Introduction to Computers, the Internet and Visual C#
Chapter 2. Dive Into® Visual C# 2010 Express Download Now »