Top SQL Server Books

A Guide to SQL

Author: Philip J. Pratt, Mary Z. Last
Publisher: Cengage Learning; 9 edition
Publication date: December 12, 2014
Format: Paperback
Price: $71.64
Description: A GUIDE TO SQL, Ninth Edition, provides an effective introduction to SQL programming using straightforward instruction, extensive hands-on exercises, and a strong foundation in real-world business applications. The Ninth Edition builds on the longstanding success of this proven text by presenting basic SQL commands in the context of a running case, in which a business uses SQL to manage orders, items, customers, and sales reps. The authors emphasize that fundamental principles and practices apply regardless of the database environment chosen, and they include examples from the latest versions of Oracle and Microsoft Access, and SQL Server throughout the text.

Advanced Transact-SQL for SQL Server 2000

Author: Itzik Ben-Gan, Tom Moreau
Publisher: Apress; Softcover reprint of the original 1st ed. edition
Publication date: June 19, 2003
Format: Paperback
Price: $31.74
Description: In Advanced Transact-SQL for SQL Server 2000, authors Itzik Ben-Gan and Thomas Moreau explore the powerful capabilities of Transact-SQL (T-SQL). Ben-Gan and Moreau offer solutions to common problems encountered using all versions of SQL Server, with a focus on the latest version, SQL Server 2000. Expert tips and real code examples teach advanced database programmers to write more efficient and better-performing code that takes full advantage of T-SQL. The authors offer practical solutions to the everyday problems programmers face and include in-depth information on advanced T-SQL topics such as joins, subqueries, stored procedures, triggers, user-defined functions (UDFs), indexed views, cascading actions, federated views, hierarchical structures, cursors, and more.

Applied Microsoft SQL Server 2008 Reporting Services

Author: Teo Lachev
Publisher: Prologika Press
Publication date: August 15, 2008
Format: Kindle, Paperback
Price: Kindle $23.99, Paperback $24.95
Description: Microsoft SQL Server 2008 Reporting Services is the “magic wand” you need to unleash the hidden power of data. The author, who has worked closely with the Reporting Services Development Team, takes you on an insightful tour that provides an authoritative yet independent view of the technology.

Beginning SQL Joes 2 Pros: The SQL Hands-On Guide for Beginners

Author: Rick A. Morelan, Doug Fritz, Jessica Brown
Publisher: BookSurge Publishing
Publication date: December 30, 2009
Format: Kindle, Paperback
Price: Kindle $11.99, Paperback $19.85
Description: Several years ago, a challenge was given to technology instructor Rick A. Morelan. Take downsized workers with little or no experience with computers or technology and turn them into industry certified technology experts. The proven material from this venture is now available to you as the Joes 2 Pros series of books and videos. This new approach has vivid pictures on almost every page that shows what you should see on your computer screen as you work through the material, and downloadable content, home practice labs, software, and fun review games available from the joes2pros web site. Starting with the basic lesson: “What is a Database?” this book helps beginners get comfortable with the SQL language. From there, you will walk step-by-step through the basics. ‘Beginning SQL Joes 2 Pros’ is the second edition of the popular ‘T-SQL Joes 2 Pros’ with updated content and a lower price. The language examples in this book can be used with any standard SQL engine. Regardless of your skill level, you too can evolve from “Joe” to “Pro” by following the steps outlined in this book. Also, so everyone can get started we do have 1 hour of free videos for EVERY SQL book on the Joes2Pros site to help get you started.

Beginning SQL Server 2012 Administration

Author: Robert Walters, Grant Fritchey
Publisher: Apress; 1st ed. edition
Publication date: May 30, 2012
Format: Paperback
Price: $40.57
Description: Beginning SQL Server 2012 Administration provides the essential skills and knowledge needed to begin a successful career as an SQL Server database administrator. It’s an ideal book for those new to database administration, as well for those moving to SQL Server from other database brands such as Oracle and IBM DB2. SQL Server is more than just a database. It’s situated within a larger context that includes solutions for reporting, for integrating data from other systems, for business intelligence and analysis, and more. Beginning SQL Server 2012 Administration paints the big picture to help you understand SQL Server’s place in the grand scheme. Then you’ll move into the nuts and bolts of installing the product, learning the management tools at your disposal, creating your first database, and maintaining that database in an ongoing state of readiness.

Delivering Business Intelligence with Microsoft SQL Server 2012

Author: Brian Larson
Publisher: McGraw-Hill Education; 3 edition
Publication date: April 6, 2012
Format: Paperback
Price: $25.38
Description: Equip your organization for informed, timely decision making using the expert tips and best practices in this practical guide. Delivering Business Intelligence with Microsoft SQL Server 2012, Third Edition explains how to effectively develop, customize, and distribute meaningful information to users enterprise-wide. Learn how to build data marts and create BI Semantic Models, work with the MDX and DAX languages, and share insights using Microsoft client tools.

Delivering Business Intelligence with Microsoft SQL Server 2016

Author: Brian Larson
Publisher: McGraw-Hill Education; 4 edition
Publication date: November 2, 2016
Format: Kindle, Paperback
Price: Kindle $35.39, Paperback $33.50
Description: Drive better, faster, more informed decision making across your organization using the expert tips and best practices featured in this hands-on guide. Delivering Business Intelligence with Microsoft SQL Server 2016, Fourth Edition, shows, step-by-step, how to distribute high-performance, custom analytics to users enterprise-wide. Discover how to build BI Semantic Models, create data marts and OLAP cubes, write MDX and DAX scripts, and share insights using Microsoft client tools. The book includes coverage of self-service business intelligence with Power BI.

Exam Ref 70-410 Installing and Configuring Windows Server 2012 R2 (MCSA)

Author: Craig Zacker
Publisher: Microsoft Press; 1 edition
Publication date: February 25, 2014
Format: Kindle, Paperback
Price: Kindle $17.28, Paperback $25.15
Description: Fully updated for Windows Server 2012 R2! Prepare for Microsoft Exam 70-410 – and help demonstrate your real-world mastery of implementing and configuring core services in Windows Server 2012 R2. Designed for experienced IT professionals ready to advance their status, Exam Ref focuses on the critical thinking and decision-making acumen needed for success at the MCSA level.

Expert Performance Indexing for SQL Server 2012

Author: Jason Strate, Ted Krueger
Publisher: Apress; 1st ed. edition
Publication date: July 12, 2012
Format: Kindle, Paperback
Price: Kindle $28.49, Paperback $41.57
Description: Expert Performance Indexing for SQL Server 2012 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. All of this will help you progress towards properly achieving your database performance goals.

Expert Scripting and Automation for SQL Server DBAs

Author: Peter A. Carter
Publisher: Apress; 1st ed. edition
Publication date: July 28, 2016
Format: Kindle, Paperback
Price: Kindle $38.06, Paperback $44.99
Description: Automate your workload and manage more databases and instances with greater ease and efficiency by combining metadata-driven automation with powerful tools like PowerShell and SQL Server Agent. Automate your new instance-builds and use monitoring to drive ongoing automation, with the help of an inventory database and a management data warehouse. The market has seen a trend towards there being a much smaller ratio of DBAs to SQL Server instances. Automation is the key to responding to this challenge and continuing to run a reliable database platform service. Expert Scripting and Automation for SQL Server DBAs guides you through the process of automating the maintenance of your SQL Server enterprise. Expert Scripting and Automation for SQL Server DBAs shows how to automate the SQL Server build processes, monitor multiple instances from a single location, and automate routine maintenance tasks throughout your environment. You will also learn how to create automated responses to common or time-consuming break/fix scenarios. The book helps you become faster and better at what you do for a living, and thus more valuable in the job market.

Head First SQL: Your Brain on SQL — A Learner’s Guide

Author: Lynn Beighley
Publisher: O’Reilly Media; 1 edition
Publication date: September 1, 2007
Format: Kindle, Paperback
Price: Kindle $29.99, Paperback $31.29
Description: Is your data dragging you down? Are your tables all tangled up? Well we’ve got the tools to teach you just how to wrangle your databases into submission. Using the latest research in neurobiology, cognitive science, and learning theory to craft a multi-sensory SQL learning experience, Head First SQL has a visually rich format designed for the way your brain works, not a text-heavy approach that puts you to sleep.

High Performance SQL Server: The Go Faster Book

