- Table View
- List View
SQL Essentials For Dummies
by Richard Blum Allen G. TaylorA right-to-the-point guide on all the key topics of SQL programming SQL Essentials For Dummies is your quick reference to all the core concepts of SQL—a valuable common standard language used in relational databases. This useful guide is straightforward—with no excess review, wordy explanations, or fluff—so you get what you need, fast. Great for a brush-up on the basics or as an everyday desk reference, this book is one you can rely on. Strengthen your understanding of the basics of SQL Review what you've already learned or pick up key skills Use SQL to create, manipulate, and control relational databases Jog your memory on the essentials as you work and get clear answers to your questions Perfect for supplementing classroom learning, reviewing for a certification, and staying knowledgeable on the job, SQL Essentials For Dummies is the convenient, direct, and digestible reference you've been looking for.
SQL For Dummies
by Allen G. TaylorUncover the secrets of SQL and start building better relational databases today!This fun and friendly guide will help you demystify database management systems so you can create more powerful databases and access information with ease. Updated for the latest SQL functionality, SQL For Dummies, 8th Edition covers the core SQL language and shows you how to use SQL to structure a DBMS, implement a database design, secure your data, and retrieve information when you need it.Includes new enhancements of SQL:2011, including temporal data functionality which allows you to set valid times for transactions to occur and helps prevent database corruptionCovers creating, accessing, manipulating, maintaining, and storing information in relational database management systems like Access, Oracle, SQL Server, and MySQLProvides tips for keeping your data safe from theft, accidental or malicious corruption, or loss due to equipment failures and advice on eliminating errors in your workDon't be daunted by database development anymore - get SQL For Dummies, 8th Edition, and you'll be on your way to SQL stardom.
SQL For Dummies (For Dummies Series)
by Allen G. TaylorGet ready to make SQL easy! Updated for the latest version of SQL, the new edition of this perennial bestseller shows programmers and web developers how to use SQL to build relational databases and get valuable information from them. Covering everything you need to know to make working with SQL easier than ever, topics include how to use SQL to structure a DBMS and implement a database design; secure a database; and retrieve information from a database; and much more. SQL is the international standard database language used to create, access, manipulate, maintain, and store information in relational database management systems (DBMS) such as Access, Oracle, SQL Server, and MySQL. SQL adds powerful data manipulation and retrieval capabilities to conventional languages—and this book shows you how to harness the core element of relational databases with ease. Server platform that gives you choices of development languages, data types, on-premises or cloud, and operating systems Find great examples on the use of temporal data Jump right in—without previous knowledge of database programming or SQL As database-driven websites continue to grow in popularity—and complexity—SQL For Dummies is the easy-to-understand, go-to resource you need to use it seamlessly.
SQL Hacks: Tips & Tools for Digging Into Your Data
by Andrew Cumming Gordon RussellWhether you're running Access, MySQL, SQL Server, Oracle, or PostgreSQL, this book will help you push the limits of traditional SQL to squeeze data effectively from your database. The book offers 100 hacks -- unique tips and tools -- that bring you the knowledge of experts who apply what they know in the real world to help you take full advantage of the expressive power of SQL. You'll find practical techniques to address complex data manipulation problems. Learn how to:Wrangle data in the most efficient way possibleAggregate and organize your data for meaningful and accurate reportingMake the most of subqueries, joins, and unionsStay on top of the performance of your queries and the server that runs themAvoid common SQL security pitfalls, including the dreaded SQL injection attackLet SQL Hacks serve as your toolbox for digging up and manipulating data. If you love to tinker and optimize, SQL is the perfect technology and SQL Hacks is the must-have book for you.
SQL Injection Strategies: Practical techniques to secure old vulnerabilities against modern attacks
by Ettore Galluccio Edoardo Caselli Gabriele LombariLearn to exploit vulnerable database applications using SQL injection tools and techniques, while understanding how to effectively prevent attacks Key Features Understand SQL injection and its effects on websites and other systems Get hands-on with SQL injection using both manual and automated tools Explore practical tips for various attack and defense strategies relating to SQL injection Book Description SQL injection (SQLi) is probably the most infamous attack that can be unleashed against applications on the internet. SQL Injection Strategies is an end-to-end guide for beginners looking to learn how to perform SQL injection and test the security of web applications, websites, or databases, using both manual and automated techniques. The book serves as both a theoretical and practical guide to take you through the important aspects of SQL injection, both from an attack and a defense perspective. You'll start with a thorough introduction to SQL injection and its impact on websites and systems. Later, the book features steps to configure a virtual environment, so you can try SQL injection techniques safely on your own computer. These tests can be performed not only on web applications but also on web services and mobile applications that can be used for managing IoT environments. Tools such as sqlmap and others are then covered, helping you understand how to use them effectively to perform SQL injection attacks. By the end of this book, you will be well-versed with SQL injection, from both the attack and defense perspective. What you will learn Focus on how to defend against SQL injection attacks Understand web application security Get up and running with a variety of SQL injection concepts Become well-versed with different SQL injection scenarios Discover SQL injection manual attack techniques Delve into SQL injection automated techniques Who this book is for This book is ideal for penetration testers, ethical hackers, or anyone who wants to learn about SQL injection and the various attack and defense strategies against this web security vulnerability. No prior knowledge of SQL injection is needed to get started with this book.
SQL Pocket Guide
by Jonathan GennickSQL is the language of databases. It's used to create and maintain database objects, place data into those objects, query the data, modify the data, and, finally, delete data that is no longer needed. Databases lie at the heart of many, if not most business applications. Chances are very good that if you're involved with software development, you're using SQL to some degree. And if you're using SQL, you should own a good reference or two. Now available in an updated second edition, our very popular SQL Pocket Guide is a major help to programmers, database administrators, and everyone who uses SQL in their day-to-day work. The SQL Pocket Guide is a concise reference to frequently used SQL statements and commonly used SQL functions. Not just an endless collection of syntax diagrams, this portable guide addresses the language's complexity head on and leads by example. The information in this edition has been updated to reflect the latest versions of the most commonly used SQL variants including:Oracle Database 10g, Release 2 (includingthe free Oracle Database 10g Express Edition (XE))Microsoft SQL Server 2005MySQL 5IBM DB2 8.2PostreSQL 8.1 database
SQL Pocket Guide, 2nd Edition
by Jonathan GennickSQL is the language of databases. It's used to create and maintain database objects, place data into those objects, query the data, modify the data, and, finally, delete data that is no longer needed. Databases lie at the heart of many, if not most business applications. Chances are very good that if you're involved with software development, you're using SQL to some degree. And if you're using SQL, you should own a good reference or two. Now available in an updated second edition, our very popular SQL Pocket Guide is a major help to programmers, database administrators, and everyone who uses SQL in their day-to-day work. The SQL Pocket Guide is a concise reference to frequently used SQL statements and commonly used SQL functions. Not just an endless collection of syntax diagrams, this portable guide addresses the language's complexity head on and leads by example. The information in this edition has been updated to reflect the latest versions of the most commonly used SQL variants including: * Oracle Database 10g, Release 2 (including the free Oracle Database 10g Express Edition (XE)) * Microsoft SQL Server 2005 * MySQL 5 * IBM DB2 8.2 * PostreSQL 8.1 database
SQL Pocket Guide: A Guide to SQL Usage
by Alice ZhaoIf you use SQL in your day-to-day work as a data analyst, data scientist, or data engineer, this popular pocket guide is your ideal on-the-job reference. You'll find many examples that address the language's complexities, along with key aspects of SQL used in Microsoft SQL Server, MySQL, Oracle Database, PostgreSQL, and SQLite.In this updated edition, author Alice Zhao describes how these database management systems implement SQL syntax for both querying and making changes to a database. You'll find details on data types and conversions, regular expression syntax, window functions, pivoting and unpivoting, and more.Quickly look up how to perform specific tasks using SQLApply the book's syntax examples to your own queriesUpdate SQL queries to work in five different database management systems NEW: Connect Python and R to a relational databaseNEW: Look up frequently asked SQL questions in the "How Do I?" chapter
SQL Pocket Guide: A Guide to SQL Usage (Pocket References Ser.)
by Jonathan GennickIf you're a programmer or database administrator who uses SQL in your day-to-day work, this popular pocket guide is the ideal on-the-job reference. You'll find many examples that address the language's complexity, along with key aspects of SQL used in IBM DB2 Release 9.7, MySQL 5.1, Oracle Database 11g Release 2, PostgreSQL 9.0, and Microsoft SQL Server 2008 Release 2. SQL Pocket Guide describes how these database systems implement SQL syntax for querying, managing transactions, and making changes to data. It also shows how the systems use SQL functions, regular expression syntax, and type conversion functions and formats. All example SQL statements in this book execute against a set of tables, with data that you can quickly download. The third edition covers important database changes, including: Oracle's support of the recursive WITH syntax, and addition of PIVOT and UNPIVOT operators Functions new to Oracle, such as LISTAGG, NTH_VALUE, and more PostgreSQL's support of recursive WITH and some window functions DB2 syntax and datatypes, some compatible with Oracle MySQL features such as the TIMESTAMP type and the TO_SECONDS function
SQL Primer: An Accelerated Introduction to SQL Basics
by Rahul BatraBuild a core level of competency in SQL so you can recognize the parts of queries and write simple SQL statements. SQL knowledge is essential for anyone involved in programming, data science, and data management. This book covers features of SQL that are standardized and common across most database vendors. You will gain a base of knowledge that will prepare you to go deeper into the specifics of any database product you might encounter. Examples in the book are worked in PostgreSQL and SQLite, but the bulk of the examples are platform agnostic and will work on any database platform supporting SQL. Early in the book you learn about table design, the importance of keys as row identifiers, and essential query operations. You then move into more advanced topics such as grouping and summarizing, creating calculated fields, joining data from multiple tables when it makes business sense to do so, and more. Throughout the book, you are exposed to a set-based approach to the language and are provided a good grounding in subtle but important topics such as the effects of null value on query results. With the explosion of data science, SQL has regained its prominence as a top skill to have for technologists and decision makers worldwide. SQL Primer will guide you from the very basics of SQL through to the mainstream features you need to have a solid, working knowledge of this important, data-oriented language.What You'll LearnCreate and populate your own database tablesRead SQL queries and understand what they are doingExecute queries that get correct resultsBring together related rows from multiple tablesGroup and sort data in support of reporting applicationsGet a grip on nulls, normalization, and other key conceptsEmploy subqueries, unions, and other advanced featuresWho This Book Is ForAnyone new to SQL who is looking for step-by-step guidance toward understanding and writing SQL queries. The book is aimed at those who encounter SQL statements often in their work, and provides a sound baseline useful across all SQL database systems. Programmers, database managers, data scientists, and business analysts all can benefit from the baseline of SQL knowledge provided in this book.
SQL Queries for Mere Mortals: A Hands-on Guide to Data Manipulation in SQL
by John ViescasSQL Queries for Mere Mortals has earned worldwide praise as the clearest, simplest tutorial on writing effective queries with the latest SQL standards and database applications. Now, author John L. Viescas has updated this hands-on classic with even more advanced and valuable techniques. <p><p> Step by step, Viescas guides you through creating reliable queries for virtually any current SQL-based database. He demystifies all aspects of SQL query writing, from simple data selection and filtering to joining multiple tables and modifying sets of data. <p><p> Building on the basics, Viescas shows how to solve challenging real-world problems, including applying multiple complex conditions on one table, performing sophisticated logical evaluations, and using unlinked tables to think “outside the box.” <p><p> In two brand-new chapters, you learn how to perform complex calculations on groups for sophisticated reporting, and how to partition data into windows for more flexible aggregation. <p><p> Practice all you want with downloadable sample databases for today’s versions of Microsoft Office Access, Microsoft SQL Server, and the open source MySQL and PostgreSQL databases. Whether you’re a DBA, developer, user, or student, there’s no better way to master SQL.
SQL Query Design Patterns and Best Practices: A practical guide to writing readable and maintainable SQL queries using its design patterns
by Steve Hughes Dennis Neer Dr. Ram Singh Shabbir H. Mala Leslie AndrewsEnhance your SQL query writing skills to provide greater business value using advanced techniques such as common table expressions, window functions, and JSONPurchase of the print or Kindle book includes a free PDF eBookKey FeaturesExamine query design and performance using query plans and indexesSolve business problems using advanced techniques such as common table expressions and window functionsUse SQL in modern data platform solutions with JSON and Jupyter notebooksBook DescriptionSQL has been the de facto standard when interacting with databases for decades and shows no signs of going away. Through the years, report developers or data wranglers have had to learn SQL on the fly to meet the business needs, so if you are someone who needs to write queries, SQL Query Design and Pattern Best Practices is for you.This book will guide you through making efficient SQL queries by reducing set sizes for effective results. You'll learn how to format your results to make them easier to consume at their destination. From there, the book will take you through solving complex business problems using more advanced techniques, such as common table expressions and window functions, and advance to uncovering issues resulting from security in the underlying dataset. Armed with this knowledge, you'll have a foundation for building queries and be ready to shift focus to using tools, such as query plans and indexes, to optimize those queries. The book will go over the modern data estate, which includes data lakes and JSON data, and wrap up with a brief on how to use Jupyter notebooks in your SQL journey.By the end of this SQL book, you'll be able to make efficient SQL queries that will improve your report writing and the overall SQL experience.What you will learnBuild efficient queries by reducing the data being returnedManipulate your data and format it for easier consumptionForm common table expressions and window functions to solve complex business issuesUnderstand the impact of SQL security on your resultsUnderstand and use query plans to optimize your queriesUnderstand the impact of indexes on your query performance and designWork with data lake data and JSON in SQL queriesOrganize your queries using Jupyter notebooksWho this book is forThis book is for SQL developers, data analysts, report writers, data scientists, and other data gatherers looking to expand their skills for complex querying as well as for building more efficient and performant queries.For those new to SQL, this book can help you accelerate your learning and keep you from making common mistakes.
SQL Server 2000 High Availability Volume 1: Planning
by Microsoft CorporationThe SQL Server 2000 High Availability Planning Guide helps database designers and systems engineers design data centers that can achieve the level of availability needed for particular business environments. This guide discusses each barrier to achieving a highly available data center and analyzes the solutions to each of these barriers. The importance of using a combination of best practices, database backups, redundant components, and redundant servers is emphasized as the key to ensuring high availability. What this guide covers: Best practices to prevent downtime Using backup to recover from disaster Using hardware redundancy to prevent downtime Using redundancy to minimize downtime Patterns & practices contains specific recommendations illustrating how to design, build, deploy, and operate architecturally sound solutions to challenging business and technical scenarios. The technical guidance is reviewed and approved by Microsoft engineering teams, consultants, and Product Support Services, and by partners and customers. Patterns & Practices are: Proven: Based on field experience Authoritative: Offers the best advice available Accurate: Technically validated and tested Actionable: Provides the steps to success Relevant: Addresses real world problems Contents: Introduction to High Availability Overcoming Barriers to High Availability Recovering a Data Center by Using Database Backups Preventing Downtime by Using Redundant Components Minimizing Downtime by Using Redundant Servers
SQL Server 2000 High Availability Volume 2: Deployment
by Microsoft CorporationThe SQL Server High Availability Solution Guide helps database designers and systems engineers implement targeted server redundancy solutions. This guide provides step-by-step guidance for implementing the following solutions: failover clustering, log shipping, log shipping with network load balancing, transactional replication, transactional replication with network load balancing, stretch clusters, and remote mirrors for achieving high availability. Step-by-step guidance is also provided for failing over to or changing the role of a redundant server. This book covers the following topics: Implementing Failover Clustering Implementing Log Shipping Implementing Transactional Replication Implementing Network Load Balancing (NLB) Implementing Remote Clustering
SQL Server 2008 Administration
by Tom CarpenterThe ideal on-the-job reference guide for SQL Server 2008 database administratorsIf you manage and administer SQL Server 2008 in the real world, you need this detailed guide at your desk. From planning to disaster recovery, this practical book explores tasks and scenarios that a working SQL Server DBA faces regularly and shows you step by step how to handle them. Topics include installation and configuration, creating databases and tables, optimizing the database server, planning for high availability, and more.And, if you're preparing for MCTS or MCITP certification in SQL Server 2008 administration, this book is the perfect supplement to your preparation, featuring a CD with practice exams, flashcards, and video walkthroughs of the more difficult administrative tasksDelves into Microsoft's SQL Server 2008, a rich set of enterprise-level database services for business-critical applicationsExplores the skills you'll need on the job as a SQL Server 2008 administratorShows you how to implement, maintain, and repair the SQL Server database, including bonus videos on the CD where the authors walks you through the more difficult tasksCovers database design, installation and configuration, creating databases and tables, security, backup and high availability, and moreSupplements your preparation for MCTS and MCITP SQL Server 2008 certification with in-depth coverage of the skill sets required for certification, as defined by MicrosoftUses hands-on exercises and real-world scenarios to keep what you're learning grounded in the reality of the workplaceMake sure you're not only prepared for certification, but also for your job as a SQL Server 2008 administrator, with this practical reference!Note: CD-ROM/DVD and other supplementary materials are not included as part of eBook file.
SQL Server 2008 Administration in Action
by Rodney C. ColledgeSQL Server 2008 Administration isn't a standard SQL Server tutorial-thereare dozens of those to choose from. Instead, this book breaks down the role of"SQL Server Administrator" into its key focus areas and tasks and details thetechniques and best practices that make an administrator effective.In this book, a reader can quickly identify a task and find the best practiceassociated with it. For example, a reader looking for information about indexingwould find step-by-step procedures for identifying and dropping unusedindexes, creating missing indexes, selecting the appropriate clustered index,and so forth.Each technique is presented in a clear, straightforward style and in the order ofthe typical lifecycle of a SQL Server system. This allows a reader to easily openthe book at the appropriate page and focus on what you need to know for eachspecific situation.While most techniques will work for all versions of SQL Server, this book is currentfor the recent final release of SQL Server 2008. Purchase of the print book comes with an offer of a free PDF, ePub, and Kindle eBook from Manning. Also available is all code from the book.
SQL Server 2012 Reporting Services Blueprints
by Mickey Stuewe Marlon RibunalFollow the fictional John Kirkland through a series of real-world reporting challenges based on actual business conditions. Use his detailed blueprints to develop your own reports for every requirement.This book is for report developers, data analysts, and database administrators struggling to master the complex world of effective reporting in SQL Server 2012. Knowledge of how data sources and data sets work will greatly help readers to speed through the tutorials.
SQL Server 2012 T-SQL Recipes
by Jonathan Gennick Andy Roberts David Dye Jason Brimhall Wayne SheffieldSQL Server 2012 T-SQL Recipes is an example-based guide to the Transact-SQL language that is at the core of SQL Server 2012. It provides ready-to-implement solutions to common programming and database administration tasks. Learn to create databases, insert and update data, generate reports, secure your data, and more. Tasks and their solutions are broken down into a problem/solution format that is quick and easy to read so that you can get the job done fast when the pressure is on. Solutions in this book are divided into chapters by problem domain. Each chapter is a collection of solutions around a single facet of the language such as writing queries, developing triggers, and applying aggregate functions. Each solution is presented code-first, giving you a working code example to copy from and implement immediately in your own environment. Following each example is an in-depth description of how and why the given solution works. Tradeoffs and alternative approaches are also discussed. Focused on solutions: Look up what you need to do. Learn how to do it. Do it. Current: Newly updated for SQL Server 2012 Comprehensive: Covers all common T-SQL problem domains What you'll learn Create databases, tables, and indexes Query and manipulate data Store and manage XML inside the database Move business logic into the database Resolve common performance problems. Build reports that matter to your business. Perform common backup and recovery tasks. Who this book is for SQL Server 2012 T-SQL Recipes is aimed at technically-oriented users of SQL Server desiring to extract the full power of the platform through it's powerful, built-in programming and scripting language. Target readers include developers who use Microsoft SQL Server 2012 as their backend database, and the database administrators who create, manage, and secure those databases. Table of Contents Getting Started with SELECT Elementary Programming Nulls and Other Pitfalls Combining Data from Multiple Tables Grouping and Summarizing Advanced SELECT Techniques Query Techniques for Reporting Inserting, Updating, Deleting Working with Strings Working with Dates Working with Numbers Transactions, Locking, Blocking, Deadlocking Managing Tables Managing Views Managing Indexes Managing Large Tables Stored Procedures User-Defined Functions Triggers Error Handling Query Performance Hints Index Tuning and Statistics XML Files, Filegroups, and Integrity Backup Recovery Principals and Users Securables and Permissions Objects and Dependencies "
SQL Server 2012 with PowerShell V3 Cookbook
by Donabel SantosSQL Server 2012 with PowerShell V3 Cookbook" is an example-focused book that provides step-by-step instructions on how to accomplish specific SQL Server tasks using PowerShell. Each recipe is followed by an analysis of the steps or design decisions taken, and additional information about the task at hand. Working scripts are provided for all examples so that you can dive in right away. You can read this book sequentially by chapter, or you can pick and choose which topics you need right away,This book is written for the SQL Server database professional (DBA, developer, BI developer) who wants to use PowerShell to automate, integrate, and simplify database tasks. A little bit of scripting background is helpful, but not necessary.
SQL Server 2012 with PowerShell V3 Cookbook
by Donabel Santos"SQL Server 2012 with PowerShell V3 Cookbook" is an example-focused book that provides step-by-step instructions on how to accomplish specific SQL Server tasks using PowerShell. Each recipe is followed by an analysis of the steps or design decisions taken, and additional information about the task at hand. Working scripts are provided for all examples so that you can dive in right away. You can read this book sequentially by chapter, or you can pick and choose which topics you need right away,This book is written for the SQL Server database professional (DBA, developer, BI developer) who wants to use PowerShell to automate, integrate, and simplify database tasks. A little bit of scripting background is helpful, but not necessary.
SQL Server 2014 Development Essentials
by Basit A. Masood-Al-FarooqThis book is an easy-to-follow, comprehensive guide that is full of hands-on examples, which you can follow to successfully design, build, and deploy mission-critical database applications with SQL Server 2014. If you are a database developer, architect, or administrator who wants to learn how to design, implement, and deliver a successful database solution with SQL Server 2014, then this book is for you. Existing users of Microsoft SQL Server will also benefit from this book as they will learn what's new in the latest version.
SQL Server 2016 Developer's Guide
by Dejan Sarka Milos Radivojevic William DurkinGet the most out of the rich development capabilities of SQL Server 2016 to build efficient database applications for your organization About This Book • Utilize the new enhancements in Transact-SQL and security features in SQL Server 2016 to build efficient database applications • Work with temporal tables to get information about data stored in the table at any point in time • A detailed guide to SQL Server 2016, introducing you to multiple new features and enhancements to improve your overall development experience Who This Book Is For This book is for database developers and solution architects who plan to use the new SQL Server 2016 features for developing efficient database applications. It is also ideal for experienced SQL Server developers who want to switch to SQL Server 2016 for its rich development capabilities. Some understanding of the basic database concepts and Transact-SQL language is assumed. What You Will Learn • Explore the new development features introduced in SQL Server 2016 • Identify opportunities for In-Memory OLTP technology, significantly enhanced in SQL Server 2016 • Use columnstore indexes to get significant storage and performance improvements • Extend database design solutions using temporal tables • Exchange JSON data between applications and SQL Server in a more efficient way • Migrate historical data transparently and securely to Microsoft Azure by using Stretch Database • Use the new security features to encrypt or to have more granular control over access to rows in a table • Simplify performance troubleshooting with Query Store • Discover the potential of R's integration with SQL Server In Detail Microsoft SQL Server 2016 is considered the biggest leap in the data platform history of the Microsoft, in the ongoing era of Big Data and data science. Compared to its predecessors, SQL Server 2016 offers developers a unique opportunity to leverage the advanced features and build applications that are robust, scalable, and easy to administer. This book introduces you to new features of SQL Server 2016 which will open a completely new set of possibilities for you as a developer. It prepares you for the more advanced topics by starting with a quick introduction to SQL Server 2016's new features and a recapitulation of the possibilities you may have already explored with previous versions of SQL Server. The next part introduces you to small delights in the Transact-SQL language and then switches to a completely new technology inside SQL Server - JSON support. We also take a look at the Stretch database, security enhancements, and temporal tables. The last chapters concentrate on implementing advanced topics, including Query Store, columnstore indexes, and In-Memory OLTP. You will finally be introduced to R and how to use the R language with Transact-SQL for data exploration and analysis. By the end of this book, you will have the required information to design efficient, high-performance database applications without any hassle. Style and approach This book is a detailed guide to mastering the development features offered by SQL Server 2016, with a unique learn-as-you-do approach. All the concepts are explained in a very easy-to-understand manner and are supplemented with examples to ensure that you—the developer—are able to take that next step in building more powerful, robust applications for your organization with ease.
SQL Server 2016 Integration Services Cookbook
by Christian CoteThis book is for software engineers, DW/ETL architects, and ETL developers who need to create a new, or enhance an existing, ETL implementation with SSIS. This book would also be good for individuals who develop ETL solutions that use SSIS and are keen to learn the Microsoft SQL Server Integration Services 2016 new features and capabilities.
SQL Server 2016 Reporting Services Cookbook
by Dinesh Priyankara Robert C. CainCreate interactive cross-platform reports and dashboards using SQL Server 2016 Reporting Services About This Book * Get up to speed with the newly-introduced enhancements and the more advanced query and reporting features * Easily access your important data by creating visually appealing dashboards in the Power BI practical recipe * Create cross-browser and cross-platform reports using SQL Server 2016 Reporting Services Who This Book Is For This book is for software professionals who develop and implement reporting solutions using Microsoft SQL Server. It is especially relevant for professionals who are software engineers, software architects, DW/BI engineers, and DW/BI architects who perform simple to complex report authoring implementations. This book is also suitable for those who develop software solutions that integrate reporting solutions and are keen to learn about Microsoft SQL Server 2016's features and capabilities. What You Will Learn * Key capabilities, architecture, and components of Reporting Services * New features that have been added to Reporting Services * Design the architecture for reporting solutions * Design the architecture for BI solutions * Implement reporting solutions using Reporting Services * Improve the performance, availability, and scalability of the reporting solution * Enhance reporting solutions with custom programming and improved security In Detail Microsoft SQL Server 2016 Reporting Services comes with many new features. It offers different types of reporting such as Production, Ad-hoc, Dashboard, Mash-up, and Analytical. SQL Server 2016 also has a surfeit of new features including Mobile Reporting, and Power BI integration. This book contains recipes that explore the new and advanced features added to SQL Server 2016. The first few chapters cover recipes on configuring components and how to explore these new features. You'll learn to build your own reporting solution with data tools and report builder, along with learning techniques to create visually appealing reports. This book also has recipes for enhanced mobile reporting solutions, accessing these solutions effectively, and delivering interactive business intelligence solutions. Towards the end of the book, you'll get to grips with running reporting services in SharePoint integrated mode and be able to administer, monitor, and secure your reporting solution. This book covers about the new offerings of Microsoft SQL Server 2016 Reporting Services in comprehensive detail and uses examples of real-world problem-solving business scenarios. Style and approach This comprehensive cookbook follows a problem-solution approach to help you overcome any obstacle when creating interactive, visually-appealing reports using SQL Server 2016 Reporting Services. Each recipe focuses on a specific task and is written in a clear, solution-focused style.
SQL Server 2017 Administrator's Guide
by Marek ChmelThis book will give you all the information you need to become an expert database administrator, and master the administrative aspects of SQL Server 2017. From setting up and configuring your SQL Server instance to fine-tuning your database by using various techniques, this extensive guide will teach you the nitty-gritty of SQL Server 2017 administration