- Table View
- List View
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
Prepare for MCPD Exam 70-519--and help demonstrate your real-world mastery of web application design and development--with this official Microsoft® Exam Ref. Written for experienced, MCTS-certified professionals ready to advance their status--this guide focuses on the critical-thinking and decision-making acumen needed for success at the MCPD level. With concise, objective-by-objective reviews, strategic case scenarios, and "Thought Experiments", you get professional-level preparation for the professional-level exam. Optimize your exam-prep by focusing on the expertise needed to: Design the application architecture Choose the right server-side and client-side technologies Design the user experience Design data access and presentation Plan for security Choose a testing methodology Plan for scalability and reliability You also get an exam discount voucher--making this book an exceptional value and a great career investment.
Deliver a successful SharePoint solution to your organization Take control of the complex requirements for delivering a SharePoint 2013 solution to your organization. Led by a SharePoint MVP specializing in SharePoint service delivery, you'll learn proven methods to help you prepare for a smooth adoption and governance process throughout the enterprise. This guide is ideal for IT professionals, including service delivery managers, project and program managers, and business analysts. Discover how to: Align your SharePoint solution with organizational goals and business priorities Engage executive sponsors, stakeholders, and SharePoint champions Provide detailed plans and schedules for an effective, structured delivery Build a team with appropriate roles to match delivery requirements Prepare user adoption, training, and communication plans, with clear business rules and policies Plan ongoing platform governance, service releases, and solution maintenance Build effective customer service models and provide SharePoint support
Get the information you need to make good SharePoint design decisions Determine the best design for your SharePoint implementation by gaining a deeper understanding of how the platform works. Written by a team of SharePoint experts, this practical guide introduces the Microsoft SharePoint 2013 architecture, and walks you through design considerations for planning and building a custom SharePoint solution. It's ideal for IT professionals, whether or not you have experience with previous versions of SharePoint. Discover how to: Dive deeper into SharePoint 2013 architecture components Gather requirements for a solution that fits your needs Upgrade from Microsoft SharePoint 2010 to 2013 Design service applications for performance and redundancy Provide the right storage plan for a SharePoint farm Map authentication and authorization requirements to your solution Take steps necessary to design a secure implementation Plan your business continuity management strategy Validate your SharePoint architecture to ensure success
Conquer Microsoft Access 2013--from the inside out! You're beyond the basics, so dive right into Access 2013--and use your skills to create sophisticated database apps! This supremely organized reference packs hundreds of timesaving solutions, troubleshooting tips, and workarounds. It's all muscle and no fluff. Discover how the experts tackle Access 2013--and challenge yourself to new levels of mastery. Build an Access Services web app with Microsoft SharePoint Server Automate your Access web app with data macros Create tables in your Access web app using built-in templates Aggregate and display your web app data using totals queries Use the Autocomplete control to quickly search for related data Create a Summary view to consolidate and group information Display related data on your views with the Related Items control Package your web app for use by others in your organization Plus--download chapters on building desktop databases For Intermediate and Advanced Users and Database Designers
Conquer SharePoint 2013--from the inside out! You're beyond the basics, so dive right into SharePoint 2013--and really put your business collaboration platform to work! This supremely organized reference packs hundreds of timesaving solutions, troubleshooting techniques, and workarounds. It's all muscle and no fluff. Discover how the experts facilitate information sharing across the enterprise--and challenge yourself to new levels of mastery. Efficiently manage documents throughout the enterprise Build team sites and collaborate with Microsoft OneNote and SkyDrive Design workflows with SharePoint Designer and Microsoft Visio Produce e-forms using Microsoft InfoPath and Access Manage community sites using business social features Connect SharePoint to external data and business systems Create business intelligence dashboards and key performance indicators Customize and control Sharepoint enterprise search
Get the full-color, visual guide that makes learning Microsoft SharePoint 2013 plain and simple! Follow the book's easy steps and screenshots and clear, concise language to learn the simplest ways to get things done. Here's WHAT you'll learn: Create libraries for all kinds of media Share information in one location Organize people and processes Connect SharePoint to Microsoft Office with no fuss Find things fast with the Search Center Expand your community with social networking Here's HOW you'll learn it: Jump in wherever you need answers Follow easy STEPS and SCREENSHOTS to see exactly what to do Get handy TIPS for new techniques and shortcuts Use TRY THIS! exercises to apply what you learn right away
<p>Get the full-color, visual guide that makes learning Microsoft Office 2013 plain and simple! Follow the book’s easy steps and screenshots and clear, concise language to learn the simplest ways to get things done with Microsoft Word, Excel®, Outlook®, PowerPoint®, Access®, Publisher, and OneNote®.</p>
<p>Experience learning made easy—and quickly teach yourself how to manage, analyze, and present data with Excel 2013. With Step by Step, you set the pace—building and practicing the skills you need, just when you them! Includes downloadable practice files and companion eBook.</p>
The smart way to learn Microsoft Office Home and Student 2013--one step at a time! Experience learning made easy--and quickly teach yourself how to get more done with Microsoft Word, Excel, PowerPoint, and OneNote. With Step by Step, you set the pace--building and practicing the skills you need, just when you need them! Use Office anywhere with touch-enabled devices Save time and work more easily with templates Make professional-looking documents and presentations Build spreadsheets to calculate and visualize data Organize and share your best ideas with OneNote Work with friends using social media and the cloud
The smart way to learn Microsoft Office Professional 2013--one step at a time! Experience learning made easy--and quickly teach yourself how to get more done with Microsoft Word, PowerPoint, Excel, Outlook, OneNote, Access, and Publisher. With Step by Step, you set the pace--building and practicing the skills you need, just when you need them! Determine the best Office tool for specific tasks Use Office efficiently on touch-enabled devices Create attractive documents, publications, and presentations Manage your e-mail, calendar, meetings, and communications Put your business data to work with Excel and Access Organize and share your notes and ideas with OneNote
<p>Programming legend Charles Petzold is rewriting his classic Programming Windows—one of the most popular programming books of all time—to show developers how to use existing skills and tools to build Windows 8 apps.</p>
Build robust, scalable search solutions to fit the way your business works Deliver powerful search tools to your clients--using Microsoft FAST Search Server 2010 for SharePoint. Led by three search experts, you'll learn how to deliver advanced intranet search capabilities and build custom, search-driven applications for your business. Use your skills as a SharePoint architect or developer to configure and program this server for different search scenarios, based on real-world examples. Discover how to: Integrate FAST Search Server for SharePoint into your existing SharePoint architecture Use best practices to develop solutions specific to your business Enable users to search millions of SharePoint documents efficiently Master powerful indexing and data modification techniques Expand document processing capabilities to handle data more effectively Develop custom search applications and web parts Configure your server for current content volume, and plan for future expansion Manage search operations and monitor performance directly from SharePoint
Delve inside Windows architecture and internals--and see how core components work behind the scenes. Led by three renowned internals experts, this classic guide is fully updated for Windows 7 and Windows Server 2008 R2--and now presents its coverage in two volumes. As always, you get critical insider perspectives on how Windows operates. And through hands-on experiments, you'll experience its internal behavior firsthand--knowledge you can apply to improve application design, debugging, system performance, and support. In Part 1, you will:Understand how core system and management mechanisms work--including the object manager, synchronization, Wow64, Hyper-V, and the registry Examine the data structures and activities behind processes, threads, and jobs Go inside the Windows security model to see how it manages access, auditing, and authorization Explore the Windows networking stack from top to bottom--including APIs, BranchCache, protocol and NDIS drivers, and layered services Dig into internals hands-on using the kernel debugger, performance monitor, and other tools NOTE: Part 2 Available Fall 2012
Assess your readiness for MCTS Exam 70-680--and quickly identify where you need to focus and practice. This practical, streamlined guide walks you through each exam objective, providing "need to know" checklists, review questions, tips, and links to further study--all designed to help bolster your preparation. Reinforce your exam prep with a Rapid Review of these objectives: Installing, Upgrading, and Migrating to Windows 7 Deploying Windows 7 Configuring Hardware and Applications Configuring Network Connectivity Configuring Access to Resources Configuring Mobile Computing Monitoring and Maintaining Systems That Run Windows 7 Configuring Backup and Recovery Options
Assess your readiness for MCTS Exam 70-662--and quickly identify where you need to focus and practice. This practical, streamlined guide walks you through each exam objective, providing "need to know" checklists, review questions, tips, and links to further study--all designed to help bolster your preparation. Reinforce your exam prep with a Rapid Review of these objectives: Installing and Configuring Exchange Servers Configuring Exchange Recipients and Public Folders Configuring Client Access Configuring Message Transport Monitoring and Reporting Implementing High Availability and Recovery Configuring Message Compliance and Security Features This book is an ideal complement to the in-depth training of the Microsoft Press® Training Kit and other exam-prep resources for Exam 70-662.
Design and develop great solutions using SharePoint 2013 Develop your business collaboration solutions quickly and effectively with the rich set of tools, classes, libraries, and controls available in Microsoft SharePoint 2013. With this practical reference, enterprise-development expert Paolo Pialorsi shows you how to extend and customize the SharePoint environment--and helps you sharpen your development skills. Ideal for ASP.NET developers with Microsoft .NET and C# knowledge. Discover how to: Create custom SharePoint apps and publish them in the Office Store Orchestrate your workflows with the new Workflow Manager 1.0 Access and manage your SharePoint data with the REST APIs Federate SharePoint with Windows Azure Access Control Services Customize your SharePoint 2013 UI for a better user experience Gain a thorough understanding of authentication and authorization
W. E. B. Du Bois never felt so at home as when he was a student at the University of Berlin. But Du Bois was also American to his core, scarred but not crippled by the racial humiliations of his homeland. In Lines of Descent," Kwame Anthony Appiah traces the twin lineages of Du Bois' American experience and German apprenticeship, showing how they shaped the great African-American scholar's ideas of race and social identity. At Harvard, Du Bois studied with such luminaries as William James and George Santayana, scholars whose contributions were largely intellectual. But arriving in Berlin in 1892, Du Bois came under the tutelage of academics who were also public men. The economist Adolf Wagner had been an advisor to Otto von Bismarck. Heinrich von Treitschke, the historian, served in the Reichstag, and the economist Gustav von Schmoller was a member of the Prussian state council. These scholars united the rigorous study of history with political activism and represented a model of real-world engagement that would strongly influence Du Bois in the years to come. With its romantic notions of human brotherhood and self-realization, German culture held a potent allure for Du Bois. Germany, he said, was the first place white people had treated him as an equal. But the prevalence of anti-Semitism allowed Du Bois no illusions that the Kaiserreich" was free of racism. His challenge, says Appiah, was to take the best of German intellectual life without its parochialism--to steal the fire without getting burned.
<p>Your easy, colorful, SEE-HOW guide to Windows® 8 for tablets! You’ll learn the quickest ways to set up and use Windows 8 with easy-to-follow steps, screenshots, and concise, straightforward language that make learning plain and simple!</p>
You're beyond the basics, so dive right into optimizing Windows® 8--and really put your PC or tablet to work! This supremely organized reference packs hundreds of timesaving solutions, troubleshooting techniques, and workarounds. It's all muscle and no fluff. Discover how the experts keep their Windows 8 systems running smoothly--and challenge yourself to new levels of mastery. Master essential Windows 8 maintenance and security features Implement best practices to help prevent and combat viruses, malware, and identity theft Apply quick fixes to the most common problems using expert tips and step-by-step repair guides Use advanced troubleshooting techniques by understanding how Windows 8 works Develop a recovery plan to restore your system and data in the event of a disaster Know when to use power utilities for advanced performance, maintenance, and diagnostics
<p>This supremely organized reference is packed with hundreds of timesaving solutions, troubleshooting tips, and workarounds for Windows 8. Discover how the experts tackle Windows 8—and challenge yourself to new levels of mastery!</p>
<p>Learn the fundamentals of programming with HTML5—and begin building your first standards-based web pages from the ground up. If you have absolutely no previous experience, no problem—simply start here! This book introduces must-know concepts and getting-started techniques through easy-to-follow explanations, examples, and exercises.</p>
Portable and precise, this pocket-sized guide delivers ready answers for the day-to-day administration of SQL Server. Zero in on core support and maintenance tasks using quick-reference tables, instructions, and lists. You'll get the focused information you need to save time and get the job done--whether at your desk or in the field! Get fast facts to:Manage SQL Server services and clients Configure, manage, and tune servers Implement policy-based management Administer security and access Monitor server activity and tune performance Automate maintenance Perform backups and recovery
Dive deep inside the architecture of SQL Server 2012 Explore the core engine of Microsoft SQL Server 2012--and put that practical knowledge to work. Led by a team of SQL Server experts, you'll learn the skills you need to exploit key architectural features. Go behind the scenes to understand internal operations for creating, expanding, shrinking, and moving databases--whether you're a database developer, architect, or administrator. Discover how to: Dig into SQL Server 2012 architecture and configuration Use the right recovery model and control transaction logging Reduce query execution time through proper index design Track events, from triggers to the Extended Event Engine Examine internal structures with database console commands Transcend row-size limitations with special storage capabilities Choose the right transaction isolation level and concurrency model Take control over query plan caching and reuse
- Embossed Braille - Use Bookshare’s DAISY Text or BRF formats to generate embossed braille.