Author: Benjamin Nevarez
Publisher: Apress; 1st ed. edition
Publication date: November 23, 2016
Format: Kindle, Paperback
Price: Kindle $35.99, Paperback $39.99
Description: Design and configure SQL Server instances and databases in support of high-throughput applications that are mission-critical and provide consistent response times in the face of variations in user numbers and query volumes. Learn to configure SQL Server and design your databases to support a given instance and workload. You’ll learn advanced configuration options, in-memory technologies, storage and disk configuration, and more, all toward enabling your desired application performance and throughput.

Inside Microsoft SQL Server 2000

Author: Kalen Delaney
Publisher: Microsoft Press; 3 edition
Publication date: November 25, 2000
Format: Hardcover, Paperback
Price: Hardcover $16.41, Paperback $59.99
Description: Master the inner workings of today’s premier relational database management system with this official guide to the SQL Server™ 2000 engine. Written by a renowned columnist in partnership with the product development team, this is the must-read book for anyone who needs to understand how SQL Server internal structures affect application development and functionality. Its extensive details about the latest product enhancements, updated installation and administration, and its development advice can help you create high-performance data-warehousing, transaction-processing, and decision-support applications that will scale up for any challenge.

Inside Microsoft SQL Server 2005: T-SQL Querying (Developer Reference)

Author: Itzik Ben-Gan, Lubor Kollar, Dejan Sarka
Publisher: Microsoft Press; 1 edition
Publication date: April 26, 2006
Format: Paperback
Price: $17.00
Description: Take a detailed look at the internal architecture of T-SQL—and unveil the power of set-based querying—with comprehensive reference and advice from the experts. Database developers and administrators get best practices, sample databases, and code to master the intricacies of the programming language—solving complex problems with real-world solutions.

Inside Microsoft SQL Server 7.0 (Mps)

Author: Ron Soukup, Kalen Delaney
Publisher: Microsoft Press
Publication date: January 1, 1999
Format: Hardcover, Digital
Price: Hardcover $6.40, Digital $11.99
Description: A Microsoft SQL Server guru provides a comprehensive guide with updated, authoritative advice for installing, administering, and programming with version 7.0. The CD-ROM contains product evaluation documentation, sample code, and scripts, white papers, and a benchmarking kit.

Inside Microsoft SQL Server 2008 T-SQL Programming: T-SQL Programming

Author: Itzik Ben-Gan,‎ Dejan Sarka,‎ Roger Wolter,‎ Greg Low,‎ Ed Katibah, Isaac Kunen
Publisher: Microsoft Press; 1 edition
Publication date: September 23, 2009
Format: Kindle, Paperback
Price: Kindle $33.59, Paperback $35.00
Description: Get a detailed look at the internal architecture of T-SQL with this comprehensive programming reference. Database developers and administrators get best practices, expert techniques, and code samples to master the intricacies of this programming language—solving complex problems with real-world solutions. Discover how to: Work with T-SQL and CLR user-defined functions, stored procedures, and triggers; Handle transactions, concurrency, and error handling; Efficiently use temporary objects, including temporary tables, table variables, and table expressions; Evaluate when to use set-based programming techniques and when to use cursors; Work with dynamic SQL in an efficient and secure manner; Treat date- and time-related data in a robust manner; Develop CLR user-defined types and learn about temporal support in the relational model; Use XML and XQuery and implement a dynamic schema solution; Work with spatial data using the new geometry and geography types and spatial indexes; Track access and changes to data using extended events, SQL Server Audit, change tracking, and change data capture; Use Service Broker for controlled asynchronous processing in database applications.

Introducing Microsoft SQL Server 2012

Author: Mistry, Ross, Misner, Stacia
Publisher: Microsoft Press; 1 edition
Publication date: Unknown
Format: Paperback
Price: $59.06
Description: Not available

Introducing Microsoft SQL Server 2014

Author: Ross Mistry,‎ Stacia Misner
Publisher: Microsoft Press; 1 edition
Publication date: May 16, 2014
Format: Paperback
Price: $9.99
Description: Based on Community Technology Preview 2 (CTP2) software, this guide introduces new features and capabilities, with practical insights on how SQL Server 2014 can meet the needs of your business. Coverage includes: SQL Server 2014 Editions and engine enhancements; Mission-critical performance enhancements; Hybrid cloud enhancements; Self-service Business Intelligence enhancements in Microsoft Excel; Enterprise information management enhancements; Big Data solutions.

Introducing Microsoft SQL Server 2016: Mission-Critical Applications, Deeper Insights, Hyperscale Cloud

Author: Stacia Varga, Denny Cherry, Joseph D’Antoni
Publisher: Microsoft Press; 1 edition
Publication date: June 28, 2016
Format: Kindle
Price: $0.00
Description: With Microsoft SQL Server 2016, a variety of new features and enhancements to the data platform deliver breakthrough performance, advanced security, and richer, integrated reporting and analytics capabilities. In this e-book, we introduce new security features: Always Encrypted, Row-Level Security, and dynamic data masking; discuss enhancements that enable you to better manage performance and storage: TemDB configuration, query store, and Stretch Database; review several improvements to Reporting Services; and also describe AlwaysOn Availability Groups, tabular enhancements, and R integration.

Learn SQL Server Administration in a Month of Lunches

Author: Don Jones
Publisher: Manning Publications; 1 edition
Publication date: May 12, 2014
Format: Paperback
Price: $31
Description: Learn SQL Server Administration in a Month of Lunches is the perfect way to get started with SQL Server operations, including maintenance, backup and recovery, high availability, and performance monitoring. In about an hour a day over a month, you’ll learn exactly what you can do, and what you shouldn’t touch. Most importantly, you’ll learn the day-to-day tasks and techniques you need to keep SQL Server humming along smoothly.

Learning SQL: Master SQL Fundamentals

Author: Alan Beaulieu
Publisher: O’Reilly Media; 2nd edition
Publication date: April 30, 2009
Format: Kindle, Paperback
Price: Kindle $20.72, Paperback $28.86
Description: Updated for the latest database management systems — including MySQL 6.0, Oracle 11g, and Microsoft’s SQL Server 2008 — this introductory guide will get you up and running with SQL quickly. Whether you need to write database applications, perform administrative tasks, or generate reports, Learning SQL, Second Edition, will help you easily master all the SQL fundamentals. Each chapter presents a self-contained lesson on a key SQL concept or technique, with numerous illustrations and annotated examples. Exercises at the end of each chapter let you practice the skills you learn.

MCTS Self-Paced Training Kit (Exam 70-431): Microsoft SQL Server 2005 Implementation and Maintenance (Pro-Certification)

Author: Solid Quality Learning
Publisher: Microsoft Press; 1 edition
Publication date: June 28, 2006
Format: Hardcover, Digital
Price: Hardcover $6.93, Digital $11.99
Description: Ace your preparation for the skills measured by MCTS Exam 70-431—and on the job. Work at your own pace through a series of lessons and reviews that fully cover each exam objective. Then, reinforce what you’ve learned by applying your knowledge to real-world case scenarios and practices. This official Microsoft study guide is designed to help you make the most of your study time.

MCTS Self-Paced Training Kit (Exam 70-432): Microsoft® SQL Server® 2008 Implementation and Maintenance (Microsoft Press Training Kit)

Author: Mike Hotek
Publisher: Microsoft Press; 1 edition
Publication date: February 18, 2009
Format: Hardcover, Paperback
Price: Hardcover $37.83, Paperback $49.03
Description: EXAM PREP GUIDE Ace your preparation for the skills measured by MCTS Exam 70-432—and on the job. Work at your own pace through a series of lessons and reviews that fully cover each exam objective. Then, reinforce and apply what you’ve learned through real-world case scenarios and practice exercises. This official Microsoft study guide is designed to help you make the most of your study time.

MCTS Self-Paced Training Kit (Exam 70-433): Microsoft® SQL Server® 2008 Database Development (Microsoft Press Training Kit)

Author: Tobias Thernstrom, Ann Weber, Mike Hotek
Publisher: Microsoft Press; 1 edition
Publication date: May 20, 2009
Format: Hardcover, Paperback
Price: Hardcover $5.14, Paperback $29.63
Description: Ace your preparation for the skills measured by MCTS Exam 70-433—and on the job. Work at your own pace through a series of lessons and reviews that fully cover each exam objective. Then, reinforce and apply what you’ve learned through real-world case scenarios and practice exercises. This official Microsoft study guide is designed to help you make the most of your study time.

