Server eBooks
Expert Performance Indexing in SQL Server, 2nd Edition
This book is a deep dive into perhaps the single-most important facet of good performance: indexes, and how to best use them. The book begins in the shallow waters with explanations of the types of indexes and how they are stored in databases. Moving deeper into the topic, and further into the book, you will look at the statistics that are accumulated both by indexes and on indexes. You'll better understand what indexes are doing in the database and what can be done to mitigate and improve their effect on performance. The final destination is a guided tour through a number of real life scenarios showing approaches you can take to investigate, mitigate, and improve the performance of your database. ...
This book is a deep dive into perhaps the single-most important facet of good performance: indexes, and how to best use them. The book begins in the shallow waters with explanations of the types of indexes and how they are stored in databases. Moving deeper into the topic, and further into the book, you will look at the statistics that are accumulated both by indexes and on indexes. You'll better understand what indexes are doing in the database and what can be done to mitigate and improve their effect on performance. The final destination is a guided tour through a number of real life scenarios showing approaches you can take to investigate, mitigate, and improve the performance of your database. ...
Pro Couchbase Server, 2nd Edition
This new edition is a hands-on guide for developers and administrators who want to use the power and flexibility of Couchbase Server 4.0 in their applications. The second edition extends coverage of N1QL, the SQL-like query language for Couchbase. It also brings coverage of multiple new features, including the new generation of client SDKs, security and LDAP integration, secondary indexes, and multi-dimensional scaling. Pro Couchbase Server covers everything you need to develop Couchbase solutions and deploy them in production. The NoSQL movement has fundamentally changed the database world in recent years. Influenced by the growing needs of web-scale applications, NoSQL databases such as Couchbase Server provide new approaches to scalability, reliability, and performance. Never have document databases been so powerful and performant. With the power and flexibility of Couchbase Server you can model your data however you want, and easily change the data mo ...
This new edition is a hands-on guide for developers and administrators who want to use the power and flexibility of Couchbase Server 4.0 in their applications. The second edition extends coverage of N1QL, the SQL-like query language for Couchbase. It also brings coverage of multiple new features, including the new generation of client SDKs, security and LDAP integration, secondary indexes, and multi-dimensional scaling. Pro Couchbase Server covers everything you need to develop Couchbase solutions and deploy them in production. The NoSQL movement has fundamentally changed the database world in recent years. Influenced by the growing needs of web-scale applications, NoSQL databases such as Couchbase Server provide new approaches to scalability, reliability, and performance. Never have document databases been so powerful and performant. With the power and flexibility of Couchbase Server you can model your data however you want, and easily change the data mo ...
SQL Server AlwaysOn Revealed
Get a fast start to using AlwaysOn, the SQL Server solution to high-availability and disaster recovery. Read this short, 150-page book that is adapted from Peter Carter's Pro SQL Server Administration to gain a solid and accurate understanding of how to implement systems requiring consistent and continuous uptime. Begin with an introduction to high-availability and disaster recovery concepts such as Recovery Point Objectives (RPOs), Recovery Time Objectives (RTO), availability levels, and the cost of downtime. Then move into detailed coverage of implementing and configuring the AlwaysOn feature set in order to meet the business objectives set by your organization. SQL Server AlwaysOn Revealed offers real-world advice on how to build and configure the most appropriate topology to meet the high-availability and disaster recovery requirements you are faced with. Content includes strong coverage on implementing clusters, on building AlwaysOn failover clustered in ...
Get a fast start to using AlwaysOn, the SQL Server solution to high-availability and disaster recovery. Read this short, 150-page book that is adapted from Peter Carter's Pro SQL Server Administration to gain a solid and accurate understanding of how to implement systems requiring consistent and continuous uptime. Begin with an introduction to high-availability and disaster recovery concepts such as Recovery Point Objectives (RPOs), Recovery Time Objectives (RTO), availability levels, and the cost of downtime. Then move into detailed coverage of implementing and configuring the AlwaysOn feature set in order to meet the business objectives set by your organization. SQL Server AlwaysOn Revealed offers real-world advice on how to build and configure the most appropriate topology to meet the high-availability and disaster recovery requirements you are faced with. Content includes strong coverage on implementing clusters, on building AlwaysOn failover clustered in ...
Ubuntu Server Essentials
Ubuntu is a Debian-based Linux operating system built on top of the Debian architecture. It is used to make operating systems for multiple platforms, including phones, desktops, TVs and mobiles. It has made some serious progress in the realms of efficiency and user friendliness. With evolving technology trends, demands on software have changed, with more and more skilled users. Over the past few years, services such as Facebook, Twitter, and push notifications on smartphones mean that users are used to being up to date with everything that happens all the time. With SignalR, the applications stay connected and will generate notifications when something happens either from the system or by other users. This provides new opportunities for the system administrators, to enter this new and exciting world of real-time application development. This is a concise and a cost-friendly guide, packed with up-to-date essentials on Ubuntu Server fundamentals. ...
Ubuntu is a Debian-based Linux operating system built on top of the Debian architecture. It is used to make operating systems for multiple platforms, including phones, desktops, TVs and mobiles. It has made some serious progress in the realms of efficiency and user friendliness. With evolving technology trends, demands on software have changed, with more and more skilled users. Over the past few years, services such as Facebook, Twitter, and push notifications on smartphones mean that users are used to being up to date with everything that happens all the time. With SignalR, the applications stay connected and will generate notifications when something happens either from the system or by other users. This provides new opportunities for the system administrators, to enter this new and exciting world of real-time application development. This is a concise and a cost-friendly guide, packed with up-to-date essentials on Ubuntu Server fundamentals. ...
Building Networks and Servers Using BeagleBone
Create your own video theatre and music jukebox using Beaglebone. Make your multimedia library available to all the devices on your network, without spending an excessive amount of money on computer components and software. You'll start off by installing the Debian operating system image onto your BeagleBone, and setting up the software required to serve up both audio and video files to any device on the network. Next, you'll move on to network monitoring software, and install traceroute, MTR (My traceroute), Nmap, and iptraf-ng, to monitor the traffic on your local network. Once the monitoring software is set up, you'll create a RAID array to store all your media files. You'll then go one step further, and set up live and recorded video streaming using a web-based application. Finally, you'll learn to add Wi-Fi connectivity to your multimedia server by setting up WAP on your BeagleBone system. ...
Create your own video theatre and music jukebox using Beaglebone. Make your multimedia library available to all the devices on your network, without spending an excessive amount of money on computer components and software. You'll start off by installing the Debian operating system image onto your BeagleBone, and setting up the software required to serve up both audio and video files to any device on the network. Next, you'll move on to network monitoring software, and install traceroute, MTR (My traceroute), Nmap, and iptraf-ng, to monitor the traffic on your local network. Once the monitoring software is set up, you'll create a RAID array to store all your media files. You'll then go one step further, and set up live and recorded video streaming using a web-based application. Finally, you'll learn to add Wi-Fi connectivity to your multimedia server by setting up WAP on your BeagleBone system. ...
Apache Solr Enterprise Search Server, 3rd Edition
Solr is a widely popular open source enterprise search server that delivers powerful search and faceted navigation features—features that are elusive with databases. Solr supports complex search criteria, faceting, result highlighting, query-completion, query spell-checking, relevancy tuning, geospatial searches, and much more. This book is a comprehensive resource for just about everything Solr has to offer, and it will take you from first exposure to development and deployment in no time. Even if you wish to use Solr 5, you should find the information to be just as applicable due to Solr's high regard for backward compatibility. The book includes some useful information specific to Solr 5. ...
Solr is a widely popular open source enterprise search server that delivers powerful search and faceted navigation features—features that are elusive with databases. Solr supports complex search criteria, faceting, result highlighting, query-completion, query spell-checking, relevancy tuning, geospatial searches, and much more. This book is a comprehensive resource for just about everything Solr has to offer, and it will take you from first exposure to development and deployment in no time. Even if you wish to use Solr 5, you should find the information to be just as applicable due to Solr's high regard for backward compatibility. The book includes some useful information specific to Solr 5. ...
Elastix Unified Communications Server Cookbook
Elastix brings together the most useful tools and features from the Unified Communications and Open Source worlds: IP-PBX, Chat, Call Center, Multisite, Video, and so on, in a modular way. Beginning with installation and gaining an in-depth understanding of the internal workings of Elastix, you will soon dive into the core features of Elastix and VoIP and Unified Communications to enable a full cost-effective Unified Communications server solution. You will explore the configuration of IP-BPX features, control call routes and destinations, and troubleshoot the unified communications software. Finish by going that extra mile and securing your server and implement advanced dialplan functions. Through this step-by-step guide you will get to grips with VoIP and Unified Communications with Elastix and dive into practical tips to install, deploy, and maintain your own solutions. ...
Elastix brings together the most useful tools and features from the Unified Communications and Open Source worlds: IP-PBX, Chat, Call Center, Multisite, Video, and so on, in a modular way. Beginning with installation and gaining an in-depth understanding of the internal workings of Elastix, you will soon dive into the core features of Elastix and VoIP and Unified Communications to enable a full cost-effective Unified Communications server solution. You will explore the configuration of IP-BPX features, control call routes and destinations, and troubleshoot the unified communications software. Finish by going that extra mile and securing your server and implement advanced dialplan functions. Through this step-by-step guide you will get to grips with VoIP and Unified Communications with Elastix and dive into practical tips to install, deploy, and maintain your own solutions. ...
Expert SQL Server in-Memory OLTP
Expert SQL Server In-Memory OLTP is a deep dive into one of the most significant features of SQL Server 2014 – support for In-Memory Online Transaction Processing. The book describes the architecture and internals of the In-Memory OLTP Engine and explains how to develop, deploy, and maintain systems using it. With it you can dramatically increase transactional throughput to handle thousands of transactions per second supporting millions of customers. Dmitri Korotkevitch is the five-star author of Pro SQL Server Internals, and now brings his same combination of clear thinking and deep expertise to the question of how to recognize the opportunities and benefit from Microsoft's In-Memory OLTP feature set in SQL Server 2014. ...
Expert SQL Server In-Memory OLTP is a deep dive into one of the most significant features of SQL Server 2014 – support for In-Memory Online Transaction Processing. The book describes the architecture and internals of the In-Memory OLTP Engine and explains how to develop, deploy, and maintain systems using it. With it you can dramatically increase transactional throughput to handle thousands of transactions per second supporting millions of customers. Dmitri Korotkevitch is the five-star author of Pro SQL Server Internals, and now brings his same combination of clear thinking and deep expertise to the question of how to recognize the opportunities and benefit from Microsoft's In-Memory OLTP feature set in SQL Server 2014. ...
Expert T-SQL Window Functions in SQL Server
Expert T-SQL Window Functions in SQL Server takes you from any level of knowledge of windowing functions and turns you into an expert who can use these powerful functions to solve many T-SQL queries. Replace slow cursors and self-joins with queries that are easy to write and fantastically better performing, all through the magic of window functions. First introduced in SQL Server 2005, window functions came into full blossom with SQL Server 2012. They truly are one of the most notable developments in SQL in a decade, and every developer and DBA can benefit from their expressive power in solving day-to-day business problems. Begin using windowing functions like ROW_NUMBER and LAG, and you will discover more ways to use them every day. You will approach SQL Server queries in a different way, thinking about sets of data instead of individual rows. Your queries will run faster, they will be easier to write, and they will be easier to deconstruct and maintain ...
Expert T-SQL Window Functions in SQL Server takes you from any level of knowledge of windowing functions and turns you into an expert who can use these powerful functions to solve many T-SQL queries. Replace slow cursors and self-joins with queries that are easy to write and fantastically better performing, all through the magic of window functions. First introduced in SQL Server 2005, window functions came into full blossom with SQL Server 2012. They truly are one of the most notable developments in SQL in a decade, and every developer and DBA can benefit from their expressive power in solving day-to-day business problems. Begin using windowing functions like ROW_NUMBER and LAG, and you will discover more ways to use them every day. You will approach SQL Server queries in a different way, thinking about sets of data instead of individual rows. Your queries will run faster, they will be easier to write, and they will be easier to deconstruct and maintain ...
Introducing SQL Server
Introducing SQL Server is a fast and easy introduction to SQL Server and the world of relational databases. You'll learn how databases work and how to use the T-SQL language by practicing on one of the most widely-used and powerful database engines in the corporate world: Microsoft SQL Server. Do you quake at the sight of a SELECT statement? Start to shiver when people start talking about tables and rows? Fear not, Introducing SQL Server is here to rescue you. The book focuses on the knowledge and skills needed to begin your journey toward becoming a solid and competent SQL Server professional and database programmer. You'll learn the core concepts of SQL Server from installing the software to executing and profiling queries. ...
Introducing SQL Server is a fast and easy introduction to SQL Server and the world of relational databases. You'll learn how databases work and how to use the T-SQL language by practicing on one of the most widely-used and powerful database engines in the corporate world: Microsoft SQL Server. Do you quake at the sight of a SELECT statement? Start to shiver when people start talking about tables and rows? Fear not, Introducing SQL Server is here to rescue you. The book focuses on the knowledge and skills needed to begin your journey toward becoming a solid and competent SQL Server professional and database programmer. You'll learn the core concepts of SQL Server from installing the software to executing and profiling queries. ...
Lync Server Cookbook
This book begins with the fundamental security-related tasks you should be aware of when working with Lync, before moving on to walk you through the authentication mechanisms. You will get hands-on experience with the steps required to integrate Lync with Office 365, Exchange, or trusted forests. You will explore how to use various tools such as the Bandwidth calculator, Lync resource kit tools, stress and performance tools, and planning tools that will help you to manage complex Lync features such as enterprise voice. This book will take you through designing a Lync solution right from assessing the existing infrastructure and capturing the requirements through to planning for user-training. Finally, the book concludes by showing you how to control and manage your networks and introduces you to various debugging tools such as Wireshark, CLSController, and more. The book aims at empowering you to successfully manage your Lync deployments with ease. ...
This book begins with the fundamental security-related tasks you should be aware of when working with Lync, before moving on to walk you through the authentication mechanisms. You will get hands-on experience with the steps required to integrate Lync with Office 365, Exchange, or trusted forests. You will explore how to use various tools such as the Bandwidth calculator, Lync resource kit tools, stress and performance tools, and planning tools that will help you to manage complex Lync features such as enterprise voice. This book will take you through designing a Lync solution right from assessing the existing infrastructure and capturing the requirements through to planning for user-training. Finally, the book concludes by showing you how to control and manage your networks and introduces you to various debugging tools such as Wireshark, CLSController, and more. The book aims at empowering you to successfully manage your Lync deployments with ease. ...