- Table View
- List View
Microsoft® SQL Server® 2012 Step by Step
by Patrick Leblanc<p>Teach yourself the programming fundamentals of SQL Server 2012—one step at a time. Ideal for beginning SQL Server database administrators and developers, this tutorial provides clear guidance and practical, learn-by-doing exercises for building database solutions that solve real-world business problems.</p>
Microsoft® SQL Server® 2012 T-SQL Fundamentals
by Itzik Ben-GanGain a solid understanding of T-SQL--and write better queries Master the fundamentals of Transact-SQL--and develop your own code for querying and modifying data in Microsoft® SQL Server® 2012. Led by a SQL Server expert, you'll learn the concepts behind T-SQL querying and programming, and then apply your knowledge with exercises in each chapter. Once you understand the logic behind T-SQL, you'll quickly learn how to write effective code--whether you're a programmer or database administrator. Discover how to: Work with programming practices unique to T-SQL Create database tables and define data integrity Query multiple tables using joins and subqueries Simplify code and improve maintainability with table expressions Implement insert, update, delete, and merge data modification strategies Tackle advanced techniques such as window functions, pivoting and grouping sets Control data consistency using isolation levels, and mitigate deadlocks and blocking Take T-SQL to the next level with programmable objects
Microsoft® SQL Server™ 2000 High Availability
by Allan Hirt Cathan Cook Frank Mcbath Kimberly TrippGet the definitive reference to maximizing the availability of your critical, SQL Server 2000-based business systems. Developed by Microsoft field consultants who create and support high availability solutions every day, this practical guide explains how to plan, design, implement, and support highly available SQL Server 2000-based systems for both 32-bit and 64-bit environments. You get in-depth, end-to-end guidance--from evaluating availability requirements and capacity planning to implementing failover clustering, log shipping, replication, system backup and restore, system recovery, and other technologies and processes. Real-world scenarios illustrate the book's best practices in action. You also get a CD featuring evaluation software, planning worksheets, scripts, and other on-the-job resources. Discover how to: Evaluate technical, staffing, and budget requirements Plan and configure disk subsystems for performance and availability Configure Microsoft Windows® 2000 Server or Microsoft Windows ServerTM 2003 to optimize SQL Server 2000 availability Plan, implement, and maintain a base server cluster and Network Load Balancing Plan and configure failover clustering Use built-in log shipping features or code your own Create comprehensive backup and restore plans Choose replication methods for high availability--and expose replication architecture Develop prevention and disaster recovery strategies; sample runbook and scripts included on CD Minimize downtime for server upgrades and service pack installations Baseline performance and use availability-monitoring tools and techniques CDs feature: 120-day evaluation version of SQL Server 2000 Enterprise Edition Scripts for custom log shipping, backup and restoration, system monitoring, and other administrative tasks Sample disaster-recovery runbook Worksheets, checklists, and templates Fully searchable eBook A Note Regarding the CD or DVD The print version of this book ships with a CD or DVD. For those customers purchasing one of the digital formats in which this book is available, we are pleased to offer the CD/DVD content as a free download via O'Reilly Media's Digital Distribution services. To download this content, please visit O'Reilly's web site, search for the title of this book to find its catalog page, and click on the link below the cover image (Examples, Companion Content, or Practice Files). Note that while we provide as much of the media content as we are able via free download, we are sometimes limited by licensing restrictions. Please direct any questions or concerns to booktech@oreilly.com.
Microsoft® SQL Server™ 2000 High Availability
by Microsoft CorporationEnsuring 24/7 database availability is crucial to your company's success. Discover the best ways to help keep your critical, Microsoft SQL Server 2000-based systems up and running and secure with this in-depth guide, straight from the source.
Microsoft® SQL Server™ 2000 Operations
by Microsoft CorporationDesigned for database administrators and system engineers, this guide provides real-world, task-based information and best practices for the day-to-day management of SQL Server 2000. It draws on the combined knowledge and experience of Microsoft Consulting Services (MCS), Microsoft's Internal Technical Support Group, and the SQL Server Developer Team--illustrating both the theory behind and the field-tested practices for improving database operations. Get specific instructions and recommendations for server monitoring, backup, verification of scheduled events, capacity planning, developer and end user support, and other key procedures--exploiting the lessons learned from real enterprise settings to improve team responsiveness and effectiveness and help avoid common errors. All PATTERNS & PRACTICES guides are--reviewed and approved by Microsoft engineering teams, consultants, partners, and customers--deliver accurate, real-world information that's technically validated and tested.
Microsoft® SQL Server™ 2005 Administrator's Companion
by Burzin Patel Edward Whalen Marcilina Garcia Stacia Misner Victor IsakovGet your mission-critical databases up and running quickly with this essential, single-volume guide. This comprehensive administrator's reference details features and capabilities of SQL Server 2005--including how to implement business intelligence applications. It delivers the easy-to-follow procedures, practical workarounds, and key troubleshooting tactics you need for on-the-job-results. Discover how to: Perform an installation or upgrade, and configure it on the network Plan and configure the I/O subsystem and model system capacity Create and maintain databases, tables, views, and indexes Administer transactions, deadlocks, and isolation levels Manage users with logins, user IDs, schemas, permissions, and roles Implement failover clustering, log shipping, and database mirroring for high availability Manage and tune snapshot, transactional, and merge replication Administer SQL Server Analysis Services and Reporting Services Monitor, troubleshoot, and fine-tune performance Includes a CD with a fully searchable eBook. A Note Regarding the CD or DVD The print version of this book ships with a CD or DVD. For those customers purchasing one of the digital formats in which this book is available, we are pleased to offer the CD/DVD content as a free download via O'Reilly Media's Digital Distribution services. To download this content, please visit O'Reilly's web site, search for the title of this book to find its catalog page, and click on the link below the cover image (Examples, Companion Content, or Practice Files). Note that while we provide as much of the media content as we are able via free download, we are sometimes limited by licensing restrictions. Please direct any questions or concerns to booktech@oreilly.com.
Microsoft® SQL Server™ 2005 Analysis Services Step by Step
by Hitachi Consulting<div xmlns="http://www.w3.org/1999/xhtml"><p>Your hands-on, practical guide to Microsoft SQL Server 2005 Analysis Services. Get started using Business Intelligence tools that simplify data analysis and with this popular, learn-by-doing tutorial.</p></div>
Microsoft® SQL Server™ 2005 Analysis Services Step by Step
by Stacia Misner Hitachi Consulting Reed JacobsenTeach yourself the fundamentals of SQL Server Analysis Services--one step at a time. With this practical, learn-by-doing tutorial, you get the guidance you need to build flexible and powerful solutions that meet the analytical needs of your organization. Discover how to: Start building cubes using the Microsoft Visual Studio 2005 Business Intelligence designers Create dimensions and measure groups to build, browse, and modify OLAP cubes Design objects to handle unique financial analysis requirements Improve query performance with aggregations and user hierarchies Customize cubes with multi-dimensional expressions (MDX) and other advanced design techniques Use actions to integrate Web pages, reporting applications, and drillthrough capabilities with cubes Manage role-based security and restrict data access Deploy and maintain a database in a production environment CD features All practice exercises and answer files Fully searchable eBook A Note Regarding the CD or DVD The print version of this book ships with a CD or DVD. For those customers purchasing one of the digital formats in which this book is available, we are pleased to offer the CD/DVD content as a free download via O'Reilly Media's Digital Distribution services. To download this content, please visit O'Reilly's web site, search for the title of this book to find its catalog page, and click on the link below the cover image (Examples, Companion Content, or Practice Files). Note that while we provide as much of the media content as we are able via free download, we are sometimes limited by licensing restrictions. Please direct any questions or concerns to booktech@oreilly.com.
Microsoft® SQL Server™ 2005 Integration Services Step by Step
by Hitachi Consulting Scott Cameron Paul Turley Satoshi Iizuka Pablo Guzman Joe KaspizakTeach yourself the fundamentals of SQL Server Integration Services--one step at a time. This practical, learn-by-doing tutorial delivers the guidance you need to transform and consolidate data--and build solutions that support your business intelligence needs. Discover how to: Design and execute packages that transform data between files and relational databases Configure connection managers to access other data sources Create data flows that alter, split, match, and merge data Develop event-handlers and monitor package performance Encrypt sensitive information and control access to packages Customize script code to automate Control Flow and Data Flow tasks Debug, troubleshoot, and optimize packages CD features: All practice exercises Sample databases Fully searchable eBook A Note Regarding the CD or DVD The print version of this book ships with a CD or DVD. For those customers purchasing one of the digital formats in which this book is available, we are pleased to offer the CD/DVD content as a free download via O'Reilly Media's Digital Distribution services. To download this content, please visit O'Reilly's web site, search for the title of this book to find its catalog page, and click on the link below the cover image (Examples, Companion Content, or Practice Files). Note that while we provide as much of the media content as we are able via free download, we are sometimes limited by licensing restrictions. Please direct any questions or concerns to booktech@oreilly.com.
Microsoft® SQL Server™ 2005 Reporting Services Step by Step
by Stacia Misner Hitachi ConsultingTeach yourself the fundamentals of SQL Server Reporting Services--one step at a time. With this practical, learn-by-doing tutorial, you get the guidance you need to build flexible and powerful solutions that support the reporting needs of your organization. Discover how to: Install and configure Reporting Services Author, manage, and access reports Create attractive, information-rich reports with the Report Designer Calculate values, organize information, and manipulate report data Build, deploy, and maintain a report model Render and distribute reports in various formats Implement role-based security to restrict access to information Explore more advanced report design techniques Programmatically customize any stage of the reporting lifecycle CD features all practice exercises. A Note Regarding the CD or DVD The print version of this book ships with a CD or DVD. For those customers purchasing one of the digital formats in which this book is available, we are pleased to offer the CD/DVD content as a free download via O'Reilly Media's Digital Distribution services. To download this content, please visit O'Reilly's web site, search for the title of this book to find its catalog page, and click on the link below the cover image (Examples, Companion Content, or Practice Files). Note that while we provide as much of the media content as we are able via free download, we are sometimes limited by licensing restrictions. Please direct any questions or concerns to booktech@oreilly.com.
Microsoft® SQL Server™ 2005 Reporting Services: Step by Step
by Hitachi Consulting<div xmlns="http://www.w3.org/1999/xhtml"><p>Your hands-on, practical guide to Microsoft SQL Server 2005 Reporting Services. Get started using Business Intelligence tools that simplify data analysis and reporting with this popular, learn-by-doing tutorial.</p></div>
Microsoft® SQL Server™ 2005: Database Essentials Step by Step
by Solid Quality LearningGet the guidance you need to start designing databases--one step at a time. With this practical tutorial, you'll teach yourself the core skills for building and managing databases with the next generation of SQL Server. Discover how to: Install and configure SQL Server 2005 Design database components with SQL Server Management Studio Apply a three-step modeling approach to design databases that meet business requirements Create, modify, and manage views Write user-defined functions and stored procedures using T-SQL Add, delete, and update information in your databases Work with data from custom applications and legacy systems Troubleshoot error messages and handle exceptions CD features: All practice exercises Code samples A Note Regarding the CD or DVD The print version of this book ships with a CD or DVD. For those customers purchasing one of the digital formats in which this book is available, we are pleased to offer the CD/DVD content as a free download via O'Reilly Media's Digital Distribution services. To download this content, please visit O'Reilly's web site, search for the title of this book to find its catalog page, and click on the link below the cover image (Examples, Companion Content, or Practice Files). Note that while we provide as much of the media content as we are able via free download, we are sometimes limited by licensing restrictions. Please direct any questions or concerns to booktech@oreilly.com.
Microsoft® SharePoint® 2010
by Bill English Brian Alderman Mark Ferrarz<p>Get comprehensive information to plan, deploy, administer, and support SharePoint 2010. With this ADMINISTRATOR'S COMPANION, you get mission-critical information from leading SharePoint experts and MVPs-in a single volume.</p>
Microsoft® SharePoint® 2010 Administrator's Pocket Consultant
by Ben CurryPortable and precise, this pocket-sized guide delivers ready answers for the day-to-day administration of SharePoint 2010. Featuring easy-to-scan tables, step-by-step instructions, and handy lists, this book offers the streamlined, straightforward information you need to solve problems and get the job done-whether at your desk or in the field! Topics include deployment, site configuration, enterprise content management, search and indexing, workflows, shared service providers, information management policies, scalability, availability, security, logging and processing analysis, and backup and recovery.
Microsoft® SharePoint® 2010 Developer Reference
by Paolo PialorsiBuild robust solutions for business collaboration--using SharePoint 2010 Sharpen your development skills with this practical reference to Microsoft SharePoint Foundation 2010 and Microsoft SharePoint Server 2010. Written by enterprise-development expert Paolo Pialorsi, this book shows you how to develop real-world business solutions, using techniques to extend and customize the SharePoint environment with Microsoft Visual Studio® 2010. Discover how to: Write robust code for SharePoint solutions using the Server Object Model Use the Client Object Model to build Microsoft Silverlight® and JavaScript applications for SharePoint Extend the UI to customize menus, ribbons, and controls for intranets, extranets, and Internet sites Query and manage items in SharePoint lists using the LINQ-to-SharePoint provider Develop custom workflows using Visual Studio 2010 or SharePoint Designer 2010 Delve into advanced solutions, such as connectable Web Parts and asynchronous programming Create security-enhanced code for SharePoint using sandboxed solutions Get code samples on the web For system requirements, see the Introduction.
Microsoft® SharePoint® 2010 Plain & Simple
by Chris Beckett Johnathan LightfootLearn the simplest ways to get things done with Microsoft® SharePoint® 2010! Here's WHAT You'll Learn Manage and share team information in one location Use project task lists to organize people and processes Create libraries for documents, media, slides, and more Work seamlessly with Microsoft Office Find content quickly with the Search Center Add SharePoint blogs, wikis, and personal sites Here's HOW You'll Learn It Jump in whenever you need answers Easy-to-follow STEPS and SCREENSHOTS show exactly what to do Handy TIPS teach new techniques and shortcuts Quick TRY THIS! exercises help apply what you learn right away
Microsoft® SharePoint® 2010: Business Connectivity Services
by Penelope Coventry Phill Duffy Brett LonsdalePut your organization's data to work with Business Connectivity Services in SharePoint 2010--and build valuable business solutions. Led by a team of SharePoint experts, you'll learn how to integrate data from several systems--such as sales, accounting, and inventory--and then search, display, combine, and modify the information using code and no-code SharePoint solutions. This hands-on guide is ideal for SharePoint project managers, business analysts, architects, and administrators. Create a central hub for your business data with SharePoint 2010 Access data from applications and databases using Business Connectivity Services Create external lists in SharePoint to display your business data Build dashboards to present charts and key performance indicators Use business information offline with Microsoft Office applications Create custom SharePoint applications to insert, modify, and delete business data Populate SharePoint user profiles with information from several sources Build Business Connectivity Service solutions in SharePoint Online
Microsoft® SharePoint® 2010: Creating and Implementing Real-World Projects
by Jennifer Mason Christian Buckley Brian T. Jackett Wes PrestonBuild effective solutions for real-world business scenarios--using out-of-the-box tools in Microsoft® SharePoint® Server, SharePoint Foundation, and Office 365. Each chapter in this hands-on book focuses on a single business project, using a standard approach to guide you through the solution-building process from start to finish. Apply your skills as a SharePoint power user or site administrator--and get started now. Tackle 10 common business problems with proven SharePoint solutions Set up a help desk solution to track service requests Build a modest project management system Design a scheduling system to manage resources Create a site to support geographically dispersed teams Implement a course registration system Build a learning center with training classes and resources Design a team blog platform to review content Create a process to coordinate RFP responses Set up a FAQ system to help users find answers quickly Implement a cost-effective contact management system
Microsoft® SharePoint® 2010: Customizing My Site
by Michael DoyleCustomize your implementation of My Site in Microsoft® SharePoint® 2010--and capture the enthusiasm for social networking in your organization. With this concise, practical guide, SharePoint expert Michael Doyle shows you how to modify key My Site features to meet specific business needs. You'll learn how to apply best practices, tackle hard-to-solve problems--and create a valuable sense of community for your employees. It's the ideal quick reference for IT and business professionals alike. Take charge of social networking opportunities with a custom My Site solution! Set up My Site user profiles with Active Directory® data Help users share ideas, documents, and personal information Create several My Site hosts to serve distinct audiences Establish unified profiles across multiple SharePoint farms Apply your company's look and feel with themes Determine a user content quota to avoid taxing your database Manage metadata to keep user tags consistent on each site Edit profile properties to personalize the Twitter widget
Microsoft® SharePoint® 2010: Deploying Cloud-Based Solutions
by Phil WicklundTake your Microsoft SharePoint solutions to the cloud--and gain scalability and high availability while helping to lower your operational costs. Led by a SharePoint expert, you'll learn hands-on how to customize and maintain SharePoint cloud solutions. You also get practical advice for migrating business solutions either to Microsoft SharePoint Online or to a private cloud, using your own data center. This is an ideal guide for IT professionals, architects, and decision makers. Extend the reach of your SharePoint solutions--in the cloud Evaluate the ROI for using a public, private, or hybrid cloud solution Build public cloud solutions on either a shared or dedicated server Use Microsoft Office 365 for email, messaging, document authoring, and more Customize SharePoint Online using sandboxed solutions and SharePoint Designer Control identity management and authentication with Windows PowerShell® Deploy SharePoint in a private cloud with Hyper-V® and Microsoft System Center Improve private cloud automation, availability, and data isolation with multi-tenancy
Microsoft® SharePoint® 2013 App Development
by Ted Pattison Scot Hillier<p>Take advantage of the most important new concept in Microsoft® SharePoint® 2013--the app. Led by two SharePoint experts, you’ll learn development techniques such as building app lists, creating event handlers, and the major classes in the object model that provide access to content stored in SharePoint.</p>
Microsoft® SharePoint® Designer 2010 Step by Step
by Penelope CoventryThe smart way to build applications with Microsoft® SharePoint® Designer 2010 -- one step at a time! Experience learning made easy -- and quickly teach yourself how to create SharePoint 2010 applications and workflows with Microsoft® SharePoint® Designer 2010. With Step by Step, you set the pace -- building and practicing the skills you need, just when you need them! Design solutions to meet your business scenario -- without code Customize lists, libraries, and SharePoint site pages Use Web Parts to display, edit, and modify list item data Access data from a variety of external sources Create workflows to automate business processes Use master pages and CSS to control how sites work Your Step by Step digital content includes: All the books practice files -- ready to download and put to work. Fully searchable online edition of this book -- with unlimited access on the Web. The print version of this book includes free digital content online. To download, please visit O'Reilly's web site, search for the title of this book to find its catalog page, and click on the link below the cover image (Examples, Companion Content, or Practice Files). Note that while we provide as much of the media content as we are able via free download, we are sometimes limited by licensing restrictions. Please direct any questions or concerns to booktech@oreilly.com.
Microsoft® SharePoint® Foundation 2010 Inside Out
by Penelope Coventry Errin O'Connor Johnathan Lightfoot Troy Lanphier Thomas Resing Michael DoyleConquer Microsoft SharePoint Foundation 2010--from the inside out! You're beyond the basics--so dive right in and really support collaboration. 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 SharePoint Foundation 2010--and challenge yourself to new levels of mastery! Build team sites with non-code solutions using SharePoint Designer 2010 Modify and share content with SharePoint lists and libraries--online and offline Implement governance policies to plan site structure and manage content Create Web Parts to customize and display SharePoint site content Interact with SharePoint content using Microsoft Office applications Generate reusable workflows and apply them to multiple SharePoint lists Use Business Connectivity Services to access your company's business intelligence Design custom SharePoint solutions using Microsoft .NET and Visual Studio®
Microsoft® SharePoint® Foundation 2010 Step by Step
by Penelope Coventry Olga M. LonderExperience learning made easy-and quickly teach yourself how to use Microsoft SharePoint Foundation to enable effective team collaboration. With Step By Step, you set the pace-building and practicing the skills you need, just when you need them!Build your own SharePoint site with easy-to-use templates Create lists and libraries to store information Add discussion boards, wikis, and blogs Set up Document and Meeting Workspaces for easy collaboration Share calendars, contacts, and data from Microsoft Office programs Customize your pages with Web Parts Your all-in-one learning experience includes: Files for building skills and practicing the book's lessons Plus other resources on the Web
Microsoft® SharePoint® Products and Technologies Administrator's Pocket Consultant
by Ben CurryGet fast answers for the day-to-day administration of Windows SharePoint Services 3.0 and Office SharePoint Server 2007. Zero in on core support and maintenance tasks using quick-reference tables, instructions, and lists. You'll get the precise information you need to get the job done--whether you're at your desk or in the field! Get fast facts to: Install and configure SharePoint Products and Technologies Create and administer SharePoint site collections Configure security and privacy settings Set up workflows and define information management policies Implement enterprise content management Configure an intranet portal with integrated search and indexing capabilities Monitor performance and troubleshoot system issues Back up and restore at the content level or system level