MCTS Self-Paced Training Kit (Exam 70-448): Microsoft® SQL Server® 2008 Business Intelligence Development and Maintenance

Author: Erik Veerman, Teo Lachev, Dejan Sarka
Publisher: Microsoft Press; 1 edition
Publication date: April 15, 2009
Format: Paperback
Price: $18.33
Description: Ace your preparation for the skills measured by MCTS Exam 70-448—and on the job. Work at your own pace through a series of lessons and reviews that fully cover each exam objective. Then, reinforce and apply what you’ve learned through real-world case scenarios and practice exercises. This official Microsoft study guide is designed to help you make the most of your study time.

Microsoft SQL Server 2000 Bible

Author: Paul Nielsen
Publisher: Wiley
Publication date: September 1, 2002
Format: Digital, Paperback
Price: Digital $9.99, Paperback $59.88
Description: Organization: The book is divided into 6 parts: Preparing to Develop with SQL Server; Building and Managing Databases with SQL Server; Managing Data with SQL Server; Implementing Business Rules with SQL Server; Monitoring and Performance Tuning with SQL Server; and Advanced Data Transfer and Analysis with SQL Server. Comprehensive coverage: This Bible covers both beginning and advanced topics. Topics covered include: installing and configuring SQL Server; using SQL server’s development tools; securing databases; retrieving data; SQL Server transactions; working with XML; understanding transact SQL language extensions; developing stored procedures; tuning queries and indexes; and developing for English query. Sample database applications: The book builds on sample database applications to demonstrate topics/concepts. Sidebars: So as readers can focus on practical information, the author is using sidebars throughout to explain the best practices associated with the product and highlight material.

Microsoft SQL Server 2008 Administrator’s Pocket Consultant

Author: William Stanek
Publisher: Microsoft Press; 2 edition
Publication date: April 21, 2010
Format: Kindle
Price: $20
Description: Microsoft SQL Server 2008 Administrator’s Pocket Consultant, 2nd Edition is the ideal concise, immediate reference you’ll want with you at all times as you deal with Microsoft SQL Server 2008 and SQL Server 2008 R2 administration. Whether you handle administration for 50 users or 5000, this hands-on, fast answers guide focuses on what you need to do to get the job done quickly. With extensive easy-to-read tables, lists, and step-by-step instructions, it’s the portable, readable guide that you consistently save you time and minimize system downtime by giving you the right information right now.

Microsoft SQL Server 2005 Analysis Services

Author: Edward Melomed,‎ Irina Gorbach,‎ Alexander Berger,‎ Py Bateman
Publisher: Sams Publishing; 1 edition
Publication date: December 25, 2006
Format: Kindle, Paperback
Price: Kindle $31.04, Paperback $11.25
Description: Microsoft SQL Server Analysis Services provides fast access to data by means of multidimensional data structures and the multidimensional query language MDX. Analysis Services provides the capability to design, create, and manage multidimensional cubes based on data warehouse tables, and it serves as the foundation for the Microsoft Business Intelligence strategy.

Microsoft SQL Server 2005 Reporting Services

Author: Brian Larson
Publisher: McGraw-Hill Education; 2 edition
Publication date: January 2, 2006
Format: Kindle, Paperback
Price: Kindle $51.72, Paperback $45.37
Description: Microsoft’s Reporting Services product is a vital part of the SQL Server 2005 business intelligence platform, but it works with virtually any data source. This hands-on guide explains how to transform data into insightful and interactive Web-based reports using Microsoft SQL Server 2005 Reporting Services. With coverage of everything from installation to administration, the book demonstrates how to use this powerful server-based reporting solution to improve business decision-making and facilitate company-wide — even worldwide — communication.

Microsoft SQL Server 2008 All-in-One Desk Reference for Dummies

Author: Robert D. Schneider,‎ Darril Gibson
Publisher: For Dummies; 1 edition
Publication date: September 29, 2008
Format: Kindle, Paperback
Price: Kindle $21.18, Paperback $18.58
Description: If you’re in charge of database administration, developing database software, or looking for database solutions for your company, Microsoft SQL Server 2008 All-In-One Desk Reference for Dummies can help you get a handle on this extremely popular relational database management system. Here you’ll find what’s new in the latest version; how to choose and install the right variation for your needs; how to monitor, maintain, and protect your data; and what it takes to keep your database healthy.

Microsoft SQL Server 2008 for Dummies

Author: Mike Chapple
Publisher: For Dummies; 1 edition
Publication date: September 22, 2008
Format: Kindle, Paperback
Price: Kindle $21.59, Paperback $27.07
Description: If you’re a database administrator, you know Microsoft SQL Server 2008 is revolutionizing database development. Get up to speed on SQL Server 2008, impress your boss, and improve your company’s data management — read Microsoft SQL Server 2008 for Dummies! SQL Server 2008 lets you build powerful databases and create database queries that give your organization the information it needs to excel. Microsoft SQL Server 2008 for Dummies helps you build the skills you need to set up, administer, and troubleshoot SQL Server 2008.

Microsoft SQL Server 2008 R2 Unleashed

Author: Ray Rankins,‎ Paul Bertucci,‎ Chris Gallelli,‎ Alex T. Silverstein
Publisher: Sams Publishing; 1 edition
Publication date: September 26, 2010
Format: Kindle, Paperback
Price: Kindle $33.59, Paperback $6.05
Description: This is the industry’s most comprehensive and useful guide to SQL Server 2008 and 2008 R2. It presents start-to-finish coverage of SQL Server’s core database server and management capabilities, plus complete introductions to Integration, Reporting, and Analysis Services, application development, and much more. Four expert SQL Server administrators, developers, and consultants have packed this book with real-world information, tips, guidelines, and samples drawn from their own extensive experience creating and managing complex database solutions. Writing for intermediate-to-advanced-level SQL Server professionals, they focus on the product’s most complex and powerful capabilities, and its newest tools and features. For example, you’ll find invaluable information on administering SQL Server more efficiently, analyzing and optimizing queries, implementing data warehouses, ensuring high availability, and tuning performance.

Microsoft SQL Server 2008 Reporting Services

Author: Brian Larson
Publisher: McGraw-Hill Osborne; 3 edition
Publication date: October 1, 2008
Format: Paperback
Price: $101.60
Description: Not available

Microsoft SQL Server 2008: A Beginner’s Guide

Author: Dusan Petkovic
Publisher: McGraw-Hill Education
Publication date: July 30, 2008
Format: Paperback
Price: $160.96
Description: Not available

Microsoft SQL Server 2012 Administration

Author: Tom Carpenter
Publisher: Sybex; 1 edition
Publication date: June 17, 2013
Format: Kindle, Paperback
Price: Kindle $36.08, Paperback 34.99
Description: As the most significant update since 2008, Microsoft SQL Server 2012 boasts updates and new features that are critical to understand. Whether you manage and administer SQL Server 2012 or are planning to get your MCSA: SQL Server 2012 certification, this book is the perfect supplement to your learning and preparation. From understanding SQL Server’s roles to implementing business intelligence and reporting, 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.

Microsoft SQL Server 2012 High-Performance T-SQL Using Window Functions

Author: Itzik Ben-Gan
Publisher: Microsoft Press; 1 edition
Publication date: April 25, 2012
Format: Kindle, Paperback
Price: Kindle $19.43, Paperback $28.92
Description: Optimize your queries—and obtain simple and elegant solutions to a variety of problems—using window functions in Transact-SQL. Led by T-SQL expert Itzik Ben-Gan, you’ll learn how to apply calculations against sets of rows in a flexible, clear, and efficient manner. Ideal whether you’re a database administrator or developer, this practical guide demonstrates ways to use more than a dozen T-SQL querying solutions to address common business tasks.

Microsoft SQL Server 2012 Internals (Developer Reference)

