Server eBooks
Professional Microsoft SQL Server 2008 Programming
Master the increasingly complex feature set of the latest release of Microsoft SQL Server with the information in Professional Microsoft SQL Server 2008 Programming. Review the new features of SQL Server that will be of interest to you as an experienced developer and move on to more detailed, practical code examples. Learn how to write complex queries, build different types of data structures, improve application speed and performance, manage advanced scripting and errors, and design advanced databases the latest edition of this valuable programming guide. ...
Master the increasingly complex feature set of the latest release of Microsoft SQL Server with the information in Professional Microsoft SQL Server 2008 Programming. Review the new features of SQL Server that will be of interest to you as an experienced developer and move on to more detailed, practical code examples. Learn how to write complex queries, build different types of data structures, improve application speed and performance, manage advanced scripting and errors, and design advanced databases the latest edition of this valuable programming guide. ...
Beginning Microsoft SQL Server 2008 Programming
Starting simply and gradually progressing to increasingly advanced topics, this introduction to the SQL Server database focuses on what is distinctive about the SQL environment - SQL Server 2008, in particular - versus other programming environments. Author Robert Vieira draws on his experience as one of the leading authorities on Microsoft SQL Server and uses his unique tutorial approach to explain the significant changes to the fundamental core components of SQL Server 2008. You'll begin with an overview of database design concepts and learn how to implement these fundamental concepts with Microsoft SQL Server 2008. Then, you'll take a look at the role of an RDBMS and where it fits in the grand scheme of system development. ...
Starting simply and gradually progressing to increasingly advanced topics, this introduction to the SQL Server database focuses on what is distinctive about the SQL environment - SQL Server 2008, in particular - versus other programming environments. Author Robert Vieira draws on his experience as one of the leading authorities on Microsoft SQL Server and uses his unique tutorial approach to explain the significant changes to the fundamental core components of SQL Server 2008. You'll begin with an overview of database design concepts and learn how to implement these fundamental concepts with Microsoft SQL Server 2008. Then, you'll take a look at the role of an RDBMS and where it fits in the grand scheme of system development. ...
Windows Server 2008 Inside Out
Learn how to conquer Windows Server 2008 - from the inside out! Designed for system administrators, this definitive resource features hundreds of timesaving solutions, expert insights, troubleshooting tips, and workarounds for administering Windows Server 2008 - all in concise, fast-answer format. You will learn how to perform upgrades and migrations, automate deployments, implement security features, manage software updates and patches, administer users and accounts, manage Active Directory directory services, and more. With INSIDE OUT, you'll discover the best and fastest ways to perform core administrative tasks, with an award-winning format that makes it easy to find exactly the tips, troubleshooting solutions, and workarounds you need. With INSIDE OUT, you get all muscle and no fluff! ...
Learn how to conquer Windows Server 2008 - from the inside out! Designed for system administrators, this definitive resource features hundreds of timesaving solutions, expert insights, troubleshooting tips, and workarounds for administering Windows Server 2008 - all in concise, fast-answer format. You will learn how to perform upgrades and migrations, automate deployments, implement security features, manage software updates and patches, administer users and accounts, manage Active Directory directory services, and more. With INSIDE OUT, you'll discover the best and fastest ways to perform core administrative tasks, with an award-winning format that makes it easy to find exactly the tips, troubleshooting solutions, and workarounds you need. With INSIDE OUT, you get all muscle and no fluff! ...
Professional SQL Server 2005 Performance Tuning
Written by a team of expert SQL users, this comprehensive resource approaches performance tuning from a new perspective by showing you a methodical scientific approach to diagnose performance problems. In addition, the authors demonstrate how to make use of the key tools for SQL Server Performance tuning. Broken into four parts, the book first walks you through how to discover bottlenecks when something is wrong and how to monitor SQL Server to see whether there is a resource bottleneck. You'll then learn how to identify and remove the problems that are causing poor performance. ...
Written by a team of expert SQL users, this comprehensive resource approaches performance tuning from a new perspective by showing you a methodical scientific approach to diagnose performance problems. In addition, the authors demonstrate how to make use of the key tools for SQL Server Performance tuning. Broken into four parts, the book first walks you through how to discover bottlenecks when something is wrong and how to monitor SQL Server to see whether there is a resource bottleneck. You'll then learn how to identify and remove the problems that are causing poor performance. ...
The Book of IMAP
IMAP (the Internet Message Access Protocol) allows clients to access their email on a remote server whether from the office, a remote location, or a cell phone or other device. IMAP is powerful and flexible, but it's also complicated to set up; it's more difficult to implement than POP3 and more error-prone for both client and server. The Book of IMAP offers a detailed introduction to IMAP and POP3, the two protocols that govern all modern mail servers and clients. You'll learn how the protocols work as well as how to install, configure, and maintain the two most popular open source mail systems, Courier and Cyrus. ...
IMAP (the Internet Message Access Protocol) allows clients to access their email on a remote server whether from the office, a remote location, or a cell phone or other device. IMAP is powerful and flexible, but it's also complicated to set up; it's more difficult to implement than POP3 and more error-prone for both client and server. The Book of IMAP offers a detailed introduction to IMAP and POP3, the two protocols that govern all modern mail servers and clients. You'll learn how the protocols work as well as how to install, configure, and maintain the two most popular open source mail systems, Courier and Cyrus. ...
Pro Full-Text Search in SQL Server 2008
Businesses today want actionable insights into their data - they want their data to reveal itself to them in a natural and user-friendly form. What could be more natural than human language? Natural-language search is at the center of a storm of ever - increasing web-driven demand for human-computer communication and information access. SQL Server 2008 provides the tools to take advantage of the features of its built-in enterprise-level natural-language search engine in the form of integrated full-text search (iFTS). ...
Businesses today want actionable insights into their data - they want their data to reveal itself to them in a natural and user-friendly form. What could be more natural than human language? Natural-language search is at the center of a storm of ever - increasing web-driven demand for human-computer communication and information access. SQL Server 2008 provides the tools to take advantage of the features of its built-in enterprise-level natural-language search engine in the form of integrated full-text search (iFTS). ...
Pro Ubuntu Server Administration
Pro Ubuntu Server Administration teaches you advanced Ubuntu system building. After reading this book, you will be able to manage anything from simple file servers to multiple virtual servers to high - availability clusters. This is the capstone volume of the Apress Ubuntu trilogy that includes Beginning Ubuntu Linux, Third Edition and Beginning Ubuntu Server LTS Administration: From Novice to Professional, Second Edition. You will be able to make Ubuntu technology shine in a Fortune 500 environment and let Ubuntu server become the backbone of your infrastructure. ...
Pro Ubuntu Server Administration teaches you advanced Ubuntu system building. After reading this book, you will be able to manage anything from simple file servers to multiple virtual servers to high - availability clusters. This is the capstone volume of the Apress Ubuntu trilogy that includes Beginning Ubuntu Linux, Third Edition and Beginning Ubuntu Server LTS Administration: From Novice to Professional, Second Edition. You will be able to make Ubuntu technology shine in a Fortune 500 environment and let Ubuntu server become the backbone of your infrastructure. ...
A Developer's Guide to Data Modeling for SQL Server
Effective data modeling is essential to ensuring that your databases will perform well, scale well, and evolve to meet changing requirements. However, if you're modeling databases to run on Microsoft SQL Server 2008 or 2005, theoretical or platform-agnostic data modeling knowledge isn't enough: models that don't reflect SQL Server's unique real-world strengths and weaknesses often lead to disastrous performance. ...
Effective data modeling is essential to ensuring that your databases will perform well, scale well, and evolve to meet changing requirements. However, if you're modeling databases to run on Microsoft SQL Server 2008 or 2005, theoretical or platform-agnostic data modeling knowledge isn't enough: models that don't reflect SQL Server's unique real-world strengths and weaknesses often lead to disastrous performance. ...
Beginning T-SQL with Microsoft SQL Server 2005 and 2008
Transact-SQL, or T-SQL, is Microsoft Corporation's powerful implementation of the ANSI standard SQL database query language, which was designed to retrieve, manipulate, and add data to relational database management systems (RDBMS). You may already have a basic idea of what SQL is used for, but you may not have a good understanding of the concepts behind relational databases and the purpose of SQL. This book will help you build a solid foundation of understanding, beginning with core relational database concepts and continuing to reinforce those concepts with real-world T-SQL query applications. ...
Transact-SQL, or T-SQL, is Microsoft Corporation's powerful implementation of the ANSI standard SQL database query language, which was designed to retrieve, manipulate, and add data to relational database management systems (RDBMS). You may already have a basic idea of what SQL is used for, but you may not have a good understanding of the concepts behind relational databases and the purpose of SQL. This book will help you build a solid foundation of understanding, beginning with core relational database concepts and continuing to reinforce those concepts with real-world T-SQL query applications. ...
Microsoft SQL Server 2008 Management and Administration
If you need to deploy, manage, or secure Microsoft SQL Server 2008, this is the complete, fast-paced, task-based reference you've been searching for. Authored by a world-class expert on SQL Server in the enterprise, this book goes far beyond the basics, taking on the complex tasks that DBAs need to make the most of Microsoft's flagship database platform. SQL Server MVP, Ross Mistry presents proven techniques for SQL Server 2008 installation, upgrades, backup/restore, data transfer, indexing, high availability, security, and much more. He draws on extensive testing in high-profile production environments to offer step-by-step solutions and powerful tips you won't find anywhere else. ...
If you need to deploy, manage, or secure Microsoft SQL Server 2008, this is the complete, fast-paced, task-based reference you've been searching for. Authored by a world-class expert on SQL Server in the enterprise, this book goes far beyond the basics, taking on the complex tasks that DBAs need to make the most of Microsoft's flagship database platform. SQL Server MVP, Ross Mistry presents proven techniques for SQL Server 2008 installation, upgrades, backup/restore, data transfer, indexing, high availability, security, and much more. He draws on extensive testing in high-profile production environments to offer step-by-step solutions and powerful tips you won't find anywhere else. ...
Windows Server 2008 Hyper-V Unleashed
Using the Hyper-V virtualization capabilities built into Windows Server 2008, organizations can slash costs for power, space, and maintenance, and dramatically improve IT flexibility at the same time. This is the first book to offer comprehensive, independent, real-world coverage of planning, designing, implementing, and supporting Windows Server 2008 Hyper-V virtualization environments. Authored by Rand Morimoto and Jeff Guillet–top consultants of Microsoft technologies with unsurpassed experience deploying Hyper-V in enterprise organizations - this book delivers start-to-finish guidance for every facet of your virtualization initiative. ...
Using the Hyper-V virtualization capabilities built into Windows Server 2008, organizations can slash costs for power, space, and maintenance, and dramatically improve IT flexibility at the same time. This is the first book to offer comprehensive, independent, real-world coverage of planning, designing, implementing, and supporting Windows Server 2008 Hyper-V virtualization environments. Authored by Rand Morimoto and Jeff Guillet–top consultants of Microsoft technologies with unsurpassed experience deploying Hyper-V in enterprise organizations - this book delivers start-to-finish guidance for every facet of your virtualization initiative. ...