Professional Microsoft SQL Server 2016 Reporting Services and Mobile Reports
Professional Microsoft SQL Server 2016 Reporting Services and Mobile Reports provides a comprehensive lesson in business intelligence (BI), operational reporting and Reporting Services architecture using a clear, concise tutorial approach. You'll learn effective report solution design based upon many years of experience with successful report solutions. Improve your own reports with advanced, best-practice design, usability, query design, and filtering techniques. Expert guidance provides insight into common report types and explains where each could be made more efficient, while providing step-by step instruction on Microsoft SQL Server 2016. All changes to the 2016 release are covered in detail, including improvements to the Visual Studio Report Designer (SQL Server Data Tools) and Report Builder, Mobile Dashboard Designer, the new Report Portal Interface, HTML-5 Rendering, Power BI integration, Custom Parameters Pane, and more. The Microsoft SQL Server 2016 release will include s ...
Professional Microsoft SQL Server 2016 Reporting Services and Mobile Reports provides a comprehensive lesson in business intelligence (BI), operational reporting and Reporting Services architecture using a clear, concise tutorial approach. You'll learn effective report solution design based upon many years of experience with successful report solutions. Improve your own reports with advanced, best-practice design, usability, query design, and filtering techniques. Expert guidance provides insight into common report types and explains where each could be made more efficient, while providing step-by step instruction on Microsoft SQL Server 2016. All changes to the 2016 release are covered in detail, including improvements to the Visual Studio Report Designer (SQL Server Data Tools) and Report Builder, Mobile Dashboard Designer, the new Report Portal Interface, HTML-5 Rendering, Power BI integration, Custom Parameters Pane, and more. The Microsoft SQL Server 2016 release will include s ...
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 and enhance in the future. ...
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 and enhance in the future. ...
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. ...
Modern API Design with ASP.NET Core 2
Use ASP.NET Core 2 to create durable and cross-platform web APIs through a series of applied, practical scenarios. Examples in this book help you build APIs that are fast and scalable. You'll progress from the basics of the framework through to solving the complex problems encountered in implementing secure RESTful services. The book is packed full of examples showing how Microsoft's ground-up rewrite of ASP.NET Core 2 enables native cross-platform applications that are fast and modular, allowing your cloud-ready server applications to scale as your business grows. Major topics covered in the book include the fundamentals and core concepts of ASP.NET Core 2. You'll learn about building RESTful APIs with the MVC pattern using proven best practices and following the six principles of REST. Examples in the book help in learning to develop world-class web APIs and applications that can run on any platform, including Windows, Linux, and MacOS. You can even deploy to Microsoft Azure and a ...
Use ASP.NET Core 2 to create durable and cross-platform web APIs through a series of applied, practical scenarios. Examples in this book help you build APIs that are fast and scalable. You'll progress from the basics of the framework through to solving the complex problems encountered in implementing secure RESTful services. The book is packed full of examples showing how Microsoft's ground-up rewrite of ASP.NET Core 2 enables native cross-platform applications that are fast and modular, allowing your cloud-ready server applications to scale as your business grows. Major topics covered in the book include the fundamentals and core concepts of ASP.NET Core 2. You'll learn about building RESTful APIs with the MVC pattern using proven best practices and following the six principles of REST. Examples in the book help in learning to develop world-class web APIs and applications that can run on any platform, including Windows, Linux, and MacOS. You can even deploy to Microsoft Azure and a ...
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. ...
Mastering VMware vSphere Storage
vSphere Storage is one of the three main infrastructure components of a vSphere deployment (Compute, Storage, and Network). Mastering VMware vSphere Storage begins with an insightful introduction to virtualization and creating your own virtual machines. We then talk about VMware vCenter Server and virtual machine management, as well as managing vSphere 5 using vSphere Management Assistant (vMA) and esxcli and vmware-cmd commands. We then swiftly move on to a very interesting topic, reviewing the vSphere performance and troubleshooting methodology. We then configure VM storage profiles, Storage DRS, and Storage I/O control. More significantly, we will troubleshoot and analyze storage using the VMware CLI and learn how to configure iSCSI storage. By the end of the book, you will be able to identify useful information to make virtual machine and virtual data center design decisions. ...
vSphere Storage is one of the three main infrastructure components of a vSphere deployment (Compute, Storage, and Network). Mastering VMware vSphere Storage begins with an insightful introduction to virtualization and creating your own virtual machines. We then talk about VMware vCenter Server and virtual machine management, as well as managing vSphere 5 using vSphere Management Assistant (vMA) and esxcli and vmware-cmd commands. We then swiftly move on to a very interesting topic, reviewing the vSphere performance and troubleshooting methodology. We then configure VM storage profiles, Storage DRS, and Storage I/O control. More significantly, we will troubleshoot and analyze storage using the VMware CLI and learn how to configure iSCSI storage. By the end of the book, you will be able to identify useful information to make virtual machine and virtual data center design decisions. ...
Mastering vRealize Operations Manager
As x86 server virtualization becomes mainstream for even the most demanding applications, the criticality of managing the heath and efficiency of virtualized environments is more important than ever. vRealize Operations Manager 6.0 (vROps 6.0) is the key to simplify operations of your virtualized environment and move from being reactive to proactive. Mastering vRealize Operations Manager 6.0 helps you streamline your processes and customize the environment to suit your needs. You will gain visibility across all devices in the network and retain full control. With easy-to-follow, step-by-step instructions and support images, you will quickly master the ability to manipulate your data and display it in a way that best suits you and the requirements of your colleagues. From the new and impressive vROps 6.0 platform architecture to troubleshooting and capacity planning, this book is aimed at ensuring you get the knowledge to manage your virtualized environment as effectively as possible ...
As x86 server virtualization becomes mainstream for even the most demanding applications, the criticality of managing the heath and efficiency of virtualized environments is more important than ever. vRealize Operations Manager 6.0 (vROps 6.0) is the key to simplify operations of your virtualized environment and move from being reactive to proactive. Mastering vRealize Operations Manager 6.0 helps you streamline your processes and customize the environment to suit your needs. You will gain visibility across all devices in the network and retain full control. With easy-to-follow, step-by-step instructions and support images, you will quickly master the ability to manipulate your data and display it in a way that best suits you and the requirements of your colleagues. From the new and impressive vROps 6.0 platform architecture to troubleshooting and capacity planning, this book is aimed at ensuring you get the knowledge to manage your virtualized environment as effectively as possible ...
Sams Teach Yourself Microsoft SQL Server T-SQL in 10 Minutes, 2nd Edition
Sams Teach Yourself Microsoft SQL Server T-SQL in 10 Minutes offers straightforward, practical answers when you need fast results. By working through the book's 30 lessons of 10 minutes or less, you'll learn what you need to know to take advantage of Microsoft SQL Server's T-SQL language. This handy pocket guide starts with simple data retrieval and moves on to more complex topics, including the use of joins, subqueries, full text-based searches, functions and stored procedures, cursors, triggers, table constraints, XML, JSON, and much more. Learn how to: Use T-SQL in the Microsoft SQL Server environment; Construct complex T-SQL statements using multiple clauses and operators; Filter data so you get the information you need quickly; Retrieve, sort, and format database contents; Join two or more related tables; Make SQL Server work for you with globalization and localization; Create subqueries to pinpoint your data; Automate your workload with triggers; Create and alter database t ...
Sams Teach Yourself Microsoft SQL Server T-SQL in 10 Minutes offers straightforward, practical answers when you need fast results. By working through the book's 30 lessons of 10 minutes or less, you'll learn what you need to know to take advantage of Microsoft SQL Server's T-SQL language. This handy pocket guide starts with simple data retrieval and moves on to more complex topics, including the use of joins, subqueries, full text-based searches, functions and stored procedures, cursors, triggers, table constraints, XML, JSON, and much more. Learn how to: Use T-SQL in the Microsoft SQL Server environment; Construct complex T-SQL statements using multiple clauses and operators; Filter data so you get the information you need quickly; Retrieve, sort, and format database contents; Join two or more related tables; Make SQL Server work for you with globalization and localization; Create subqueries to pinpoint your data; Automate your workload with triggers; Create and alter database t ...
Sams Teach Yourself PHP, MySQL & JavaScript All in One, 6th Edition
In just a short time, you can learn how to use PHP, MySQL, and JavaScript together to create dynamic, interactive websites and applications using three leading web development technologies. No previous programming experience is required. Using a straightforward, step-by-step approach, each lesson in this book builds on the previous ones, enabling you to learn the essentials of full-stack web application development - from HTML, CSS, and JavaScript on the front end, to PHP scripting and MySQL databases on the server. Regardless of whether you run Linux, Windows, or MacOS, the book includes complete instructions to install all the software you need to set up a stable environment for learning, testing, and production. Learn how to: Build web pages with HTML5 and CSS; Use JavaScript to build dynamic, interactive web pages; Get PHP, MySQL, and JavaScript to work together to create modern, standards-compliant web applications; Enhance interactivity with AJAX; Leverage JavaScript lib ...
In just a short time, you can learn how to use PHP, MySQL, and JavaScript together to create dynamic, interactive websites and applications using three leading web development technologies. No previous programming experience is required. Using a straightforward, step-by-step approach, each lesson in this book builds on the previous ones, enabling you to learn the essentials of full-stack web application development - from HTML, CSS, and JavaScript on the front end, to PHP scripting and MySQL databases on the server. Regardless of whether you run Linux, Windows, or MacOS, the book includes complete instructions to install all the software you need to set up a stable environment for learning, testing, and production. Learn how to: Build web pages with HTML5 and CSS; Use JavaScript to build dynamic, interactive web pages; Get PHP, MySQL, and JavaScript to work together to create modern, standards-compliant web applications; Enhance interactivity with AJAX; Leverage JavaScript lib ...
Network Attacks and Exploitation
Network Attacks and Exploitation provides a clear, comprehensive roadmap for developing a complete offensive and defensive strategy to engage in or thwart hacking and computer espionage. Written by an expert in both government and corporate vulnerability and security operations, this guide helps you understand the principles of the space and look beyond the individual technologies of the moment to develop durable comprehensive solutions. Numerous real-world examples illustrate the offensive and defensive concepts at work, including Conficker, Stuxnet, the Target compromise, and more. You will find clear guidance toward strategy, tools, and implementation, with practical advice on blocking systematic computer espionage and the theft of information from governments, companies, and individuals. Assaults and manipulation of computer networks are rampant around the world. One of the biggest challenges is fitting the ever-increasing amount of information into a whole plan or framework to ...
Network Attacks and Exploitation provides a clear, comprehensive roadmap for developing a complete offensive and defensive strategy to engage in or thwart hacking and computer espionage. Written by an expert in both government and corporate vulnerability and security operations, this guide helps you understand the principles of the space and look beyond the individual technologies of the moment to develop durable comprehensive solutions. Numerous real-world examples illustrate the offensive and defensive concepts at work, including Conficker, Stuxnet, the Target compromise, and more. You will find clear guidance toward strategy, tools, and implementation, with practical advice on blocking systematic computer espionage and the theft of information from governments, companies, and individuals. Assaults and manipulation of computer networks are rampant around the world. One of the biggest challenges is fitting the ever-increasing amount of information into a whole plan or framework to ...