Author: Kalen Delaney, Bob Beauchemin, Conor Cunningham, Jonathan Kehayias, Paul S. Randal, Benjamin Nevarez
Publisher: Microsoft Press; 1 edition
Publication date: November 25, 2013
Format: Kindle, Paperback
Price: Kindle $34.79, Paperback $21.53
Description: Microsoft SQL Server 2012 Internals is discovering how to Dig into SQL Server 2012 architecture and configuration; Use the right recovery model and control transaction logging; Reduce query execution time through proper index design; Track events, from triggers to the Extended Event Engine; Examine internal structures with database console commands; Transcend row-size limitations with special storage capabilities; Choose the right transaction isolation level and concurrency model; Take control over query plan caching and reuse.

Microsoft SQL Server 2012 Reporting Services 4/E

Author: Brian Larson
Publisher: McGraw-Hill Education; 4 edition
Publication date: March 22, 2012
Format: Paperback
Price: Paperback $38.95
Description: Create, deploy, and manage business intelligence reports using the expert tips and best practices in this hands-on resource. Written by a member of the original Reporting Services development team, Microsoft SQL Server 2012 Reporting Services, Fourth Edition covers the complete process of building and distributing reports and explains how to maximize all of the powerful, integrated SSRS capabilities, including the new and enhanced features. A detailed case study and sample reports are included in this practical reference

Microsoft SQL Server 2012 Step by Step

Author: Patrick LeBlanc
Publisher: Microsoft Press; 1 edition
Publication date: February 15, 2013
Format: Kindle, Paperback
Price: Kindle $28.19, Paperback $34.94
Description: Teach 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.

Microsoft SQL Server 2012 T-SQL Fundamentals (Developer Reference)

Author: Itzik Ben-Gan
Publisher: Microsoft Press; 1 edition
Publication date: July 15, 2012
Format: Kindle, Paperback
Price: Kindle $28.92, Paperback $15.05
Description: 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.

Microsoft SQL Server 2016: A Beginner’s Guide, Sixth Edition

Author: Dusan Petkovic
Publisher: McGraw-Hill Education; 6 edition
Publication date: October 14, 2016
Format: Kindle, Paperback
Price: Kindle $31.79, Paperback from $24.04
Description: Filled with new real-world examples and hands-on exercises, Microsoft SQL Server 2016: A Beginner’s Guide, Sixth Edition, starts by explaining fundamental relational database system concepts. From there, you will learn how to write Transact-SQL statements, execute simple and complex database queries, handle system administration and security, and use the powerful analysis and BI tools. XML, spatial data, and full-text search are also covered in this step-by-step tutorial.

Microsoft SQL Server T-SQL in 10 Minutes, Sams Teach Yourself

Author: Ben Forta
Publisher: Sams Publishing; 2 edition
Publication date: December 28, 2016
Format: Kindle, Paperback
Price: Kindle $16.19, Paperback $25.49
Description: 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.

Microsoft® SQL Server® 2008 Internals (Developer Reference)

Author: Kalen Delaney,‎ Paul S. Randal,‎ Kimberly L. Tripp,‎ Conor Cunningham,‎ Adam Machanic,‎ Benjamin Nevarez
Publisher: Microsoft Press; 1 edition
Publication date: March 11, 2009
Format: Kindle, Paperback
Price: Kindle $33.59, Paperback from $0.01
Description: Delve inside the core SQL Server engine—and put that knowledge to work—with guidance from a team of well-known internals experts. Whether database developer, architect, or administrator, you’ll gain the deep knowledge you need to exploit key architectural changes—and capture the product’s full potential.

Microsoft® SQL Server® 2008 Step by Step

Author: Mike Hotek
Publisher: Microsoft Press; 1 edition
Publication date: November 12, 2008
Format: Kindle, Paperback
Price: Kindle $29.55, Paperback from $25.92
Description: Teach yourself SQL Server 2008—one step at a time. Get the practical guidance you need to build database solutions that solve real-world business problems. Learn to integrate SQL Server data in your applications, write queries, develop reports, and employ powerful business intelligence systems.

Microsoft® SQL Server® 2008 T-SQL Fundamentals

Author: Itzik Ben-Gan
Publisher: Microsoft Press; 1 edition
Publication date: October 22, 2008
Format: Kindle, Paperback
Price: Kindle $28.19, Paperback $13.87
Description: Master the foundations of T-SQL with the right balance of conceptual and practical content. Get hands-on guidance—including exercises and code samples—that show you how to develop code to query and modify data. You’ll gain a solid understanding of the T-SQL language and good programming practices, and learn to write more efficient and powerful queries.

Murach’s SQL Server 2008 for Developers

Author: Joel Murach, Bryan Syverson
Publisher: Mike Murach & Associates; 3rd edition
Publication date: November 24, 2008
Format: Paperback
Price: $14.95
Description: This book is designed to teach application developers all of the skills they need to use SQL to work with a Microsoft SQL Server 2008 database. But it’s also a great first book for developers who are on the path to becoming a DBA. Unlike most SQL Server 2008 books, this one starts by showing you how to use SQL queries to extract and update the data in a database, because that’s what every application developer needs to know first. Then, it shows how to design and implement a database, how to use powerful backend database features like views, stored procedures, functions, triggers, cursors, transactions, locking, security, and how to work with BLOB and XML data. Finally, it shows how to use the CLR integration feature to create database objects using a .NET language such as C# or Visual Basic.

Murach’s SQL Server 2016 for Developers

Author: Joel Murach, Bryan Syverson
Publisher: Mike Murach & Associates
Publication date: June 30, 2016
Format: Paperback
Price: $54.62
Description: If you’re an application developer, or you’re training to be one, this 2016 edition of Murach’s classic SQL Server book is made for you. To start, it presents the SQL statements that you need to retrieve and update the data in a database. These are the SQL statements that you’ll use every day. Then, it shows you how to design a database, how to implement that design, and how to work with database features like views, scripts, stored procedures, functions, triggers, transactions, security, XML data, BLOB data with FILESTREAM storage, and the CLR integration feature.

Pro SQL Server Internals

Author: Dmitri Korotkevitch
Publisher: Apress; 1 edition
Publication date: June 14, 2014
Format: Kindle, Paperback
Price: Kindle $50.39, Paperback $59.99
Description: Pro SQL Server Internals explains how different SQL Server components work “under the hood” and how they communicate with each other. This is the practical book with a large number of examples that will show you how various design and implementation decisions affect the behavior and performance of your systems. Pro SQL Server Internals covers multiple SQL Server versions starting with SQL Server 2005 all the way up to the recently released SQL Server 2014. You’ll learn about new SQL Server 2014 features including the new Cardinality Estimator, In-Memory OLTP Engine (codename Hekaton), and Clustered Columnstore Indexes. With Pro SQL Server Internals, you have a solid roadmap for understanding the depth and power of the SQL Server database backend, regardless of the version and edition of SQL Server you use.

Pro SQL Server Relational Database Design and Implementation

Author: Louis Davidson,‎ Jessica Moss
Publisher: Apress; 5th ed. edition
Publication date: December 30, 2016
Format: Kindle, Paperback
Price: Kindle $53.99, Paperback $59.99
Description: Learn effective and scalable database design techniques in a SQL Server 2016 and higher environment. This book is revised to cover in-memory online transaction processing, temporal data storage, row-level security, durability enhancements, and other design-related features that are new or changed in SQL Server 2016. Designing an effective and scalable database using SQL Server is a task requiring skills that have been around for forty years coupled with technology that is constantly changing. Pro SQL Server Relational Database Design and Implementation covers everything from design logic that business users will understand, all the way to the physical implementation of design in a SQL Server database. Grounded in best practices and a solid understanding of the underlying theory, Louis Davidson shows how to “get it right” in SQL Server database design and lay a solid groundwork for the future use of valuable business data.

Professional Microsoft SQL Server 2012 Integration Services

Author: Brian Knight,‎ Erik Veerman,‎ Jessica M. Moss,‎ Mike Davis,‎ Chris Rock
Publisher: Wrox; 1 edition
Publication date: March 27, 2012
Format: Kindle, Paperback
Price: Kindle $30.80, Paperback $34.16
Description: Microsoft SQL Server 2012 Integration Services (SISS) builds on the revolutionary database product suite first introduced in 2005. With this crucial resource, you will explore how this newest release serves as a powerful tool for performing extraction, transformation, and load operations (ETL). A team of SQL Server experts deciphers this complex topic and provides detailed coverage of the new features of the 2012 product release. In addition to technical updates and additions, the authors present you with a new set of SISS best practices, based on years of real-world experience that have transpired since the previous edition was published.

Professional Microsoft SQL Server 2014 Integration Services

Author: Brian Knight
Publisher: Unknown
Publication date: August 2, 2017
Format: Kindle, Paperback
Price: Kindle $12, Paperback $42.17
Description: The 2014 release of Microsoft′s SQL Server Integration Services provides enhancements for managing extraction, transformation, and load operations, plus expanded in–memory capabilities, improved disaster recovery, increased scalability, and much more. The increased functionality will streamline your ETL processes and smooth out your workflow, but the catch is that your workflow must change. New tools come with new best practices, and Professional Microsoft SQL Server 2014 Integration Services will keep you ahead of the curve.

Professional Microsoft SQL Server 2016 Reporting Services and Mobile Reports

Author: Paul Turley, Riccardo Muti, Christopher Finlan
Publisher: Wrox
Publication date: August 2, 2017
Format: Kindle, Paperback
Price: Kindle $27.79, Paperback $23.98
Description: 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.

Professional SQL Server 2000 Programming

Author: Rob Vieira
Publisher: Peer Information; illustrated edition edition
Publication date: August 31, 2000
Format: Kindle, Paperback
Price: Kindle $27.20, Paperback from $4.97
Description: Microsoft SQL Server 2000 will be a significant new revision of the fastest rising player in the RDBMS marketplace. Microsoft is actively encouraging a growing number of users onto the SQL platform, by making it cheaply available. The new release, SQL 2000, is tightly integrated with Windows 2000, offering more support for XML and much improved OLAP (Online Analytical Processing) services. SQL Server is very strong in the market place, supporting both small and large Internet sites. Large users include Merryl Lynch, DELL Computer and HarperCollins Publishers. Commercial applications running on SQL Server range in size from small databases such as Sales Logix, to large ERP systems such as SAP, where it is now the SAP “preferred” database for NT based installations. SQL Server is now first choice for the developer wanting a powerful, reliable and sophisticated database.

Professional SQL Server 2005 Integration Services

Author: Brian Knight,‎ Allan Mitchell,‎ Darren Green,‎ Douglas Hinson,‎ Kathi Kellenberger,‎ Andy Leonard,‎ Erik Veerman,‎ Jason Gerard,‎ Haidong Ji,‎ Mike Murphy
Publisher: Wrox; 1 edition
Publication date: January 31, 2006
Format: Paperback, Digital
Price: Paperback from $1.80, Digital $9.99
Description: This book will help you get past the initial learning curve quickly so that you can get started using SSIS to transform data, create a workflow, or maintain your SQL Server. Offering you hands-on guidance, you’ll learn a new world of integration possibilities and be able to move away from scripting complex logic to programming tasks using a full-featured language.

Professional SQL Server 2012 Internals and Troubleshooting

Author: Christian Bolton,‎ Rob Farley,‎ Glenn Berry,‎ Justin Langford,‎ Gavin Payne,‎ Amit Banerjee
Publisher: Wrox; 1 edition
Publication date: November 6, 2012
Format: Kindle, Paperback
Price: Kindle $35.74, Paperback $31.35
Description: The 2012 release of SQL Server is the most significant one since 2005 and introduces an abundance of new features. This critical book provides in-depth coverage of best practices for troubleshooting performance problems based on a solid understanding of both SQL Server and Windows internals and shows experienced DBAs how to ensure reliable performance. The team of authors shows you how to master the use of specific troubleshooting tools and how to interpret their output so you can quickly identify and resolve any performance issue on any server running SQL Server.

Professional SQL Server 7.0 Programming

Author: Rob Vieira
Publisher: Unknown
Publication date: November 30, 1998
Format: Paperback
Price: from $5.69
Description: With the big step up from 6.5 to 7.0, SQL Server 7.0 is effectively a new product that can be installed on a pc. This enables a more flexible and powerful database for high database transaction volume. Microsoft SQL Server 7.0 is available as a standalone product and also as part of the Microsoft Backoffice suite of products. The adoption of SQL Server 7.0 is reflected in increasing sales figures for competing titles.

Sams Teach Yourself Microsoft SQL Server T-SQL in 10 Minutes

Author: Ben Forta
Publisher: Sams Publishing; 1 edition
Publication date: August 12, 2007
Format: Kindle, Paperback
Price: Kindle $16.19, Paperback $20.25
Description: Sams Teach Yourself Microsoft SQL Server T-SQL in 10 Minutes offers straightforward, practical answers when you need fast results. By working through 10-minute lessons, you’ll learn everything 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, and much more.

Securing SQL Server, Third Edition: Protecting Your Database from Attackers

Author: Denny Cherry
Publisher: Syngress; 3 edition
Publication date: May 7, 2015
Format: Kindle, Paperback
Price: Kindle $47.35 , Paperback $49.95
Description: SQL server is the most widely-used database platform in the world, and a large percentage of these databases are not properly secured, exposing sensitive customer and business data to attack. In Securing SQL Server, Third Edition, you will learn about the potential attack vectors that can be used to break into SQL server databases as well as how to protect databases from these attacks. In this book, Denny Cherry – a Microsoft SQL MVP and one of the biggest names in SQL server – will teach you how to properly secure an SQL server database from internal and external threats using best practices as well as specific tricks that the author employs in his role as a consultant for some of the largest SQL server deployments in the world.

SQL

Author: Chris Fehily
Publisher: Peachpit Press; 1 edition
Publication date: July 29, 2002
Format: Paperback
Price: from $21.99
Description: Database management. It may sound daunting, but it doesn’t have to be, even if you’ve never programmed before. SQL: Visual QuickStart Guide isn’t an exhaustive guide to SQL written for aspiring programming experts. It’s simply an invaluable resource for those who want a fast, easy way to harness information living in complex databases. Because author Chris Fehily assumes no prior programming experience on your part (just a familiarity with your OS’s file system), he spends the first few chapters laying out the basics, including clear explanations of the relational database model and SQL syntax. Then he jumps into step-by-step tasks designed to get you comfortable using SQL right away.

SQL (Database Programming)

Author: Chris Fehily
Publisher: Questing Vole Press
Publication date: July 14, 2014
Format: Kindle, Paperback
Price: Kindle $11.99, Paperback $24.99
Description: 2015 Edition. Perfect for end users, analysts, data scientists, and app developers, this best-selling guide will get you up and running with SQL, the language of databases. You’ll find general concepts, practical answers, and clear explanations of what the various SQL statements can do. Hundreds of examples of varied difficulty encourage you to experiment and explore. Full-color SQL code listings help you see the elements and structure of the language. You can download the sample database to follow along with the author’s examples.

SQL Antipatterns: Avoiding the Pitfalls of Database Programming

Author: Bill Karwin
Publisher: Pragmatic Bookshelf; 1 edition
Publication date: July 5, 2010
Format: Kindle, Paperback
Price: Kindle $26.17, Paperback $22.96
Description: Bill Karwin has helped thousands of people write better SQL and build stronger relational databases. Now he’s sharing his collection of antipatterns–the most common errors he’s identified in those thousands of requests for help. Most developers aren’t SQL experts, and most of the SQL that gets used is inefficient, hard to maintain, and sometimes just plain wrong. This book shows you all the common mistakes, and then leads you through the best fixes. What’s more, it shows you what’s behind these fixes, so you’ll learn a lot about relational databases along the way.

SQL Cookbook: Query Solutions and Techniques for Database Developers

Author: Anthony Molinaro
Publisher: O’Reilly Media; 1 edition
Publication date: December 26, 2005
Format: Kindle, Paperback
Price: Kindle $21.59, Paperback $32.59
Description: You know the rudiments of the SQL query language, yet you feel you aren’t taking full advantage of SQL’s expressive power. You’d like to learn how to do more work with SQL inside the database before pushing data across the network to your applications. You’d like to take your SQL skills to the next level. Let’s face it, SQL is a deceptively simple language to learn, and many database developers never go far beyond the simple statement: SELECT columns FROM table WHERE conditions. But there is so much more you can do with the language. In the SQL Cookbook, experienced SQL developer Anthony Molinaro shares his favorite SQL techniques and features.

SQL Data Warehouse Database Management , SQL Server, Structured Query Language, Business Intelligence, Data Models: Master SQL Programming

Author: William Sullivan
Publisher: CreateSpace Independent Publishing Platform
Publication date: April 4, 2018
Format: Kindle, Paperback
Price: Kindle $3.59, Paperback $14.37
Description: This is my second book in the SQL series… This book breaks down the fundamentals elements that are essential to make you proficient in SQL Data Warehouse Database Management. By the end of this book you will be confident enough to take on any problems that encompass SQL. The demand for SQL professionals is HUGE and the opportunities are endless! Learn how to easily master it and land yourself high grade paying jobs or free-lance work.

SQL for Beginners: Learn the Structured Query Language for the Most Popular Databases including Microsoft SQL Server, MySQL, MariaDB, PostgreSQL, and Oracle

Author: Preston Prescott
Publisher: CreateSpace Independent Publishing Platform
Publication date: February 16, 2015
Format: Kindle, Paperback
Price: Kindle $3.59 , Paperback $14.98
Description: Knowing how to craft SQL queries and navigate your way around a database is an essential skill if are a Database Administrator, System Administrator, or Programmer. Step-by-Step in Plain English This book guides you step-by-step by teaching you how to create databases, populate those databases with data, extract just the data you need, and much more. The book uses plain, clear, and concise language all geared to helped you learn SQL in the easiest manner possible.

SQL for Dummies

Author: Allen G. Taylor
Publisher: For Dummies; 8 edition
Publication date: September 3, 2013
Format: Kindle, Paperback
Price: Kindle $19.19, Paperback $16.84
Description: 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.

SQL Fundamentals

Author: John J. Patrick
Publisher: Prentice Hall; 3 edition
Publication date: September 12, 2008
Format: Kindle, Paperback
Price: Kindle $32.16, Paperback $42.21
Description: Don’t just learn “generic” SQL. Learn SQL to get results with the world’s top database platforms–Oracle for the enterprise and Microsoft Access for the desktop. Based on John Patrick’s hands-on SQL course at the University of California, Berkeley Extension, this book shows exactly how to retrieve the data you want, when you need it, in any application–from ad hoc reports to the data warehouse. Thoroughly updated for the newest versions of Oracle, Access, and the SQL standard, this book contains more exercises, techniques, and solutions than ever before. You’ll learn exactly how to write SQL queries that are easy to understand, verify, modify, and extend–even if you’ve never worked with databases before.

SQL in 10 Minutes, Sams Teach Yourself

Author: Ben Forta
Publisher: Sams Publishing; 4 edition
Publication date: November 4, 2012
Format: Kindle, Paperback
Price: Kindle $17.27, Paperback $19.88
Description: Whether you’re an application developer, database administrator, web application designer, mobile app developer, or Microsoft Office users, a good working knowledge of SQL is an important part of interacting with databases. And Sams Teach Yourself SQL in 10 Minutes offers the straightforward, practical answers you need to help you do your job. Expert trainer and popular author Ben Forta teaches you just the parts of SQL you need to know–starting with simple data retrieval and quickly going on to more complex topics including the use of joins, subqueries, stored procedures, cursors, triggers, and table constraints. You’ll learn methodically, systematically, and simply–in 22 short, quick lessons that will each take only 10 minutes or less to complete.

SQL in a Nutshell: A Desktop Quick Reference Guide

Author: Kevin Kline,‎ Brand Hunt,‎ Daniel Kline
Publisher: O’Reilly Media; 3 edition
Publication date: December 5, 2008
Format: Kindle, Paperback
Price: Kindle $23.75, Paperback $24.28
Description: For programmers, analysts, and database administrators, SQL in a Nutshell is the essential reference for the SQL language used in today’s most popular database products. This new edition clearly documents every SQL command according to the latest ANSI standard, and details how those commands are implemented in Microsoft SQL Server 2008, Oracle 11g, and the MySQL 5.1 and PostgreSQL 8.3 open source database products. You’ll also get a concise overview of the Relational Database Management System (RDBMS) model, and a clear-cut explanation of foundational RDBMS concepts — all packed into a succinct, comprehensive, and easy-to-use format.

SQL Pocket Guide: A Guide to SQL Usage

Author: Jonathan Gennick
Publisher: O’Reilly Media; 3 edition
Publication date: December 4, 2010
Format: Kindle, Paperback, Unknown Binding
Price: Kindle $11.51, Paperback $12.33, Unknown Binding $58.85
Description: If 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.

SQL Practice Problems: 57 beginning, intermediate, and advanced challenges for you to solve using a “learn-by-doing” approach

Author: Sylvia Moestl Vasilik
Publisher: Independently published
Publication date: March 13, 2017
Format: Kindle, Paperback
Price: Kindle $11.99, Paperback $16.03
Description: It’s easy to find basic SQL syntax and keyword information online. What’s hard to find is challenging, well-designed, real-world problems–the type of problems that come up all the time when you’re dealing with data. Learning how to solve these problems will give you the skill and confidence to step up in your career. With SQL Practice Problems, you can get that level of experience by solving sets of targeted problems. These aren’t just problems designed to give an example of specific syntax. These are the most common problems you encounter when you deal with data. You will get real world practice, with real world data. I’ll teach you how to “think” in SQL, how to analyze data problems, figure out the fundamentals, and work towards a solution that you can be proud of. It contains challenging problems, which develop your ability to write high quality SQL code.

SQL Programming & Database Management for Absolute Beginners SQL Server

Author: William Sullivan
Publisher: Unknown
Publication date: November 9, 2017
Format: Kindle, Paperback
Price: Kindle $3.59, Paperback $17.38
Description: This book breaks down the fundamentals elements that are essential to make you proficient in SQL programming and database management. By the end of this book you will be confident enough to take on any problems that encompass SQL. SQL software can be complex, but a powerful tool if used with the right understanding. In this book you will discover how SQL is simple, flexible, portable and most of all well integrated to various database applications. The demand for SQL professionals is HUGE and the opportunities are endless! Learn how to easily master it and land yourself high grade paying jobs or free-lance work.

SQL Queries for Mere Mortals: A Hands-On Guide to Data Manipulation in SQL

Author: John L. Viescas,‎ Michael J. Hernandez
Publisher: Addison-Wesley Professional; 3 edition
Publication date: June 21, 2014
Format: Kindle, Paperback
Price: Kindle $28.19, Paperback $30.76
Description: SQL Queries for Mere Mortals ® has earned worldwide praise as the clearest, simplest tutorial on writing effective SQL queries. The authors have updated this hands-on classic to reflect new SQL standards and database applications and teach valuable new techniques. Step by step, John L. Viescas and Michael J. Hernandez guide you through creating reliable queries for virtually any modern SQL-based database. They demystify all aspects of SQL query writing, from simple data selection and filtering to joining multiple tables and modifying sets of data. Three brand-new chapters teach you how to solve a wide range of challenging SQL problems. You’ll learn how to write queries that apply multiple complex conditions on one table, perform sophisticated logical evaluations, and think “outside the box” using unlinked tables.

SQL QuickStart Guide: The Simplified Beginner’s Guide To SQL

Author: ClydeBank Technology
Publisher: CreateSpace Independent Publishing Platform
Publication date: March 11, 2015
Format: Kindle, Paperback
Price: Kindle $5.99, Paperback $14.99
Description: Structured Query Language or SQL (pronounced sequel by many) is the most widely used programming language used in database management and is the standard language for Relational Database Management Systems (RDBMS). SQL programming allows users to return, analyze, create, manage and delete data within a database – all within a few commands. With more industries and organizations looking to the power of data, the need for an efficient, scalable solution for data management is required. More often than not, organizations implement a Relational Database Management System in one form or another. These systems create long-term data “warehouses” that can be easily accessed to return and analyze results, such as, “Show me all of the clients from Canada that have purchased more than $20,000 in the last 3 years.” This “query,” which would have taken an extensive amount of hands-on research to complete prior to the use of database, can now be determined in seconds by executing a simple SELECT SQL statement on a database.

SQL Server 2000 Stored Procedure Programming

Author: Dejan Sunderic
Publisher: McGraw-Hill/OsborneMedia; 1st edition
Publication date: October 2, 2000
Format: Paperback
Price: $49.90
Description: This is a guide to building and using stored procedures in SQL server applications. Stored procedures are used for a variety of complex data gathering tasks, to optimize performance.

Sql Server 2008 Administration in Action

Author: Rod Colledge
Publisher: Dreamtech Press India Pvt. Ltd
Publication date: Unknown
Format: Paperback
Price: $78.86
Description: Not available

SQL Server 2008 Query Performance Tuning Distilled

Author: Sajal Dam, Grant Fritchey
Publisher: Apress; 1st ed. edition
Publication date: March 16, 2009
Format: Paperback
Price: $41.22
Description: SQL Server 2008 Query Performance Tuning Distilled presents a direct trouble–shooting methodology for identifying poorly-performing stored procedures and queries, isolating the causes of that poor performance, and fixing the underlying problems. Each chapter is dedicated to one of the top causes of poorly performing queries and shows methods for identifying and dealing with the problems in that chapter’s domain. Emphasis is always put upon or placed upon practical methods that you can put to immediate use in your day–to–day work. SQL Server 2008 functionality, tips, and tricks are emphasized in each subject area.

SQL Server 2012 T-SQL Recipes: A Problem-Solution Approach

Author: Jason Brimhall, David Dye, Jonathan Gennick, Tim Roberts
Publisher: Apress; 3 edition
Publication date: 2012
Format: Paperback
Price: $119.56
Description: Not available

SQL Server 2016 Reporting Services Cookbook

Author: Dinesh Priyankara, Robert C. Cain
Publisher: Packt Publishing – ebooks Account
Publication date: November 29, 2016
Format: Kindle, Paperback
Price: Kindle $38.06, Paperback $34.99
Description: Key Features: 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

SQL Server Execution Plans

Author: Grant Fritchey
Publisher: Red Gate Books
Publication date: October 12, 2012
Format: Paperback
Price: $61.95
Description: Every day, out in the various online forums devoted to SQL Server, and on Twitter, the same types of questions come up repeatedly: Why is this query running slowly? Why is SQL Server ignoring my index? Why does this query run quickly sometimes and slowly at others? My response is the same in each case: have you looked at the execution plan? An execution plan describes what’s going on behind the scenes when SQL Server executes a query. It shows how the query optimizer joined the data from the various tables defined in the query, which indexes it used, if any, how it performed any aggregations or sorting, and much more. It also estimates the cost of all of these operations, in terms of the relative load placed on the system. Every Database Administrator, developer, report writer, and anyone else who writes T-SQL to access SQL Server data, must understand how to read and interpret execution plans. My book leads you right from the basics of capturing plans, through how to interrupt them in their various forms, graphical or XML, and then how to use the information you find there to diagnose the most common causes of poor query performance, and so optimize your SQL queries, and improve your indexing strategy.

SQL Server Internals: In-Memory OLTP

Author: Kalen Delaney
Publisher: Red Gate Books
Publication date: October 10, 2014
Format: Kindle, Paperback
Price: Kindle $11.99, Paperback $25.18
Description: The SQL Server 2014 In-Memory OLTP engine (a.k.a. Hekaton) is designed from the ground up to exploit terabytes of available memory and high numbers of processing cores. It allows us to work with memory-optimized tables and indexes, and natively compiled stored procedures, in addition to the disk-based tables and indexes, and T-SQL stored procedures, that SQL Server has always provided. Hekaton in-memory data is accessible, transparently, using familiar interfaces such as T-SQL and SSMS, but Hekaton’s internal behavior and capabilities are very different than those of the standard relational engine. Everything you knew about how your SQL Server stores and accesses data is different in Hekaton. Everything you understood about how multiple concurrent processes are handled needs to be reconsidered. In this book, Kalen Delaney explains how the new In-Memory OLTP engine works, how it stores and manipulates data, and how, even with all data stored in memory and no locking or latching, it can still guarantee the ACID properties of all transactions. Kalen has been working with SQL Server since 1987, specializing in query performance tuning and SQL Server internals. The Hekaton internals knowledge she provides in this book will help you migrate existing tables or databases to Hekaton, and get faster performance from your SQL Server applications than you ever thought possible.

SQL Server Interview Questions and Answers

Author: Pinal Dave, Vinod Kumar
Publisher: Joes 2 Pros International LLC
Publication date: January 1, 2011
Format: Kindle, Paperback
Price: Kindle $11.99, Paperback $9.99
Description: This book will flow in a “Question & Answer” mode from start to finish to help you grasp concepts faster and get to the point quickly. Once you understand the concepts, it gets easier to see twists using that concept within a scenario and to ultimately solve them. Though each of these chapters are geared towards convenience we highly recommend reading each of the sections irrespective of the roles you might be doing since each of the sections have some interesting trivia about working with SQL Server. In the industry the role of accidental DBA’s (especially with SQL Server) is very common. Hence if you have performed the role of DBA for a short stint and want to brush-up your fundamentals then the upcoming sections will be a great review.

SQL Server MVP Deep Dives

Author: Paul Nielson, Kalen Delaney, Adam Machanic, Kimberly Tripp, Paul Randal, Greg Low
Publisher: Manning Publications; 1 edition
Publication date: December 23, 2009
Format: Paperback
Price: $40.84
Description: SQL Server MVP Deep Dives is organized into five parts: Design and Architecture, Development, Administration, Performance Tuning and Optimization, and Business Intelligence. Within each part, you’ll find a collection of brilliantly concise and focused chapters that take on key topics like mobile data strategies, Dynamic Management Views, or query performance. The range of subjects covered is comprehensive, from database design tips to data profiling strategies for BI.

SQL Server MVP Deep Dives, Volume 2

Author: Kalen Delaney, Louis Davidson,‎ Greg Low,‎ Brad McGhee,‎ Paul Nielson,‎ Paul Randal,‎ Kimberly Tripp
Publisher: Manning Publications; 1 edition
Publication date: October 24, 2011
Format: Paperback
Price: $49.35
Description: SQL Server MVP Deep Dives, Volume 2 is a unique book that lets you learn from the best in the business – 64 SQL Server MVPs offer completely new content in this second volume on topics ranging from testing and policy management to integration services, reporting, and performance optimization techniques…and more.

SQL Server Query Performance Tuning

Author: Grant Fritchey
Publisher: Apress; 4th ed. edition
Publication date: August 28, 2014
Format: Kindle, Paperback
Price: Kindle $50.39, Paperback $50.24
Description: Queries not running fast enough? Wondering about the in-memory database features in 2014? Tired of phone calls from frustrated users? Grant Fritchey’s book SQL Server Query Performance Tuning is the answer to your SQL Server query performance problems. The book is revised to cover the very latest in performance optimization features and techniques, especially including the newly-added, in-memory database features formerly known under the code name Project Hekaton. This book provides the tools you need to approach your queries with performance in mind.

SQL: Easy SQL the Programming & Database Management for Beginners, Your Step-By-Step Guide to Learning the SQL Database (SQL Series Book 1)

Author: Felix Alvaro
Publisher: Unknown
Publication date: November 3, 2016
Format: Kindle, Paperback
Price: Kindle $1.19, Paperback $19.95
Description: “Easy SQL Programming & Database Management For Beginners, Your Step-By-Step Guide To Learning The SQL Database” by Felix Alvaro is the book for you! It breaks down the fundamental elements that are essential to make you a confident SQL programmer and proficient in Database Management. SQL is a software language that is powerful yet simple, flexible, portable and, most of all, integrated into numerous database applications. The current trend now is to become more digital in managing databases.

SQL: Learn the Structured Query Language for the Most Popular Databases including Microsoft SQL Server, MySQL, MariaDB, PostgreSQL, and Oracle

Author: Preston Prescott
Publisher: Unknown
Publication date: February 15, 2015
Format: Kindle, Paperback
Price: Kindle $3.59, Paperback $14.98
Description: Knowing how to craft SQL queries and navigate your way around a database is an essential skill if are a Database Administrator, System Administrator, or Programmer. This book guides you step-by-step by teaching you how to create databases, populate those databases with data, extract just the data you need, and much more. The book uses plain, clear, and concise language all geared to helped you learn SQL in the easiest manner possible.

SQL: The Ultimate Beginner’s Guide!

Author: Andrew Johansen
Publisher: CreateSpace Independent Publishing Platform
Publication date: November 27, 2015
Format: Kindle, Paperback
Price: Kindle $1.19, Paperback $12.99
Description: This book will teach you the basics of SQL and database operations. Since SQL is a language used to manage databases, you have to familiarize yourself with its basics and nuances. Don’t worry if you have never used SQL before: this book will turn you from a beginner to an efficient SQL-user. This book will cover important topics about SQL. For instance, a chapter focuses on the operators that you can use. Another chapter, however, concentrates on giving you accurate results from your database queries. Overall, you’ll be an effective SQL user after reading this book.

SQL: The Ultimate Beginners Guide: Learn SQL Today

Author: Steve Tale
Publisher: CreateSpace Independent Publishing Platform
Publication date: June 4, 2016
Format: Kindle, Paperback
Price: Kindle $5.99, Paperback $16.99
Description: Learning the SQL language can be laborious and tedious, but if you have genuine interest in learning a new language and updating your skills, it could be relatively easy. In this book, all the basic information that you need to learn as a beginner are presented. All you have to do is to apply them. This book will serve as an essential guide for you, as a SQL beginner. In addition, the concepts of SQL are laid out in a simple, concise language and instructions to help you learn the steps properly. Specific examples and sample tables is showcased to help you practice most of the SQL queries.

SQL: The Ultimate Guide from Beginner to Expert – Learn and Master SQL In No Time!

Author: Peter Adams
Publisher: CreateSpace Independent Publishing Platform
Publication date: November 28, 2016
Format: Kindle, Paperback
Price: Kindle $3.59, Paperback $14.97
Description: Structured Query Language or SQL is famously used to interact with database. You may be working at a hotel, bank, government, or any industry, SQL is certainly a necessity to run your daily operations! SQL: The Ultimate Guide from Beginner to Expert – Learn and Master SQL In No Time is a book that will introduce you to a computer language that has helped so many business owners and information technologists with daily reports and database management without the fear of crashing.

SQL: Visual QuickStart Guide

Author: Chris Fehily
Publisher: Peachpit Press; 3 edition
Publication date: April 16, 2010
Format: Kindle, Paperback
Price: Kindle $28.92, Paperback $49.99
Description: SQL is a standard interactive and programming language for querying and modifying data and managing databases. This task-based tutorial and reference guide takes the mystery out learning and applying SQL. After going over the relational database model and SQL syntax in the first few chapters, veteran author Chris Fehily immediately launches into the tasks that will get readers comfortable with SQL. In addition to covering all the SQL basics, this thoroughly updated reference contains a wealth of in-depth SQL knowledge and serves as an excellent reference for more experienced users.

The Definitive Guide to DAX: Business intelligence with Microsoft Excel, SQL Server Analysis Services, and Power BI

Author: Alberto Ferrari, Marco Russo
Publisher: Microsoft Press; 1 edition
Publication date: October 23, 2015
Format: Kindle, Paperback
Price: Kindle $47.99, $Paperback $47.49
Description: This comprehensive and authoritative guide will teach you the DAX language for business intelligence, data modeling, and analytics. Leading Microsoft BI consultants Marco Russo and Alberto Ferrari help you master everything from table functions through advanced code and model optimization. You’ll learn exactly what happens under the hood when you run a DAX expression, how DAX behaves differently from other languages, and how to use this knowledge to write fast, robust code. If you want to leverage all of DAX’s remarkable power and flexibility, this no-compromise “deep dive” is exactly what you need.

The Guru’s Guide to Transact-SQL

Author: Ken Henderson, Joe Celko
Publisher: Addison-Wesley Professional; 1st edition
Publication date: March 4, 2000
Format: Kindle, Paperback
Price: Kindle $38.99, Paperback $40.10
Description: Since its introduction over a decade ago, the Microsoft SQL Server query language, Transact-SQL, has become increasingly popular and more powerful. The current version sports such advanced features as OLE Automation support, cross-platform querying facilities, and full-text search management. This book is the consummate guide to Microsoft Transact-SQL. From data type nuances to complex statistical computations to the bevy of undocumented features in the language, The Guru’s Guide to Transact-SQL imparts the knowledge you need to become a virtuoso of the language as quickly as possible.

Training Kit (Exam 70-461) Querying Microsoft SQL Server 2012 (MCSA) (Microsoft Press Training Kit)

Author: Dejan Sarka, Itzik Ben-Gan, Ron Talmage
Publisher: Microsoft Press; 1 edition
Publication date: December 25, 2012
Format: Paperback
Price: $29.27
Description: Ace your preparation for Microsoft Certification Exam 70-461 with this 2-in-1 Training Kit from Microsoft Press. Work at your own pace through a series of lessons and practical exercises, and then assess your skills with practice tests on CD–featuring multiple, customizable testing options.

Training Kit (Exam 70-462) Administering Microsoft SQL Server 2012 Databases (MCSA) (Microsoft Press Training Kit)

Author: Orin Thomas, Peter Ward, Bob Taylor
Publisher: Microsoft Press; 1 edition
Publication date: July 25, 2012
Format: Paperback
Price: $45.01
Description: Ace your preparation for the skills measured by Exam 70-462—and on the job—with this official Microsoft study guide. Work at your own pace through a series of lessons and reviews that fully cover each exam objective. Then, reinforce and apply what you’ve learned through real-world case scenarios and practice exercises.

Training Kit (Exam 70-463) Implementing a Data Warehouse with Microsoft SQL Server 2012 (MCSA) (Microsoft Press Training Kit)

Author: Dejan Sarka, Matija Lah, Grega Jerkic
Publisher: Microsoft Press; 1 edition
Publication date: December 25, 2012
Format: Paperback
Price: $29.26
Description: Ace your preparation for Microsoft Certification Exam 70-463 with this 2-in-1 Training Kit from Microsoft Press. Work at your own pace through a series of lessons and practical exercises, and then assess your skills with online practice tests—featuring multiple, customizable testing options.

Transact-SQL Programming

Author: Kevin Kline, Lee Gould, Andrew Zanevsky
Publisher: O’Reilly Media; First edition
Publication date: April 11, 1999
Format: Paperback
Price: from $2.99
Description: Transact-SQL is a procedural language used on both Microsoft SQL Server and Sybase SQL Server systems. It is a full-featured programming language that dramatically extends the power of SQL (Structured Query Language).

Troubleshooting SQL Server – A Guide for the Accidental DBA

Author: Jonathan Kehayias, Ted Krueger
Publisher: Red gate books
Publication date: September 26, 2011
Format: Kindle, Paperback
Price: Kindle $11.99, Paperback $28.17
Description: We spend much of our working life trying to help people solve SQL Server-related performance problems, either hands-on, during consulting, or on various online community forums. Over the years, we’ve been exposed to a few weird-and-wonderful SQL Server issues but, mainly, we’ve seen the same problems and the same misconceptions about how SQL Server works crop up time-and-again. This book is our attempt to describe, diagnose, and solve some of the most common problems associated with the currently-supported versions of SQL Server: SQL Server 2005, 2008, and 2008 R2.

T-SQL Fundamentals

Author: Itzik Ben-Gan
Publisher: Microsoft Press; 3 edition
Publication date: August 13, 2016
Format: Kindle, Paperback
Price: Kindle $37.43, Paperback $46.81
Description: Master T-SQL fundamentals and write robust code for Microsoft SQL Server and Azure SQL Database. Itzik Ben-Gan explains key T-SQL concepts and helps you apply your knowledge with hands-on exercises. The book first introduces T-SQL’s roots and underlying logic. Next, it walks you through core topics such as single-table queries, joins, subqueries, table expressions, and set operators. Then the book covers more-advanced data-query topics such as window functions, pivoting, and grouping sets. The book also explains how to modify data, work with temporal tables, and handle transactions, and provides an overview of programmable objects.

T-SQL Querying

Author: Itzik Ben-Gan, Adam Machanic, Dejan Sarka, Kevin Farlee
Publisher: Microsoft Press
Publication date: March 6, 2015
Format: Kindle, Paperback
Price: Kindle £23.84, Paperback £41.04
Description: T-SQL insiders help you tackle your toughest queries and query-tuning problems. Squeeze maximum performance and efficiency from every T-SQL query you write or tune. Four leading experts take an in-depth look at T-SQL’s internal architecture and offer advanced practical techniques for optimizing response time and resource usage. Emphasizing a correct understanding of the language and its foundations, the authors present unique solutions they have spent years developing and refining. All code and techniques are fully updated to reflect new T-SQL enhancements in Microsoft SQL Server 2014 and SQL Server 2012.

See also

Related posts: